Database Compatibility Stored Procedural Language Guide

Advanced Serverのストアドプロシージャ言語（SPL）は、以下を提供するAdvanced Serverのカスタムプロシージャ、関数、トリガー、およびパッケージソフトを作成するための生産性の高いプロシージャプログラミング言語です。

SQL言語を補完する完全な手続きプログラミング機能 Advanced Serverデータベースのストアドプロシージャ、関数、トリガー、およびパッケージソフトを作成するための単一の共通言語 - シームレスな開発およびテスト環境 - 再利用可能なコードの使用 - 使いやすさ

このガイドはSPLプログラムの基本的な要素について説明してから、SPLプログラムの組織の概要と、それがプロシージャやファンクションを作成するのにどう使われるかを提供する前に。 SPL言語と組み合わせて使用される可能性のある他の互換性機能（トリガーやビルトイン関数など）に関するガイドは、EDB websiteで入手できます。

• Basic SPL Elements
  • Case Sensitivity
  • Identifiers
  • Qualifiers
  • Constants
  • User-Defined PL/SQL Subtypes
  • Character Set
• SPL Programs
  • 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