Re: PL/SQL web application

[Alex Russell <alex () netWindows org>]

-----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
alex () netWindows org
alex () SecurePipe com
-----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>