PL/SQL |
 Previous |
 Next |
PL/SQL is an Oracle procedural extension to SQL, the standard database access language. It is an advanced programming language, which like SQL, has a built-in treatment of the relational database domain. Applications written in any of the Oracle programmatic interfaces can call stored procedures and functions written in PL/SQL.
In PL/SQL, you can manipulate data with SQL statements and control program flow with procedural constructs such as loops. You can also do the following:
-
Declare constants and variables
-
Define procedures and functions
-
Use collections and object types
-
Trap runtime errors
-
Create functions, packages, procedures, and triggers
For information about using PL/SQL, see Using PL/SQL.
|
See Also:
|