Résumé
(considered the bible for PL/SQL developers), Oracle Built-in Packages, and Advanced Oracle PL/SQL:
Programming with Packages. The workbook provides a carefully constructed set of exercises that test PL/SQL
developers' language skills and help them become better programmers. Exercises are provided at three levels:
beginner, intermediate, and advanced; in this way, the book is suitable for complete beginners, yet continues to
be useful as readers gain mastery of the PL/SQL language.
The workbook exercises cover all of the major features of
PL/SQL, including:
- Variables and program data
- Conditional and sequential control and looping
- Database interaction and cursors
- Exception handling
- PL/SQL records and tables
- Functions, procedures, packages, and modular
programming
- Object features (e.g., object types, nested tables and
VARRAYs, object views, and external procedures)
- Debugging, tuning, and tracing features
Exercises also cover the new PL/SQL features available in
Oracle8i, the "Internet database," (e.g., autonomous
transactions, invoker's rights, bulk binds, and native
dynamic SQL), as well as the use of Java and the Web
via
PL/SQL.
In addition to the exercises, the workbook provides a
primer to the PL/SQL language and a collection of
Feuerstein's best practices for PL/SQL programming.
Table of contents
- 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
L'auteur - Steven Feuerstein
Steven Feuerstein is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL for DBAs, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, and several pocket reference books (all from O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and serves as a Senior Technology Advisor to Quest Software. His products include utPLSQL (an open source unit testing framework for PL/SQL) and Qnxo (active mentoring software that helps to generate, reuse, and test code. He has won numerous awards for his writing and trainings, offers a PL/SQL portal, and can be reached via email at steven@stevenfeuerstein.com. He lives in Chicago with his wife, Veva, and three cats. Two sons, Eli and Chris, orbit nearby.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Steven Feuerstein |
| Parution | 15/05/2000 |
| Nb. de pages | 640 |
| Poids | 79g |
| EAN13 | 9781565926745 |
| ISBN13 | 978-1-56592-674-5 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
