PL/SQL

PL/SQL (Procedural Language / Structured Query Language) is Oracle’s procedural extension to the database standard SQL coding language.

It creates Triggers, Functions, Procedures, Packages etc on the Oracle RDBMS – it includes elements such as conditions & loops, the declaration of variables & constants.  It can handle exceptions during runtime errors.

From Oracle version 8 it had features associated with object orientation – all PL/SQL objects can be compiled and stored in the database for constant re-use by applications and users.

Leave a Reply

Your email address will not be published. Required fields are marked *