Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introducing SQL*Plus

Overview

Basic Concepts

2 Installing SQL*Plus Help and Demonstration Tables

Installing SQL*Plus

Installing SQL*Plus Online Help

Prerequisites

Installing SQL*Plus Help

Accessing SQL*Plus Help

Accessing Demonstration Tables

3 Using SQL*Plus

Using the Command Line Interface

Using the Graphical User Interface

Using the SQL*Plus Application Window

Using the Mouse Buttons to Copy SQL Commands in the Application Window

Using the Command Keys

Using the SQL*Plus Menus

Setting Options and Values, Using the Environment Dialog

Exiting SQL*Plus

4 Operating System-Specific References

Automatic Login

TIMING Command

Interpreting Error Messages

Setting Up Your SQL*Plus Environment

Sending Results to a File

@, @@, and START Commands

HOST Command

SET NEWPAGE Command

PRODUCT_USER_PROFILE Table

A Customizing Operating System Parameters

Using the Registry

SQLPATH Parameter Description

SQLPLUS Environment Variable

Index