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

Book Description

Like most PL/SQL programmers, you've found Oracle PL/SQL Programming to be a reference book you can't do without. Packed with examples and recommendations, it's a book that has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. But you can't always carry it with you, and even at your desk there are times when you just need a reminder, a quick answer to a problem you're up against. For times like those, PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes have written a new edition of Oracle PL/SQL Language Pocket Reference. Updated for Oracle9i, this little book is easy to take with you and use anywhere for quick problem solving. The second edition of the Oracle PL/SQL Language Pocket Reference boils down the most vital information from Oracle PL/SQL Programming into a convenient quick reference to PL/SQL basics. This compact book will be indispensable for new and seasoned Oracle database developers alike. It summarizes features available in Oracle9i and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java classes from PL/SQL. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.

Table of Contents

  1. Oracle PL/SQL Language Pocket Reference, 2nd Edition
    1. 1. Oracle PL/SQL Language Pocket Reference
      1. Introduction
      2. Acknowledgments
      3. Conventions
      4. PL/SQL Language Fundamentals
        1. PL/SQL Character Set
        2. Identifiers
        3. Boolean, Numeric, and String Literals
        4. Datetime Interval Literals (Oracle9i)
        5. Delimiters
        6. Comments
        7. Pragmas
        8. Statements
        9. Block Structure
      5. Variables and Program Data
        1. Scalar Datatypes
          1. Numeric datatypes
          2. Character datatypes
          3. Datetime datatypes
          4. Boolean datatype
        2. NLS Character Datatypes
        3. LOB Datatypes
        4. Implicit Datatype Conversions
        5. NULLs in PL/SQL
        6. Declaring Variables
          1. Constrained declarations
          2. Constants
          3. Default values
        7. Anchored Declarations
        8. Programmer-Defined Subtypes
      6. Conditional and Sequential Control
        1. Conditional Control Statements
          1. IF-THEN combination
          2. IF-THEN-ELSE combination
          3. IF-THEN-ELSIF combination
          4. CASE statement (Oracle9i)
          5. CASE expression (Oracle9i)
        2. Sequential Control Statements
          1. GOTO
          2. NULL
      7. Loops
        1. Simple Loop
        2. Numeric FOR Loop
        3. Cursor FOR Loop
        4. WHILE Loop
        5. REPEAT UNTIL Loop Emulation
        6. EXIT Statement
        7. Loop Labels
      8. Database Interaction
        1. Transaction Management
          1. COMMIT
          2. ROLLBACK
          3. SAVEPOINT
          4. SET TRANSACTION
          5. LOCK TABLE
        2. Autonomous Transactions
      9. Cursors in PL/SQL
        1. Explicit Cursors
          1. Declaring explicit cursors
          2. Opening explicit cursors
          3. Fetching from explicit cursors
          4. Closing explicit cursors
          5. Explicit cursor attributes
        2. Implicit Cursors
          1. SELECT FOR UPDATE clause
          2. WHERE CURRENT OF clause
        3. Dynamic Cursors
        4. Cursor Variables
        5. Cursor Expressions
      10. Exception Handling
        1. Declaring Exceptions
        2. Raising Exceptions
        3. Scope
        4. Propagation
          1. WHEN OTHERS clause
          2. SQLCODE and SQLERRM
          3. Exceptions and DML
      11. Records in PL/SQL
        1. Declaring Records
        2. Referencing Fields of Records
        3. Record Assignment
        4. Nested Records
      12. Named Program Units
        1. Procedures
        2. Functions
        3. Parameters
          1. Datatype
          2. Mode
          3. Default values
          4. Parameter-passing notations
          5. Local programs
          6. Program overloading
          7. Forward declarations
          8. Table functions
          9. Compiling stored PL/SQL programs
          10. Native compilation of PL/SQL (Oracle9i)
          11. Privileges and stored PL/SQL
      13. Triggers
        1. Creating Triggers
        2. Trigger Predicates
        3. DML Events
        4. DDL Events
        5. 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. Requirements and Restrictions
        3. Calling Packaged Functions in SQL
        4. Column/Function Name Precedence
      16. Oracle’s Object-Oriented Features
        1. Object Types
        2. Type Inheritance (Oracle9i)
        3. Methods
          1. Member methods
          2. Static methods
          3. Constructor methods
          4. Comparison methods
        4. Methods in Subtypes (Oracle9i)
        5. Manipulating Objects in PL/SQL and SQL
        6. Upcasting and Downcasting (Oracle9i)
          1. REF operator
          2. VALUE operator
          3. DEREF operator
        7. Changing Object Types
      17. Collections
        1. Declaring a Collection
        2. Initializing Collections
        3. Adding and Removing Elements
        4. Collection Pseudo-Functions
        5. Collection Methods
        6. Collections and Privileges
        7. Nested Collections (Oracle9i)
        8. Bulk Binds
      18. External Procedures
        1. Creating an External Procedure
          1. Set up the listener
          2. Identify or create the shared library or DLL
          3. Create the library in the database
          4. Create the PL/SQL wrapper for the external procedure
        2. Parameters
      19. Java Language Integration
        1. Example
        2. Publishing Java to PL/SQL
        3. Data Dictionary
      20. Reserved Words
    2. Index