PL/SQL is an EXTENSION for SQL and Oracle. It enhances the capabilities of SQL. Therefore, with every release of the Oracle Database, the feature and functionalities of PL/SQL is enhanced.

It is AVAILABLE in Oracle Database since version 6. However, PL/SQL is also available in TimesTen in-memory database since version 11.2.1 and IBM DB2 since version 9.7.

PL/SQL is strongly integrated with SQL and supports both static and dynamic SQL.

The following are the features in PL/SQL:

• PL/SQL is a procedural language that extends SQL.
• PL/SQL has a built-in interpreted programming environment.
• PL/SQL's syntax has shaped ADA and Pascal programming language.
• Structured programming is possible with PL/SQL through functions and procedures.
• It has Block Structures as well as nest block structures. Executes as a WHOLE block.
• PL/SQL has object-oriented features in it.
• PL/SQL also comes with the functionality of Triggers. Triggers are stored in a database and fired when some event occurs. The event here can be a Database Manipulation statement i.e. DELETE, INSERT, or UPDATE, or a Database Definition statement (CREATE, ALTER, or DROP).
• PL/SQL is a standard language for Oracle development.
• PL/SQL is used to write program blocks, functions, procedures triggers, etc.
• It has cursors. Oracle FORMS a memory area, when an SQL statement is processed. This memory area is called context area. A cursor in PL/SQL is a pointer to this context area. It has information about processing the statement.