Home » SQL & PL/SQL » SQL & PL/SQL » sql vs pl/sql
sql vs pl/sql [message #251162] Thu, 12 July 2007 10:08 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
If I have one single query only, which will be executed many a times, then which is more efficient sql or pl/sql.
Thanks.
Re: sql vs pl/sql [message #251163 is a reply to message #251162] Thu, 12 July 2007 10:11 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
sql
Re: sql vs pl/sql [message #251164 is a reply to message #251162] Thu, 12 July 2007 10:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL.
In the end, all is SQL in database, so if you don't need PL/SQL to go to SQL then only do SQL.

Regards
Michel
Re: sql vs pl/sql [message #251165 is a reply to message #251162] Thu, 12 July 2007 10:13 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
Can you please provide the details why sql is efficient.
Re: sql vs pl/sql [message #251181 is a reply to message #251165] Thu, 12 July 2007 10:30 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I provide you reason why PL/SQL is less efficient.
Is this not sufficient?

Regards
Michel
Previous Topic: need help in using cursors
Next Topic: Stored procedure name length in Oracle
Goto Forum:
  


Current Time: Wed Dec 07 18:27:36 CST 2016

Total time taken to generate the page: 0.08099 seconds