SQL*Plus User's Guide and Reference -- Index

-- (comment delimiter), 6-11

- (hyphen)

clause, 4-4

continuing a long SQL*Plus command, 5-9, 13-1

. (period), 5-7

/ (slash) command

default logon, 4-11, 13-46

entered at buffer line-number prompt, 5-5, 13-9

entered at command prompt, 5-7, 13-9

executing current PL/SQL block, 5-7

executing current SQL command, 5-7

similar to RUN, 5-7, 13-9, 13-92

usage, 13-9

# pound sign, 13-34

$ number format, 7-5

& (ampersand)

disabling substitution variables, 6-23

substitution variables, 6-18

&&, 6-21

* (asterisk)

in DEL command, 6-4, 13-51

in LIST command, 6-4, 13-73

/*...*/ (comment delimiters), 6-10

: (colon)

bind variables, 6-31

:BindVariable clause

EXIT command, 13-65

; (semicolon), 5-4

@ ("at" sign)

command, 3-4, 6-14, 13-5

command arguments, 13-6

in CONNECT command, 13-46

in COPY command, B-2, B-5

in SQLPLUS command, 4-3, 4-21, 6-15

passing parameters to a script, 13-5

script, 6-14, 13-5

similar to START, 6-14, 13-6, 13-133

@@ (double "at" sign) command, 3-4, 13-7

script, 13-7

similar to START, 13-8, 13-133

[Cancel] key, 5-12

_EDITOR, in EDIT command, 6-2, 13-61

~ infinity sign, 13-34

-~ negative infinity sign, 13-34

0, number format, 7-5

9, number format, 7-5

ABORT mode, 13-129

abort query, 5-12

ACCEPT command, 6-27, 13-10

and DEFINE command, 13-49

CHAR clause, 13-10

customizing prompts for value, 6-29

DATE clause, 13-10

DEFAULT clause, 13-11

FORMAT clause, 13-10

HIDE clause, 13-11

NOPROMPT clause, 13-11

NUMBER clause, 6-30

PROMPT clause, 6-28, 13-11

access, denying and granting, 10-2

adding authentication entries, 10-12

administrator

Oracle HTTP Server, 10-12

ALIAS clause, 13-30

in ATTRIBUTE command, 13-16

ALL clause, 13-124

ALTER command

disabling, 10-5

ampersands (&)

in parameters, 6-26, 13-5, 13-132

substitution variables, 6-18

ANALYZE command

disabling, 10-5

APPEND clause

in COPY command, B-3, B-7

in SAVE command, 13-93

APPEND command, 6-4, 6-8, 13-12

APPINFO clause, 9-10, 13-99

ARCH background process, 13-14

ARCHIVE LOG

command, 11-4, 13-13

mode, 11-4

argument

in START command, 6-26

ARRAYSIZE variable, 9-10, 13-100

relationship to COPY command, B-4, B-8

ATTRIBUTE command, 13-16

ALIAS clause, 13-16

and CLEAR COLUMN command, 13-17

CLEAR clause, 13-16

clearing columns, 13-27, 13-30

controlling display characteristics, 13-17

display characteristics, 13-16

entering multiple, 13-17

FORMAT clause, 13-17

LIKE clause, 13-17

listing attribute display characteristics, 13-16

OFF clause, 13-17

ON clause, 13-17

restoring column display attributes, 13-17

suppressing column display attributes, 13-17

AUDIT command

disabling, 10-5

authentication

adding connection entries, 10-12

adding username/password entries, 3-11, 10-11

DBA access in iSQL*Plus, 10-9, 10-11

enabling for iSQL*Plus users, 3-11

htpasswd utility, 10-12

iSQL*Plus, 10-10

iSQL*Plus Server statistics, 10-9

AUTOCOMMIT variable, 5-11, 13-101

AUTOMATIC clause, 13-80

AUTOPRINT variable, 13-101

AUTORECOVERY variable, 13-101

autotrace report, 9-2

AUTOTRACE variable, 9-2, 13-102

AVG function, 7-17

background process,

startup after abnormal termination, 13-129

batch mode, 6-17, 13-65

BEGIN command, 5-7

disabling, 10-5

bind variables, 6-31

creating, 13-145

displaying, 13-77

displaying automatically, 13-101, 13-147

in PL/SQL blocks, 13-147

in SQL statements, 13-147

in the COPY command, 13-147

blank line

in PL/SQL blocks, 5-7

in SQL commands, 5-5

preserving in SQL commands, 13-118

blocks, PL/SQL

continuing, 5-7

editing in buffer, 6-4

editing with host system editor, 6-2, 13-61

entering and executing, 5-7

listing current in buffer, 6-5

run from SQL buffer, 5-7

saving current, 13-93

setting character used to end, 13-102

stored in SQL buffer, 5-7

timing statistics, 13-122

within SQL commands, 5-6

BLOCKTERMINATOR, 13-102, 13-118, 13-121

BODY clause, 4-6

BODY option, 4-6

BOLD clause, 13-90, 13-142

break columns, 7-12, 13-18

inserting space when value changes, 7-13

specifying multiple, 7-14

suppressing duplicate values in, 7-12

BREAK command, 7-12, 13-18

and SQL ORDER BY clause, 7-12, 7-13, 7-14, 13-19

clearing BREAKS, 7-16

displaying column values in titles, 7-29

DUPLICATES clause, 13-21

inserting space after every row, 7-14

inserting space when break column changes, 7-13

listing current break definition, 7-16, 13-21

ON column clause, 7-13, 13-18

ON expr clause, 13-19

ON REPORT clause, 7-20, 13-20

ON ROW clause, 7-14, 13-20

printing "grand" and "sub" summaries, 7-20

printing summary lines at ends of reports, 7-20

removing definition, 13-27

SKIP clause, 7-14, 13-20

SKIP PAGE clause, 7-13, 7-14, 13-21

specifying multiple break columns, 7-14, 13-18

storing current date in variable for titles, 7-31

suppressing duplicate values, 7-12

used in conjunction with COMPUTE, 7-16

used in conjunction with SET COLSEP, 13-104

used to format a REFCURSOR variable, 13-147

used with COMPUTE, 13-18, 13-20, 13-42

break definition

listing current, 7-16, 13-21

removing current, 7-16, 13-27

BREAKS clause, 7-16, 13-27

browse button, 2-6, 2-15

browser, web, 8-2

BTITLE clause, 13-124

BTITLE command, 7-23, 13-23

aligning title elements, 13-142

BOLD clause, 13-142

CENTER clause, 13-142

COL clause, 13-142

FORMAT clause, 13-142

indenting titles, 13-142

LEFT clause, 13-142

OFF clause, 13-141

old form, C-3

printing blank lines before bottom title, 7-26

referencing column value variable, 13-35

RIGHT clause, 13-142

SKIP clause, 13-142

suppressing current definition, 13-141

TAB clause, 13-142

TTITLE command, 13-23

buffer, 5-2

appending text to a line in, 6-8, 13-12

delete a single line, 6-4

delete the current line, 6-4

delete the last line, 6-4

deleting a range of lines, 6-4, 13-51

deleting a single line, 13-51

deleting all lines, 6-4, 13-27, 13-51

deleting lines from, 6-9, 13-51

deleting the current line, 13-51

deleting the last line, 13-51

executing contents, 5-7, 13-9, 13-92

inserting new line in, 6-7, 13-71

listing a range of lines, 6-5, 13-73

listing a single line, 6-4, 13-73

listing all lines, 6-4, 13-73

listing contents, 6-5, 13-73

listing the current line, 6-4, 13-73

listing the last line, 6-5, 13-73

loading into host system editor, 13-61

saving contents, 13-93

BUFFER clause, 6-3, 6-4, 13-27

BUFFER variable, C-4

buttons

browse, 2-6, 2-15

cancel, 2-8, 4-19, 6-25

clear screen, 2-6

execute, 2-6

load script, 2-6

log in, 2-5, 2-12

save script, 2-6

cancel button, 2-8, 4-19, 6-25

CANCEL clause, 13-81, 13-83

cancel query, 5-12

