Table Of Contents
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
|
Related Books
Oracle Books
Database Books
PL/SQL Books
Related Articles
|
