Oracle SQL & PL/SQL Trainers

Oracle SQL & 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 Datatypes, 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

Quick Enroll