You are previewing Oracle PL/SQL Language Pocket Reference, 5th Edition.
O'Reilly logo
Oracle PL/SQL Language Pocket Reference, 5th Edition

Book Description

Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c. Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Table of Contents

  1. Introduction
    1. Acknowledgments
    2. Conventions
  2. PL/SQL Language Fundamentals
    1. PL/SQL Character Set
    2. Identifiers
    3. Boolean, Numeric, and String Literals
    4. Numeric Literals
    5. Datetime Interval Literals
    6. Delimiters
    7. Comments
    8. Pragmas
    9. Statements
    10. Block Structure
  3. Variables and Program Data
    1. Scalar Datatypes
    2. LOB Datatypes
    3. Implicit Datatype Conversions
    4. NULLs in PL/SQL
    5. Declaring Variables
    6. Anchored Declarations
    7. Programmer-Defined Subtypes
  4. Conditional and Sequential Control
    1. Conditional Control Statements
    2. Sequential Control Statements
  5. Loops
    1. Simple Loop
    2. Numeric FOR Loop
    3. Cursor FOR Loop
    4. WHILE Loop
    5. “Repeat Until” Loop Emulation
    6. EXIT Statement
    7. CONTINUE Statement
    8. Loop Labels
  6. Database Interaction
    1. Sequences in PL/SQL
    2. Transaction Management
    3. Autonomous Transactions
  7. Cursors in PL/SQL
    1. Explicit Cursors
    2. Implicit Cursors
    3. Native Dynamic SQL
    4. DBMS_SQL
    5. SQL Injection and Bind Variables
    6. Cursor Variables
    7. Cursor Expressions
  8. Exception Handling
    1. Declaring Exceptions
    2. Raising Exceptions
    3. Scope
    4. Propagation
  9. Records in PL/SQL
    1. Declaring Records
    2. Referencing a Record’s Fields
    3. Assigning Records
    4. Records and DML
    5. Nested Records
  10. Collections in PL/SQL
    1. Declaring a Collection
    2. Initializing a Collection
    3. Adding and Removing Elements
    4. Nested Table Functions
    5. Collection Methods
    6. Collections and Privileges
    7. Nested Collections
    8. Bulk Binds
  11. Built-in Functions and Packages
    1. Built-in Functions
    2. Built-in Regular Expression Functions
  12. Stored Procedures and Functions
    1. Procedures
    2. Functions
    3. Parameters
    4. Local Programs
    5. Program Overloading
    6. Forward Declarations
    7. Table Functions
    8. Function Result Cache
    9. Privileges and Stored PL/SQL
  13. Triggers
    1. Creating Triggers
    2. Trigger Predicates
    3. DML Events
    4. Compound DML Triggers
    5. DDL Events
    6. Database Events
  14. Packages
    1. Package Structure
    2. Referencing Package Elements
    3. Package Data
    4. SERIALLY_REUSABLE Pragma
    5. Package Initialization
  15. Calling PL/SQL Functions in SQL
    1. Calling a Function
    2. Improving Performance of Calling PL/SQL Functions from SQL
    3. Column Name Versus Function Name Precedence
  16. Object-Oriented Features
    1. Object Types
    2. Type Inheritance
    3. Methods
    4. Methods in Subtypes
    5. Manipulating Objects in PL/SQL and SQL
    6. Upcasting and Downcasting
    7. Changing Object Types
  17. Compilation
    1. Compiling Stored PL/SQL Programs
    2. Conditional Compilation
    3. Compiler Warnings
    4. Optimizing Compiler
    5. Performing Native Compilation of PL/SQL
  18. Java Language Integration
    1. Example
    2. Publishing Java to PL/SQL
    3. Data Dictionary
  19. Index