Oracle PL/SQL programming / Steven Feuerstein with Bill Pribyl.

Format:

Book

Author/Creator:

Feuerstein, Steven.

Contributor:

Pribyl, Bill.

Class of 1897 Book Fund.

Language:

English

Subjects (All):

Oracle (Computer file).

PL/SQL (Computer program language).

Database management.

Physical Description:

xxiii, 989 pages : illustrations ; 24 cm

Edition:

Third edition.

Place of Publication:

Beijing ; Sebastopol, CA : O'Reilly, [2002]

Summary:

Nearly a quarter-million PL/SQL programmers -- novices and experienced developers alike -- have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone from Oracle Forms developers to database administrators make the most of PL/SQL.

This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. You'll find coverage of new datatypes (e.g., timestamps and XMLType) and new PL/SQL features, such as native dynamic SQL, autonomous transactions, invoker rights, new string-indexed and multilevel collections, record-based DML, and object type inheritance.

The third edition adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter -- designed especially for experienced PL/SQL developers -- describes PL/SQL's runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL.

Even if you've been a PL/SQL developer for years, you'll find an enormous amount of new and revised information in this third edition and on its companion web site. If you're new to PL/SQL, you'll find Oracle PL/SQL Programming an invaluable companion on the road to mastery.

Contents:

Programming in PL/SQL : Introduction to PL/SQL

Creating and running PL/SQL code

Language fundamentals

PL/SQL program structure : Conditional and sequential control

Iterative processing with loops

Exception handlers

PL/SQL program data : Working with program data

Strings

Numbers

Dates and timestamps

Records and collections

Miscellaneous datatypes

SQL in PL/SQL : DML and transaction management

Data retrieval

Dynamic SQL and dynamic PL/SQL

PL/SQL application construction : Procedures, functions, and parameters

Packages

Triggers

Managing PL/SQL applications

Advanced PL/SQL topics : PL/SQL's runtime architecture

Object-oriented aspects of PL/SQL

Calling Java from PL/SQL

External procedures.

Notes:

Includes index.

Previous ed.: 1997.

"Oracle development languages"--Cover.

"Covers versions through Oracle9i"--Cover.

Local Notes:

Acquired for the Penn Libraries with assistance from the Class of 1897 Book Fund.

ISBN:

0596003811

OCLC:

50775680