Index

A B C D E F G H I J L M N O P Q R S T U V W X

Symbols

-- (comment delimiter), 6.3.3

- (hyphen)

clause, 4.5.1.2

continuing a long SQL*Plus command, 5.6.1.1, 13

. (period), 5.5

/ (slash) command

default logon, 4.5.2, 13

entered at buffer line-number prompt, 5.4.1.2, 13

entered at command prompt, 13

executing current PL/SQL block, 5.5

similar to RUN, 13, 13

usage, 13

", 6.2, 6.2

listing all lines, 6.2

" list command, 6.2

# pound sign

overflow indication, 13

SET SQLPREFIX character, 13

$ number format, 7.1.2.2

& (ampersand)

disabling substitution variables, 6.9.4

substitution variables, 6.9

&&, 6.9.2

* (asterisk)

in DEL command, 6.2, 13

in LIST command, 6.2, 13

/*...*/ (comment delimiters), 6.3.2

: (colon)

bind variables, 6.13

:BindVariable clause

EXIT command, 13

; (semicolon), 5.4

@ ("at" sign)

command, 3.2.3.1, 6.4, 13

in CONNECT command, 13

in COPY command, B.1, B.2.1

in SQLPLUS command, 4.5

script, 6.4

similar to START, 6.4, 13, 13

@@ (double "at" sign) command, 3.2.3.1, 13

script, 13

similar to START, 13, 13

[Cancel] key, 5.8

_CONNECT_IDENTIFIER predefined variable, Preface, Preface, 3.2.2.1, 13, 13

_DATE predefined variable, 13, 13

_EDITOR predefined variable, 2.2.3.2, 6.1.1, 13, 13, 13, 13

_EDITOR substitution variable, 13

_EDITOR, in EDIT command, 6.1.1, 13, 13

_O_RELEASE predefined variable, 13, 13

_O_VERSION predefined variable, 13, 13

_PRIVILEGE predefined variable, Preface, 13, 13

_RC predefined variable, 13

_SQLPLUS_RELEASE predefined variable, 13, 13, 13

_USER predefined variable, 13, 13

~ infinity sign, 13

-~ negative infinity sign, 13

Numerics

0, number format, 7.1.2.2

9, number format, 7.1.2.2

A

ABORT mode, 13

abort query, 5.8

ACCEPT command, 6.12.1, 13, 13

and DEFINE command, 13

BINARY_DOUBLE clause, 13

BINARY_FLOAT clause, 13

customizing prompts for value, 6.12.2

DATE clause, 13

DEFAULT clause, 13

FORMAT clause, 13

HIDE clause, 13

NOPROMPT clause, 13

NUMBER clause, 6.12.2

PROMPT clause, 6.12.1, 13

access, denying and granting, 10.1

AFIEDT.BUF

See editor

alias, 4.2.2

ALIAS clause, 13, 13

in ATTRIBUTE command, 13

ALL clause, 13

ALTER command

disabling, 10.2

ampersands &(amp;)

in parameters, 6.11, 13

substitution variables, 6.9

ANALYZE command

disabling, 10.2

APPEND clause

in COPY command, B.1.1, B.2.2

in SAVE command, 13, 13

APPEND command, 6.2, 6.2.3, 13

APPINFO clause, 9.4.2, 13

Application Server

authentication, 2.3.3.2, 10.6.3

isqlplusctl utility, 4.3.4

port in use, 3.3.1

Product User Profile table, 10.6.5

starting, 4.3.4

starting the Windows service, 4.3.4

stopping, 4.3.6

test if running, 3.3.2

ARCH background process, 13

ARCHIVE LOG

command, 11.3.1, 13

mode, 11.3.1

argument

in START command, 6.11

ARRAYSIZE variable, 9.4.3, 13, 13

relationship to COPY command, B.1.2, B.2.3

ATTRIBUTE command, 13

ALIAS clause, 13

and CLEAR COLUMN command, 13

CLEAR clause, 13

clearing columns, 13, 13

controlling display characteristics, 13

display characteristics, 13

entering multiple, 13

FORMAT clause, 13

LIKE clause, 13

listing attribute display characteristics, 13, 13

OFF clause, 13

ON clause, 13

restoring column display attributes, 13

suppressing column display attributes, 13

AUDIT command

disabling, 10.2

authentication

adding username/password entries, 10.6.3

DBA access in iSQL*Plus, 10.6.2

AUTOCOMMIT variable, 5.11, 13, 13

AUTOMATIC clause, 13

AUTOPRINT variable, 13, 13

AUTORECOVERY variable, 13, 13

autotrace report, 9.1.1

AUTOTRACE variable, 9.1.1, 13, 13

B

background process

startup after abnormal termination, 13

batch mode, 13

BEGIN command, 5.5

disabling, 10.2

BINARY_DOUBLE clause

ACCEPT command, 13

VARIABLE command, 13

BINARY_FLOAT clause

ACCEPT command, 13

VARIABLE command, 13

bind variables, 6.13

creating, 13

displaying, 13

displaying automatically, 13, 13

in PL/SQL blocks, 13

in SQL statements, 13

in the COPY command, 13

blank line

in PL/SQL blocks, 5.5

in SQL commands, 5.4.1.2

preserving in SQL commands, 13, 13

blocks, PL/SQL

continuing, 5.5

editing in buffer, 6.2

editing with system editor, 6.1, 13

entering and executing, 5.5

listing current in buffer, 6.2.1

saving current, 13

setting character used to end, 13, 13

stored in SQL buffer, 5.5

timing statistics, 13

within SQL commands, 5.5.1

BLOCKTERMINATOR, 13, 13, 13, 13

BODY clause, 4.5.1.5

BODY option, 4.5.1.5

BOLD clause, 13, 13

break columns, 7.2, 13

inserting space when value changes, 7.2.2

specifying multiple, 7.2.4

suppressing duplicate values in, 7.2.1

BREAK command, 7.2, 13

and SQL ORDER BY clause, 7.2, 7.2.1, 7.2.4, 13

clearing BREAKS, 7.2.5

displaying column values in titles, 7.3.4

DUPLICATES clause, 13

inserting space after every row, 7.2.3

inserting space when break column changes, 7.2.2

listing current break definition, 7.2.5, 13

ON column clause, 7.2.1, 13

ON expr clause, 13

ON REPORT clause, 7.2.7, 13

ON ROW clause, 7.2.3, 13

printing "grand" and "sub" summaries, 7.2.7

printing summary lines at ends of reports, 7.2.7

removing definition, 13

SKIP clause, 7.2.3, 13

SKIP PAGE clause, 7.2.2, 7.2.2, 7.2.3, 13

specifying multiple break columns, 7.2.4, 13

suppressing duplicate values, 7.2.1

used in conjunction with COMPUTE, 7.2.6

used in conjunction with SET COLSEP, 13

used to format a REFCURSOR variable, 13

used with COMPUTE, 13, 13, 13, 13, 13

break definition

listing current, 7.2.5, 13

removing current, 7.2.5, 13

BREAKS clause, 7.2.5, 13

browser, web, 8.1.1

BTITLE clause, 13

BTITLE command, 7.3.1, 13

aligning title elements, 13

BOLD clause, 13

CENTER clause, 13

COL clause, 13

FORMAT clause, 13

indenting titles, 13

LEFT clause, 13

OFF clause, 13

old form, C.2

printing blank lines before bottom title, 7.3.1.1

referencing column value variable, 13

RIGHT clause, 13

SKIP clause, 13

suppressing current definition, 13

TAB clause, 13

TTITLE command, 13

buffer, 5.1.1

appending text to a line in, 6.2.3, 13

clearing your screen, 2.2.3.2

delete a single line, 6.2

delete the current line, 6.2

delete the last line, 6.2

deleting a range of lines, 6.2, 13

deleting a single line, 13

deleting all lines, 6.2, 13, 13

deleting lines from, 6.2.5, 13

deleting the current line, 13

deleting the last line, 13

executing contents, 13, 13

inserting new line in, 6.2.4, 13

listing a range of lines, 6.2, 13

listing a single line, 6.2, 13

listing all lines, 6.2, 13

listing contents, 6.2.1, 13

listing the current line, 6.2, 13

listing the last line, 6.2, 13

loading into system editor, 13

saving contents, 13

screen area, 2.2.3.4

SQL, 2.2.3.1

BUFFER clause, 6.1.1, 6.2, 13

BUFFER variable, C.5

buttons

cancel, 2.3.7.3, 2.3.8.1, 2.3.8.1, 4.1.2.6, 6.10.1.3

