Oracle7 : the complete reference / George Koch ; Oracle7 updated by Robert Muller.

Part I
Critical Database Concept
1. Sharing knowledge and success
The Cooperative Approach
Everyone has Data
The familiar Language of Oracle
Some Common, Everyday Examples
A 100-Year-Old Example
etc

2. The dangers in a Relational Database
Is it really as easy as they say?
What are the risks
The importance of the New Vision
Codes, Abbreviations and Naming standards
How to reduce the confusion
etc

3. The Basic parts of Speech in SQL
Style
Using SQL to select Data from Tables
Select from, where, and order by
Logic and Value
Another use for where -sub queries
etc

4. Basic SQLPLUS reports and commands
Building a Simple Report
Other Features
Checking the SQLPLUS Environment
Building Blocks

5. Getting Text Information and Changing it
Data types
What is a string
Notation
Concentration (II II)
How to cut and paste strings

6. Playing the Numbers
The three classes of Number Functions
Notation
Single value Functions
Group Value Functions
List Functions

7. Dates: Then, Now, and the Difference
Date arithmetic
Round and Trunc in Date Calculations
To_Date and To_CHAR
Date in where Clauses

8. Conversion and Transformation Functions
Elementary Conversion
Specialized Conversion
Transformation Functions
Review

9. Grouping Things Together
The Use of Group by and having
View Groups
The power of views of Groups
Where, having, group by, and order by

10. When one query depends upon another.
Advanced Sub queries
Outer Joins
Union, Intersect and Minus
Restrictions on Union, Intersect, and Minus

11. Some Complex Possibilities
Creating a Complex View
Family trees and connect by

12. Building a Report in SQLPLUS
Advanced Formatting
Set termout off and set termout on
Variables in SQLPLUS
Numeric Formatting
Using mask.sql
Using buffers to save SQLPLUS commands
etc.

13. Changing Data: insert, update, and delete
Insert
Rollback, Commit, and autocommit
Delete
Update

14. Advanced use of Functions and variables
Functions in order by
Bar charts and Graphs
Using Translate
Inserting Commas in a number
Complex cut and paste.

15. Decode -Amazing Power in single word
If then else
Example: Aging Invoices
Flipping a table onto its side
Using MOD in Decode
Order by and row number
etc.

Includes Index