Oracle PL/SQL by Example

Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site.
In Oracle PL/SQL by Example, Third Edition, authors Benjamin Rosenzweig and Elena Silvestrova cover Oracle 10G and all the fundamentals: You'll master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packages and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records.
A free, Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates!

Contents

• Introduction
• Programming concepts
• PL/SQL concepts
• General programming langage fundamentals
• SQL in PL/SQL
• Conditional controls: IF statements
• Conditional controls: Case statements
• Error handling and built-in exceptions
• Iterative control
• Introduction to cursors
• Exceptions
• Exceptions: advanced concepts
• Procedures
• Functions
• Packages
• Advanced cursors
• Stored code
• Triggers
• Collections
• Records
• Native dynamic SQL
• oracle supplied packages
• Appendixes