clear screen, 2.3.4.1

execute, 2.3.4.2

load script, 2.3.4.3

save script, 2.3.4.4

C

cancel button, 2.3.7.3, 2.3.8.1, 2.3.8.1, 4.1.2.6, 6.10.1.3

CANCEL clause, 13, 13

cancel query, 5.8

cancelling an in-progress operation, 2.2.3.1

CENTER clause, 7.3.1.1, 13, 13

CHANGE command, 6.2, 6.2.2, 13

Change Password screen, 4.1.2

CHAR clause

VARIABLE command, 13

CHAR columns

changing format, 13

default format, 7.1.3.1

definition from DESCRIBE, 13

Character Map Windows utility

choosing a font, 2.1.2.2, 2.2.4.2

CLEAR clause, 7.1.5, 13

in ATTRIBUTE command, 13

CLEAR command, 13

BREAKS clause, 7.2.5, 13

BUFFER clause, 6.1.1, 6.2, 13

COLUMNS clause, 13

COMPUTES clause, 13

SCREEN clause, 6.12.4, 13

SQL clause, 13

TIMING clause, 13

clear screen button, 2.3.4.1

clearing your screen, 2.2.3.2

client tier, 1.2, 1.3

CLOB clause

VARIABLE command, 13

CLOB columns

changing format, 13

default format, 13

setting maximum width, 13, 13

setting retrieval position, 13, 13

setting retrieval size, 9.4.7, 13, 13, 13

CLOSECURSOR variable, C.1, C.6

CMDSEP variable, 13, 13

COL clause, 7.3.1.2, 13, 13

colons (:)

bind variables, 6.13

COLSEP variable, 13, 13

COLUMN command, 7.1, 13

ALIAS clause, 13

and BREAK command, 13

and DEFINE command, 13

CLEAR clause, 7.1.5, 13, 13

DEFAULT clause, C.3

displaying column values in bottom titles, 7.3.4, 13

displaying column values in top titles, 7.3.4, 13

entering multiple, 13

ENTMAP clause, 13

FOLD_AFTER clause, 13, 13, 13

FOLD_BEFORE clause, 13, 13

FORMAT clause, 7.1.2.2, 7.1.3.2, 13, 13

formatting a REFCURSOR variable, 13

formatting NUMBER columns, 7.1.2.1, 13

HEADING clause, 7.1.1.2, 13, 13

HEADSEP character, 13

JUSTIFY clause, 13

LIKE clause, 7.1.4, 13, 13

listing column display attributes, 7.1.5, 7.1.5, 13, 13

NEW_VALUE clause, 7.3.4, 13, 13

NEWLINE clause, 13, 13

NOPRINT clause, 7.3.4, 9.4.1, 13

NULL clause, 13, 13

OFF clause, 7.1.6, 13

OLD_VALUE clause, 7.3.4, 13, 13

ON clause, 7.1.6, 13

PRINT clause, 13

resetting a column to default display, C.1

resetting to default display, 7.1.5, 13, C.1

restoring column display attributes, 7.1.6, 13

storing current date in variable for titles, 13

suppressing column display attributes, 7.1.6, 13

TRUNCATED clause, 7.1.3.2, 13

WORD_WRAPPED clause, 7.1.3.2, 7.1.7, 13

WRAPPED clause, 7.1.3.2, 13

column headings

aligning, 13

changing, 7.1.1.1, 13

changing character used to underline, 13, 13

changing to two or more words, 7.1.1.2, 13

displaying on more than one line, 7.1.1.2, 13

suppressing printing in a report, 13, 13

when truncated, 13

when truncated for CHAR and LONG columns, 7.1.3.2

when truncated for DATE columns, 7.1.3.2

when truncated for NUMBER columns, 7.1.2.1

column separator, 13, 13, C.1

columns

assigning aliases, 13

computing summary lines, 7.2.6, 13

copying display attributes, 7.1.4, 13, 13

copying values between tables, B.1, B.2, B.3

displaying values in bottom titles, 7.3.4, 13

displaying values in top titles, 7.3.4, 13

formatting CHAR, VARCHAR, LONG, and DATE, 13

formatting in reports, 7.1, 13

formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 13

formatting NUMBER, 7.1.2.1, 13

listing display attributes for all, 7.1.5, 13

listing display attributes for one, 7.1.5, 13

names in destination table when copying, B.1.1, B.2.1

printing line after values that overflow, 7.1.7, 13, 13

resetting a column to default display, 7.1.5, 13, C.1, C.1

resetting all columns to default display, 13

restoring display attributes, 7.1.6, 13, 13

setting printing to off or on, 7.3.4, 9.4.1, 13

starting new lines, 13

storing values in variables, 7.3.4, 13

suppressing display attributes, 7.1.6, 13, 13

truncating display for all when value overflows, 7.1.3.2, 13

truncating display for one when value overflows, 7.1.3.2, 13

wrapping display for all when value overflows, 7.1.3.2, 13

wrapping display for one when value overflows, 7.1.3.2, 13

wrapping whole words for one, 7.1.7

COLUMNS clause, 13

comma, number format, 7.1.2.2

command files

aborting and exiting with a return code, 6.6, 13, 13, 13

creating with a system editor, 6.1.1

creating with SAVE, 13, 13

editing with system editor, 13

in @ ("at" sign) command, 6.4, 13

in EDIT command, 13

in GET command, 13

in SAVE command, 6.1.1, 13

in SQLPLUS command, 4.5.3, 6.4.1

in START command, 6.4, 13

including comments in, 6.3, 13

including more than one PL/SQL block, 6.1.1

including more than one SQL command, 6.1.1

nesting, 6.5

opening, 2.2.3.1

passing parameters to, 6.11, 13

registering, 13, 13

retrieving, 13

running, 6.4, 13, 13

running a series in sequence, 6.5

running as you start SQL*Plus, 4.5.3, 6.4.1

running in batch mode, 6.6, 13

saving, 2.2.3.1

uniform resource locator, 13, 13, 13

command keys, SQL*Plus Windows GUI, 2.2.2

command prompt

SET SQLPROMPT, 9.4.10, 13, 13

SQL*Plus, 4.3.1

command-line

configuring globalization support, 12.1

command-line interface

changing face and size, 2.1.2

Euro sign, 2.1.2.2

special character, 2.1.2.2

Windows Character Map utility, 2.1.2.2

commands

collecting timing statistics on, 9.2, 13

copying text, 2.2.1

disabled in schema, 14.1

disabling, 10.2

echo on screen, 13

finding text, 2.2.3.3

host, running from SQL*Plus, 5.9, 13

listing current in buffer, 13

pasting text, 2.2.3.2

re-enabling, 10.2

spaces, 5.1

SQL

continuing on additional lines, 5.4.1.1

editing in buffer, 6.2

editing with system editor, 13

ending, 5.4.1.2

entering and executing, 5.4

entering without executing, 5.4.1.2

executing current, 13, 13

following syntax, 5.4.1

listing current in buffer, 6.2.1

saving current, 13

setting character used to end and run, 13

SQL*Plus

continuing on additional lines, 5.6.1.1, 13

ending, 5.6.1, 13

entering and executing, 5.6

entering during SQL command entry, 13

obsolete command alternatives, C.1

stopping while running, 5.8

tabs, 5.1

types of, 5.1

variables that affect running, 5.7

comments

including in command files, C.1

including in scripts, 6.3, 13, C.1

using -- to create, 6.3.3

using /*...*/ to create, 6.3.2

using REMARK, C.1

using REMARK to create, 6.3.1, 13, C.1

COMMIT clause, 13

WHENEVER OSERROR, 13

WHENEVER SQLERROR, 13

COMMIT command, 5.11

communication between tiers, 1.2.2, 1.3.3

COMPATIBILITY variable, 13, 13

compilation errors, 5.5.1, 13, 14.1

COMPUTE command, 7.2, 13

computing a summary on different columns, 7.2.8

LABEL clause, 7.2.6, 7.2.7, 13

listing all definitions, 7.2.9, 13

maximum LABEL length, 13

OF clause, 7.2.6

ON, 13

ON column clause, 7.2.6, 13

ON expr clause, 13

ON REPORT clause, 7.2.7, 13

printing "grand" and "sub" summaries, 7.2.7

printing multiple summaries on same column, 7.2.8

printing summary lines at ends of reports, 7.2.7

printing summary lines on a break, 7.2.6

referencing a SELECT expression in OF, 13

referencing a SELECT expression in ON, 13

removing definitions, 7.2.9, 13

used to format a REFCURSOR variable, 13

COMPUTES clause, 13

