Oracle PL/SQL Language Pocket Reference, 5th Edition

Table of Contents

1. Introduction
   1. Acknowledgments
   2. Conventions
2. PL/SQL Language Fundamentals
   1. PL/SQL Character Set
   2. Identifiers
   3. Boolean, Numeric, and String Literals
   4. Numeric Literals
   5. Datetime Interval Literals
   6. Delimiters
   7. Comments
   8. Pragmas
   9. Statements
   10. Block Structure
3. Variables and Program Data
   1. Scalar Datatypes
   2. LOB Datatypes
   3. Implicit Datatype Conversions
   4. NULLs in PL/SQL
   5. Declaring Variables
   6. Anchored Declarations
   7. Programmer-Defined Subtypes
4. Conditional and Sequential Control
   1. Conditional Control Statements
   2. Sequential Control Statements
5. Loops
   1. Simple Loop
   2. Numeric FOR Loop
   3. Cursor FOR Loop
   4. WHILE Loop
   5. “Repeat Until” Loop Emulation
   6. EXIT Statement
   7. CONTINUE Statement
   8. Loop Labels
6. Database Interaction
   1. Sequences in PL/SQL
   2. Transaction Management
   3. Autonomous Transactions
7. Cursors in PL/SQL
   1. Explicit Cursors
   2. Implicit Cursors
   3. Native Dynamic SQL
   4. DBMS_SQL
   5. SQL Injection and Bind Variables
   6. Cursor Variables
   7. Cursor Expressions
8. Exception Handling
   1. Declaring Exceptions
   2. Raising Exceptions
   3. Scope
   4. Propagation
9. Records in PL/SQL
   1. Declaring Records
   2. Referencing a Record’s Fields
   3. Assigning Records
   4. Records and DML
   5. Nested Records
10. Collections in PL/SQL
    1. Declaring a Collection
    2. Initializing a Collection
    3. Adding and Removing Elements
    4. Nested Table Functions
    5. Collection Methods
    6. Collections and Privileges
    7. Nested Collections
    8. Bulk Binds
11. Built-in Functions and Packages
    1. Built-in Functions
    2. Built-in Regular Expression Functions
12. Stored Procedures and Functions
    1. Procedures
    2. Functions
    3. Parameters
    4. Local Programs
    5. Program Overloading
    6. Forward Declarations
    7. Table Functions
    8. Function Result Cache
    9. Privileges and Stored PL/SQL
13. Triggers
    1. Creating Triggers
    2. Trigger Predicates
    3. DML Events
    4. Compound DML Triggers
    5. DDL Events
    6. Database Events
14. Packages
    1. Package Structure
    2. Referencing Package Elements
    3. Package Data
    4. SERIALLY_REUSABLE Pragma
    5. Package Initialization
15. Calling PL/SQL Functions in SQL
    1. Calling a Function
    2. Improving Performance of Calling PL/SQL Functions from SQL
    3. Column Name Versus Function Name Precedence
16. Object-Oriented Features
    1. Object Types
    2. Type Inheritance
    3. Methods
    4. Methods in Subtypes
    5. Manipulating Objects in PL/SQL and SQL
    6. Upcasting and Downcasting
    7. Changing Object Types
17. Compilation
    1. Compiling Stored PL/SQL Programs
    2. Conditional Compilation
    3. Compiler Warnings
    4. Optimizing Compiler
    5. Performing Native Compilation of PL/SQL
18. Java Language Integration
    1. Example
    2. Publishing Java to PL/SQL
    3. Data Dictionary
19. Index