Chapter 42.
pl/sql
—
SQL
Procedural Language
Prev
Up
Part V. Server Programming
Home
Next
Chapter 42.
pl/sql
—
SQL
Procedural Language
Table of Contents
42.1. Overview
42.1.1. Advantages of Using
pl/sql
42.1.2. Supported Argument and Result Data Types
42.2. Structure of
pl/sql
42.2.1. Anonymous Block
42.2.2. Comments
42.3. Declarations
42.3.1. Declaring Function Parameters
42.3.2. Copying Types
42.3.3. Row Types
42.3.4. Record Types
42.3.5. Exception Types
42.4. Data Types
42.4.1. The SQL data types
42.4.2. PLS_INTEGER
42.4.3. STRING
42.5. Expressions
42.6. Basic Statements
42.6.1. Assignment
42.6.2. Executing a Query with a Single-Row Result
42.6.3. Execute a DML Query with with_clause
42.6.4. Execute a DML Query in pl/sql
42.6.5. Executing Dynamic Commands
42.6.6. Doing Nothing At All
42.7. Control Structures
42.7.1. Returning from a Function
42.7.2. Returning from a Procedure
42.7.3. Calling a Procedure
42.7.4. Conditionals
42.7.5. Simple Loops
42.7.6. GOTO Statement
42.7.7. Looping through Query Results
42.7.8. Trapping Errors
42.8. Cursors
42.8.1. Implicit cursors
42.8.2. Explicit cursors
42.8.3. Processing Query Result Sets
42.8.4. Cursor Variables
42.9. Collections
42.9.1. Associative Arrays
42.9.2. Nested Tables
42.9.3. Varrays
42.9.4. Collection Methods
42.10. Transaction Management
42.10.1. Operations Cursor With Transcations
42.10.2. AUTONOMOUS TRANSACTION Pragma
42.11. Packages
42.11.1. Package Overview
42.11.2. Create Package
42.11.3. Create and Access Packages
42.11.4. Examples
42.11.5. Limitations
42.11.6. Package Reference
42.12. Table function
42.13. Error Handling
42.13.1. Overview of Exception Handling
42.13.2. Predefined Exceptions
42.13.3. Raising Exceptions Explicitly
42.13.4. support DBMS_UTILITY built-in package format_error_backtrace
42.13.5. support SQLCODE
42.13.6. 支持 SQLERRM
42.14. Object name search rule
42.15. Enhancements for Oracle