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