Professional Oracle Programming is designed to teach programmers how to use Oracle data and data structures to build effective, robust, and scalable software applications. The book will teach developers how to leverage Oracle's strengths, both in terms of logical functionality and operations. The book assumes that the reader is an experienced developer with basic knowledge of Oracle, Java, and SQL. Since Java is the most commonly used language for Oracle database applications, all examples will be written in Java. Many of the sample applications will also employ SQL and PL/SQL extensively, reflecting the fact that SQL is the primary data access language for Oracle databases.
The book will cover all of the most recent releases of Oracle (Oracle 8 through 10g), and the vast majority of material will apply to all current releases. The book will also fully cover the programming features of the latest release, Oracle 10g, in particular, there will be chapters on the MODEL clause in SQL, the use of regular expressions, and the expression filter, all of which are new in 10g,. The Wrox companion site will provide all of the code in the book.
Chapter 1 Oracle Architecture and Storage
Chapter 2 Using SQL
Chapter 3 Handling Multiple Users
Chapter 4 Database Design Basics
Chapter 5 Oracle Security
Chapter 6 The Oracle Data Dictionary
Chapter 7 Installing Oracle
Chapter 8 Introduction to SQL
Chapter 9 Extended SQL
Chapter 10 Indexes
etc.