Scribd
Upload
7 views1 page

Understanding PL/SQL: Definition & Features

PL/SQL is Oracle Corporation's procedural extension for SQL that allows developers to write stored procedures, functions, packages and triggers in Oracle Database. It includes procedural elements like conditions and loops and allows declaration of variables, procedures, functions and types. PL/SQL has been available in Oracle Database since version 6 and is also supported in IBM DB2 and TimesTen databases.

Uploaded by

Hopa Popa
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

Understanding PL/SQL: Definition & Features

PL/SQL is Oracle Corporation's procedural extension for SQL that allows developers to write stored procedures, functions, packages and triggers in Oracle Database. It includes procedural elements like conditions and loops and allows declaration of variables, procedures, functions and types. PL/SQL has been available in Oracle Database since version 6 and is also supported in IBM DB2 and TimesTen databases.

Uploaded by

Hopa Popa
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PL/SQL

PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and
the Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored PL/
SQL procedures/functions/packages/triggers since version 7), TimesTen in-memory database (since
version 11.2.1), and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL
functionality with each successive release of the Oracle Database.
PL/SQL 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). Arrays are supported involving the use of
PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included
features associated with object-orientation. One can create PL/SQL 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.

Source: [Link]

You might also like