From: Alex Russell (alex@netWindows.org)
Date: Tue Feb 25 2003 - 13:47:58 EST
-----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-----
----------------------------------------------------------------------------
This archive was generated by hypermail 2.1.7
: Sat Apr 12 2008 - 10:53:29 EDT
<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>