Pkg Oracle Developer PL SQL Prog Oracle CD

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 -- Oracle11g. ORACLE 11 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. Introduction to PL/SQL Basic PL/SQL block structures Handling data in PL/SQL blocks Cursors and exception handling Procedures Functions PL/SQL packages Dependencies, privileges, and compilation Database triggers Oracle-supplied packages, dynamic SQL, and hiding source code Appendix A : tables for the Brewbean's database Appendix B : Oracle installation and using Oracle SQL developer.