Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL with an easy to follow format and numerous real examples based on most commonly usedbusiness database models.
It delves deeply into new features found in Oracle Database 11g, the next incarnation of Oracle’s flagship database management system along with existing features found in Oracle Database 9i and 10g.
Sample Chapter TOC
THE TOPICS COVERED IN THE BOOK
Overview Of Oracle Database
Basics Of SQL
Working With Data
SQL Performance Tuning
Beyond The Basics
Backup, Restore And Data Loading
Scripting In Oracle
CONTENTS OF THE CD-ROM
Setup files for Oracle database 10g eXpress Edition.
Video Footage of Installing Oracle Database 10g [XE] and 11g.
Source code for examples in this book.