Why PLSQL is efficient than any other PL on Oracle database?

12 years ago when I argued on the performance of  Programming Languages with an experienced Java programmer, who was developing CORBA like communication infrastructure and preferring only Java, confessed that a dba might develop better performance code than him in PLSQL.

In Turkish, there is a saying "tools work, hands take pride on".  So why not use PLSQL much more...

PLSQL is really on database and closer to database layer any other Programming Languae could manage to be .

After years passed, using SQL instead of PLSQL was my first goal while implementing any requirement.

I had first seen below statement nearly 1 year ago, and it really fit my thoughts which I have not been clearly stated before. I really appreciated it and compelled to get my knowledge world.

My mantra, that I'll be sticking with thank you very much, is:

• You should do it in a single SQL statement if at all possible.


• If you cannot do it in a single SQL Statement, then do it in PL/SQL.


• If you cannot do it in PL/SQL, try a Java Stored Procedure.


• If you cannot do it in Java, do it in a C external procedure.


• If you cannot do it in a C external routine, you might want to seriously think about why it is you need to do it…

http://tkyte.blogspot.com/2006/10/slow-by-slow.html