iSQL*Plus Contents

iSQL*Plus User's Guide and Reference
Release 9.0.1
Part Number A88826-01

Preface

Introduction to iSQL*Plus

Configuring iSQL*Plus

The iSQL*Plus User Interface

Using iSQL*Plus

SQL*Plus Error Messages

Security

Unsupported Commands

Glossary

Index

Title and Copyright

Send Us Your Comments

Oracle9i Documentation Library

SQL and PL/SQL Commands

The above two links require an internet connection and Oracle TechNet membership.

SQL*Plus Commands

@ ("at" sign)

@@ (double "at" sign)

/ (slash)

ARCHIVE LOG

ATTRIBUTE

BREAK

BTITLE

CLEAR

COLUMN

COMPUTE

CONNECT

COPY

DEFINE

DESCRIBE

DISCONNECT

EXECUTE

HELP

LIST

PRINT

PROMPT

RECOVER

REMARK

REPFOOTER

REPHEADER

RUN

SET

SHOW

SHUTDOWN

START

STARTUP

TIMING

TTITLE

UNDEFINE

VARIABLE

WHENEVER OSERROR

WHENEVER SQLERROR

SQLPLUS SET Command Options

APPINFO   {ON|OFF|text}
ARRAYSIZE   {15|n}
AUTOCOMMIT   {ON|OFF|IMMEDIATE|n}
AUTOPRINT   {ON|OFF}
AUTORECOVERY    [ON|OFF]
AUTOTRACE    {ON|OFF|TRACE[ONLY]} [EXPLAIN] [STATISTICS]
BLOCKTERMINATOR    {.|c}
CMDSEP    {;|c|ON|OFF}
COMPATIBILITY    {V7|V8|NATIVE}
CONCAT    {.|c|ON|OFF}
COPYCOMMIT    {0|n}
COPYTYPECHECK    {ON|OFF}
DEFINE    {&|c|ON|OFF}
DESCRIBE    [DEPTH {1|n|ALL}][LINENUM {ON|OFF}][INDENT {ON|OFF}]
ECHO    {ON|OFF}
EMBEDDED    {ON|OFF}
ESCAPE    {\|c|ON|OFF}
FEEDBACK    {6|n|ON|OFF}
FLAGGER    {OFF|ENTRY |INTERMEDIATE|FULL}
HEADING    {ON|OFF}
HEADSEP    {||c|ON|OFF}
INSTANCE    [instance_path|LOCAL]
LINESIZE    {80|n}
LOBOFFSET    {n|1}
LOGSOURCE    [pathname]
LONG    {80|n}
LONGCHUNKSIZE    {80|n}
MARKUP HTML    [HEAD text] [BODY text] [TABLE text] [ENTMAP {ON|OFF}] [PREFORMAT {ON|OFF}]
NULL    text
NUMFORMAT    format
NUMWIDTH    {10|n}
PAGESIZE    {24|n}
RECSEP    {WRAPPED|EACH|OFF}
RECSEPCHAR    {_|c}
SERVEROUTPUT    {ON|OFF} [SIZE n] [FORMAT {WRAPPED | WORD WRAPPED | TRUNCATED}]
SQLCASE    {MIXED|LOWER|UPPER}
SQLPLUSCOMPATIBILITY    {x.y[.z]}
SQLTERMINATOR    {;|c|ON|OFF}
TIMING    {ON|OFF}
UNDERLINE    {-|c|ON|OFF}
VERIFY    {ON|OFF}
WRAP    {ON|OFF

Oracle

Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.