The PL / SQL (Procedural Language / Structured QueryLanguage) is a proprietary programming language (forOracle database), procedural, and server-based extensionof SQL.
The PL / SQL supports variables, conditions, and handles exceptions.
The PL / SQL has several predefined packages, the most important are:
- DBMS_OUTPUT - for output operations
- DBMS_JOBS - to launch specific procedures orfunctions in a particular time, for example, the scheduling
- DBMS_XPLAN - to format output "Explain Plan"