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