Oracle PL/SQL Language Pocket Reference

Introduction Acknowledgments Conventions PL/SQL Language Fundamentals PL/SQL Character Set Identifiers Boolean, Numeric, and String Literals Numeric Literals Datetime Interval Literals 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 Assigning Records DML and Records 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 Methods Methods in Subtypes Manipulating Objects in PL/SQL and SQL Upcasting and Downcasting Changing Object Types Collections Declaring a Collection Initializing a Collection Adding and Removing Elements Nested Table Functions Collection Methods Collections and Privileges Nested Collections Bulk Binds External Procedures Creating an External Procedure Parameters Java Language Integration Example Publishing Java to PL/SQL Data Dictionary Regular Expressions (Oracle Database 10g) Metacharacters REGEXP_LIKE REGEXP_INSTR REGEXP_SUBSTR REGEXP_REPLACE Match Modifiers Reserved Words Index