Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Do you use PL/SQL
On 21.05.2007 07:55, Arto Viitanen wrote:
> Ana C. Dent wrote:
>> Doug Davis <douglass_davis_at_earthlink.net> wrote in >> news:1179630172.123167.246530_at_o5g2000hsb.googlegroups.com: >> >>> >>> 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.) >> >> >> I contend that PL/SQL reduces network traffic by significant amounts. >> With SQL you can't do any type of flow control (IF THEN ELSE). >> With any 3GL lanuage, the results set must be returned back to the 3GL >> before simple flow control can occur. >> While the identical results can be obtained using either approach, >> I believe that PL/SQL solution(s) can scale to MUCH large databases >> and/or many more application users.
To me your posting demonstrates very well why I would choose PL/SQL - at least for all tasks that are close to the DB (i.e. maintenance scripts, jobs etc.): you can simply rely on it being there which you cannot with Java, C# etc. :-)
Kind regards
robert Received on Mon May 21 2007 - 05:15:14 CDT
![]() |
![]() |