Share-Ebooks.com

The purpose of this book is not to teach the syntax of SQL and
PL/SQL coding, but to emphasize the concepts behind the code. Toward
this end, I’ve emphasized designing, documenting, and testing code as the most important duties of the application developer. If you
need to know syntax, look at the manual. Technique is the most
important weapon an application developer has against a dragon of a
system.

Chapter 1 is an introduction to the central concepts of database
automation. The chapter also discusses some long-term advancements that
will make database automation even more powerful. Chapter 2 is a primer
on Oracle, SQL, and PL/SQL for readers who are new to Oracle or to
those who have limited experience with the database.

Chapters 3 through 7 emphasize the concepts behind designing,
documenting, coding, and testing scripts, stored procedures, stored
functions, packages, and database triggers. Emphasis is given to
design, documentation, and testing over syntax.

Chapter 8 contains essential debugging skills for your code, with an
emphasis on the best methods to locate runtime errors and write code
that is easily debugged and maintained. Chapter 9 discusses the
packages that are provided by Oracle and presents real-world examples
of how to use these tools. Finally, Chapter 10 discusses tips and
techniques that you can use to get the best performance out of your SQL
and PL/SQL code. I’ve also included a look at some of Oracle8’s new
features, and a sample PL/SQL coding standard that can be customized
for your place of business.

Table of Contents

Chapter 1—Database Automation In The Real World
Chapter 2—The Architecture Of The Oracle Database, SQL, And PL/SQL
Chapter 3—SQL And PL/SQL Scripting
Chapter 4—Procedures
Chapter 5—Functions
Chapter 6—Packages
Chapter 7—Database Triggers
Chapter 8—Debugging
Chapter 9—Special Packages
Chapter 10—Performance Tuning

To Download this E-Book Click Here.