28th Dec, 2019
PL/SQL or procedural language for SQL is a procedural extension of Oracle corporations, for Oracle relational database and SQL. PL/ SQL is found in IBM DB 2(from the version 9.7), Oracle database (from the version 6- compiled PL/SQL functions/procedures/triggers/packages from the version 7), and Times Ten in-memory database (from the version 11.2.1). Oracle corporation usually expands PL/SQL functionality along with each succeeding Oracle database's release.
PL/SQL incorporates operational language elements like loops and conditions. It permits communication of variables and constants, functions and procedures, triggers, and variables and kinds of those types. It can deal with run-time errors or exceptions.