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...!!
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...!!
