Cover image for Oracle PL/SQL Programming: A Developer's Workbook

Book description

A companion to Feuerstein's other bestselling Oracle PL/SQL books, this workbook presents a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer. Three levels of exercises--beginner, intermediate, and expert--cover the full set of language features. These include variables, loops, exception handling, data structures, object technology, cursors, built-in functions and packages, PL/SQL tuning, and the new Oracle8i features (including Java and the Web).

Table of Contents

  1. Oracle PL/SQL Programming: A Developer’s Workbook
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. Preface
      1. Structure of the Developer’s Workbook
      2. About the Oracle PL/SQL Series
      3. About the Examples
      4. Conventions Used in This Book
      5. Comments and Questions
      6. Acknowledgments
    4. I. Problems
      1. 1. Declaring Variables and Naming Elements
        1. Beginner
        2. Intermediate
        3. Expert
      2. 2. Loops
        1. Beginner
        2. Intermediate
        3. Expert
      3. 3. Conditional and Sequential Logic
        1. Beginner
        2. Intermediate
        3. Expert
      4. 4. Exception Handling
        1. Beginner
        2. Intermediate
        3. Expert
      5. 5. Records
        1. Beginner
        2. Intermediate
        3. Expert
      6. 6. Index-by Tables
        1. Beginner
        2. Intermediate
        3. Expert
      7. 7. Nested Tables
        1. Beginner
        2. Intermediate
        3. Expert
      8. 8. Variable Arrays
        1. Beginner
        2. Intermediate
        3. Expert
      9. 9. Object Technology
        1. Beginner
        2. Intermediate
        3. Expert
      10. 10. Cursors
        1. Beginner
        2. Intermediate
        3. Expert
      11. 11. DML and Transaction Management
        1. Beginner
        2. Intermediate
        3. Expert
      12. 12. Cursor Variables
        1. Beginner
        2. Intermediate
        3. Expert
      13. 13. Native Dynamic SQL
        1. Beginner
        2. Intermediate
        3. Expert
      14. 14. Procedures, Functions, and Blocks
        1. Beginner
        2. Intermediate
        3. Expert
      15. 15. Packages
        1. Beginner
        2. Intermediate
        3. Expert
      16. 16. Triggers
        1. Beginner
        2. Intermediate
        3. Expert
      17. 17. Calling Functions in SQL
        1. Beginner
        2. Intermediate
        3. Expert
      18. 18. Character Functions
        1. Beginner
        2. Intermediate
        3. Expert
      19. 19. Date Functions
        1. Beginner
        2. Intermediate
        3. Expert
      20. 20. Conversion, Numeric, and Miscellaneous Functions
        1. Beginner
        2. Intermediate
        3. Expert
      21. 21. DBMS_SQL Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      22. 22. DBMS_PIPE Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      23. 23. DBMS_OUTPUT Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      24. 24. UTL_FILE Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      25. 25. DBMS_JOB Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      26. 26. Using Java with PL/SQL
        1. Beginner
        2. Intermediate
        3. Expert
      27. 27. External Procedures
        1. Beginner
        2. Intermediate
        3. Expert
      28. 28. PL/SQL Web Development
        1. Beginner
        2. Intermediate
        3. Expert
      29. 29. Tuning PL/SQL
        1. Beginner
        2. Intermediate
        3. Expert
      30. 30. PL/SQL for DBAs
        1. Beginner
        2. Intermediate
        3. Expert
    5. II. Solutions
      1. 1. Declaring Variables and Naming Elements
        1. Beginner
        2. Intermediate
        3. Expert
      2. 2. Loops
        1. Beginner
        2. Intermediate
        3. Expert
      3. 3. Conditional and Sequential Logic
        1. Beginner
        2. Intermediate
        3. Expert
      4. 4. Exception Handling
        1. Beginner
        2. Intermediate
        3. Expert
      5. 5. Records
        1. Beginner
        2. Intermediate
        3. Expert
      6. 6. Index-by Tables
        1. Beginner
        2. Intermediate
        3. Expert
      7. 7. Nested Tables
        1. Beginner
        2. Intermediate
        3. Expert
      8. 8. Variable Arrays
        1. Beginner
        2. Intermediate
        3. Expert
      9. 9. Object Technology
        1. Beginner
        2. Intermediate
        3. Expert
      10. 10. Cursors
        1. Beginner
        2. Intermediate
        3. Expert
      11. 11. DML and Transaction Management
        1. Beginner
        2. Intermediate
        3. Expert
      12. 12. Cursor Variables
        1. Beginner
        2. Intermediate
        3. Expert
      13. 13. Native Dynamic SQL
        1. Beginner
        2. Intermediate
        3. Expert
      14. 14. Procedures, Functions, and Blocks
        1. Beginner
        2. Intermediate
        3. Expert
      15. 15. Packages
        1. Beginner
        2. Intermediate
        3. Expert
      16. 16. Triggers
        1. Beginner
        2. Intermediate
        3. Expert
      17. 17. Calling Functions in SQL
        1. Beginner
        2. Intermediate
        3. Expert
      18. 18. Character Functions
        1. Beginner
        2. Intermediate
        3. Expert
      19. 19. Date Functions
        1. Beginner
        2. Intermediate
        3. Expert
      20. 20. Conversion, Numeric, and Miscellaneous Functions
        1. Beginner
        2. Intermediate
        3. Expert
      21. 21. DBMS_SQL Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      22. 22. DBMS_PIPE Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      23. 23. DBMS_OUTPUT Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      24. 24. UTL_FILE Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      25. 25. DBMS_JOB Built-in Package
        1. Beginner
        2. Intermediate
        3. Expert
      26. 26. Using Java with PL/SQL
        1. Beginner
        2. Intermediate
        3. Expert
      27. 27. External Procedures
        1. Beginner
        2. Intermediate
        3. Expert
      28. 28. PL/SQL Web Development
        1. Beginner
        2. Intermediate
        3. Expert
      29. 29. Tuning PL/SQL
        1. Beginner
        2. Intermediate
        3. Expert
      30. 30. PL/SQL for DBAs
        1. Beginner
        2. Intermediate
        3. Expert
    6. About the Authors
    7. Colophon
    8. SPECIAL OFFER: Upgrade this ebook with O’Reilly