Oracle PL / SQL Language Pocket Reference A Guide to Language Fundamentals - Steven Feuerstein ^ Bill Pribyl ^ Chip Dawes - First - 1999 - Paperback - O'reilly

Oracle PL / SQL Language Pocket Reference A Guide to Language Fundamentals

Includes Oracle 8i

Oracle / Database

This pocket reference provides quick-reference information that will help you use Oracle's PL SQL language, including the newest OracleS/ features. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.

This book boils down the most vital information from Oracle PL/SQL Programming into an accessible summary of fundamental language elements (e.g., block structure, identifiers, variables, datatypes, and declarations); statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/SQL functions in SQL. It covers OracleS objects, collections, and external procedures, and such OracleS/ elements as native dynamic SQL, autonomous transactions, bulk binds, and Java language integration.

Steven Feuerstein has adopted PL/SQL as a member of his immediate family. Pay them both a visit at http://ivww.stevenfeuerstein.com. Bill Pribyl is thankful if his writing and lectures about PL/SQL make things a little bit easier for Oracle users. Chip Dawes is a DBA and PL/SQL developer consultant in the Chicago area.

Contents

Introduction
Acknowledgments
Conventions
PL/SQL Language Fundamentals
Variables and Program Data
Conditional and Sequential Control
Loops
Database Interaction and Cursors
Cursors in PL/SQL
Exception Handling
Records in PL/SQL
Named Program Units
Triggers
Packages
Calling PL/SQL Functions in SQL
Oracle8 Objects
Collections
External Procedures
Java Language Integration