Oracle PL/SQL Interactive Workbook

Learn PL/SQL hands-on, through practical exercises, self-review questions and real-world answers. This book teaches all the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle PL/SQL concept, including: the basics of structured programming; PL/SQL structure and syntax; iterative control; scoping and anchored datatypes; SQL within PL/SQL; for update cursors and subprograms; stored code, triggers, security, tables, even advanced-level package and parameter passing techniques. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author. As Oracle's premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. Oracle Developers typically learn SQL before venturing in to Oracle's PL/SQL. SQL is the foundation Language on which PL/SQL is build.