Oracle PL/SQL Language Pocket Reference, 3rd Edition A guide to Oracle's PL/SQL language fundamentals

Customers who bought this, also bought: Oracle PL/SQL Programming, Fourth Edition Perl Pocket Reference, 4th Edition Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions (Expert One-On-One) Mastering Oracle PL/SQL: Practical Solutions Perl Best Practices Oracle SQL*Plus Pocket Reference, 3rd Edition The Data Warehouse ETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data Learning Perl, Fourth (4th) Edition Pro Oracle Spatial for Oracle Database 11g Mastering Oracle SQL (2nd Edition)

by: Steven Feuerstein, Bill Pribyl, Chip Dawes

Notify me when in stock

On-line Price: $13.95 (includes GST) Paperback package 156 20%Off Retail Price You save: $4.00 OUT OF PRINT...price/avail/options will be confirmed by reply email. Usual delay approx 3 weeks. _____________________ Supplier : In Transit	Retail Price: $17.95 Publisher: O'REILLY,2004/04/30 Category: ORACLE Level: I/A ISBN: 0596006802 ISBN13: 9780596006808
Add to Shopping Cart

When you need a reminder or quick answer to a PL/SQL problem Oracle PL/SQL Language Pocket Reference, Third Edition is the key. Updated for Oracle10g, it includes fundamental language elements; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL; new Oracle 10g elements, and much more.

  Full Description

While it's good to have a book with all the answers--like your trusty copy of Oracle PL/SQL Programming-- how often do you need all the answers? More likely, you just need a reminder, a quick answer to a problem you're up against. For these times, nothing's handier than the new edition of the Oracle PL/SQL Language Pocket Reference by PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes. Newly updated for Oracle10g, this little book is always at the ready for the quick problem solving you need.

  The third edition of this popular mini-reference boils down the most vital information from Oracle PL/SQL Programming into a handy guide to PL/SQL basics. The book includes fundamental language elements, such as block structure, identifiers, variables, datatypes, ad declarations; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL.

  And there's more. This concise guide also covers Oracle objects, collections, external procedures, Java integration, and new Oracle 10g elements like regular expressions, compile-time warnings, more implicit conversion, FORALL support for non-consecutive indexes, and more. The amount of valuable information packed into this slim volume--intelligently arranged for quick accessibility--make this an indispensable reference for new and seasoned Oracle database developers alike.

  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 third edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.

Table of Contents

Introduction

                      Acknowledgments

                      Conventions

              PL/SQL Language Fundamentals

                      PL/SQL Character Set

                      Identifiers

                      Boolean, Numeric, and String Literals

                      Numeric Literals

                      Datetime Interval Literals

                      Delimiters

                      Comments

                      Pragmas

                      Statements

                      Block Structure

              Variables and Program Data

                      Scalar Datatypes

                      NLS Character Datatypes

                      LOB Datatypes

                      Implicit Datatype Conversions

                      NULLs in PL/SQL

                      Declaring Variables

                      Anchored Declarations

                      Programmer-Defined Subtypes

              Conditional and Sequential Control

                      Conditional Control Statements

                      Sequential Control Statements

              Loops

                      Simple Loop

                      Numeric FOR Loop

                      Cursor FOR Loop

                      WHILE Loop

                      REPEAT UNTIL Loop Emulation

                      EXIT Statement

                      Loop Labels

              Database Interaction

                      Transaction Management

                      Autonomous Transactions

              Cursors in PL/SQL

                      Explicit Cursors

                      Implicit Cursors

                      Dynamic Cursors

                      Cursor Variables

                      Cursor Expressions

              Exception Handling

                      Declaring Exceptions

                      Raising Exceptions

                      Scope

                      Propagation

              Records in PL/SQL

                      Declaring Records

                      Referencing Fields of Records

                      Assigning Records

                      DML and Records

                      Nested Records

              Named Program Units

                      Procedures

                      Functions

                      Parameters

              Triggers

                      Creating Triggers

                      Trigger Predicates

                      DML Events

                      DDL Events

                      Database Events

              Packages

                      Package Structure

                      Referencing Package Elements

                      Package Data

                      SERIALLY--REUSABLE Pragma

                      Package Initialization

              Calling PL/SQL Functions in SQL

                      Calling a Function

                      Requirements and Restrictions

                      Calling Packaged Functions in SQL

                      Column/Function Name Precedence

              Oracle's Object-Oriented Features

                      Object Types

                      Type Inheritance

                      Methods

                      Methods in Subtypes

                      Manipulating Objects in PL/SQL and SQL

                      Upcasting and Downcasting

                      Changing Object Types

              Collections

                      Declaring a Collection

                      Initializing a Collection

                      Adding and Removing Elements

                      Nested Table Functions

                      Collection Methods

                      Collections and Privileges

                      Nested Collections

                      Bulk Binds

              External Procedures

                      Creating an External Procedure

                      Parameters

              Java Language Integration

                      Example

                      Publishing Java to PL/SQL

                      Data Dictionary

              Regular Expressions (Oracle Database 10g)

                      Metacharacters

                      REGEXP--LIKE

                      REGEXP--INSTR

                      REGEXP--SUBSTR

                      REGEXP--REPLACE

                      Match Modifiers

              Reserved Words

              Index