Re: Do you use PL/SQL

On May 19, 11:02 pm, Doug Davis <douglass_da..._at_earthlink.net> wrote:
> I will be teaching a PL/SQL class, and I wanted to get some opinions.
> I read about PL/SQL, but wanted some practical advice from people who
> have used it.
>
> 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.)
>
> 2. What are some examples of "real-world" things that you have done
> with PL/SQL (or have heard some one do with PL/SQL?)
>
> thanks.
>
> --http://www.douglassdavis.com

If you know Java or C++, you are better of using them than using PL/ SQL. Computers run so fast that performance advantages gained by PL/ SQL over C++ or Java are very little. On the other hand, if you do not know these languages or do not want to write lot of code in them use PL/SQL. PL/SQL you can write database centric programs quickly (lot less lines of code than JAVA or C++). JAVA or C++ , however, are not limited to calling SQL, you can do lot more things. If you are a software engineer, have complex big software projects, use Java or C+ +. On the other hand if you want to write database centric programs quickly write them in PL/SQL.

Certain activity such as writing triggers etc can be best done only using PL/SQL blocks. Event, tough Java in theory can be called from triggers (using Java stored procedures), one has to write convoluted code to do it (you still write lots of PL/SQL code). Received on Sat May 19 2007 - 23:44:24 CDT