 |
Oracle PL/SQL Developer's Workbook
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $40.50, 38% Off!
- Mastering Oracle SQL, 2nd Edition; Sanjay Mishra, et al, $24.95, 38% Off!
- Toad Pocket Reference for Oracle, 2nd Edition; Patrick McGrath, et al, $6.95, 30% Off!
- SQL Cookbook; Anthony Molinaro, $24.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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
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
|
|
