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 … Read more