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.
Publisher resources
Table of contents
-
Oracle PL/SQL Programming: A Developer’s Workbook
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- A Note Regarding Supplemental Files
- Preface
-
I. Problems
- 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
- 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
- About the Authors
- Colophon
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Product information
- Title: Oracle PL/SQL Programming: A Developer's Workbook
- Author(s):
- Release date: May 2000
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449324087
You might also like
book
Oracle Database 11g PL/SQL Programming Workbook
Ramp Up Your PL/SQL Programming Skills Master PL/SQL through the hands-on exercises, extensive examples, and real-world …
book
Oracle Database 12c PL/SQL Advanced Programming Techniques
Take Your PL/SQL Programming Skills to the Next Level Build robust database-centric PL/SQL applications quickly and …
book
Oracle PL/SQL Language Pocket Reference, 5th Edition
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference …
book
Oracle Advanced PL/SQL Developer Professional Guide
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book …