Teach your students how to use the PL/SQL programming language effectively as you introduce them to one of the most popular and widely used software programs in large companies: Oracle® 11g. Casteel's ORACLE 11g: PL/SQL PROGRAMMING, 2E, uses Oracle 11g to give students an overview of the PL/SQL programming language. It's the only book of its kind designed specifically for classroom use and certification preparation with instructional support resources and student assignments.
The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to writing and testing PL/SQL code. This edition also covers more advanced topics, such as dynamic SQL and compound triggers, as well as important developments in bulk processing, PL/SQL compiler features, and hiding source code.
Updates throughout reflect the latest Oracle 11g release, and figures and examples are shown in the user-friendly SQL Developer tool. The book is written from a developer's perspective to focus on the PL/SQL component of Oracle, using numerous real-world examples and a straightforward writing style. This book, and a complete instructor support package, offers the resources you need to help students prepare for the new Oracle certification exam or simply master the PL/SQL programming language with Oracle.
Table of Contents
1. Introduction to PL/SQL.
2. Basic PL/SQL Block Structures.
3. Handling Data in PL/SQL Blocks.
4. Cursors and Exception Handling.
7. PL/SQL Packages.
8. Dependencies, Privileges, and Compilation.
9. Database Triggers.
10. Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code.
A. Tables for the Brewbean's Database.
B. Oracle Installation and Using Oracle SQL Developer.
C. TOAD (Tool for Oracle Application Developers).
D. Statement Tuning.
E. SQL*Loader Utility.
F. An Introduction to Object Technology.