OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql vs pl/sql

Thu, 12 July 2007 10:08

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.

Thu, 12 July 2007 10:11

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

sql

Thu, 12 July 2007 10:13

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Thu, 12 July 2007 10:13

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

Can you please provide the details why sql is efficient.

Thu, 12 July 2007 10:30

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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: Fri Nov 07 16:12:37 CST 2025