Oracle Database 11g: Program with PL/SQL

To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.

Includes 8 Chapters:

• Getting Started With PL/SQL
• Using DML, DDL, Cursors, Loops, and Control Structures
• Using Data Types, INDEX BY Tables, and Cursors
• Using Exceptions, Subprograms, JDeveloper, and REF Cursors
• Subprograms, Packages, and Exception Handling
• Packages, Dynamic SQL, and Coding Considerations
• Using Triggers and the PL/SQL Compiler
• PL/SQL Code and Dependency Management