iSQL*Plus logo

Previous Page - Disabled
Previous

Next Page
Next

Table Of Contents - Disabled
Contents

Index
Index

Contents

Using iSQL*Plus

Quick Start

User Interface

Configuring iSQL*Plus

Using iSQL*Plus

Creating Dynamic Reports

iSQL*Plus Server Statistics

Security

Globalization Support

 

Copyright Information

 

SQL*Plus Readme*

SQL*Plus FAQ*

 

Oracle9i Syntax

Oracle9i Documentation Library*

SQL & PL/SQL Commands*

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*Links require internet connection to the Oracle Technology Network.

Command Syntax

@ ("at" sign)

@@ (double "at" sign)

/ (slash)

ARCHIVE LOG

ATTRIBUTE

BREAK

BTITLE

CLEAR

COLUMN

COMPUTE

CONNECT

DEFINE

DESCRIBE

DISCONNECT

EXECUTE

EXIT

HELP

LIST

PRINT

PROMPT

RECOVER

REMARK

REPFOOTER

REPHEADER

RUN

SET

SHOW

SHUTDOWN

START

STARTUP

TIMING

TTITLE

UNDEFINE

VARIABLE

WHENEVER OSERROR

WHENEVER SQLERROR

SET Command Syntax

SET APPINFO{ON|OFF|text}

SET ARRAYSIZE {15|n}

SET AUTOCOMMIT{ON|OFF|IMMEDIATE|n}

SET AUTOPRINT {ON|OFF}

SET AUTORECOVERY [ON|OFF]

SET AUTOTRACE {ON|OFF|TRACE[ONLY]} [EXPLAIN] [STATISTICS]

SET BLOCKTERMINATOR {.|c|ON|OFF}

SET CMDSEP {;|c|ON|OFF}

SET COLSEP {_|text}

SET COMPATIBILITY{V7|V8|NATIVE}

SET CONCAT {.|c|ON|OFF}

SET COPYCOMMIT {0|n}

SET COPYTYPECHECK {ON|OFF}

SET DEFINE {&|c|ON|OFF}

SET DESCRIBE [DEPTH {1|n|ALL}][LINENUM {ON|OFF}][INDENT {ON|OFF}]

SET ECHO {ON|OFF}

SET EMBEDDED {ON|OFF}

SET ESCAPE {\|c|ON|OFF}

SET FEEDBACK {6|n|ON|OFF}

SET FLAGGER {OFF|ENTRY |INTERMEDIATE|FULL}

SET HEADING {ON|OFF}

SET HEADSEP {||c|ON|OFF}

SET INSTANCE [instance_path|LOCAL]

SET LINESIZE {80|n}

SET LOBOFFSET {n|1}

SET LOGSOURCE [pathname]

SET LONG {80|n}

SET LONGCHUNKSIZE {80|n}

SET MARKUP HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text] [ENTMAP {ON|OFF}][SPOOL {ON|OFF}] [PREFORMAT {ON|OFF}]

SET NULL text

SET NUMFORMAT format

SET NUMWIDTH {10|n}

SET PAGESIZE {24|n}

SET RECSEPCHAR {_|c}

SET RECSEP {WRAPPED|EACH|OFF}

SET SERVEROUTPUT {ON|OFF} [SIZE n] [FORMAT {WRAPPED|WORD_WRAPPED|TRUNCATED}]

SET SQLCASE {MIXED|LOWER|UPPER}

SET SQLPLUSCOMPATIBILITY {x.y[.z]}

SET SQLTERMINATOR {;|c|ON|OFF}

SET TIM[NG {ON|OFF}

SET UNDERLINE {-|c|ON|OFF}

SET VERIFY {ON|OFF}

SET WRAP {ON|OFF}

Previous Page - Disabled
Previous

Next Page
Next

Table Of Contents - Disabled
Contents

Index
Index