O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle PL/SQL Programming: A Developer's Workbook

Book Description

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

  1. Dedication
  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. Copyright