CONCAT variable, 6.9.4, 6.9.4, 13, 13, 13, 13

configuration

globalization support

configuration parameter

iSQLPlusAllowUserMarkup, 3.1

iSQLPlusConnectIdList, 3.1

log4j.rootLogger, 3.1

configuring

cookies for iSQL*Plus, 3.4

javascript for iSQL*Plus, 3.4

Oracle Net, 3.2.4

SQL*Plus, 3

Windows GUI, 3.5

CONNECT command, 4.1, 13

and @ ("at" sign), 13

changing password, 13, 13, 13

SYSDBA clause, 4.5.2, 13, 13

SYSOPER clause, 4.5.2, 13

username/password, 13

connect identifier, 13

field, 2.3.2.3, 2.3.3.5

in CONNECT command, 13

in COPY command, B.1

in DESCRIBE command, 13

in SQLPLUS command, 4.5.2

connect port conflict, 3.3.1

connect string

See connection identifier

connection identifier, 4.2.1, 4.3.3.1

easy or abbreviated, 4.2.3

full, 4.2.2

net service name, 4.2.2

CONTINUE clause

WHENEVER OSERROR, 13

WHENEVER SQLERROR, 13

continuing a long SQL*Plus command, 5.6.1.1, 13

cookies, configuring for iSQL*Plus, 3.4

COPY command, 13, B.1, B.2

and @ ("at" sign), B.1, B.2.1

and ARRAYSIZE variable, B.1.2, B.2.3

and COPYCOMMIT variable, B.1.2, B.2.3

and LONG variable, B.1.2, B.2.3

APPEND clause, B.1.1, B.2.2

copying data between databases, B.2

copying data between tables on one database, B.3

CREATE clause, B.1.1, B.2.2

creating a table, B.1.1, B.2.2, B.2.2

destination table, B.1.1, B.2.1

determining actions, B.2.1

determining source rows and columns, B.1.1, B.2.1

error messages, 14.3

FROM clause, B.2.1

INSERT clause, B.1.1, B.2.2

inserting data in a table, B.1.1, B.2.2, B.2.2

interpreting messages, B.2.3

mandatory connect identifier, B.1.1

naming the source table with SELECT, B.1.1, B.2.1

query, B.1.1, B.2.1

referring to another user's table, B.2.4

REPLACE clause, B.1.1, B.2.2

replacing data in a table, B.1.1, B.2.2

sample command, B.2.1, B.2.1

service name, B.2.1, B.2.2, B.3

specifying columns for destination, B.1.1, B.2.1

specifying the data to copy, B.1.1, B.2.1

TO clause, B.2.1

username/password, B.1.1, B.2.1, B.2.2, B.3

USING clause, B.1.1, B.2.1

COPYCOMMIT variable, 13, 13

relationship to COPY command, B.1.2, B.2.3

copying text, 2.2.1, 2.2.3.2

COPYTYPECHECK variable, 13, 13

CREATE clause

in COPY command, B.1.1, B.2.2

CREATE command

disabling, 10.2

entering PL/SQL, 5.5.1

creating a PLAN_TABLE, 9.1.1

creating flat files, 7.4.1

creating PLUSTRACE role, 9.1.1

creating sample tables, 1.8.1

creating the PRODUCT_USER_PROFILE table, 10.1.1

cursor variables, 13

D

database

administrator, 11.1

connect identifier, 13

mounting, 13, 13

opening, 13, 13

database changes, saving automatically, 13, 13

DATABASE clause, 13

database files

recovering, 13

database name at startup, 13

database schema, 9.1.1

default, 13

DESCRIBE parameter, 13

SHOW, 13, 13

database tier, 1.3, 1.3

databases

connecting to default, 13

connecting to remote, 13

copying data between, B.1, B.2

copying data between tables on a single, B.3

disconnecting without leaving SQL*Plus, 4.1, 13

mounting, 11.2.1

opening, 11.2.1, 11.2.1

recovering, 11.4, 13

shutting down, 11.2, 11.2.2

starting, 11.2

DATAFILE clause, 13

DATE

column definition from DESCRIBE, 13

DATE clause, 13

DATE columns

changing format, 13, 13

default format, 7.1.3.1

date, storing current in variable for titles, 7.3.5, 13, 13

DB2, 13, 13

DBA, 11.1

connections, 3.3.6

DBA Login screen, 2.3.3

DBA Workspace, 2.3.5

iSQL*Plus access, 10.6.2

mode, 13

privilege, 2.3.3, 13

DBMS output, 9.4.9, 13

DBMS_APPLICATION_INFO package, 9.4.2, 13, 13

DECLARE command

disabling, 10.2

PL/SQL, 5.5

DEFAULT clause, 13

default port conflict, 3.3.1

DEFINE command, 6.7, 13

and system editor, 6.1.1, 13

and UNDEFINE command, 6.7, 13

CHAR values, 13

SET DEFINE ON|OFF, 13, 13

substitution variables, 13

DEFINE variable

See substitution variable

DEL command, 6.2, 6.2.5, 13

using an asterisk, 6.2, 13

DELETE command

disabling, 10.2

DESCRIBE command (SQL*Plus), 5.2, 13

connect_identifier, 13

PL/SQL properties listed by, 13

table properties listed by, 13

DISABLED keyword, disabling commands, 10.1.3

disabling

iSQL*Plus, 3.3.8

PL/SQL commands, 10.2

SQL commands, 10.2

SQL*Plus commands, 10.2

DISCONNECT command, 4.1, 13

DOCUMENT command, C.1, C.4

REMARK as newer version of, C.4, C.4

DOCUMENT variable, C.1, C.7

DROP command

disabling, 10.2

DUPLICATES clause, 13

dynamic reports, creating, 8.2

E

ECHO

SET command, 13

ECHO variable, 6.4, 13, 13

Ed on UNIX, 13

EDIT command, 6.1.1, 13, 13, 13

creating scripts with, 6.1.1

defining _EDITOR, 13

modifying scripts, 13

setting default file name, 13, 13

Edit menu, 2.2.3.2

EDITFILE variable, 13, 13

editor

defining, 2.2.3.2

invoking, 2.2.3.2

registry entries, 3.5.2.1

EDITOR operating system variable, 13

EMBEDDED variable, 13, 13

enabling iSQL*Plus, 3.3.8

Enter statements field, 2.3.6.1, 2.3.6.1, 2.3.6.2, 2.3.6.3

entities, HTML, 8.1.3

ENTMAP, 4.5.1.5

ENTMAP clause, 4.5.1.5, 8.1.3, 13

environment variables

iSQL*Plus, 3.1

LD_LIBRARY_PATH, 3.1

LOCAL, 3.1

NLS_LANG, 3.1

ORA_NLS10, 3.1

ORACLE_HOME, 3.1

ORACLE_PATH, 3.1

ORACLE_SID, 3.1

PATH, 3.1

SQL*Plus, 3.1

SQLPATH, 3.1

SQLPLUS, 3.1

TNS_ADMIN, 3.1

TWO_TASK, 3.1

error messages

COPY command, 14.3

interpreting, 5.12

iSQL*Plus, 14.2

sqlplus, 14.1

errors

compilation errors, 5.5.1, 13, 14.1

making line containing current, 6.2.2

escape characters, definition of, 13, 13

ESCAPE variable, 6.9.4, 13, 13

Euro sign

command-line interface, 2.1.2.2

GUI, 2.2.4, 2.2.4.2

example

interactive HTML report, 8.1.1, 8.1.1

execute button, 2.3.4.2

EXECUTE command, 13

executing

a CREATE command, 5.5.1

statements, 5.1.2

executing scripts

See running

execution plan, 9.1.2

execution statistics

including in report, 13

EXIT clause

WHENEVER OSERROR, 13

WHENEVER SQLERROR, 13

EXIT command, 4.4.1, 4.4.2, 13

:BindVariable clause, 13

COMMIT clause, 13

FAILURE clause, 13

in a script, 13

ROLLBACK clause, 13

use with SET MARKUP, 8.1.1

WARNING clause, 13

exit, conditional, 13

exiting

iSQL*Plus, Preface, 4.4.3

SQL*Plus GUI, 2.2.3.1

Expired Password screen, 4.1.4

extension, 13, 13, 13

F

FAILURE clause, 13

FEEDBACK variable, 13, 13

fields

connection identifier, 2.3.2.3, 2.3.3.5

enter statements, 2.3.6.1, 2.3.6.1, 2.3.6.2, 2.3.6.3

new password, 4.1.2.3

password, 2.3.2.2, 2.3.3.4

