Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle®11g. ORACLE® 11G: PL/SQL PROGRAMMING & ORACLE® CD, 2E uses Oracle® 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle® 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle® CD make this book is an invaluable resource in preparing for the new Oracle® Certification exam or mastering the PL/SQL programming language with Oracle®.
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.
All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.
For more information about these supplements, or to obtain them, contact your Learning Consultant.
Find all of the teaching and preparation resources you need at your fingertips with this convenient all-in-one-source. The Instructor's Resource CD (IRCD) contains easy-to-access Figure Files, PowerPoint® presentations, complete syllabus, invaluable Instructor's Manual, time-saving Solutions Manual, ExamView™ testbanks and software, and Data Files.