Re: Do you use PL/SQL

On Sat, 19 May 2007 20:02:52 -0700, Doug Davis wrote:

> 1. Why use PL/SQL instead of just sending SQL queries from a program
> written in a procedural language on the client side (Java, Visual Basic,
> C++, anything.)

Because it is simpler and more optimal to do database things within the database. For any communication between the client and the server process, one needs network communication while PL/SQL is executed within the database. There are things that are hard to do with PL/SQL. Processing an input file or formatting your output is much harder with PL/SQL then with C++, Java or my personal favorites, Perl and PHP. For programming GUI you need the external programming language. However, it is a good thing to do all things database in the database because you save yourself significant amount of time for the network communication.

-- 
http://www.mladen-gogala.com