What is PL/SQL?
ORACLE PL/SQL is an acronym for Procedural Language / Structured Query Language. It is a blend of SQL and procedural elements of programming languages and is designed to address the limited access like single query environment in SQL. PL/SQL enables developers to define and execute procedural language syntax on databases including declaration of variables and their types, arrays, functions and more. It also offers abstraction and modularity. Unlike some SQL versions that process client environment, PL/SQL resides on a database server.