privilege, 2.3.3.6

script location, 2.3.8.4

username, 2.3.2.1, 2.3.3.3, 4.1.2.1

file extensions, 3.2.3, 13, 13, 13

File menu, 2.2.3.1

file names

in @@ (double "at" sign) command, 13

in EDIT command, 13

in GET command, 13

in SAVE command, 13

in SPOOL command, 7.4.2, 13

in SQLPLUS command, 4.5.3

files

flat, 7.4.1

finding text, 2.2.3.3

FLAGGER variable, 13, 13

flat file, 7.4.1

FLUSH variable, 9.4.5, 13, 13

FOLD_AFTER clause, 13

FOLD_BEFORE clause, 13

font

changing face and size in command-line, 2.1.2

changing face and size in GUI, 2.2.4, 2.2.4.1

changing in GUI, 2.2.4

euro sign in command-line, 2.1.2.2

fixed pitch TrueType, 2.2.4

Oracle Database home, 2.2.4.1

setting default in GUI, 3.5.2.3

setting default size in GUI, 3.5.2.4

special character in command-line, 2.1.2.2

Windows Character Map utility, 2.1.2.2

footers

aligning elements, 13

displaying at bottom of page, 13

displaying system-maintained values, 13

formatting elements, 13

indenting, 13

listing current definition, 13

setting at the end of reports, 7.3

suppressing definition, 13

FORCE clause, 13

FORMAT clause, 13, 13

in ATTRIBUTE command, 13

in COLUMN command, 7.1.2.2, 7.1.3.2

in REPHEADER and REPFOOTER commands, 13

in TTITLE and BTITLE commands, 7.3.2, 13

format models, number, 7.1.2.2, 13

formfeed, to begin a new page, 7.3.6, 13

FROM clause, 13, B.2.1

G

GET command, 13

LIST clause, 13

NOLIST clause, 13

retrieving scripts, 13

globalization support

Oracle10g, 12.4

glogin

profile, 13

See also login.sql

site profile, Preface, Preface, 3.2, 3.2.1, 3.2.2.1, 4.5.1.7, 9.1.2, 9.3, 10.6.5, 13, 13

GRANT command, 10.1

disabling, 10.2

graphical user interface

See GUI

GUI

changing face and size, 2.2.4, 2.2.4.1

changing font, 2.2.4

menus, 2.2.3

Windows Character Map utility, 2.2.4.2

H

HEAD clause, 4.5.1.5

HEAD option, 4.5.1.5

headers

aligning elements, 7.3.1.1

displaying at top of page, 13

displaying system-maintained values, 13

setting at the start of reports, 7.3

suppressing, 7.3.1

HEADING clause, 7.1.1.2, 13

HEADING variable, 13

headings

aligning elements, 13

column headings, 13

formatting elements, 13

indenting, 13

listing current definition, 13

suppressing definition, 13

HEADSEP variable, 13, 13

use in COLUMN command, 7.1.1.2

help

enabling or disabling iSQL*Plus help, 3.3.8

iSQL*Plus online, 4.3.10

menu, 2.2.3.5

online, 4.3.2, 13

HELP command, ? command, 13

HIDE clause, 13

History screen, 2.3.6

HOST command, 5.9, 13

host string, 4.3.3.1

HTML, 8.1.1

clause, 4.5.1.5

entities, 3.3.9, 8.1.3

option, 4.5.1.5

running dynamic reports, 8.2

spooling to file, 4.5.1.5

tag, 8.1

HTTP

Application Server authentication, 10.6.3

HTTPS security, 10.6

security, 10.6

hyphen

continuing a long SQL*Plus command, 5.6.1.1, 13

I

IMMEDIATE mode, 13

infinity sign (~), 13

initialization parameters

displaying, 13

INIT.ORA file

parameter file, 13

input

accepting [Return], 6.12.3

accepting values from the user, 6.12.1, 13

INPUT command, 6.2, 6.2.4, 13

entering several lines, 13

INSERT clause, B.1.1, B.2.2

INSERT command

disabling, 10.2

INSTANCE variable, 13, 13

instances

shutting down, 13

starting, 13

iSQL*Plus

access modes, 10.6.2

Application Server running, 3.3.2

Change Password screen, 4.1.2

configuring Oracle Net, 3.2.4

DBA Login screen, 2.3.3

dynamic reports, 8.2

enabling cookies, 3.4

enabling javascript, 3.4

enabling or disabling, 3.3.8

enabling or disabling iSQL*Plus help, 3.3.8

enabling restricted database access, 3.3.5

environment variables, 3.1

error messages, 14.2

exiting, Preface, 4.4.3

Expired Password screen, 4.1.4

History screen, 2.3.6

language support, 4.3.10

logging, 3.3.3

online help, 4.3.10

port conflict, 3.3.1

Preferences screen, 2.3.8

retained session settings, 3.4.1

security, 10.6, 10.6

session-timeout, 3.3.4

setting up SSL, 3.3.7

starting, 4.3.4, 4.3.4, 4.3.9

starting from a URL, 4.3.9

stopping, 4.3.6

substitution variables, 6.10

three-tier model, 1.3

user access, 10.6.2

user interface, 1.2, 1.2.1, 1.3.1

Workspace, 2.3.4

iSQL*Plus DBA URL, 3.3.6

iSQLPlusAllowUserMarkup

configuration parameter, 3.1, 3.3.9

iSQLPlusConnectIdList

configuration parameter, 3.1, 3.3.5

isqlplusctl

starting Application Server, 4.3.4

J

JAAS, 3.3.6

Japanese

Java Authentication and Authorization Service (JAAS), 3.3.6

Java AuthoriZatioN (JAZN), 3.3.6

javascript, configuring for iSQL*Plus, 3.4

JAZN, 3.3.6

JUSTIFY clause, 13, 13

L

LABEL variable

SHOW command, C.1, C.12

labels

in COMPUTE command, 7.2.6, 13

language support in iSQL*Plus, 4.3.10

LD_LIBRARY_PATH

environment variables, 3.1

LEFT clause, 7.3.1.1, 13, 13

LIKE clause, 7.1.4, 13, 13

limits, SQL*Plus, A

line numbers, for SQL commands, 5.4

lines

adding at beginning of buffer, 13

adding at end of buffer, 13

adding new after current, 6.2.4, 13

appending text to, 6.2.3, 13

changing width, 7.3.6, 9.4.6, 13, 13

deleting all in buffer, 13

deleting from buffer, 6.2.5, 13

determining which is current, 6.2.2

editing current, 6.2.2

listing all in buffer, 6.2, 13

removing blanks at end, 13

LINESIZE variable, 7.3.1.1, 7.3.6, 13, 13

LIST clause, 13, 13

LIST command, 6.2, 13

determining current line, 6.2.2, 13

making last line current, 6.2.2, 13

using an asterisk, 6.2, 13

LNO clause, 13

load script button, 2.3.4.3

LOBOFFSET variable, 13, 13

LOCAL

environment variables, 3.1

LOCK TABLE command

disabling, 10.2

Log On dialog, 4.3.3.1

LOG_ARCHIVE_DEST parameter, 13

log4j.rootLogger, 3.3.3

configuration parameter, 3.1

LOGFILE clause, 13

logging, 3.3.3

logging off

conditionally, 13, 13

Oracle Database, 4.1, 13

SQL*Plus, 4.4.1, 13

logging on

Oracle Database, 13

SQL*Plus, 4.3.1

user profile

See glogin.sql

Logout, Preface, 4.4.3

LONG

column definition from DESCRIBE, 13

LONG columns

changing format, 13

default format, 13

setting maximum width, 13, 13, 13

setting retrieval size, 9.4.7, 9.4.7, 13, 13, 13

LONG variable, 13, 13

effect on COPY command, B.1.2, B.2.3

LONGCHUNKSIZE variable, 7.1.3.1, 13, 13, 13, 13, 13

LONGRAW

column definition from DESCRIBE, 13

M

-MARKUP, 4.5.1.5, 4.5.1.5, 8.1, 8.1, 13, 13

BODY clause, 4.5.1.5

ENTMAP clause, 4.5.1.5

HEAD clause, 4.5.1.5

PREFORMAT clause, 4.5.1.5

SQLPLUS command clause, 4.5.1.5

TABLE clause, 4.5.1.5

MAXDATA variable, C.1, C.8

media recovery, 13

menus, Windows GUI, 2.2.3

message logging, 3.3.3

message, sending to screen, 6.12.1, 13

middle tier, 1.3

MOUNT clause, 13

mounting a database, 13

mouse, using to copy command, 2.2.1