cascading style sheet

customizing, 3-11

user interface, 3-11

CENTER clause, 7-26, 13-90, 13-142

CHANGE command, 6-4, 6-6, 13-24

Change Password screen, 4-19

CHAR clause, 13-10

VARIABLE command, 13-145

CHAR columns

changing format, 7-6, 13-31

default format, 7-6, 13-31

definition from DESCRIBE, 13-53

character encoding

national language support, 12-3

CLEAR clause, 7-10, 13-30

in ATTRIBUTE command, 13-16

CLEAR command, 13-27

BREAKS clause, 7-16, 13-27

BUFFER clause, 6-3, 6-4, 13-27

COLUMNS clause, 13-27

COMPUTES clause, 13-27

SCREEN clause, 6-30, 13-27

SQL clause, 13-28

TIMING clause, 13-28

clear screen button, 2-6

client tier, 1-4

configuring, 3-5

CLOB clause

VARIABLE command, 13-146

CLOB columns

changing format, 7-6, 13-31

default format, 13-31

setting maximum width, 13-112

setting retrieval position, 13-111

setting retrieval size, 13-112

CLOSECURSOR variable, C-2, C-5

CMDSEP variable, 13-103

COL clause, 7-26, 13-90, 13-142

colons (:)

bind variables, 6-31

COLSEP variable, 13-104

COLUMN command, 7-2, 13-29

ALIAS clause, 13-30

and BREAK command, 13-20

and DEFINE command, 13-49

CLEAR clause, 7-10, 13-30

DEFAULT clause, C-3

displaying column values in bottom titles, 7-30, 13-35

displaying column values in top titles, 7-29, 13-34

entering multiple, 13-36

ENTMAP clause, 13-30

FOLD_AFTER clause, 13-30, 13-31

FOLD_BEFORE clause, 13-31

FORMAT clause, 7-5, 7-6, 13-31

formatting a REFCURSOR variable, 13-147

formatting columns, 7-6

formatting NUMBER columns, 7-4, 13-32

HEADING clause, 7-2, 13-34

HEADSEP character, 13-34

JUSTIFY clause, 13-34

LIKE clause, 7-9, 13-34

listing column display attributes, 7-9, 13-29

NEW_VALUE clause, 7-29, 7-31, 13-34

NEWLINE clause, 13-34

NOPRINT clause, 7-29, 13-35

NULL clause, 13-35

OFF clause, 7-10, 13-36

OLD_VALUE clause, 7-30, 13-35

ON clause, 7-10, 13-36

PRINT clause, 13-35

resetting to default display, 7-10, 13-30, C-2

restoring column display attributes, 7-10, 13-36

storing current date in variable for titles, 7-31, 13-37

suppressing column display attributes, 7-10, 13-36

TRUNCATED clause, 7-7, 13-36

WORD_WRAPPED clause, 7-7, 7-10, 13-36

WRAPPED clause, 7-7, 13-36

column headings

aligning, 13-34

changing, 7-2, 13-34

column headings (continued)

changing character used to underline, 13-123

changing to two or more words, 7-3, 13-34

displaying on more than one line, 7-3, 13-34

suppressing printing in a report, 13-109

when truncated, 13-31

when truncated for CHAR and LONG columns, 7-6

when truncated for DATE columns, 7-6

when truncated for NUMBER columns, 7-4

column separator, 13-104, C-2

columns

assigning aliases, 13-30

computing summary lines, 7-16, 13-40

copying display attributes, 7-9, 13-17, 13-34

copying values between tables, B-2, B-5, B-9

displaying values in bottom titles, 7-30, 13-35

displaying values in top titles, 7-29, 13-34

formatting CHAR, VARCHAR, LONG, and DATE, 13-31

formatting in reports, 7-2, 13-29

formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 13-31

formatting NUMBER, 7-4, 13-32

listing display attributes for all, 7-9, 13-29

listing display attributes for one, 7-9, 13-29

names in destination table when copying, B-3, B-6

printing line after values that overflow, 7-10, 13-115

resetting a column to default display, 7-10, 13-30, C-2

resetting all columns to default display, 13-27

restoring display attributes, 7-10, 13-17, 13-36

setting printing to off or on, 7-29, 13-35

starting new lines, 13-34

storing values in variables, 7-29, 13-34

suppressing display attributes, 7-10, 13-17, 13-36

truncating display for all when value overflows, 7-7, 13-123

truncating display for one when value overflows, 7-7, 13-36

wrapping display for all when value overflows, 7-7, 13-123

wrapping display for one when value overflows, 7-7, 13-36

wrapping whole words for one, 7-10

COLUMNS clause, 13-27

comma, number format, 7-5

command file extension, 13-98

command files

aborting and exiting with a return code, 6-17, 13-153, 13-155

allowing end-user input, 6-17

creating with a system editor, 6-2

creating with SAVE, 13-93

editing with host system editor, 6-3, 13-61

in @ ("at" sign) command, 6-14, 13-5

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

in EDIT command, 6-3, 13-61

in GET command, 13-66

in SAVE command, 6-3, 13-93

in SQLPLUS command, 4-12, 6-15

in START command, 6-14, 13-132

including comments in, 6-10, 13-86

including more than one PL/SQL block, 6-2

including more than one SQL command, 6-2

nesting, 6-15

passing parameters to, 6-26, 13-5, 13-132

registering, 9-10, 13-99

retrieving, 13-66

running, 6-14, 13-5, 13-132

running a series in sequence, 6-15

running as you start SQL*Plus, 4-12, 6-15

running in batch mode, 6-17, 13-65

running nested, 13-7

uniform resource locator, 13-5, 13-7, 13-132

command prompt

SET SQLPROMPT, 13-120

SQL*Plus, 4-2

command-line

configuring globalization support, 12-2

user interface, 2-2

commands

collecting timing statistics on, 9-7, 13-139

disabling, 10-4

commands (continued)

entering in iSQL*Plus, 2-6

host, running from SQL*Plus, 5-12, 13-69

listing current in buffer, 13-73

not supported in iSQL*Plus, D-1

re-enabling, 10-4

spaces, 5-2

SQL

editing in buffer, 6-4

editing with host system editor, 13-61

ending, 5-5

entering and executing, 5-3

entering without executing, 5-5

executing current, 5-7, 13-9, 13-92

following syntax, 5-4

listing current in buffer, 6-5

saving current, 13-93

setting character used to end and run, 13-121

SQL*Plus

abbreviations, 5-8

command summary, 13-2

continuing on additional lines, 5-9, 13-1

editing at command prompt, 6-4

ending, 5-10, 13-1

entering and executing, 5-8

entering during SQL command entry, 13-120

obsolete command alternatives, C-2

SQL, continuing on additional lines, 5-5

stopping while running, 5-12

tabs, 5-2

types of, 5-2

variables that affect running, 5-10

writing interactive, 6-17

comments

including in scripts, 6-10, 13-86, C-2

using -- to create, 6-11

using /*...*/ to create, 6-10

using REMARK to create, 6-10, 13-86, C-2

COMMIT clause, 13-64

WHENEVER OSERROR, 13-152

WHENEVER SQLERROR, 13-154

COMMIT command, 5-11

communication between tiers, 1-4, 1-5

COMPATIBILITY variable, 13-104

COMPUTE command, 7-12, 13-40

AVG function, 7-17

computing a summary on different columns, 7-20

COUNT function, 7-17

LABEL clause, 7-17, 7-20, 13-41

listing all definitions, 7-22, 13-42

MAXIMUM function, 7-17

maximum LABEL length, 13-41

MINIMUM function, 7-17

NUMBER function, 7-17

OF clause, 7-16

ON column clause, 7-16, 13-41

ON expr clause, 13-41

ON REPORT clause, 7-20, 13-41

ON ROW clause, 13-41

printing "grand" and "sub" summaries, 7-20

printing multiple summaries on same column, 7-21

printing summary lines at ends of reports, 7-20

printing summary lines on a break, 7-16

referencing a SELECT expression in OF, 13-41

referencing a SELECT expression in ON, 13-42

removing definitions, 7-22, 13-27

