Congress Number: 2010927533
Perfect bind - 9x7
Easy Oracle Series
Get Started Fast with Working PL/SQL Code Examples
Retail Price $27.95 USD
/ £18.95 / $30.95 Canadian
This second edition, authored by distinguished Oracle veteran,
John Garmany, is an indispensable guide for any Oracle
professional who must quickly implement Oracle reporting.
John's decades of SQL*Plus experience come to bear in this
indispensible book. New tips and tricks have been
included in this cutting edge edition.
In this text, John Garmany leverages his ability to explain complex issues in
English into a one-of-a-kind book for PL/SQL beginners. This
book is intended
for anyone who needs to extract Oracle data and format reports.
John reveals even more secrets for quickly and easily producing stunning
reports from Oracle.
This second edition of
Easy Oracle PL/SQL provides the reader with the tools needed to create,
debug and execute PL/SQL code. The example driven methodology will
have users coding basic PL/SQL blocks by the end of the first
chapter. Each chapter builds on previous concepts, introducing
increasingly more complex PL/SQL coding, while always
focusing on readability and manageability.
Each concept is
introduced using multiple examples and each chapter has exercises
to test knowledge. With Easy Oracle PL/SQL, the incredible power
to use the Oracle Database in harmony with your application will
be at your fingertips.
* Learn PL/SQL
basics, anonymous blocks, stored procedures and functions.
* Implement Best Practices to make your code readable and
* Understand PL/SQL variable including user defined and abstract
* Learn PL/SQL language structures including if/then/else and
* Become skilled at handling exceptions.
* Learn to effectively use Cursors and Ref Cursors.
* Begin working with Collections, Arrays, and PL/SQL Tables.
* Improve performance with Bulk Collects and Loads.
* See the power of packages including creating and using
* Call PL/SQL procedures and functions from applications.
* Run PL/SQL from a script or database job.
* Learn how to use triggers to react to database events.
About the Author:
has been working as an Oracle DBA since 2002.
Table of Contents: