ORACLE SQL*Plus: An Introduction and Tutorial

Contents

1. Introduction

2. Oracle Products: An Overview

    2.1 Application Development Tools

    2.2 Database Utilities

    2.3 Connectivity Products

    2.4 Core Database Engine

3. SQL*Plus Basics

    3.1 Running SQL*Plus

    3.2 SQL*Plus Commands

    3.3 SQL*Plus Help Facilities

4. The SQL Language

    4.1 SQL Statements

    4.2 SQL Data Definition Language

    4.2.1 Create, Modify and Drop Tables, Views, Indexes and Sequences

    4.2.2 GRANT and REVOKE Statements

    4.2.3 Synonyms

    4.3 SQL Data Manipulation Language

    4.3.1 Select, Insert, Update, Delete, Commit and Rollback Data

    4.3.2 Displaying Table Metadata

    4.3.3 Oracle Pseudo-Columns

    4.3.4 Oracle SQL Functions

    4.3.5 Examples of SQL DML Statements

             Basic Select Statements

             Selecting from 2 or More Tables

             Recursive Queries and Table Aliases

             Tree Queries

             WHERE Clause Expressions

              Examples of SQL Functions

5. Advanced SQL*Plus Commands

    5.1 Editing The SQL Buffer

    5.2 Formatting SQL*Plus Output

    5.3 Saving SQL*Plus Output using the SPOOL Command

    5.4 Prompting and Accepting user Input

    5.5 Collecting Statistics On SQL Statements

    5.6 Using the ALTER SESSION Statement for Date Formats

6. Stored Procedures and Triggers

    6.1 Trigger Syntax

    6.2 Trigger Example

    6.3 Stored Procedure Example

7. Acknowledgements