STD function, 7-17

SUM function, 7-17

used to format a REFCURSOR variable, 13-147

VARIANCE function, 7-17

COMPUTES clause, 13-27

CONCAT variable, 6-23, 13-105

configuration

client tier, 3-5

database tier, 3-15

file associations, 3-5

globalization support

iSQL*Plus Server, 3-7

middle tier, 3-7

MIME types, 3-5

Oracle HTTP Server, 3-7

Oracle9i, 3-15

testing HTTP Server configuration file, 3-12

configuring

cookies for iSQL*Plus, 3-5

globalization support, 12-1

HTTP Server, 3-12

configuring (continued)

httpd.conf, 3-12

iSQL*Plus, 3-5

iSQL*Plus extension for windows, 3-15

javascript for iSQL*Plus, 3-5

Oracle Net, 3-15

oracle_apache.conf, 3-12

proxy server exceptions, 3-6

SQL*Plus, 3-1

CONNECT command, 4-18, 4-22, 13-46

and @ ("at" sign), 13-46

changing password, 13-46, 13-47, 13-75

service name, 4-22

SYSDBA clause, 4-11, 13-47

SYSOPER clause, 4-11, 13-47

username/password, 4-21, 13-46

CONNECT command (SQL)

disabling, 10-5

connect identifier, 2-5, 2-11, 4-21, 13-46

field, 2-5, 2-11

in CONNECT command, 13-46

in COPY command, B-2

in DESCRIBE command, 13-53

in SQLPLUS command, 4-11

connection identifier, 4-20

context menu

iSQL*Plus extension for windows, 2-16

CONTINUE clause

WHENEVER OSERROR, 13-152

WHENEVER SQLERROR, 13-154

continuing a long SQL*Plus command, 5-9, 13-1

cookies, configuring for iSQL*Plus, 3-5

COPY command, 13-48, B-2, B-5

and @ ("at" sign), B-2, B-5

and ARRAYSIZE variable, B-4, B-8

and COPYCOMMIT variable, B-4, B-8

and LONG variable, B-4, B-8

APPEND clause, B-3, B-7

copying data between databases, B-5

copying data between tables on one database, B-9

CREATE clause, B-3, B-7

creating a table, B-3, B-7

destination table, B-3, B-6

determining actions, B-6

determining source rows and columns, B-3, B-6

disabling, 10-5

FROM clause, B-5

INSERT clause, B-3, B-7

inserting data in a table, B-3, B-7

interpreting messages, B-8

mandatory connect identifier, B-3

naming the source table with SELECT, B-3, B-6

query, B-3, B-6

referring to another user's table, B-9

REPLACE clause, B-3, B-7

replacing data in a table, B-3, B-7

sample command, B-5, B-6

service name, B-5, B-8, B-9

specifying columns for destination, B-3, B-6

specifying the data to copy, B-3, B-6

TO clause, B-5

username/password, B-2, B-5, B-8, B-9

USING clause, B-3, B-6

copy command

error messages, 14-45

COPYCOMMIT variable, 13-105

relationship to COPY command, B-4, B-8

COPYTYPECHECK variable, 13-105

COUNT function, 7-17

CREATE clause

in COPY command, B-3, B-7

CREATE command

disabling, 10-5

entering PL/SQL, 5-6

creating a PLAN_TABLE, 9-2

creating flat files, 7-34

creating PLUSTRACE role, 9-3

creating sample tables, 1-8

creating the PRODUCT_USER_PROFILE table, 10-2

CSS user interface, 3-11

cursor variables, 13-147

database

connect identifier, 13-46

mounting, 13-135

opening, 13-135

database administrator, 11-2

database changes, saving automatically, 5-11, 13-101

DATABASE clause, 13-81

database files

recovering, 13-79

database name at startup, 13-134

database tier, 1-4

configuration, 3-15

databases

connecting to default, 13-46

connecting to remote, 4-21, 13-46

copying data between, B-2, B-5

copying data between tables on a single, B-9

disconnecting without leaving SQL*Plus, 4-18, 13-60

mounting, 11-3

opening, 11-3

recovering, 11-5, 13-79

shutting down, 11-2, 11-3

starting, 11-2

DATAFILE clause, 13-82

DATE

column definition from DESCRIBE, 13-53

DATE clause, 13-10

DATE columns

changing format, 7-6, 13-32, 13-39

default format, 7-6

date, storing current in variable for titles, 7-30, 13-35, 13-37

DB2, 13-105

DBA, 11-2

iSQL*Plus access, 10-9

mode, 13-134

privilege, 2-10, 13-134

DBA access, 10-11

DBA Login screen, 2-10

DBA Work screen, 2-12

DBMS_APPLICATION_INFO package, 9-10, 13-99

DECLARE command (PL/SQL), 5-7

DECLARE command, disabling, 10-5

DEFAULT clause, 13-11

default logins

created at installation, 4-17

DEFINE command, 6-17, 13-49

and host system editor, 6-2, 13-50

and UNDEFINE command, 6-18, 13-144

CHAR values, 13-49

SET DEFINE ON|OFF, 13-105

substitution variables, 6-21, 13-49

define substitution variables field, 6-25

DEFINE variable, 6-23, 13-105

DEL command, 6-4, 6-9, 13-51

using an asterisk, 6-4, 13-51

DELETE command

disabling, 10-5

DESCRIBE command (SQL*Plus), 5-13, 13-53

connect_identifier, 13-53

PL/SQL properties listed by, 13-54

table properties listed by, 13-53

DISABLED keyword, disabling commands, 10-4

disabling

iSQL*Plus, 3-14

PL/SQL commands, 10-5

SQL commands, 10-4

SQL*Plus commands, 10-4

DISCONNECT command, 4-18, 13-60

DOCUMENT command, C-2, C-3

REMARK as newer version of, C-4

DOCUMENT variable, C-2, C-5

DROP command

disabling, 10-5

DUPLICATES clause, 13-21

dynamic reports, creating, 8-13

ECHO variable, 6-14, 13-107

EDIT command, 6-2, 13-61

creating scripts with, 6-2

defining _EDITOR, 13-61

disabling, 10-5

modifying scripts, 6-3, 13-61

setting default file name, 13-107

EDITFILE variable, 13-107

editing

external editor, 5-2

input area, 5-2

scripts, 5-2

editor, 5-2

EMBEDDED variable, 13-107

EMP table, 1-7

enabling HTTP Server authentication, 3-11, 10-10

enabling iSQL*Plus, 3-14

Enter statements field, 2-6, 2-7

entities, HTML, 8-12

ENTMAP, 4-6

ENTMAP clause, 4-6, 8-12, 13-30

error messages

copy command, 14-45

iSQL*Plus, 14-35

sqlplus, 14-2

error messages, interpreting, 5-15

errors, making line containing current, 6-6

escape characters, definition of, 13-108

ESCAPE variable, 6-23, 13-108

example

embedded CGI report, 8-7

interactive HTML report, 8-3, 8-6

execute button, 2-6

EXECUTE command, 13-63

disabling, 10-5

executing

a CREATE command, 5-6

statements, 5-3

executing scripts

See running

execution plan, 9-3

execution statistics

including in report, 13-102

EXIT clause

WHENEVER OSERROR, 13-152

WHENEVER SQLERROR, 13-154

EXIT command, 4-13, 13-64

:BindVariable clause, 13-65

COMMIT clause, 13-64

disabling, 10-5

FAILURE clause, 13-64

in a script, 13-133

ROLLBACK clause, 13-65

use with SET MARKUP, 8-3

WARNING clause, 13-64

exit, conditional, 13-152, 13-154

exiting

iSQL*Plus, 4-15

Expired Password screen, 4-19

extension, 13-93, 13-121, 13-138

extension for windows, 2-16

FAILURE clause, 13-64

FEEDBACK variable, 13-108

fields

connection identifier, 2-5, 2-11

define substitution variables, 6-25

enter statements, 2-6, 2-7

new password, 4-19

old password, 4-19

password, 2-4, 2-11

privilege, 2-11

retype new password, 4-19

script location, 2-8

