Oracle Database 11g The Complete Reference

Contents at a Glance

PART ICritical Database Concepts

1 Oracle Database 11g Architecture Options

2 Installing Oracle Database 11g and Creating a Database

3 Upgrading to Oracle Database 11g

4 Planning Oracle Applications—Approaches, Risks, and Standards

PART IISQL and SQL*Plus

5 The Basic Parts of Speech in SQL

6 Basic SQL*Plus Reports and Commands

7 Getting Text Information and Changing It

8 Searching for Regular Expressions

9 Playing the Numbers

10 Dates: Then, Now, and the Difference

11 Conversion and Transformation Functions

12 Grouping Things Together

13 When One Query Depends upon Another

14 Some Complex Possibilities

15 Changing Data: insert, update, merge, and delete

16 DECODE and CASE: if, then, and else in SQL

17 Creating and Managing ...