Database Compatibility Stored Procedural Language Guide

• Basic SPL Elements
  • Character Set
  • Case Sensitivity
  • Identifiers
  • Qualifiers
  • Constants
  • User-Defined PL/SQL Subtypes
• SPL Programs
  • Basic SPL Elements
    • Character Set
    • Case Sensitivity
    • Identifiers
    • Qualifiers
    • Constants
    • User-Defined PL/SQL Subtypes
  • SPL Block Structure
  • Anonymous Blocks
  • Procedures Overview
    • Creating a Procedure
    • Calling a Procedure
    • Deleting a Procedure
  • Functions Overview
    • Creating a Function
    • Calling a Function
    • Deleting a Function
  • Procedure and Function Parameters
    • Positional vs. Named Parameter Notation
    • Parameter Modes
    • Using Default Values in Parameters
  • Subprograms – Subprocedures and Subfunctions
    • Creating a Subprocedure
    • Creating a Subfunction
    • Block Relationships
    • Invoking Subprograms
    • Using Forward Declarations
    • Overloading Subprograms
    • Accessing Subprogram Variables
  • Compilation Errors in Procedures and Functions
  • Program Security
    • EXECUTE Privilege
    • Database Object Name Resolution
    • Database Object Privileges
    • Definer’s vs. Invokers Rights
    • Security Example
• Variable Declarations
  • Declaring a Variable
  • Using %TYPE in Variable Declarations
  • Using %ROWTYPE in Record Declarations
  • User-Defined Record Types and Record Variables
• Basic Statements
  • Assignment
  • DELETE
  • INSERT
  • NULL
  • Using the RETURNING INTO Clause
  • SELECT INTO
  • UPDATE
  • Obtaining the Result Status
• Control Structures
  • IF Statement
    • IF-THEN
    • IF-THEN-ELSE
    • IF-THEN-ELSE IF
    • IF-THEN-ELSIF-ELSE
  • RETURN Statement
  • GOTO Statement
  • CASE Expression
    • Selector CASE Expression
    • Searched CASE Expression
  • CASE Statement
    • Selector CASE Statement
    • Searched CASE Statement
  • Loops
    • LOOP
    • EXIT
    • CONTINUE
    • WHILE
    • FOR (integer variant)
  • Exception Handling
  • User-defined Exceptions
  • PRAGMA EXCEPTION_INIT
  • RAISE_APPLICATION_ERROR
• Transaction Control
  • COMMIT
  • ROLLBACK
  • PRAGMA AUTONOMOUS_TRANSACTION
• Dynamic SQL
• Static Cursors
  • Declaring a Cursor
  • Opening a Cursor
  • Fetching Rows From a Cursor
  • Closing a Cursor
  • Using %ROWTYPE With Cursors
  • Cursor Attributes
    • %ISOPEN
    • %FOUND
    • %NOTFOUND
    • %ROWCOUNT
    • Summary of Cursor States and Attributes
  • Cursor FOR Loop
  • Parameterized Cursors
• REF CURSORs and Cursor Variables
  • REF CURSOR Overview
  • Declaring a Cursor Variable
    • Declaring a SYS_REFCURSOR Cursor Variable
    • Declaring a User Defined REF CURSOR Type Variable
  • Opening a Cursor Variable
  • Fetching Rows From a Cursor Variable
  • Closing a Cursor Variable
  • Usage Restrictions
  • Examples
    • Returning a REF CURSOR From a Function
    • Modularizing Cursor Operations
  • Dynamic Queries With REF CURSORs
• Collections
  • Associative Arrays
  • Nested Tables
  • Varrays
• Collection Methods
  • COUNT
  • DELETE
  • EXISTS
  • EXTEND
  • FIRST
  • LAST
  • LIMIT
  • NEXT
  • PRIOR
  • TRIM
• Working with Collections
  • TABLE()
  • Using the MULTISET UNION Operator
  • Using the FORALL Statement
  • Using the BULK COLLECT Clause
    • SELECT BULK COLLECT
    • FETCH BULK COLLECT
    • EXECUTE IMMEDIATE BULK COLLECT
    • RETURNING BULK COLLECT
  • Errors and Messages
• Triggers
  • Overview
  • Types of Triggers
  • Creating Triggers
  • Trigger Variables
  • Transactions and Exceptions
  • Compound Triggers
  • Trigger Examples
    • Before Statement-Level Trigger
    • After Statement-Level Trigger
    • Before Row-Level Trigger
    • After Row-Level Trigger
    • INSTEAD OF Trigger
    • Compound Triggers
• Packages
• Object Types and Objects
  • Basic Object Concepts
    • Attributes
    • Methods
    • Overloading Methods
  • Object Type Components
    • Object Type Specification Syntax
    • Object Type Body Syntax
  • Creating Object Types
    • Member Methods
    • Static Methods
    • Constructor Methods
  • Creating Object Instances
  • Referencing an Object
  • Dropping an Object Type
• Errors and Messages
• Conclusion