username, 2-4, 2-11, 3-16, 4-19

file extensions, 3-3, 13-93, 13-121, 13-138

file names

in @ ("at" sign) command, 13-5

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

in EDIT command, 13-61

in GET command, 13-66

in SAVE command, 13-93

in SPOOL command, 7-34, 13-131

in SQLPLUS command, 4-12

files

configuring associations, 3-5

flat, 7-34

output, 2-9

FLAGGER variable, 13-108

flat file, 7-34

FLUSH variable, 13-109

FOLD_AFTER clause, 13-31

FOLD_BEFORE clause, 13-31

font

national language support, 12-3

footers

aligning elements, 13-90

displaying at bottom of page, 13-87

displaying system-maintained values, 13-89

formatting elements, 13-90

footers (continued)

indenting, 13-90

listing current definition, 13-87

setting at the end of reports, 7-23

suppressing definition, 13-90

FORCE clause, 13-134

FORMAT clause, 13-10, 13-31

in ATTRIBUTE command, 13-17

in COLUMN command, 7-5, 7-6

in REPHEADER and REPFOOTER commands, 13-90

in TTITLE and BTITLE commands, 7-28, 13-142

format models, number, 7-5, 13-33

formfeed, to begin a new page, 7-32, 13-114

FROM clause, 13-80

FROM clause (SQL*Plus), B-5

functionality, 2-3

GET command, 13-66

disabling, 10-5

LIST clause, 13-66

NOLIST clause, 13-66

retrieving scripts, 13-66

globalization support, 12-1

Oracle9i database, 12-2, 12-4

GLOGIN.SQL, 3-2, 9-4, 9-8

See also LOGIN.SQL

glogin.sql, 10-13

GRANT command, 10-2

disabling, 10-5

HEAD clause, 4-6

HEAD option, 4-6

headers

aligning elements, 7-25

displaying at top of page, 13-89

displaying system-maintained values, 13-89

setting at the start of reports, 7-23

suppressing, 7-25

HEADING clause, 7-2, 13-34

HEADING variable, 13-109

headings

aligning elements, 13-90

column headings, 13-109

formatting elements, 13-90

indenting, 13-90

listing current definition, 13-91

suppressing definition, 13-90

HEADSEP variable, 13-110

use in COLUMN command, 7-3, 13-34

help

iSQL*Plus online, 4-14

HELP command, 13-68

help, online, 4-12, 13-68

HIDE clause, 13-11

History screen, 2-6

HOST command, 5-13, 13-69

disabling, 10-5

host operating system

editor, 6-2, 13-61

file, loading into buffer, 13-66

running commands from SQL*Plus, 5-12, 13-69

HTML, 8-2

clause, 4-5

entities, 8-12

option, 4-5

running dynamic reports, 8-13

spooling to file, 4-8

tag, 8-2

htpasswd

adding username/password file entries, 10-12

HTTP

HTTPS security, 10-9

security, 10-9

HTTP Server

adding authentication entries, 10-12

authentication, 2-10, 10-10

authentication username/password entries, 3-11

configuring, 3-12

configuring globalization support, 12-4

enabling DBA, 10-11

testing configuration file, 3-12

httpd.conf, 3-12

testing httpd.conf edits, 3-15

hyphen, continuing SQL*Plus command, 5-9, 13-1

-idle-timeout parameter, 9-14

IMMEDIATE mode, 13-129

infinity sign (~), 13-34

initialization parameters

displaying, 13-125

INIT.ORA file

parameter file, 13-134

input

accepting [Return], 6-30

accepting values from the user, 6-27, 13-10

input area, 2-6

editing, 5-2

INPUT command, 6-4, 6-7, 13-71

entering several lines, 13-71

INSERT clause, B-3, B-7

INSERT command

disabling, 10-5

installation

default users created, 4-17

INSTANCE variable, 13-110

instances

shutting down, 13-129

starting, 13-134

Interface options screen, 2-9

iplus.css, 3-11

iplusdba.pw, 10-11

iplus.pw, 10-10

iSQL*Plus, 2-3

access modes, 10-9

cascading style sheet, 3-11

Change Password screen, 4-19

configuring, 3-5

configuring extension for windows, 3-15

configuring globalization support, 12-3

configuring HTTP Server, 3-12

configuring Oracle Net, 3-15

DBA Login screen, 2-10

DBA Work screen, 2-12

enabling cookies, 3-5

enabling HTTP Server authentication, 3-11

enabling javascript, 3-5

enabling or disabling, 3-14

entering commands, 2-6

exiting, 4-15

Expired Password screen, 4-19

extension for windows, 2-16

globalization support, 12-1

History screen, 2-6

Interface options screen, 2-9

iSQLPlusHashTableSize parameter, 9-13

iSQLPlusNumberOfThreads parameter, 9-13

language support, 4-14

Login screen, 2-4, 4-14

online help, 4-14

overview, 2-3

Preferences screen, 2-8

security, 10-9

Server configuration, 3-7

server parameters, 2-14

server statistics, 2-12

session, 1-5

setting system variables, 2-14

starting, 4-14, 4-15

System variables screen, 2-14

three-tier model, 1-4

unsupported commands, D-1

user access, 10-9

user interface, 1-4, 1-5, 2-3

Work screen, 2-5

iSQL*Plus error messages, 14-35

iSQL*Plus Server

active statistics, 9-12

authentication, 10-10

configuring httpd.conf, 3-12

configuring oracle_apache.conf, 3-12

enabling DBA access, 10-11

enabling restricted database access, 10-10

isqlplus.conf, 3-8, 3-9, 3-10, 3-11, 3-12, 10-11

iSQLPlusConnectIdList, 10-10

iSQLPlusHashTableSize parameter, 9-13

iSQLPlusNumberOfThreads parameter, 9-13

iSQLPlusTimeOutInterval parameter, 9-14

Japanese, 12-2, 12-3

javascript, configuring for iSQL*Plus, 3-5

JUSTIFY clause, 13-34

LABEL variable

SHOW command, C-2, C-7

labels

in COMPUTE command, 7-17, 13-41

language support in iSQL*Plus, 4-14

LEFT clause, 7-26, 13-90, 13-142

LIKE clause, 7-9, 13-17, 13-34

limits, SQL*Plus, A-1

line numbers, for SQL commands, 5-4

lines

adding at beginning of buffer, 13-71

adding at end of buffer, 13-71

adding new after current, 6-7, 13-71

appending text to, 6-8, 13-12

changing width, 7-32, 13-111

deleting all in buffer, 13-51

deleting from buffer, 6-9, 13-51

determining which is current, 6-6

editing current, 6-6

listing all in buffer, 6-4, 13-73

removing blanks at end, 13-122

LINESIZE variable, 7-25, 7-32, 13-111

LIST clause, 13-13, 13-66

LIST command, 6-4, 13-73

determining current line, 6-6, 13-73

making last line current, 6-6, 13-73

using an asterisk, 6-4, 13-73

LNO clause, 13-125

load script button, 2-6

LOBOFFSET variable, 13-111

LOCK TABLE command

disabling, 10-5

log in button, 2-5, 2-12

LOG_ARCHIVE_DEST parameter, 13-13

LOGFILE clause, 13-80

logging off

conditionally, 13-152, 13-154

Oracle, 4-18, 13-60

SQL*Plus, 4-13, 13-64

logging on

default users created at installation, 4-17

Oracle, 4-22, 13-46

SQL*Plus, 4-2

Login screen, 2-4, 2-10, 4-14, 10-10

LOGIN.SQL, 3-2

including SET commands, 3-3

sample commands to include, 3-3

See also GLOGIN.SQL

storing current date in variable for titles, 7-31

login.sql

See glogin.sql

Logout, 4-15

LONG

column definition from DESCRIBE, 13-53

LONG columns

changing format, 7-6, 13-31

default format, 13-31

setting maximum width, 13-112

setting retrieval size, 13-112

LONG variable, 13-112

effect on COPY command, B-4, B-8

LONGCHUNKSIZE variable, 7-6, 13-31, 13-112

LONGRAW

column definition from DESCRIBE, 13-53