multiple Oracle Database homes, specifying font, 2.2.4.1

N

national language support

See also globalization support

NCHAR clause

VARIABLE command, 13

NCHAR columns

changing format, 13

default format, 7.1.3.1, 7.1.3.1, 13

NCLOB clause

VARIABLE command, 13

NCLOB columns

changing format, 13

default format, 13

setting maximum width, 13, 13

setting retrieval position, 13, 13

setting retrieval size, 9.4.7, 13, 13, 13

negative infinity sign (-~), 13

net service name, 4.2.1, 4.2.2

See also connection identifier

new password field, 4.1.2.3

NEW_VALUE clause, 7.3.4, 13

storing current date in variable for titles, 13

NEWLINE clause, 13

NEWPAGE command, C.1

NEWPAGE variable, 7.3.6, 13, 13

NEXT clause, 13

NLS

NLS_DATE_FORMAT, 13, 13

NLS_LANG

environment variables, 3.1

NOAUDIT command

disabling, 10.2

NOLIST clause, 13

NOLOG, 4.2.4, 4.5.2

NOMOUNT clause, 13

NONE clause

WHENEVER OSERROR, 13

WHENEVER SQLERROR, 13

NOPARALLEL clause, 13

NOPRINT clause, 7.2.6, 7.3.4, 9.4.1, 13

NOPROMPT clause, 13

NORMAL mode, 13

Notepad on Windows, 13

NULL clause, 13

null values

setting text displayed, 13, 13, 13

NULL variable, 13, 13

NUMBER

column definition from DESCRIBE, 13

NUMBER clause, 6.12.2

VARIABLE command, 13

NUMBER columns

changing format, 7.1.2.1, 13

default format, 7.1.2.1, 13

number formats

$, 7.1.2.2

0, 7.1.2.2

9, 7.1.2.2

comma, 7.1.2.2

setting default, 6.9.4, 6.9.4, 13, 13

NUMFORMAT clause

in LOGIN.SQL, 3.2.2.1

NUMFORMAT variable, 13, 13

NUMWIDTH variable, 13, 13

effect on NUMBER column format, 7.1.2.1, 13

NVARCHAR2 columns

changing format, 13

default format, 7.1.3.1, 13

O

objects, describing, 13

obsolete commands

BTITLE, C.2

COLUMN command DEFAULT clause, C.3

DOCUMENT, C.1, C.4

NEWPAGE, C.1

SET command BUFFER variable, C.5

SET command CLOSECURSOR variable, C.1, C.6

SET command DOCUMENT variable, C.1, C.7

SET command MAXDATA variable, C.1, C.8

SET command SCAN variable, C.1, C.9

SET command SPACE variable, C.1, C.10

SET command TRUNCATE variable, C.1, C.11

SHOW command LABEL variable, C.1, C.12

TTITLE command old form, C.13

OF clause, 7.2.6

OFF clause, 13

in ATTRIBUTE command, 13

in COLUMN command, 7.1.6, 13

in REPFOOTER commands, 13

in REPHEADER commands, 13

in SPOOL command, 7.4, 13

in TTITLE and BTITLE commands, 7.3.3, 13

OLD_VALUE clause, 7.3.4, 13

ON clause

in ATTRIBUTE command, 13

in COLUMN command, 7.1.6, 13

in TTITLE and BTITLE commands, 7.3.3

ON column clause

in BREAK command, 13

in COMPUTE command, 7.2.6, 13

ON expr clause

in BREAK command, 13

in COMPUTE command, 13

ON REPORT clause

in BREAK command, 7.2.7, 13

in COMPUTE command, 7.2.7, 13

ON ROW clause

in BREAK command, 7.2.3, 13

in COMPUTE command, 13

online help, 4.3.2, 4.3.2, 13

OPEN clause, 13

opening a database, 13

operating system

editor, 6.1.1, 13, 13

file, loading into buffer, 13

running commands from SQL*Plus, 5.9, 13

text editor, 6.1.1

Options menu, 2.2.3.4

ORA_NLS10

environment variables, 3.1

Oracle Database home

specifying font, 2.2.4.1

Oracle Net, 1.3, 3.3.7.5, 10.6

configuring, 3.2.4

connect identifier, 13

security, 10.6

ORACLE_HOME

environment variables, 3.1

ORACLE_PATH

environment variables, 3.1

ORACLE_SID

environment variables, 3.1

Oracle10g, 1.3

globalization support, 12.4

ORDER BY clause

displaying column values in titles, 7.3.4

displaying values together in output, 7.2

OUT clause, 7.4.3, 13

output

formatting white space in, 9.4.11, 13

pausing during display, 5.10, 13

P

PAGE clause, 13

page number, including in titles, 7.2.4, 7.3.2

pages

changing length, 7.3.6, 9.4.8, 13, 13

default dimensions, 7.3.6

matching to screen or paper size, 7.3.6

setting dimensions, 7.3.6

PAGESIZE clause

in LOGIN.SQL, 3.2.2.1

PAGESIZE variable, 5.4, 7.3.6, 9.4.8, 13, 13

parameter, 6.11, 13

iSQL*Plus session-timeout, 3.3.4

iSQLPlusAllowUserMarkup, 3.3.9

SQLPATH, 3.5.2.2

SQLPLUS_FONT, 2.2.4, 3.5.2.3

SQLPLUS_FONT_SIZE, 2.2.4, 2.2.4, 3.5.2.4

parameter files (INIT.ORA files)

specifying alternate, 13

PARAMETERS clause, 13

password

Application Server authentication, 2.3.3.2

changing in iSQL*Plus, 4.1.2, 4.1.4

changing with the PASSWORD command, 13

field, 2.3.2.2, 2.3.3.4

in CONNECT command, 4.1, 13

in COPY command, B.2.1, B.2.2, B.3

in SQLPLUS command, 4.3.1, 4.5.2

viewable warning, 4.5.2

PASSWORD command, 13, 13

pasting text, 2.2.3.2

PATH

environment variables, 3.1

PAUSE command, 6.12.3, 13

PAUSE variable, 5.10, 13, 13

performance

of SQL statements, 9.1

over dial-up lines, 13

period (.)

terminating PL/SQL blocks, 5.5, 13, 13

PLAN_TABLE

creating, 9.1.1

table, 9.1.1

PL/SQL, 5.5

blocks, PL/SQL, 5.5

executing, 13

formatting output in SQL*Plus, 13

listing definitions, 5.3

mode in SQL*Plus, 5.5.1

within SQL commands, 5.5.1

PLUSTRACE

creating role, 9.1.1

role, 9.1.1

PNO clause, 13

port conflict, 3.3.1

