-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 26 February 2003 11:29 am, Balwant Rathore wrote: > > Why they choosed PL/SQL for programming language? > > I cannot understand. > > Stored PL/SQL is faster because it parses only ones and resides in main > memory and further request doesn't require re-parsing. > For example if a 100 line SQL statement accessed by 100 clients. It has > to compile 100 x 100 times. Same thing can be achieved in PL/SQL block in > compiling only once. > > Rich family of In-built function also makes it faster as compare to other > languages. > > It’s good to perform DML operations in PL/SQL rather than using methods > of other languages, as they require heavy processing to perform the same > actions. It should be noted that the same advantages hold for Java Stored Procedures under Oracle 8i and up. - -- Alex Russell alexat_private alexat_private -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+W7ppoV0dQ6uSmkYRAmUdAKDfVmmiwIv9VCHywwBRA/Hsb/rblgCg2YvH 0EJ8vdwiflJKNp4PIFbraNs= =5RgU -----END PGP SIGNATURE----- ---------------------------------------------------------------------------- <Pre>Do you know the base address of the Global Offset Table (GOT) on a Solaris 8 box? CORE IMPACT does.</Pre> <A href="http://www.securityfocus.com/core"> http://www.securityfocus.com/core>
This archive was generated by hypermail 2b30 : Wed Feb 26 2003 - 11:28:16 PST