Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

Part I Understanding SQL*Plus

1 Introduction

Overview of SQL*Plus

Basic Concepts

Who Can Use SQL*Plus

Using this Guide

Sample Tables

What You Need to Run SQL*Plus

Hardware and Software

Information Specific to Your Operating System

Username and Password

Access to Sample Tables

2 Learning SQL*Plus Basics

Starting SQL*Plus

Leaving SQL*Plus

Entering and Executing Commands

Running SQL Commands

Running PL/SQL Blocks

Running SQL*Plus Commands

Variables that Affect Running Commands

Saving Changes to the Database Automatically

Stopping a Command while it is Running

Collecting Timing Statistics on Commands You Run

Running Host Operating System Commands

Getting Help

Listing a Table Definition

Listing PL/SQL Definitions

Controlling the Display

Interpreting Error Messages

3 Manipulating Commands

Editing Commands

Listing the Buffer Contents

Editing the Current Line

Adding a New Line

Appending Text to a Line

Deleting Lines

Editing Commands with a System Editor

Saving Commands for Later Use

Storing Commands in Command Files

Placing Comments in Command Files

Retrieving Command Files

Running Command Files

Nesting Command Files

Modifying Command Files

Exiting from a Command File with a Return Code

Setting Up Your SQL*Plus Environment

Storing and Restoring SQL*Plus System Variables

Writing Interactive Commands

Defining User Variables

Using Substitution Variables

Passing Parameters through the START Command

Communicating with the User

Using Bind Variables

Creating Bind Variables

Referencing Bind Variables

Displaying Bind Variables

Using REFCURSOR Bind Variables

Tracing Statements

Controlling the Report

Execution Plan

Statistics

Tracing Parallel and Distributed Queries

4 Formatting Query Results

Formatting Columns

Changing Column Headings

Formatting NUMBER Columns

Formatting Datatypes

Copying Column Display Attributes

Listing and Resetting Column Display Attributes

Suppressing and Restoring Column Display Attributes

Printing a Line of Characters after Wrapped Column Values

Clarifying Your Report with Spacing and Summary Lines

Suppressing Duplicate Values in Break Columns

Inserting Space when a Break Column's Value Changes

Inserting Space after Every Row

Using Multiple Spacing Techniques

Listing and Removing Break Definitions

Computing Summary Lines when a Break Column's Value Changes

Computing Summary Lines at the End of the Report

Computing Multiple Summary Values and Lines

Listing and Removing COMPUTE Definitions

Defining Page and Report Titles and Dimensions

Setting the Top and Bottom Titles and Headers and Footers

Displaying the Page Number and other System-Maintained Values in Titles

Listing, Suppressing, and Restoring Page Title Definitions

Displaying Column Values in Titles

Displaying the Current Date in Titles

Setting Page Dimensions

Storing and Printing Query Results

Sending Results to a File

Sending Results to a Printer

Creating Web Reports

Creating Static Web Reports

Creating Dynamic Web Reports with CGI Scripts

Suppressing the Display of SQL*Plus Commands in Web Reports

HTML Entities

5 Database Administration

Overview

Introduction to Database Startup and Shutdown

Database Startup

Database Shutdown

Redo Log Files

ARCHIVELOG Mode

Database Recovery

6 Accessing SQL Databases

Connecting to the Default Database

Connecting to a Remote Database

Connecting to a Remote Database from within SQL*Plus

Connecting to a Remote Database as You Start SQL*Plus

Copying Data from One Database to Another

Understanding COPY Command Syntax

Controlling Treatment of the Destination Table

Interpreting the Messages that COPY Displays

Specifying Another User's Table

Copying Data between Tables on One Database

Part II Reference

7 Starting SQL*Plus and Getting Help

Starting SQL*Plus Using the SQLPLUS Command

Options

Logon

Start

Setting Up the Site Profile

Setting Up the User Profile

Receiving a Return Code

Getting Help

8 Command Reference

SQL*Plus Command Summary

@ ("at" sign)

@@ (double "at" sign)

/ (slash)

ACCEPT

APPEND

ARCHIVE LOG

ATTRIBUTE

BREAK

BTITLE

CHANGE

CLEAR

COLUMN

COMPUTE

CONNECT

COPY

DEFINE

DEL

DESCRIBE

DISCONNECT

EDIT

EXECUTE

EXIT

GET

HELP

HOST

INPUT

LIST

PASSWORD

PAUSE

PRINT

PROMPT

RECOVER

REMARK

REPFOOTER

REPHEADER

RUN

SAVE

SET

SHOW

SHUTDOWN

SPOOL

START

STARTUP

STORE

TIMING

TTITLE

UNDEFINE

VARIABLE

WHENEVER OSERROR

WHENEVER SQLERROR

A SQL*Plus Error Messages

B Release 9.0.1 Enhancements

C SQL*Plus Limits

D SQL Command List

E Security

F Obsolete SQL*Plus Commands

Glossary

Index