| 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 |
|
|
