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

Feuerstein, Steven, Odewahn, Andrew

4.12 out of 5 stars

16 ratings by Goodreads

Softcover

ISBN 10: 8173662401 ISBN 13: 9788173662409

Publisher: O'Reilly Media, 2000

This specific ISBN edition is currently not available.

0 Used

0 New

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

"synopsis" may belong to another edition of this title.