TY  - BOOK
AU  - Koch,George
AU  - Muller,Robert
TI  - Oracle7: the complete reference 
SN  - 0078819199 :
U1  - 005.13 20
PY  - 1993///
CY  - Berkeley
PB  - Osborne McGraw-Hill
KW  - Oracle (Computer file)
KW  - Relational databases
N1  - 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
ER  -