Writing Basic SQL Statement

Restricting & Sorting Data

Single Row Functions

Displaying Data from Multiple Tables

Aggregating Data using Group Functions


Producing Readable Output with iSQL*Plus

Manipulating Data

Creating and Managing Tables

Including Constraints

Creating Views & other Database Objects

Controlling User Access

Using Set Operators

Oracle 9i Date time Functions

Enhancements to the Group BY Clause

Advanced Sub-Queries

Hierarchical Retrieval

Oracle 9i Extensions to DML and DDL Statements