Oracle Advanced PL/SQL Developer Professional Guide.

Intro -- Oracle Advanced PL/SQL Developer Professional Guide -- Table of Contents -- Oracle Advanced PL/SQL Developer Professional Guide -- Credits -- Foreword -- About the Author -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Overview of PL/SQL Programming Concepts -- PL/SQL-the procedural aspect -- My first PL/SQL program -- PL/SQL development environments -- SQL Developer -- SQL Developer-the history -- Creating a connection -- SQL Worksheet -- Executing a SQL statement -- Calling a SQL script from SQL Developer -- Creating and executing an anonymous PL/SQL block -- Debugging the PL/SQL code -- Editing and saving the scripts -- SQL*Plus -- Executing a SQL statement in SQL*Plus -- Executing an anonymous PL/SQL block -- Procedures -- Executing a procedure -- Functions -- Function-execution methods -- Restrictions on calling functions from SQL expressions -- PL/SQL packages -- Cursors-an overview -- Cursor execution cycle -- Cursor attributes -- Cursor FOR loop -- Exception handling in PL/SQL -- System-defined exceptions -- User-defined exceptions -- The RAISE_APPLICATION_ERROR procedure -- Exception propagation -- Managing database dependencies -- Displaying the direct and indirect dependencies -- Dependency metadata -- Dependency issues and enhancements -- Reviewing Oracle-supplied packages -- Summary -- Practice exercise -- 2. Designing PL/SQL Code -- Understanding cursor structures -- Cursor execution cycle -- Cursor design considerations -- Cursor design-guidelines.