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.
BENJAMIN ROSENZWEIG is an Integration Specialist at IQ Financial Systems. Prior to that he was a principal consultant for more than 3 years at Oracle Corporation in the Custom Development Department. His computer experience ranges from creating an electronic Tibetan-English Dictionary in Kathmandu, Nepal, to supporting presentations centers at Goldman Sachs and managing a trading system at TIAA-CREF. His previous Prentice Hall PTR publications include Oracle PL/SQL: The Complete Video Course and Oracle Forms Developer: The Complete Video Course.
ELENA SILVESTROVA, a senior software engineer for a prominent New York brokerage firm and securities dealer, has taught relational database programming in Columbia University's CTA program during the past four years. She studied analysis and design at Columbia University and applied mathematics at Baku State University in Azerbaijan.