3 Review(s)

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers. Key Features The only book on Oracle PL/SQL programming that teaches through exercises and projects Covers the new features in Oracle 11g, which was recently released Both of the authors have extensive experience in training and teaching students and employees in the use of PL/SQL Table of Contents    1. PL/SQL Concepts    2. General Programming Language    3. SQL in PL/SQL    4. Conditional Control: IF Statements    5. Conditional Control: CASE Statements    6. Iterative Control: Part I    7. Iterative Control: Part II    8. Error Handling and Built-in Exceptions    9. Exceptions   10. Exceptions: Advanced Concepts   11. Introduction to Cursors   12. Advanced Cursors   13. Triggers   14. Compound Triggers   15. Collections   16. Records   17. Native Dynamic SQL   18. Bulk SQL   19. Procedures   20. Functions   21. Packages   22. Stored Code   23. Object Types in Oracle   24. Oracle Supplied Packages