Oracle PL/SQLワークブック

by Steven Feuerstein

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/ 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 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, 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

Tankobon Hardcover

First published January 1, 2000