The "Oracle PL/SQL Developer's Workbook" is a unique resource designed to actively engage readers in solving programming problems and applying their knowledge of PL/SQL. Whether you are a professional mechanic or a DIY enthusiast, this workbook, in companion with Steven Feuerstein's bestselling "Oracle PL/SQL Programming" and other PL/SQL books from O'Reilly, offers a carefully constructed set of problems and solutions to test your language skills and enhance your development capabilities.
Featuring exercises at beginner, intermediate, and expert levels, the workbook covers all major features of PL/SQL, including new features introduced in Oracle8i such as Java and web features, autonomous transactions, and bulk binds. The chapters include:
Basic language elements--variables, naming, loops, conditional and sequential control, exception handling, and records.
Data structures--index-by tables, nested tables, variables arrays (VARRAYs), and object technology.
Database interaction--cursors, DML and transaction management, cursor variables, and native dynamic SQL.
Program construction--procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL.
Built-in functionality--the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages.
Miscellaneous topics--using Java with PL/SQL, external programs, PL/SQL web development, tuning PL/SQL, and PL/SQL for DBAs.
Published by O'Reilly Media and authored by Steven Feuerstein and Andrew Odewahn, this workbook is an invaluable resource for anyone looking to deepen their knowledge of PL/SQL and become proficient in programming with the language.
