Triggers |
PL/SQL Variables and Datatypes |
 |
Beyond Declarative Integrity |
 |
Triggers |
 |
Types of Triggers |
 |
Trigger Sequencing |
 |
Row-Level Triggers |
 |
Trigger Predicates |
 |
Trigger Conditions |
 |
Using Sequences |
 |
Cascading Triggers and Mutating Tables |
 |
Generating an Error |
 |
Maintaining Triggers |
|
 |
Anonymous Blocks |
 |
Declaring Variables |
 |
Datatypes |
 |
Subtypes |
 |
Character Data |
 |
Dates and Timestamps |
 |
Date Intervals |
 |
Anchored Types |
 |
Assignment and Conversions |
 |
Selecting into a Variable |
 |
Returning into a Variable |
|
PL/SQL Syntax and Logic |
Stored Procedures and Functions |
 |
Conditional Statements - IF/THEN |
 |
Conditional Statements - CASE |
 |
Comments and Labels |
 |
Loops |
 |
WHILE and FOR Loops |
 |
SQL in PL/SQL |
 |
Local Procedures and Functions |
|
 |
Stored Subprograms |
 |
Creating a Stored Procedure |
 |
Procedure Calls and Parameters |
 |
Parameter Modes |
 |
Named Parameter Notation |
 |
Default Arguments |
 |
Creating a Stored Function |
 |
Stored Functions and SQL |
 |
Invoker's Rights |
|
Exception Handling |
Records, Collections and User-Defined Types |
 |
SQLCODE and SQLERRM |
 |
Exception Handlers |
 |
Nesting Blocks |
 |
Scope and Name Resolution |
 |
Declaring and Raising Named Exceptions |
 |
User-Defined Exceptions |
|
 |
Record Variables |
 |
Using the %ROWTYPE Attribute |
 |
User-Defined Object Types |
 |
VARRAY and Nested TABLE Collections |
 |
Using Nested TABLEs |
 |
Using VARRAYs |
 |
Collections in Database Tables |
 |
Associative Array Collections |
 |
Collection Methods |
 |
Iterating through Collections |
|
Cursors |
Bulk Operations |
 |
Multi-Row Queries |
 |
Declaring and Opening Cursors |
 |
Fetching Rows |
 |
Closing Cursors |
 |
The Cursor FOR Loop |
 |
FOR UPDATE Cursors |
 |
Cursor Parameters |
 |
The Implicit (SQL) Cursor |
|
 |
Bulk Binding |
 |
BULK COLLECT Clause |
 |
FORALL Statement |
 |
FORALL Variations |
 |
Bulk Returns |
 |
Bulk Fetching with Cursors |
|
Using Packages |
Creating Packages |
 |
Packages |
 |
Oracle-Supplied Packages |
 |
The DBMS_OUTPUT Package |
 |
The DBMS_UTILITY Package |
 |
The UTL_FILE Package |
 |
Creating Pipes with DBMS_PIPE |
 |
Writing to and Reading from a Pipe |
 |
The DBMS_METADATA Package |
 |
XML Packages |
 |
Networking Packages |
 |
Other Supplied Packages |
|
 |
Structure of a Package |
 |
The Package Interface and Implementation |
 |
Package Variables and Package State |
 |
Overloading Package Functions and Procedures |
 |
Forward Declarations |
 |
Strong REF CURSOR Variables |
 |
Weak REF CURSOR Variables |
|
Working with LOBs |
Maintaining PL/SQL Code |
 |
Large Object Types |
 |
Oracle Directories |
 |
LOB Locators |
 |
Internal LOBs |
 |
LOB Storage and SECUREFILEs |
 |
External LOBs |
 |
Temporary LOBs |
 |
The DBMS_LOB Package |
|
 |
Privileges for Stored Programs |
 |
Data Dictionary |
 |
PL/SQL Stored Program Compilation |
 |
Conditional Compilation |
 |
Compile-Time Warnings |
 |
The PL/SQL Execution Environment |
 |
Dependencies and Validation |
 |
Maintaining Stored Programs |
|
Dynamic SQL |
|
 |
Generating SQL at Runtime |
 |
Native Dynamic SQL Vs DBMS_SQL Package |
 |
The EXECUTE IMMEDIATE Statement |
 |
Using Bind Variables |
 |
Multi-row Dynamic Queries |
 |
Bulk Operations with Dynamic SQL |
 |
Using DBMS_SQL |
 |
DBMS_SQL Subprograms |
|
|