Oracle PL/SQL Programming: A Developer’s Workbook

02/21/2012 · No Responses

However excellent they are, most computer books are inherently passive–readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer’s Workbook is a different kind of animal! It’s designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you’ve learned about PL/SQL–and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you’ll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts.

The Oracle PL/SQL Developer’s Workbook is a companion to Steven Feuerstein’s bestselling Oracle PL/SQL Programming and his other PL/SQL books from O’Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer–both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds).

You’ll find chapters on:

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.

Table of Contents
Chapter 1. Declaring Variables and Naming Elements
Chapter 2. Loops
Chapter 3. Conditional and Sequential Logic
Chapter 4. Exception Handling
Chapter 5. Records
Chapter 6. Index-by Tables
Chapter 7. Nested Tables
Chapter 8. Variable Arrays
Chapter 9. Object Technology
Chapter 10. Cursors
Chapter 11. DML and Transaction Management
Chapter 12. Cursor Variables
Chapter 13. Native Dynamic SQL
Chapter 14. Procedures, Functions, and Blocks
Chapter 15. Packages
Chapter 16. Triggers
Chapter 17. Calling Functions in SQL
Chapter 18. Character Functions
Chapter 19. Date Functions
Chapter 20. Conversion, Numeric, and Miscellaneous Functions
Chapter 21. DBMS_SQL Built-in Package
Chapter 22. DBMS_PIPE Built-in Package
Chapter 23. DBMS_OUTPUT Built-in Package
Chapter 24. UTL_FILE Built-in Package
Chapter 25. DBMS_JOB Built-in Package
Chapter 26. Using Java with PL/SQL
Chapter 27. External Procedures
Chapter 28. PL/SQL Web Development
Chapter 29. Tuning PL/SQL
Chapter 30. PL/SQL for DBAs