-----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 [EMAIL PROTECTED] [EMAIL PROTECTED] -----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</A>
