Oracle PL/SQL Programming: A Developer's Workbook (Development Workbook) 1st edition by Feuerstein, Steven; Odewahn, Andrew published by O'Reilly Media [ Paperback ]

by Steven Feuerstein, Andrew Odewahn

This workbook is a companion to Steven Feuerstein's bestselling books, Oracle PL/SQL Programming (considered the bible for PL/SQL developers), Oracle Built-in Packages, and Advanced Oracle PL/SQL: Programming with Packages. The workbook provides a carefully constructed set of exercises that test PL/SQL developers' language skills and help them become better programmers. Exercises are provided at three levels: beginner, intermediate, and advanced; in this way, the book is suitable for complete beginners, yet continues to be useful as readers gain mastery of the PL/SQL language.

The workbook exercises cover all of the major features of PL/SQL, including:

Variables and program data Conditional and sequential control and looping Database interaction and cursors Exception handling PL/SQL records and tables Functions, procedures, packages, and modular programming Object features (e.g., object types, nested tables and VARRAYs, object views, and external procedures) Debugging, tuning, and tracing features

Exercises also cover the new PL/SQL features available in Oracle8i, the "Internet database," (e.g., autonomous transactions, invoker's rights, bulk binds, and native dynamic SQL), as well as the use of Java and the Web via PL/SQL.

In addition to the exercises, the workbook provides a primer to the PL/SQL language and a collection of Feuerstein's best practices for PL/SQL programming.

Oracle PL/SQL Developer's Workbook

576 pages, Paperback

First published January 1, 2000