pound sign (#), 13

predefined variable

_CONNECT_IDENTIFIER, Preface, Preface, 3.2.2.1, 13, 13

_DATE, 13, 13

_EDITOR, 2.2.3.2, 6.1.1, 13, 13, 13, 13

_O_RELEASE, 13, 13

_O_VERSION, 13, 13

_PRIVILEGE, Preface, 13, 13

_RC, 13

_SQLPLUS_RELEASE, 13, 13, 13

_USER, 13, 13

Preferences screen, 2.3.8

PREFORMAT, 4.5.1.5

PREFORMAT clause, 4.5.1.5

PRINT clause, 13

PRINT command, 13

printing

bind variables automatically, 13

REFCURSOR variables, 13

SPOOL command, 13

privileges

list, 2.3.3.6

Product User Profile table, 10.1, 10.6.5

prompt

SET SQLPROMPT, 9.4.10, 13, 13

PROMPT clause, 6.12.1, 13

PROMPT command, 6.12.1, 13

customizing prompts for value, 6.12.2

prompts for value

bypassing with parameters, 6.11

customizing, 6.12.2

through ACCEPT, 6.12.1

through substitution variables, 6.9.1

PUPBLD.SQL, 10.1.1

Q

queries

in COPY command, B.1.1, B.2.1

show number of records retrieved, 5.4, 13, 13

tracing, 9.3

query execution path

including in report, 13

query results

displaying on-screen, 5.4

sending to a printer, 7.4.3, 13

storing in a file, 7.4.2, 13

QUIT command, 13

See also EXIT

R

RAW

column definition from DESCRIBE, 13

record separators, printing, 7.1.7, 13, 13

RECOVER clause, 13

RECOVER command, 13

and database recovery, 11.4

AUTOMATIC clause, 13

CANCEL clause, 13, 13

CONTINUE clause, 13

DATABASE clause, 13

FROM clause, 13

LOGFILE clause, 13

NOPARALLEL clause, 13

STANDBY DATABASE clause, 13

STANDBY DATAFILE clause, 13

STANDBY TABLESPACE clause, 13, 13

UNTIL CANCEL clause, 13

UNTIL CONTROLFILE clause, 13

UNTIL TIME clause, 13

USING BACKUP CONTROL FILE clause, 13

recovery

RECOVER command, 13

RECSEP variable, 7.1.7, 13, 13

RECSEPCHAR variable, 7.1.7, 13, 13

redo Log Files

ARCHIVE LOG command, 13

REFCURSOR bind variables

in a stored function, 6.14

REFCURSOR clause

VARIABLE command, 13

REGEDIT.EXE, 3.5.2.1

REGEDT32.EXE, 3.5.2.1

registry

editor, 2.2.4, 3.5.2.1, 3.5.2.2, 3.5.2.3, 3.5.2.4

REGEDIT.EXE, 3.5.2.1

REGEDT32.EXE, 3.5.2.1

registry entry

SQLPATH, 3.1, 3.5.2.2

SQLPLUS_FONT, 2.2.4, 3.1, 3.5.2.3

SQLPLUS_FONT_SIZE, 2.2.4, 2.2.4, 3.1, 3.5.2.4

RELEASE clause, 13

REMARK command, 6.3.1, 13

removing sample tables, 1.8.1

RENAME command

disabling, 10.2

REPFOOTER clause, 13

REPFOOTER command, 7.3.1, 13

aligning footer elements, 13

BOLD clause, 13

CENTER clause, 13

COL clause, 13

FORMAT clause, 13

indenting report footers, 13

LEFT clause, 13

OFF clause, 13

RIGHT clause, 13

SKIP clause, 13

suppressing current definition, 13

TAB clause, 13

REPHEADER clause, 13

REPHEADER command, 7.3.1, 13

aligning header elements, 7.3.1.1

aligning heading elements, 13

BOLD clause, 13

CENTER clause, 13

COL clause, 13

FORMAT clause, 13

indenting headings, 13

LEFT clause, 13

OFF clause, 13

PAGE clause, 13

RIGHT clause, 13

SKIP clause, 13

suppressing current definition, 13

TAB clause, 13

REPLACE clause

in COPY command, B.1.1, B.2.2

in SAVE command, 13, 13

reports

autotrace, 9.1.1

breaks, 13

clarifying with spacing and summary lines, 7.2

columns, 13

creating bottom titles, 7.3, 13, C.1, C.1

creating dynamic, 8.2

creating footers, 13

creating headers, 13

creating headers and footers, 7.3

creating master/detail, 7.3.4, 13, 13

creating top titles, 7.3, 13, C.1

displaying, 13, 13

formatting column headings, 7.1.1.2, 13

formatting columns, 7.1.2.1, 7.1.3.1, 13

interactive HTML example, 8.1.1, 8.1.1

on the web, 8.1

running from a URL, 8.2

SILENT mode, 8.1.2

starting on a new page, 13

title, 13, C.1

RESTRICT, 4.5.1.7, 10.4, 13

restricted database access, 3.3.5

return code, specifying, 6.6, 13, 13

REVOKE command, 10.1

disabling, 10.2

RIGHT clause, 7.3.1.1, 13, 13

roles, 10.3

disabling, 10.3.2

re-enabling, 10.3.2

ROLLBACK clause, 13

WHENEVER OSERROR, 13

WHENEVER SQLERROR, 13

ROWID

column definition from DESCRIBE, 13

rows

performing computations on, 7.2.6, 13

setting number retrieved at one time, 9.4.3, 13, 13

setting the number after which COPY commits, 13

RUN command, 13

executing current PL/SQL block, 5.5

making last line current, 6.2.2

similar to / (slash) command, 13

Run menu command, 2.2.3.1

S

sample schemas, Preface, Preface, Preface, 1.8, 1.8.1, 1.8.1, 8.2

see Oracle Database Sample Schemas guide, Preface

see Oracle9i Sample Schemas guide, 1.8

using HR in COLUMN example, 13

using HR in examples, 6, 7

sample tables

access to, 1.8.1

creating, 1.8.1

removing, 1.8.1

unlocking, Preface, 1.8.1

SAVE command, 13

APPEND clause, 13

CREATE clause, 13

REPLACE clause, 13

storing commands in scripts, 13

using with INPUT to create scripts, 6.1.1

save script button, 2.3.4.4

saving environment attributes, 13

saving, command files, 2.2.3.1

SCAN variable, C.1, C.9

schemas

command, 14.1

database, 9.1.1

database default, 13

DESCRIBE parameter, 13

disabled commands, 14.1

HR sample, Preface, 1.8

installing own copy of HR, 1.8.1

sample, Preface

SHOW parameter, 13, 13

unlocking HR, Preface, 1.8.1

using HR in COLUMN example, 13

using HR in examples, 6, 7, 8.2

screen buffer area, 2.2.3.4

SCREEN clause, 6.12.4, 13

screens

Change Password, 4.1.2

clearing, 6.12.4, 13

connection identifier field, 2.3.2.3, 2.3.3.5

DBA Login, 2.3.3

DBA Workspace, 2.3.5

enter statements field, 2.3.6.1, 2.3.6.1, 2.3.6.2, 2.3.6.3

Expired Password, 4.1.4

History, 2.3.6

new password field, 4.1.2.3

password field, 2.3.2.2, 2.3.3.4

Preferences, 2.3.8

privilege list, 2.3.3.6

script location field, 2.3.8.4

username field, 2.3.2.1, 2.3.3.3, 4.1.2.1

Workspace, 2.3.4

scripts

extension, 13, 13, 13

location field, 2.3.8.4

registering, 9.4.2

See also command file

Search menu, 2.2.3.3

Secure Sockets Layer security, 10.6

security

Application Server, 10.6

changing password, 13

HTTP, 10.6

Oracle Net, 10.6

password viewable, 4.5.2

PRODUCT_USER_PROFILE table, 10.1

RESTRICT, 4.5.1.7, 10.4

Secure Sockets Layer (SSL), 10.6

SELECT command

and BREAK command, 7.2, 13, 13, 13

and COLUMN command, 13

and COMPUTE command, 7.2

and COPY command, B.1.1, B.2.1

and DEFINE command, 13

and ORDER BY clause, 7.2

formatting results, 6.14

semicolon (;)

in PL/SQL blocks, 5.5

in SQL commands, 5.4, 5.4.1.2

in SQL*Plus commands, 5.6.1, 13

not stored in buffer, 6.2.1

server

iSQL*Plus port conflict, 3.3.1

SERVEROUTPUT variable, 13

service name

in COPY command, B.2.1, B.2.2, B.3

session

identification, 4.3.7

settings, 3.4.1

stateful behavior, 3.4.1

session-timeout parameter, 3.3.4

SET AUTOTRACE, 9.1.1

SET clause, 13

SET command, 3.2.3, 5.7, 13

APPINFO variable, 9.4.2, 13

ARRAYSIZE variable, 9.4.3, 13, 13, B.2.3

AUTOCOMMIT variable, 13, 13

AUTOPRINT variable, 13, 13, 13

AUTORECOVERY variable, 13, 13

AUTOTRACE variable, 13, 13

BLOCKTERMINATOR variable, 13, 13

BUFFER variable, C.5

CLOSECURSOR variable, C.1, C.6

CMDSEP variable, 13, 13

COLSEP variable, 7.4.1, 13, 13

COMPATIBILITY variable, 13, 13

CONCAT variable, 6.9.4, 6.9.4, 13, 13

COPYCOMMIT variable, 13, 13, B.2.3

COPYTYPECHECK variable, 13, 13

DEFINE clause, 6.9.4

DEFINE variable, 13

DESCRIBE variable, 13, 13

DOCUMENT variable, C.1, C.7

ECHO variable, 13, 13

EDITFILE variable, 13, 13

EMBEDDED variable, 13, 13

ESCAPE variable, 6.9.4, 13, 13

FEEDBACK variable, 13, 13

FLAGGER variable, 13, 13

FLUSH variable, 9.4.5, 13, 13

HEADING variable, 13

HEADSEP variable, 7.1.1.2, 13, 13

INSTANCE variable, 13, 13

LINESIZE variable, 7.3.1.1, 7.3.6, 13, 13

LOBOFFSET variable, 13, 13

LOGSOURCE variable, 13, 13

LONG variable, 13, 13, B.2.3

LONGCHUNKSIZE variable, 13, 13

MARKUP clause, 13, 13

MAXDATA variable, C.1, C.8

NEWPAGE variable, 7.3.6, 13, 13

NULL variable, 13, 13

NUMFORMAT clause, 3.2.2.1

NUMFORMAT variable, 13, 13

NUMWIDTH variable, 7.1.2.1, 13, 13, 13

PAGESIZE clause, 3.2.2.1

PAGESIZE variable, 5.4, 7.3.6, 9.4.8, 13, 13

PAUSE variable, 13, 13

RECSEP variable, 7.1.7, 13, 13

RECSEPCHAR variable, 7.1.7, 13, 13

SCAN variable, C.1, C.9

SERVEROUTPUT variable, 13

SHIFTINOUT variable, 13, 13

SPACE variable, C.1, C.10

SQLBLANKLINES variable, 13

SQLCASE variable, 13, 13

SQLCONTINUE variable, 13, 13

SQLNUMBER variable, 13, 13

SQLPLUSCOMPATIBILITY variable, 13, 13

SQLPREFIX variable, 13, 13

SQLPROMPT variable, 9.4.10, 13, 13

SQLTERMINATOR variable, 13, 13

substitution variable, 13

SUFFIX variable, 13, 13

TAB variable, 9.4.11, 13, 13

TERMOUT variable, 9.4.12, 13, 13

TIME variable, 13, 13

TIMING variable, 13, 13

TRIMOUT variable, 13, 13

TRIMSPOOL variable, 13, 13

TRUNCATE variable, C.1, C.11

UNDERLINE variable, 13, 13

used to format a REFCURSOR variable, 13

VERIFY clause, 6.9.1

VERIFY variable, 6.9.4, 6.9.4, 13, 13

WRAP variable, 7.1.3.2, 13, 13

SET MARKUP

BODY clause, 4.5.1.5

ENTMAP clause, 4.5.1.5, 8.1.3

HEAD clause, 4.5.1.5

HTML, 4.5.1.5

interactive HTML example, 8.1.1, 8.1.1

PREFORMAT clause, 4.5.1.5

See also SPOOL command

TABLE clause, 4.5.1.5

Set Options area, 2.2.3.4

SET ROLE command

disabling, 10.2

SET system variable summary, 13

SET TRANSACTION command

disabling, 10.2

SET variables, 5.7

See system variables

SGA clause, 13

SHIFTINOUT variable, 13, 13

SHOW

schema parameter, 13, 13

SHOW clause, 13

SHOW command, 5.7, 13

ALL clause, 13

BTITLE clause, 13

ERRORS clause, 13

LABEL variable, C.1, C.12

listing current page dimensions, 7.3.6

LNO clause, 13

PNO clause, 13

RELEASE clause, 13

REPFOOTER clause, 13

REPHEADER clause, 13

SPOOL clause, 13

SQLCODE clause, 13

TTITLE clause, 13

USER clause, 13

SHOWMODE variable, 13, 13

SHUTDOWN command, 13, 13

ABORT, 13

IMMEDIATE, 13

NORMAL, 13

TRANSACTIONAL LOCAL, 13

-SILENT option, 4.5.1.8, 8.1.2

site profile

glogin, Preface, Preface, 3.2, 3.2.1, 3.2.2.1, 4.5.1.7, 9.1.2, 9.3, 10.6.5, 13, 13, 13

SKIP clause

in BREAK command, 7.2.2, 7.2.3, 13

in REPHEADER and REPFOOTER commands, 13

in TTITLE and BTITLE commands, 7.3.1.1, 13

used to place blank lines before bottom title, 7.3.1.1

SKIP PAGE clause, 7.2.2, 7.2.3, 13

slash (/) command, 13

SPACE variable, C.1, C.10

special characters

choosing a font, 2.1.2.2

Euro sign, 2.1.2.2, 2.2.4, 2.2.4.2

using, 2.1.2.2, 2.2.4.2

SPOOL clause, 4.5.1.5, 13

SPOOL command, 7.3.6, 13

APPEND clause, 13

CREATE clause, 13

file name, 7.4.2, 13

OFF clause, 7.4, 13

OUT clause, 7.4.3, 13

REPLACE clause, 13

to HTML file, 4.5.1.5

turning spooling off, 7.4, 13

use with SET MARKUP, 8.1.1

spool menu command, 2.2.3.1

SQL buffer, 2.2.3.1

SQL clause, 13

SQL DML statements

reporting on, 13, 13

SQL optimizer, 9.1.2

SQL*Plus

application window, 2.2, 4.3.3.2

command prompt, 4.3.1

configuring globalization support, 12.1

database administration, 11.1

environment variables, 3.1

error messages, 14.1

execution plan, 9.1.2

exiting, 4.4.1, 13, 13

exiting conditionally, 13

limits, A

menus, 2.2.3

obsolete command alternatives, C.1

setting up environment, 3.2

shortcuts to starting, 4.3.1.1

starting, 4.3, 4.3.1, 4.5

statistics, 9.1.3

system variables affecting performance, 9.4

tuning, 9.1

who can use, 1.5

SQL*Plus Windows GUI

changing face and size, 2.2.4, 2.2.4.1

changing font, 2.2.4

SQLBLANKLINES variable, 13, 13

SQLCASE variable, 13, 13

SQLCODE clause, 13

SHOW command, 13

SQLCONTINUE variable, 13, 13

SQL.PNO, referencing in report titles, 7.3.2

SQLNUMBER variable, 13, 13, 13, 13

SQLPATH

environment variables, 3.1

registry entry, 3.1, 3.5.2.2

SQLPLUS

environment variables, 3.1

SQLPLUS command, 4.3.1

- clause, 4.5.1.2

-? clause, 4.5.1.3

and @ ("at" sign), 4.5

and EXIT FAILURE, 4.4

BODY option, 4.5.1.5

commands

SQLPLUS, 4.5

connect identifier, 4.5.2

display syntax, 4.5.1.2

ENTMAP option, 4.5.1.5

HEAD option, 4.5.1.5

HTML option, 4.5.1.5

-MARKUP clause, 4.5.1.5

-MARKUP option, 4.5.1.5

/NOLOG clause, 4.5.2

PREFORMAT option, 4.5.1.5

RESTRICT, 4.5.1.7, 10.4

service name, 4.5.2

-SILENT clause, 4.5.1.8

-SILENT option, 4.5.1.8, 8.1.2

SPOOL clause, 4.5.1.5

syntax, 4.5

SYSDBA clause, 4.5.2

TABLE option, 4.5.1.5

unsuccessful connection, 4.4

username/password, 4.3.1, 4.5.2

SQLPLUS_FONT

registry entry, 2.2.4, 3.1, 3.5.2.3

SQLPLUS_FONT_SIZE

registry entry, 2.2.4, 2.2.4, 3.1, 3.5.2.4

SQLPREFIX variable, 13, 13

SQLPROMPT variable, 9.4.10, 13, 13

SQL.SQLCODE

using in EXIT command, 13

SQLTERMINATOR variable, 13, 13, 13, 13

SSL

iSQL*Plus setup, 3.3.7

security, 10.6

STANDBY DATAFILE clause, 13

STANDBY TABLESPACE clause, 13

START clause, 13, 13

START command, 6.4, 13

arguments, 6.11

passing parameters to a script, 6.11

script, 6.4, 13

similar to @ ("at" sign) command, 6.4, 13, 13

similar to @@ (double "at" sign) command, 13

Start menu

starting SQL*Plus, 4.3.3.1

starting

iSQL*Plus, 4.3.4, 4.3.4, 4.3.9

SQL*Plus, 2.1, 4.3, 4.3.1

SQL*Plus shortcuts, 4.3.1.1

SQL*Plus Windows GUI, 4.3.3.1

STARTUP command, 13

FORCE clause, 13

MOUNT clause, 13

NOMOUNT clause, 13

OPEN clause, 13

PFILE clause, 13

RECOVER clause, 13

RESTRICT clause, 13

specifying a database, 13

statements

executing, 5.1.2

statistics, 9.1.3

collecting TIMING statistics, 9.2

STOP clause, 13, 13

stop query, 5.8

stopping

iSQL*Plus Application Server, 4.3.6

STORE command, 3.2.3, 13

SET clause, 13

stored functions, 6.14

stored procedures

creating, 5.5.1

subkey, registry, 3.5.2.1, 3.5.2.2, 3.5.2.3, 3.5.2.4

substitution variables, 6.7, 6.9, 6.9.4, 13, 13

_EDITOR, 13

appending characters immediately after, 6.9.1

avoiding unnecessary prompts for value, 6.9.2

concatenation character, 13, 13

DEFINE command, 13

defining, 6.7, 6.9.2, 13

deleting, 6.7, 13

displaying in headers and footers, 13

displaying in titles, 13

in ACCEPT command, 6.12.1, 13

iSQL*Plus, 6.10

listing definitions, 6.7, 6.7, 13, 13

parsing, 9.4.4

prefixing, 13, C.1

related system variables, 6.9.4

restrictions, 6.9.3

single and double ampersands, 6.9.2

system variables used with, 6.9.4

undefined, 6.9.1

where and how to use, 6.9.1

SUFFIX variable, 13, 13

used with EDIT command, 13

used with SAVE command, 13

used with START command, 13

SUM function, 7.2.6

summary lines

computing and printing, 7.2.6, 13

computing and printing at ends of reports, 7.2.7

computing same type on different columns, 7.2.8

printing "grand" and "sub" summaries (totals), 7.2.7

printing multiple on same break column, 7.2.8

syntax

COPY command, B.2.1

syntax rules

SQL commands, 5.4.1

SQL*Plus commands, 5.6.1

SYSDBA clause, 13

SYSOPER clause, 4.5.2, 13

system variables, 5.7, 13

affecting SQL*Plus performance, 9.4

affecting substitution variables, 6.9.4

listing current settings, 5.7, 13

listing old and new values, 13, 13

screen buffer, 2.2.3.4

Set Options area, 2.2.3.4

setting, 2.2.3.4

storing and restoring, 3.2.3

summary of SET commands, 13

value area, 2.2.3.4

system-maintained values

displaying in headers and footers, 13

displaying in titles, 7.3.2, 13

formatting in titles, 7.3.2

T

TAB clause, 13, 13

TAB variable, 9.4.11, 13, 13

TABLE clause, 4.5.1.5

TABLE option, 4.5.1.5

tables

access to sample, 1.8.1

controlling destination when copying, B.1.1, B.2.2

copying values between, B.2, B.3

listing column definitions, 5.2, 13

referring to another user's when copying, B.2.4

TABLESPACE clause, 13

tablespaces, recovering, 13

tag, HTML, 8.1

TERMOUT variable, 9.4.12, 13, 13

using with SPOOL command, 13

text, 4.5.1.5, 4.5.1.5

adding to current line with APPEND, 6.2.3, 13

changing old to new with CHANGE, 6.2.2, 13

clearing from buffer, 6.2, 13

text editor

defining, 2.2.3.2

invoking, 2.2.3.2

operating system, 6.1.1, 13

three-tier model, 1.3

TIME variable, 13, 13

TIMING clause, 13

TIMING command, 9.2, 13

deleting all areas created by, 13

deleting current area, 13

SHOW clause, 13

START clause, 13

STOP clause, 13

TIMING variable, 13, 13

titles

aligning elements, 7.3.1.1, 13

displaying at bottom of page, 7.3, 13, C.1, C.1

displaying at top of page, 7.3, 13, C.1

displaying column values, 7.3.4, 13, 13

displaying current date, 7.3.5, 13, 13

displaying page number, 7.3.2, 13

displaying system-maintained values, 7.3.2, 13

formatting elements, 13

formatting system-maintained values in, 7.3.2

indenting, 7.3.1.2, 13

listing current definition, 7.3.3, 13, 13

restoring definition, 7.3.3

setting at start or end of report, 7.3

setting lines from top of page to top title, 7.3.6, 13, 13, C.1

setting lines from top title to end of page, 9.4.8, 13, 13

setting top and bottom, 7.3, 13, 13, C.1, C.1, C.1

spacing between last row and bottom title, 7.3.1.1

suppressing definition, 7.3.3, 13

TNS_ADMIN

environment variables, 3.1

TO clause, B.2.1

tracing queries, 9.3

tracing statements

for performance statistics, 9.1.3

for query execution path, 9.1.3

using a database link, 9.1.3

with parallel query option, 9.3

TRIMOUT variable, 13, 13

TRIMSPOOL variable, 13, 13

TRUNCATE command

disabling, 10.2

TRUNCATE variable, C.1, C.11

TRUNCATED clause, 7.1.3.2, 13

TTITLE clause, 13

TTITLE command, 7.3.1, 13

aligning title elements, 7.3.1.1, 13

BOLD clause, 13

CENTER clause, 7.3.1.1, 13

COL clause, 7.3.1.2, 13

FORMAT clause, 7.3.2, 13

indenting titles, 7.3.1.2, 13

LEFT clause, 7.3.1.1, 13

listing current definition, 7.3.3, 13

OFF clause, 7.3.3, 13

old form, C.13

ON clause, 7.3.3

referencing column value variable, 7.3.4, 13

restoring current definition, 7.3.3

RIGHT clause, 7.3.1.1, 13

SKIP clause, 7.3.1.1, 13

suppressing current definition, 7.3.3, 13

TAB clause, 13

tuning

SET APPINFO OFF, 9.4.2

SET ARRAYSIZE, 9.4.3

SET DEFINE OFF, 9.4.4

SET FLUSH OFF, 9.4.5

SET TRIMOUT ON, 9.4.13

SET TRIMSPOOL ON, 9.4.13

SQL*Plus, 9.1

system variables, 9.4

TWO_TASK

environment variables, 3.1

U

UNDEFINE command, 6.7, 13

and DEFINE command, 13

UNDERLINE variable, 13, 13

unicode

UNIX

ed, 13

unlocking sample tables, Preface, 1.8.1

UNTIL CANCEL clause, 13

UNTIL CHANGE clause, 13

UNTIL CONTROLFILE clause, 13

UNTIL TIME clause, 13

UPDATE command, disabling, 10.2

URL

running dynamic reports, 8.2

starting iSQL*Plus, 4.3.9

USER clause, 13

user profile, 3.2.2

glogin.sql, 3.2.2

See also site profile

user variable

See substitution variable

username, 4.1

connecting under different, 4.1, 13

field, 2.3.2.1, 2.3.3.3, 4.1.2.1

in CONNECT command, 4.1, 13

in COPY command, B.2.1, B.2.2, B.3

in SQLPLUS command, 4.3.1, 4.5.2

USING BACKUP CONTROL FILE clause, 13

USING clause, B.1.1, B.2.1

UTF-8

V

V$SESSION virtual table, 13

V$SQLAREA virtual table, 13

value area, 2.2.3.4

value screen area, 2.2.3.4

VARCHAR columns

default format, 7.1.3.1

VARCHAR2

column definition from DESCRIBE, 13

VARCHAR2 clause

VARIABLE command, 13

VARCHAR2 columns

changing format, 13

default format, 7.1.3.1

VARIABLE command, 13

BINARY_DOUBLE clause, 13

BINARY_FLOAT clause, 13

CHAR clause, 13

CLOB clause, 13

NCHAR clause, 13

NCLOB clause, 13

NUMBER clause, 13

REFCURSOR clause, 13

VARCHAR2 clause, 13

variable clause, 13

variables

bind variables, 6.13

substitution variables, 13

system variables, 5.7

VERIFY clause, 6.9.1

VERIFY variable, 6.9.4, 6.9.4, 13, 13

W

WARNING clause, 13

web browser, 1.2, 8.1.1

web, outputting reports, 8.1

WHENEVER OSERROR command, 13

COMMIT clause, 13

CONTINUE clause, 13

EXIT clause, 13

NONE clause, 13

ROLLBACK clause, 13

WHENEVER SQLERROR command, 13

COMMIT clause, 13

CONTINUE clause, 13

EXIT clause, 13

NONE clause, 13

ROLLBACK clause, 13

Windows

notepad, 13

Windows GUI

application window, 2.2, 4.3.3.2

cancelling, 2.2.3.1

changing face and size, 2.2.4, 2.2.4.1

changing font, 2.2.4

command keys, 2.2.2

configuring, 3.5

exiting, 2.2.3.1

File menu, 2.2.3.1

Log On dialog, 4.3.3.1

menus, 2.2.3

starting SQL*Plus, 4.3.3.1

Windows service

starting iSQL*Plus Application Server, 4.3.4

WORD_WRAPPED clause, 7.1.3.2, 7.1.7, 13

Workspace, 2.3.4

WRAP variable, 7.1.3.2, 13, 13

WRAPPED clause, 7.1.3.2, 13, 13

X

XMLType

column definition from DESCRIBE, 13

column formatting, 7.1.3.2

column width, 7.1.3.1

creating, 7.1.3.2

formatting in reports, 7.1.3

inserting values, 7.1.3.2

selecting data, 7.1.3.2

setting column retrieval size, 9.4.7, 13

setting maximum column width, 13