What Are The Advantages Of PL/SQL Over SQL?


2 Answers

Shru Acharya Profile
Shru Acharya answered
1. Exceptions can be handled in PL/SQL where as in SQL you cannot.
2. PL/SQL uses packages of functions and procedures which are simply stored in the database. And these can be used far more easily.
3. Once these functions and procedures(in PL/SQL) are created, they can used anytime in the application. Even triggering functions possible when necessary.
4. Batch updates possible in PL/SQL.
5. Inserts, updates, select, etc can executed within a single block in PL/SQL.
Cool right...!!
Anonymous Profile
Anonymous answered
The advantage of the pl/sql over the sql is we use the procedures to  perform more then one query and to solve the complex problem which do not solve through  the single query,we also used the trigger to fire the event

Answer Question