PL/SQL

PL/SQL
About PL/SQL: PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (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.
The purpose of a PL/SQL function is generally to compute and return a single value. This returned value may be a single scalar value (such as a number, date or character string) or a single collection (such as a nested table or varay). User-defined functions supplement the built-in functions provided by Oracle Corporation.

Blocks
•    Structure, Writing Anonymous Blocks
Variables
•    Oracle Data types, TYPE and ROWTYPE declarations, Value assignments
Control structures
•    IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement,
LOOP END , LOOP statement, WHILE condition, FOR condition
Cursors
•    Implicit and Explicit Cursors, Cursor Manipulation statements,
OPEN FETCH CLOSE EXIT WHEN
Procedures
•    Creating and Calling Procedures
Functions
•    Creating and Calling Functions
Packages
•    Package Header, Package Body
Design Tips and Techniques
•    Format of standard packages in an application, Spec and Body, NOCOPY hint
Triggers
•    Database triggers, calling procedures from triggers
Dynamic SQL
•    EXECUTE IMMEDIATE, DBMS_SQL package
Oracle Supplied packages
•    DBMS_OUTPUT, UTL_FILE
Collection data types
•    Associative Arrays, Nested tables, VARRAYs

Last modified: Monday, 18 July 2016, 12:18 AM