-MARKUP, 4-4, 8-2

SPOOL clause, 4-6

SQLPLUS command clause, 4-5

MARKUP, 4-4, 8-2, 13-112

BODY clause, 4-6

ENTMAP clause, 4-6

HEAD clause, 4-6

PREFORMAT clause, 4-8

SPOOL clause, 4-6

TABLE clause, 4-6

MAXDATA variable, C-2, C-6

MAXIMUM function, 7-17

media recovery, 13-135

message, sending to screen, 6-27, 13-78

Microsoft Internet Explorer

configuring proxy exceptions, 3-6

middle tier, 1-4

configuration, 3-7

MIME type

configuration, 3-5

MINIMUM function, 7-17

mod_ssl, 10-9

MOUNT clause, 13-135

mounting a database, 13-135

national language support, 12-2, 12-3

character encoding, 12-3

font, 12-3

See also globalization support

NCHAR clause

VARIABLE command, 13-145

NCHAR columns

changing format, 7-6, 13-31

default format, 7-6, 13-31

NCLOB clause

VARIABLE command, 13-146

NCLOB columns

changing format, 7-6, 13-31

default format, 13-31

setting maximum width, 13-112

setting retrieval position, 13-111

setting retrieval size, 13-112

negative infinity sign (-~), 13-34

Netscape Navigator

configuring proxy exceptions, 3-6

new password field, 4-19

NEW_VALUE clause, 7-29, 13-34

storing current date in variable for titles, 7-31, 13-35

NEWLINE clause, 13-34

NEWPAGE command, C-2, C-4

NEWPAGE variable, 7-32, 13-114

NEXT clause, 13-14

NLS, 12-2, 12-3

NLS_DATE_FORMAT, 13-10, 13-39

NOAUDIT command

disabling, 10-5

NOLIST clause, 13-66

NOLOG, 4-11

/NOLOG option, 4-11

NOMOUNT clause, 13-135

NONE clause

WHENEVER OSERROR, 13-153

WHENEVER SQLERROR, 13-155

NOPRINT clause, 7-17, 7-29, 13-35

NOPROMPT clause, 13-11

NORMAL mode, 13-129

NULL clause, 13-35

null values

setting text displayed, 13-35, 13-114

NULL variable, 13-114

NUMBER

column definition from DESCRIBE, 13-53

NUMBER clause, 6-30, 13-10

VARIABLE command, 13-145

NUMBER columns

changing format, 7-4, 13-32

default format, 7-4, 13-33

number formats

$, 7-5

0, 7-5

9, 7-5

comma, 7-5

setting default, 13-114

NUMBER function, 7-17

NUMFORMAT clause

in LOGIN.SQL, 3-3

NUMFORMAT variable, 13-114

NUMWIDTH variable, 13-114

effect on NUMBER column format, 7-4, 13-33

NVARCHAR2 columns

changing format, 7-6, 13-31

default format, 7-6, 13-31

objects, describing, 13-106

obsolete commands

BTITLE, C-3

COLUMN command DEFAULT clause, C-3

DOCUMENT, C-2, C-3

NEWPAGE, C-2, C-4

SET command BUFFER variable, C-4

SET command CLOSECURSOR variable, C-2, C-5

SET command DOCUMENT variable, C-2, C-5

SET command MAXDATA variable, C-2, C-6

SET command SCAN variable, C-2, C-6

obsolete commands (continued)

SET command SPACE variable, C-2, C-6

SET command TRUNCATE variable, C-2, C-7

SHOW command LABEL variable, C-2, C-7

TTITLE command old form, C-7

OF clause, 7-16

OFF clause, 13-36

in ATTRIBUTE command, 13-17

in COLUMN command, 7-10, 13-36

in REPFOOTER commands, 13-90

in REPHEADER commands, 13-90

in SPOOL command, 7-34, 13-131

in TTITLE and BTITLE commands, 7-29, 13-141

old password field, 4-19

OLD_VALUE clause, 7-30, 13-35

ON clause

in ATTRIBUTE command, 13-17

in COLUMN command, 7-10, 13-36

in TTITLE and BTITLE commands, 7-29

ON column clause

in BREAK command, 7-13, 13-18

in COMPUTE command, 7-16, 13-41

ON expr clause

in BREAK command, 13-19

in COMPUTE command, 13-41

ON REPORT clause

in BREAK command, 7-20, 13-20

in COMPUTE command, 7-20, 13-41

ON ROW clause

in BREAK command, 7-14, 13-20

in COMPUTE command, 13-41

online help, 4-12, 13-68

OPEN clause, 13-135

opening a database, 13-135

Oracle HTTP Server, 1-5

administrator, 10-12

authentication username/password entries, 3-11, 10-11

configuration, 3-7

configuring, 3-12

configuring globalization support, 12-4

glogin.sql, 10-13

Product User Profile table, 10-13

starting and stopping, 3-13

testing configuration file, 3-12

Oracle Net, 1-4, 10-9

connect identifier, 13-46

protocol, 4-22

security, 10-9

Oracle Net, configuring, 3-15

oracle_apache.conf, 3-12, 3-14

Oracle9i, 1-4, 3-15

globalization support, 12-2, 12-4

ORDER BY clause

displaying column values in titles, 7-29

displaying values together in output, 7-12

OUT clause, 7-35, 13-131

output

formatting white space in, 13-122

pausing during display, 5-15, 13-115

output options

file, 2-9

new window, 2-9

work screen, 2-9

PAGE clause, 13-89

page number, including in titles, 7-15, 7-27

pages

changing length, 7-31, 13-115

default dimensions, 7-31

matching to screen or paper size, 7-31

setting dimensions, 7-31

PAGESIZE clause

in LOGIN.SQL, 3-3

PAGESIZE variable, 5-4, 7-32, 13-115

parameter files (INIT.ORA files)

specifying alternate, 13-134

parameters, 6-26, 13-5, 13-132

-idle-timeout, 9-14

iSQL*Plus server, 2-14

iSQLPlusHashTableSize, 9-13

iSQLPlusNumberOfThreads, 9-13

iSQLPlusTimeOutInterval, 9-14

PARAMETERS clause, 13-125

parsing httpd.conf file, 3-15

password, 4-17

changing in iSQL*Plus, 2-8, 4-19

password (continued) password (continued)

changing with the PASSWORD command, 13-75

field, 2-4, 2-11

HTTP Server authentication, 2-10

in CONNECT command, 4-18, 4-22, 13-46

in COPY command, B-5, B-8, B-9

in SQLPLUS command, 4-2, 4-10, 4-21

viewable warning, 4-10

PASSWORD command, 13-46, 13-75

disabling, 10-5

PAUSE command, 6-30, 13-76

in LOGIN.SQL, 3-3

PAUSE variable, 5-15, 13-115

performance

of SQL statements, 9-2

over dial-up lines, 13-122

period (.)

terminating PL/SQL blocks, 5-7, 13-102

PLAN_TABLE table, 9-2

PLAN_TABLE, creating, 9-2

PL/SQL, 5-7

blocks, PL/SQL, 5-7

executing, 13-63

formatting output in SQL*Plus, 13-147

listing definitions, 5-14

mode in SQL*Plus, 5-6

within SQL commands, 5-6

PLUSTRACE role, 9-2

PLUSTRACE, creating role, 9-3

PNO clause, 13-126

