Oracle PL/SQL Language Pocket Reference

Introduction

PL/SQL Language Fundamentals
PL/SQL Character Set
Identifiers
Boolean, Numeric, and String Literals
Datetime Interval Literals (Oracle9i)
Delimiters
Comments
Pragmas
Statements
Block Structure

Variables and Program Data
Scalar Datatypes
NLS Character Datatypes
LOB Datatypes
Implicit Datatype Conversions
NULLs in PL/SQL
Declaring Variables
Anchored Declarations
Programmer-Defined Subtypes

Conditional and Sequential Control
Conditional Control Statements
Sequential Control Statements

Loops
Simple Loop
Numeric FOR Loop
Cursor FOR Loop
WHILE Loop
REPEAT UNTIL Loop Emulation
EXIT Statement
Loop Labels

Database Interaction
Transaction Management
Autonomous Transactions

Cursors in PL/SQL
Explicit Cursors
Implicit Cursors
Dynamic Cursors
Cursor Variables
Cursor Expressions

Exception Handling
Declaring Exceptions
Raising Exceptions
Scope
Propagation

Records in PL/SQL
Declaring Records
Referencing Fields of Records
Record Assignment
Nested Records

Named Program Units
Procedures
Functions
Parameters

Triggers
Creating Triggers
Trigger Predicates
DML Events
DDL Events
Database Events

Packages
Package Structure
Referencing Package Elements
Package Data
SERIALLY_REUSABLE Pragma
Package Initialization

Calling PL/SQL Functions in SQL
Calling a Function
Requirements and Restrictions
Calling Packaged Functions in SQL
Column/Function Name Precedence

Oracle's Object-Oriented Features
Object Types
Type Inheritance (Oracle9i)
Methods
Methods in Subtypes (Oracle9i)
Manipulating Objects in PL/SQL and SQL
Upcasting and Downcasting (Oracle9i)
Changing Object Types

Collections
Declaring a Collection
Initializing Collections
Adding and Removing Elements
Collection Pseudo-Functions
Collection Methods
Collections and Privileges
Nested Collections (Oracle9i)
Bulk Binds

External Procedures
Creating an External Procedure
Parameters

Java Language Integration
Example
Publishing Java to PL/SQL
Data Dictionary

Reserved Words

Index