PL/SQL is Oracle Corporation’s procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database, TimesTen in-memory database, and IBM DB2. Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
The extension includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). In fact arrays support involves the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create extension units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
The main feature of SQL is also a drawback of SQL. One cannot use control statements if only SQL is to use. The extension is primarily a procedural language, which provides the functionality of decision making, iteration and many more features like other procedural programming languages. An extension program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the extension source code that compiled, developed and ultimately executed on the database.
CHECK OUT SOME OF OUR JOBS BELOW.
Database Developer with SQL & PL/SQL
3 years ago
Got a question?
We're here to help. Check out our FAQs, send us an email or call us at 0034 965020606