pound sign (#), 13-34

Preferences screen, 2-8

PREFORMAT, 4-8

PREFORMAT clause, 4-8

PRINT clause, 13-35

PRINT command, 13-77

printing

bind variables automatically, 13-101

REFCURSOR variables, 13-147

SPOOL command, 13-131

privileges

list, 2-11

Product User Profile table, 10-13

PRODUCT_USER_PROFILE table, 10-2

prompt

SET SQLPROMPT, 13-120

PROMPT clause, 6-28, 13-11

PROMPT command, 6-27, 13-78

customizing prompts for value, 6-29

prompts for value

bypassing with parameters, 6-26

customizing, 6-29

through ACCEPT, 6-27

through substitution variables, 6-19

proxy server exceptions

configuration, 3-6

Microsoft Internet Explorer, 3-6

Netscape Navigator, 3-6

PUPBLD.SQL, 10-2

queries

in COPY command, B-3, B-6

show number of records retrieved, 5-4, 13-108

queries, tracing, 9-7

query execution path

including in report, 13-102

query results

displaying on-screen, 5-4

sending to a printer, 7-35, 13-131

storing in a file, 7-34, 13-131

QUIT command, 13-64

See also EXIT

RAW

column definition from DESCRIBE, 13-53

record separators, printing, 7-10, 13-115

RECOVER clause, 13-135

RECOVER command, 13-79

and database recovery, 11-5

AUTOMATIC clause, 13-80

CANCEL clause, 13-81, 13-83

CONTINUE clause, 13-80

DATABASE clause, 13-81

FROM clause, 13-80

RECOVER command (continued) RECOVER command (continued)

LOGFILE clause, 13-80

STANDBY DATABASE clause, 13-81

STANDBY DATAFILE clause, 13-82

STANDBY TABLESPACE clause, 13-82

UNTIL CANCEL clause, 13-81

UNTIL CONTROLFILE clause, 13-82

UNTIL TIME clause, 13-81

USING BACKUP CONTROL FILE clause, 13-81

recovery

RECOVER command, 13-79

RECSEP variable, 7-10, 13-115

RECSEPCHAR variable, 7-10, 13-115

redo Log Files

ARCHIVE LOG command, 13-13

REFCURSOR bind variables

in a stored function, 6-32

REFCURSOR clause

VARIABLE command, 13-147

RELEASE clause, 13-126

REMARK command, 6-10, 13-86

remote database

connect identifier, 2-5, 2-11, 4-21

removing sample tables, 1-8

RENAME command, disabling, 10-5

REPFOOTER clause, 13-126

REPFOOTER command, 7-23, 13-87

aligning footer elements, 13-90

BOLD clause, 13-90

CENTER clause, 13-90

COL clause, 13-90

FORMAT clause, 13-90

indenting report footers, 13-90

LEFT clause, 13-90

OFF clause, 13-90

RIGHT clause, 13-90

SKIP clause, 13-90

suppressing current definition, 13-90

TAB clause, 13-90

REPHEADER clause, 13-126

REPHEADER command, 7-23, 13-89

aligning header elements, 7-25

aligning heading elements, 13-90

BOLD clause, 13-90

CENTER clause, 13-90

COL clause, 13-90

FORMAT clause, 13-90

indenting headings, 13-90

LEFT clause, 13-90

OFF clause, 13-90

PAGE clause, 13-89

RIGHT clause, 13-90

SKIP clause, 13-90

suppressing current definition, 13-90

TAB clause, 13-90

REPLACE clause

in COPY command, B-3, B-7

in SAVE command, 13-93

reports

autotrace, 9-2

breaks, 13-18

clarifying with spacing and summary lines, 7-12

columns, 13-30

creating bottom titles, 7-23, 13-23, C-2

creating dynamic, 8-13

creating footers, 13-87

creating headers, 13-89

creating headers and footers, 7-23

creating master/detail, 7-29, 13-35

creating top titles, 7-23, 13-141, C-2

displaying, 13-102

embedded CGI example, 8-7

formatting column headings, 7-2, 13-29

formatting columns, 7-4, 7-6, 13-29

interactive HTML example, 8-3, 8-6

on the web, 8-2

running from a URL, 8-13

SILENT mode, 8-12

starting on a new page, 13-107

title, 13-141, C-2

RESTRICT, 4-9, 10-8, 13-134

restricted database access, 10-10

return code, specifying, 6-17, 13-65, 13-155

retype new password field, 4-19

REVOKE command, 10-2

disabling, 10-5

RIGHT clause, 7-26, 13-90, 13-142

roles, 10-6

disabling, 10-7

re-enabling, 10-8

ROLLBACK clause, 13-65

WHENEVER OSERROR, 13-152

WHENEVER SQLERROR, 13-154

ROWID

column definition from DESCRIBE, 13-53

rows

performing computations on, 7-16, 13-40

setting number retrieved at one time, 9-10, 13-100

setting the number after which COPY commits, 13-105

RUN command, 5-7, 13-92

disabling, 10-5

executing current PL/SQL block, 5-7

executing current SQL command or PL/SQL block, 5-7

making last line current, 6-6

similar to / (slash) command, 5-7, 13-92

sample tables

access to, 1-8

creating, 1-8

removing, 1-8

unlocking, 1-7

SAVE command, 13-93

APPEND clause, 13-93

CREATE clause, 13-93

disabling, 10-5

REPLACE clause, 13-93

storing commands in scripts, 13-93

using with INPUT to create scripts, 6-3

save script button, 2-6

saving environment attributes, 13-138

SCAN variable, C-2, C-6

SCREEN clause, 6-30, 13-27

screen, clearing, 6-30, 13-27

screens

Change Password, 4-19

connection identifier field, 2-5, 2-11

DBA Login, 2-10

DBA Work screen, 2-12

define substitution variables field, 6-25

enter statements field, 2-6, 2-7

Expired Password, 4-19

History, 2-6

Interface options, 2-9

Login, 2-4, 2-10

new password field, 4-19

old password field, 4-19

password field, 2-4, 2-11

Preferences, 2-8

privilege list, 2-11

retype new password field, 4-19

script location field, 2-8

System variables, 2-14

username field, 2-4, 2-11, 3-16, 4-19

Work, 2-5

scripts

editing, 5-2

extension, 13-93, 13-121, 13-138

location field, 2-8

See also command files

Secure Sockets Layer security, 10-9

security

changing password, 13-75

embedded web reports, 8-7

HTTP, 10-9

Oracle HTTP Server, 10-9

Oracle Net, 10-9

password viewable, 4-10

PRODUCT_USER_PROFILE table, 10-2

RESTRICT, 4-9, 10-8

Secure Sockets Layer (SSL), 10-9

SELECT command

and BREAK command, 7-12, 13-19, 13-20

and COLUMN command, 13-30

and COMPUTE command, 7-12

and COPY command, B-3, B-6

and DEFINE command, 13-49

and ORDER BY clause, 7-12

disabling, 10-5

formatting results, 6-32

storing current date in variable for titles, 7-31

semicolon (;)

in PL/SQL blocks, 5-7

in SQL commands, 5-4, 5-5

in SQL*Plus commands, 5-10, 13-1

not stored in buffer, 6-5

server

iSQL*Plus parameters, 2-14

SERVEROUTPUT variable, 13-116

service name

in CONNECT command, 4-22

in COPY command, B-5, B-8, B-9

in SQLPLUS command, 4-21

session

concurrent, 1-5

identification, 1-5, 3-7, 4-14

stateful behavior, 3-7

SET AUTOTRACE, 9-2

SET clause, 13-138

SET command, 3-3, 5-10, 13-95

affecting substitution variables, 6-24

APPINFO variable, 9-10, 13-99

ARRAYSIZE variable, 9-10, 13-100, B-8

AUTOCOMMIT variable, 5-11, 13-101

AUTOPRINT variable, 13-101, 13-147

AUTORECOVERY variable, 13-101

AUTOTRACE variable, 13-102

BLOCKTERMINATOR variable, 13-102

BUFFER variable, C-4

CLOSECURSOR variable, C-2, C-5

CMDSEP variable, 13-103

COLSEP variable, 7-34, 13-104

COMPATIBILITY variable, 13-104

CONCAT variable, 6-23, 13-105

COPYCOMMIT variable, 13-105, B-8

COPYTYPECHECK variable, 13-105

DEFINE clause, 6-23

DEFINE variable, 13-105

DESCRIBE variable, 13-106

disabling, 10-5

DOCUMENT variable, C-2, C-5

ECHO variable, 6-14, 13-107

EDITFILE variable, 13-107

EMBEDDED variable, 13-107

ESCAPE variable, 6-23, 13-108

FEEDBACK variable, 13-108

FLAGGER variable, 13-108

FLUSH variable, 13-109

HEADING variable, 13-109

HEADSEP variable, 7-3, 13-110

INSTANCE variable, 13-110

LINESIZE variable, 7-25, 7-32, 13-111

LOBOFFSET variable, 13-111

LOGSOURCE variable, 13-111

LONG variable, 13-112, B-8

LONGCHUNKSIZE variable, 13-112

MARKUP clause, 13-112

MAXDATA variable, C-2, C-6

NEWPAGE variable, 7-32, 13-114

NULL variable, 13-114

NUMFORMAT clause, 3-3

NUMFORMAT variable, 13-114

NUMWIDTH variable, 7-4, 13-33, 13-114

PAGESIZE clause, 3-3

PAGESIZE variable, 5-4, 7-32, 13-115

PAUSE clause, 3-3

PAUSE variable, 5-15, 13-115

RECSEP variable, 7-10, 13-115

RECSEPCHAR variable, 7-10, 13-115

SCAN variable, C-2, C-6

SERVEROUTPUT variable, 13-116

SHIFTINOUT variable, 13-117

SPACE variable, C-2, C-6

SQLBLANKLINES variable, 13-118

SQLCASE variable, 13-119

SQLCONTINUE variable, 13-119

SQLNUMBER variable, 13-120

SQLPLUSCOMPATIBILITY variable, 13-120

SQLPREFIX variable, 13-120

SQLPROMPT variable, 13-120

SQLTERMINATOR variable, 13-121

SUFFIX variable, 13-121

TAB variable, 13-122

TERMOUT variable, 13-122

TIME clause, 3-3

TIME variable, 13-122

TIMING variable, 13-122

TRIMOUT variable, 13-122

TRIMSPOOL variable, 13-123

TRUNCATE variable, C-2, C-7

UNDERLINE variable, 13-123

used to format a REFCURSOR variable, 13-147

VERIFY clause, 6-19

VERIFY variable, 6-23, 13-123

WRAP variable, 7-7, 13-123

SET MARKUP

BODY clause, 4-6

embedded CGI example, 8-7

ENTMAP clause, 4-6, 8-12

HEAD clause, 4-6

HTML, 4-5

interactive HTML example, 8-3, 8-6

PREFORMAT clause, 4-8

See also SPOOL command

SPOOL clause, 4-6

TABLE clause, 4-6

SET ROLE command

disabling, 10-5

SET TRANSACTION command

disabling, 10-5

SET variables, 5-10

See system variables

SGA clause, 13-126

SHIFTINOUT variable, 13-117

SHOW clause, 13-139

SHOW command, 5-11, 13-124

ALL clause, 13-124

BTITLE clause, 13-124

ERRORS clause, 13-125

LABEL variable, C-2, C-7

listing current page dimensions, 7-33

LNO clause, 13-125

PNO clause, 13-126

RELEASE clause, 13-126

REPFOOTER clause, 13-126

REPHEADER clause, 13-126

SPOOL clause, 13-126

SQLCODE clause, 13-126

TTITLE clause, 13-126

USER clause, 13-126

SHOWMODE variable, 13-118

SHUTDOWN command, 13-129

ABORT, 13-129

IMMEDIATE, 13-129

NORMAL, 13-129

TRANSACTIONAL LOCAL, 13-130

-SILENT option, 4-10, 8-12

site profile

GLOGIN.SQL, 3-2

LOGIN.SQL, 3-2

See also user profile

SKIP clause

in BREAK command, 7-13, 7-14, 13-20

in REPHEADER and REPFOOTER commands, 13-90

in TTITLE and BTITLE commands, 7-26, 13-142

to place blank lines before bottom title, 7-26

SKIP PAGE clause, 7-13, 7-14, 13-21

slash (/) command, 13-9

files loaded with GET command, 13-66

SPACE variable, C-2, C-6

SPOOL clause, 4-6, 4-7, 13-126

SPOOL command, 7-33, 13-131

disabling, 10-5

file name, 7-34, 13-131

OFF clause, 7-34, 13-131

OUT clause, 7-35, 13-131

to HTML file, 4-8

turning spooling off, 7-34, 13-131

use with SET MARKUP, 8-3

SQL buffer, 5-2

SQL clause, 13-28

SQL DML statements

reporting on, 13-102

SQL optimizer, 9-3

SQL*Plus

command prompt, 4-2

command summary, 13-2,

command-line, 2-2

configuring globalization support, 12-2

database administration, 11-2

execution plan, 9-3

exiting, 4-13, 13-64

exiting conditionally, 13-152, 13-154

globalization support, 12-1

limits, A-1

obsolete command alternatives, C-2

running commands in batch mode, 6-17

setting up environment, 3-2

shortcuts to starting, 4-3

starting, 4-2, 4-3

statistics, 9-4

system variables affecting performance, 9-10

tuning, 9-2

who can use, 1-5

SQL*Plus error messages, 14-2

SQLBLANKLINES variable, 13-118

SQLCASE variable, 13-119

SQLCODE clause, 13-126

SHOW command, 13-126

SQLCONTINUE variable, 13-119

SQLNUMBER variable, 13-120

SQLPLUS command, 4-2

- clause, 4-4

-? clause, 4-4

and @ ("at" sign), 4-3, 4-21, 6-15

and EXIT FAILURE, 6-16

BODY option, 4-6

commands

SQLPLUS, 4-3

connect identifier, 4-11

connecting to a remote database, 4-21

display syntax, 4-4

ENTMAP option, 4-6

HEAD option, 4-6

HTML option, 4-5

-MARKUP clause, 4-5

-MARKUP option, 4-4

-MARKUP SPOOL clause, 4-6

/NOLOG clause, 4-11

PREFORMAT option, 4-8

RESTRICT, 4-9, 10-8

running scripts, 6-15

service name, 4-11, 4-21

-SILENT clause, 4-10

-SILENT option, 4-10, 8-12

SPOOL clause, 4-7

syntax, 4-3

SYSDBA clause, 4-11

TABLE option, 4-6

unsuccessful connection, 6-16

username/password, 4-2, 4-10

SQL.PNO, referencing in report titles, 7-27

SQLPREFIX variable, 13-120

SQLPROMPT variable, 13-120

SQL.SQLCODE

using in EXIT command, 13-64

SQLTERMINATOR, 13-118

SQLTERMINATOR variable, 13-69, 13-121

SSL security, 10-9

STANDBY DATAFILE clause, 13-82

STANDBY TABLESPACE clause, 13-82

START clause, 13-14, 13-139

START command, 6-14, 13-132

arguments, 6-26

disabling, 10-5

passing parameters to a script, 6-26

script, 6-14, 13-132

similar to @ ("at" sign) command, 6-14, 13-6, 13-133

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

starting

iSQL*Plus, 4-14, 4-15

Oracle HTTP Server, 3-13

SQL*Plus, 2-2, 4-2

SQL*Plus shortcuts, 4-3

STARTUP command, 13-134

FORCE clause, 13-134

MOUNT clause, 13-135

NOMOUNT clause, 13-135

OPEN clause, 13-135

PFILE clause, 13-134

RECOVER clause, 13-135

RESTRICT clause, 13-134

specifying a database, 13-135

statements

executing, 5-3

statistics, 9-4

collecting TIMING statistics, 9-7

interpreting iSQL*Plus active statistics, 9-13

iSQL*Plus Server, 2-12

iSQL*Plus Server active statistics, 9-12

STD function, 7-17

STOP clause, 13-14, 13-139

stop query, 5-12

stopping Oracle HTTP Server, 3-13

STORE command, 3-3, 13-138

SET clause, 13-138

stored functions, 6-32

stored procedures

creating, 5-6

substitution variables, 6-18, 6-24

appending characters immediately after, 6-20

avoiding unnecessary prompts for value, 6-21

substitution variables (continued) substitution variables (continued)

concatenation character, 13-105

DEFINE command, 6-21, 13-49

defined, 6-21

parsing, 9-11

prefixing, 13-105, C-2

restrictions, 6-23

single and double ampersands, 6-21

system variables used with, 6-23

undefined, 6-19

where and how to use, 6-19

SUFFIX variable, 13-121

used with @ ("at" sign) command, 13-5

used with EDIT command, 13-61

used with GET command, 13-66

used with SAVE command, 13-93

used with START command, 13-132

SUM function, 7-17

summary lines

computing and printing, 7-16, 13-40

computing and printing at ends of reports, 7-20

computing same type, different columns, 7-20

printing "grand" and "sub" summaries (totals), 7-20

printing multiple on same break column, 7-21

syntax

COPY command, B-5

syntax rules

SQL commands, 5-4

SQL*Plus commands, 5-9

SYSDATE, 7-31

SYSDBA clause, 13-47

SYSOPER clause, 4-11, 13-47

system variables, 5-10,

affecting SQL*Plus performance, 9-10

listing current settings, 5-11, 13-124

listing old and new values, 13-118

setting in iSQL*Plus, 2-14

storing and restoring, 3-3

used with substitution variables, 6-23

System variables screen, 2-14

system-maintained values

displaying in headers and footers, 13-89

displaying in titles, 7-27, 13-141

formatting in titles, 7-28

TAB clause, 13-90, 13-142

TAB variable, 13-122

TABLE clause, 4-6

TABLE option, 4-6

tables

access to sample, 1-8

controlling destination when copying, B-3, B-7

copying values between, B-2, B-5, B-9

listing column definitions, 5-13, 13-53

referring to another user's when copying, B-9

TABLESPACE clause, 13-81

tablespaces, recovering, 13-79

tag, HTML, 8-2

TERMOUT variable, 13-122

using with SPOOL command, 13-131

text, 4-6

adding to current line with APPEND, 6-8, 13-12

changing old to new with CHANGE, 6-6, 13-24

clearing from buffer, 6-4, 13-27

text editor, host operating system, 6-2, 13-61

three-tier model, 1-4

TIME clause in LOGIN.SQL, 3-3

TIME variable, 13-122

TIMING clause, 13-28

TIMING command, 9-7, 13-139

deleting all areas created by, 13-28

deleting current area, 13-139

SHOW clause, 13-139

START clause, 13-139

STOP clause, 13-139

TIMING variable, 13-122

titles

aligning elements, 7-25, 13-142

displaying at bottom of page, 7-23, 13-23, C-2

displaying at top of page, 7-23, 13-141, C-2

displaying column values, 7-29, 13-34, 13-35

displaying current date, 7-30, 13-35, 13-37

displaying page number, 7-27, 13-143

displaying system-maintained values, 7-27, 13-141

formatting elements, 13-142

formatting system-maintained values in, 7-28

indenting, 7-26, 13-142

titles (continued)

listing current definition, 7-29, 13-23, 13-143

restoring definition, 7-29

setting at start or end of report, 7-23

setting lines, top of page to top title, 7-32, 13-114, C-2

setting lines, top title to page end, 13-115

setting top and bottom, 7-23, 13-23, 13-141, C-2

spacing between last row and bottom title, 7-26

suppressing definition, 7-29, 13-141

TNS alias, 2-5, 2-11, 4-21

TO clause, B-5

tracing queries, 9-7

tracing statements

for performance statistics, 9-5

for query execution path, 9-5

using a database link, 9-7

with parallel query option, 9-8

TRIMOUT variable, 13-122

TRIMSPOOL variable, 13-123

TRUNCATE command

disabling, 10-5

TRUNCATE variable, C-2, C-7

TRUNCATED clause, 7-7, 13-36

TTITLE clause, 13-126

TTITLE command, 7-23, 13-141

aligning title elements, 7-25, 13-142

BOLD clause, 13-142

CENTER clause, 7-26, 13-142

COL clause, 7-26, 13-142

FORMAT clause, 7-28, 13-142

indenting titles, 7-26, 13-142

LEFT clause, 7-26, 13-142

listing current definition, 7-29, 13-143

OFF clause, 7-29, 13-141

old form, C-7

ON clause, 7-29

referencing column value variable, 7-29, 13-34

restoring current definition, 7-29

RIGHT clause, 7-26, 13-142

SKIP clause, 7-26, 13-142

suppressing current definition, 7-29, 13-141

TAB clause, 13-142

tuning

-idle-timeout, 9-14

iSQL*Plus active statistics, 9-12

iSQLPlusHashTableSize, 9-13

iSQLPlusNumberOfThreads, 9-13

iSQLPlusTimeOutInterval, 9-14

SET APPINFO OFF, 9-10

SET ARRAYSIZE, 9-10

SET DEFINE OFF, 9-11

SET FLUSH OFF, 9-11

SET SERVEROUTPUT OFF, 9-11

SET TRIMOUT ON, 9-11

SET TRIMSPOOL ON, 9-11

SQL*Plus, 9-2

system variables, 9-10

UNDEFINE command, 6-18, 13-144

and DEFINE command, 13-49

UNDERLINE variable, 13-123

unicode, 12-2, 12-3

unlocking sample tables, 1-7

UNTIL CANCEL clause, 13-81

UNTIL CHANGE clause, 13-81

UNTIL CONTROLFILE clause, 13-82

UNTIL TIME clause, 13-81

UPDATE command, disabling, 10-5

URL, 1-5

running dynamic reports, 8-13

starting iSQL*Plus, 4-15

USER clause, 13-126

user interfaces, 2-3

command-line, 2-2

user profile, 3-2

GLOGIN.SQL, 3-2

LOGIN.SQL, 3-2

See also site profile

user variables, 6-17

defining, 6-17, 13-49

deleting, 6-18, 13-144

displaying in headers and footers, 13-89

displaying in titles, 13-141

in ACCEPT command, 6-27, 13-10

listing definition of one, 6-17, 13-49

listing definitions of all, 6-18, 13-49

username, 4-17

connecting under different, 4-18, 13-46

created at installation, 4-17

field, 2-4, 2-11, 3-16, 4-19

in CONNECT command, 4-18, 13-46

in COPY command, B-5, B-8, B-9

in SQLPLUS command, 4-2, 4-10, 4-21

username/password

adding authentication file entries, 10-12

USING BACKUP CONTROL FILE clause, 13-81

USING clause, B-3, B-6

UTF-8, 12-2, 12-3

V$SESSION virtual table, 13-99

V$SQLAREA virtual table, 13-99

VARCHAR columns

changing format, 7-6

default format, 7-6, 13-31

VARCHAR2

column definition from DESCRIBE, 13-53

VARCHAR2 clause

VARIABLE command, 13-146

VARCHAR2 columns

changing format, 7-6, 13-31

default format, 7-6

VARIABLE command, 13-145

CHAR clause, 13-145

CLOB clause, 13-146

NCHAR clause, 13-145

NCLOB clause, 13-146

NUMBER clause, 13-145

REFCURSOR clause, 13-147

VARCHAR2 clause, 13-146

variable clause, 13-145

variables

bind variables, 6-31

substitution, 6-24

substitution variables, 6-18

system variables, 5-10

user variables, 13-49

VARIANCE function, 7-17

VERIFY clause, 6-19

VERIFY variable, 6-23, 13-123

WARNING clause, 13-64

web browser, 1-4, 2-3, 8-2

web, outputting reports, 8-2

WHENEVER OSERROR command, 13-152

COMMIT clause, 13-152

CONTINUE clause, 13-152

EXIT clause, 13-152

NONE clause, 13-153

ROLLBACK clause, 13-152

WHENEVER SQLERROR command, 6-17, 13-154

COMMIT clause, 13-154

CONTINUE clause, 13-154

EXIT clause, 13-154

NONE clause, 13-155

ROLLBACK clause, 13-154

window, output, 2-9

windows iSQL*Plus extension, 2-16

WORD_WRAPPED clause, 7-7, 7-10, 13-36

Work screen, 2-5

output options, 2-9

WRAP variable, 7-7, 13-123

WRAPPED clause, 7-7, 13-36

XMLType

column definition from DESCRIBE, 13-53

column formatting, 7-8

column width, 7-6

creating, 7-8

formatting in reports, 7-6

inserting values, 7-8

selecting data, 7-8

setting column retrieval size, 13-112

setting maximum column width, 13-112

Index

Symbols

Numerics

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W

X