Contents Listing

Foreword
Preface
1. Elements of SQL
Lexical Conventions
Naming in SQL
Schema Objects
Datatypes
Data Conversion
Relational Operators
Structure of a SQL Statement
SQL Statements
2. Data Definition Statements
SQL DDL Statements by Task
SQL Statement Syntax
3. Data Manipulation and Control Statements
SQL DML and Control Statements by Task
SQL Statement Syntax
4. Common SQL Elements
5. SQL Functions
Aggregate Functions
Numeric Functions
Character Functions
Date Functions
Conversion Functions
Other Functions
6. SQL*Plus
Command-Line Syntax
SQL*Plus Editing Commands
Formatting SQL*Plus Output
Miscellaneous SQL*Plus Commands
SQL*Plus Variables and Related Commands
SQL*Plus System Variables
7. PL/SQL
The Structure of PL/SQL
Block Header
Declaration Section
Execution Section
Exception Section
Procedures and Packages
Triggers
8. SQL Statement Tuning
Using EXPLAIN PLAN
Using Oracle's SQL Trace Facility
SQL*Plus Tuning Aids
Improving Query Performance
A. SQL Resources
Index