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

-- (comment delimiter), 3-12

- (hyphen)

clause, 7-2

continuing a long SQL*Plus command, 2-12, 8-1

. (period), 2-10

/ (slash) command

default logon, 7-9, 8-47

entered at buffer line-number prompt, 2-8, 8-9

entered at command prompt, 2-10, 8-9

executing current PL/SQL block, 2-10

executing current SQL command, 2-10

similar to RUN, 2-10, 8-9, 8-95

usage, 8-9

# pound sign, 8-35

$ number format, 4-5

& (ampersand)

substitution variables, 3-22

* (asterisk)

in DEL command, 3-2, 8-54

in LIST command, 3-2, 8-75

/*...*/ (comment delimiters), 3-12

: (colon)

bind variables, 3-31

:BindVariable clause

EXIT command, 8-67

; (semicolon), 2-6

@ ("at" sign)

command, 3-16, 3-20, 8-5

command arguments, 8-5

command file, 3-16, 8-5

in CONNECT command, 6-3, 8-47

in COPY command, 6-5, 8-49

in SQLPLUS command, 3-17, 6-4, 7-2

passing parameters to a command file, 8-5

similar to START, 3-16, 8-6, 8-132

@@ (double "at" sign) command, 3-20, 8-7

command file, 8-7

similar to START, 8-7, 8-132

[Backspace] key, 2-2

[Cancel] key, 2-2, 2-15

[Interrupt] key, 2-2

[Pause] key, 2-2, 2-17

[Resume] key, 2-2

[Return] key, 2-2

_EDITOR, in EDIT command, 3-8, 8-64

~ infinity sign, 8-35

-~ negative infinity sign, 8-35

0, number format, 4-5

9, number format, 4-5

ABORT mode, 8-128

ACCEPT command, 3-28, 8-10

and DEFINE command, 8-52

CHAR clause, 8-10

customizing prompts for value, 3-30

DATE clause, 8-10

DEFAULT clause, 8-11

FORMAT clause, 8-10

HIDE clause, 8-11

NOPROMPT clause, 8-11

NUMBER clause, 3-30

PROMPT clause, 3-29, 8-11

access, denying and granting, E-2

account, GL-1, GL-24

alias, GL-1, GL-23

ALIAS clause, 8-31

in ATTRIBUTE command, 8-17

alignment, GL-1

ALL clause, 8-123

ALTER command

disabling, E-5

ampersands (&)

in parameters, 3-27, 8-5, 8-131

substitution variables, 3-22

ANALYZE command

disabling, E-5

anonymous block, GL-1

APPEND clause

in COPY command, 6-7, 8-50

in SAVE command, 3-18, 8-96

APPEND command, 3-2, 3-6, 8-12

APPINFO clause, 8-99

ARCH background process, 8-14

ARCHIVE LOG

command, 5-4, 8-13

mode, 5-4

archived redo log, GL-1

ARCHIVELOG, GL-1

argument, GL-2

in START command, 3-27, 8-131

array processing, GL-2

ARRAYSIZE variable, 8-100

relationship to COPY command, 6-8, 8-51

ASCII, GL-2

attribute

display characteristics, 8-17

ATTRIBUTE command, 8-17

ALIAS clause, 8-17

and CLEAR COLUMN command, 8-18

CLEAR clause, 8-18

clearing columns, 8-28, 8-31

controlling display characteristics, 8-18

entering multiple, 8-18

FORMAT clause, 8-18

LIKE clause, 8-18

listing all attributes' display characteristics, 8-17

listing an attribute's display characteristics, 8-17

OFF clause, 8-18

ON clause, 8-18

restoring column display attributes, 8-18

suppressing column display attributes, 8-18

AUDIT command

disabling, E-5

autocommit, GL-2

AUTOCOMMIT variable, 2-14, 8-100

AUTOMATIC clause, 8-82

AUTOPRINT variable, 8-101

AUTORECOVERY variable, 8-101

AUTOTRACE variable, 3-36, 8-101

AVG function, 4-16

background process, GL-2

startup after abnormal termination, 8-128

batch mode, 3-18, 8-68

BEGIN command, 2-10

disabling, E-6

bind reference, GL-2

bind variables, 3-31, GL-2, GL-25

creating, 8-145

displaying, 8-79

displaying automatically, 8-101, 8-146

in PL/SQL blocks, 8-146

in SQL statements, 8-146

in the COPY command, 8-146

REFCURSOR, 3-33

bit, GL-3

blank line

in PL/SQL blocks, 2-10

in SQL commands, 2-8

preserving in SQL commands, 8-110

blocks, GL-3

blocks, PL/SQL, 1-2

continuing, 2-10

editing in buffer, 3-2

editing with host system editor, 3-7, 8-64

entering and executing, 2-10

listing current in buffer, 3-3

run from SQL buffer, 2-10

saving current, 3-8, 8-96

setting character used to end, 8-102

stored in SQL buffer, 2-10

storing in command files, 3-8

timing statistics, 8-111

within SQL commands, 2-8

BLOCKTERMINATOR, 8-102, 8-110, 8-111

body, GL-3

BODY clause, 7-4

BODY option, 7-4

BOLD clause, 8-92, 8-141

break, GL-3

break columns, 4-11, 8-19, GL-3

inserting space when value changes, 4-13

specifying multiple, 4-14

suppressing duplicate values in, 4-12

BREAK command, 4-11, 8-19

and SQL ORDER BY clause, 4-11, 4-12, 4-14, 8-20

clearing BREAKS, 4-15

displaying column values in titles, 4-29

DUPLICATES clause, 8-22

inserting space after every row, 4-13

inserting space when break column changes, 4-13

listing current break definition, 4-15, 8-22

ON column clause, 4-12, 8-19

ON expr clause, 8-20

ON REPORT clause, 4-19, 8-21

ON ROW clause, 4-13, 8-21

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

printing summary lines at ends of reports, 4-19

removing definition, 8-28

SKIP clause, 4-13, 8-21

SKIP PAGE clause, 4-13, 4-14, 8-22

specifying multiple break columns, 4-14, 8-19

storing current date in variable for titles, 4-30

suppressing duplicate values, 4-12

used in conjunction with COMPUTE, 4-15, 8-19, 8-21, 8-43

used in conjunction with SET COLSEP, 8-103

used to format a REFCURSOR variable, 8-147

break definition

listing current, 4-15, 8-22

removing current, 4-15, 8-28

break group, GL-3

break hierarchy, GL-3

break order, GL-3

break report, GL-3

BREAKS clause, 4-15, 8-28

browser, web, 4-38

BTITLE clause, 8-124

BTITLE command, 4-22, 8-24, GL-24

aligning title elements, 8-141

BOLD clause, 8-141

CENTER clause, 8-141

COL clause, 8-141

FORMAT clause, 8-142

indenting titles, 8-141

LEFT clause, 8-141

OFF clause, 8-141

old form, F-3

printing blank lines before bottom title, 4-25

referencing column value variable, 8-36

RIGHT clause, 8-141

SKIP clause, 8-141

suppressing current definition, 8-141

TAB clause, 8-141

TTITLE command, 8-24

buffer, 2-9, GL-4, GL-21

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

delete a single line, 3-2

delete the current line, 3-2

delete the last line, 3-2

deleting a range of lines, 3-2, 8-54

deleting a single line, 8-54

deleting all lines, 3-2, 8-28, 8-54

deleting lines from, 3-7, 8-54

deleting the current line, 8-54

deleting the last line, 8-54

executing contents, 2-10, 8-9, 8-95

inserting new line in, 3-5, 8-73

listing a range of lines, 3-3, 8-75

listing a single line, 3-2, 8-75

listing all lines, 3-2, 8-75

listing contents, 3-3, 8-75

listing the current line, 3-2, 8-75

listing the last line, 3-3, 8-75

loading into host system editor, 3-8, 8-64

saving contents, 3-8, 8-96

BUFFER clause, 3-2, 3-10, 8-28

BUFFER variable, F-4

byte, GL-4

CANCEL clause, 8-84

CENTER clause, 4-25, 8-92, 8-141

CGI scripts, 4-42, GL-6

CHANGE command, 3-2, 3-3, 8-25

CHAR clause, 8-10

VARIABLE command, 8-145

CHAR columns

changing format, 4-6, 8-32

default format, 4-6, 8-32

CHAR datatype, GL-4

character, GL-4

character string, GL-4

clause, GL-4

CLEAR clause, 4-9, 8-31

in ATTRIBUTE command, 8-18

CLEAR command, 8-28

BREAKS clause, 4-15, 8-28

BUFFER clause, 3-2, 3-10, 8-28

COLUMNS clause, 4-9, 8-28

COMPUTES clause, 8-28

SCREEN clause, 3-31, 8-28

SQL clause, 8-29

TIMING clause, 8-29

client, GL-4

CLOB clause

VARIABLE command, 8-146

CLOB columns

changing format, 4-6, 8-32

default format, 8-32

setting maximum width, 8-107

setting retrieval position, 8-107

setting retrieval size, 8-107

CLOB datatype, GL-4

CLOSECURSOR variable, F-2, F-5

CMDSEP variable, 8-102

COL clause, 4-26, 8-92, 8-141

colons (:)

bind variables, 3-31

COLSEP variable, 8-102

column, GL-5

format, GL-24

width, GL-25

COLUMN command, 4-2, 8-30

ALIAS clause, 8-31

and BREAK command, 8-21

and DEFINE command, 8-52

CLEAR clause, 4-9, 8-31

DEFAULT clause, F-3

displaying column values in bottom titles, 4-30, 8-36

displaying column values in top titles, 4-29, 8-35

entering multiple, 8-37

ENTMAP clause, 8-31

FOLD_AFTER clause, 8-31, 8-32

FOLD_BEFORE clause, 8-32

FORMAT clause, 4-5, 4-6, 8-32

formatting columns, 4-6

formatting NUMBER columns, 4-4, 8-33

HEADING clause, 4-2, 8-35

HEADSEP character, 8-35

JUSTIFY clause, 8-35

LIKE clause, 4-8, 8-35

listing column display attributes, 4-8, 4-9, 8-30

NEW_VALUE clause, 4-29, 4-30, 8-35

NEWLINE clause, 8-35

NOPRINT clause, 4-29, 8-36

NULL clause, 8-36

OFF clause, 4-9, 8-37

OLD_VALUE clause, 4-30, 8-36

ON clause, 4-9, 8-37

PRINT clause, 8-36

resetting a column to default display, 4-9, 8-31, F-2

restoring column display attributes, 4-9, 8-37

storing current date in variable for titles, 4-30, 8-38

suppressing column display attributes, 4-9, 8-37

TRUNCATED clause, 4-7, 8-37

used to format a REFCURSOR variable, 8-147

WORD_WRAPPED clause, 4-7, 4-10, 8-37

WRAPPED clause, 4-7, 8-37

column expression, GL-5

column headings

aligning, 8-35

changing, 4-2, 8-35

changing character used to underline, 4-3, 8-112

changing to two or more words, 4-3, 8-35

displaying on more than one line, 4-3, 8-35

suppressing printing in a report, 8-105

when truncated, 8-32

when truncated for CHAR and LONG columns, 4-7

when truncated for DATE columns, 4-7

when truncated for NUMBER columns, 4-4

column separator, 8-102, F-2

columns

assigning aliases, 8-31

computing summary lines, 4-16, 8-41

copying display attributes, 4-8, 8-18, 8-35

copying values between tables, 6-4, 6-9, 8-49

displaying values in bottom titles, 4-30, 8-36

displaying values in top titles, 4-29, 8-35

formatting CHAR, VARCHAR, LONG, and DATE, 8-32

formatting in reports, 4-2, 8-30

formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 8-32

formatting NUMBER, 4-4, 8-33

listing display attributes for all, 4-9, 8-30

listing display attributes for one, 4-8, 8-30

names in destination table when copying, 6-5, 8-50

printing line after values that overflow, 4-9, 8-108

resetting a column to default display, 4-9, 8-31, F-2

resetting all columns to default display, 4-9, 8-28

restoring display attributes, 4-9, 8-18, 8-37

setting printing to off or on, 4-29, 8-36

starting new lines, 8-35

storing values in variables, 4-29, 8-35

suppressing display attributes, 4-9, 8-18, 8-37

truncating display for all when value overflows, 4-7, 8-112

truncating display for one when value overflows, 4-7, 8-37

wrapping display for all when value overflows, 4-7, 8-112

wrapping display for one when value overflows, 4-7, 8-37

wrapping whole words for one, 4-10

COLUMNS clause, 4-9, 8-28

comma, number format, 4-5

command, GL-5

command file extension, 8-96, 8-111, 8-137

command files, 3-8

aborting and exiting with a return code, 3-18, 8-152, 8-154

allowing end-user input, 3-21

creating with a system editor, 3-11

creating with INPUT and SAVE, 3-9

creating with SAVE, 3-8, 8-96

editing with GET and SAVE, 3-18

editing with host system editor, 3-18, 8-64

in @ ("at" sign) command, 3-16, 8-5

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

in EDIT command, 3-18, 8-64

in GET command, 3-15, 8-69

in SAVE command, 3-8, 3-10, 8-96

in SQLPLUS command, 3-17, 7-10

in START command, 3-16, 8-131

including comments in, 3-11, 8-88

including more than one PL/SQL block, 3-11

including more than one SQL command, 3-10, 3-11

listing names with HOST command, 3-9

nesting, 3-17

passing parameters to, 3-27, 8-5, 8-131

registering, 8-99

retrieving, 3-15, 8-69

running, 3-16, 8-5, 8-131

running a series in sequence, 3-17

running as you start SQL*Plus, 3-17, 7-10

running in batch mode, 3-18, 8-68

running nested, 8-7

saving contents of buffer in, 3-8, 8-96

command prompt, GL-5

host operating system, 2-3

SQL*Plus, 2-4

commands, 1-2

collecting timing statistics on, 2-15, 8-138

disabling, E-4

host, running from SQL*Plus, 2-16, 8-71

listing current in buffer, 8-75

re-enabling, E-5

spaces, 2-5

SQL

continuing on additional lines, 2-7

editing in buffer, 3-2

editing with host system editor, 3-7, 8-64

ending, 2-7

entering and executing, 2-6

entering without executing, 2-8

executing current, 2-10, 8-9, 8-95

following syntax, 2-7

list of major, D-1

listing current in buffer, 3-3

saving current, 3-8, 8-96

setting character used to end and run, 8-110

SQL*Plus

abbreviations, 2-11

command summary, 8-2

continuing on additional lines, 2-12, 8-1

editing at command prompt, 3-2

ending, 2-13, 8-1

entering and executing, 2-11

entering during SQL command entry, 8-110

obsolete command alternatives, F-2

stopping while running, 2-15

storing in command files, 3-8

syntax conventions, 1-3

tabs, 2-5

types of, 2-5

variables that affect running, 2-13

writing interactive, 3-21

comments, GL-5, GL-18

including in command files, 3-11, 8-88, F-2

using -- to create, 3-12

using /*...*/ to create, 3-12

using REMARK to create, 3-12, 8-88, F-2

commit, GL-6

COMMIT clause, 8-67

WHENEVER OSERROR, 8-151

WHENEVER SQLERROR, 8-153

COMMIT command, 2-13

Common Gateway Interface, GL-6

communications, GL-14

COMPATIBILITY clause

in LOGIN.SQL, 3-19

COMPATIBILITY variable, 8-103

computation, GL-6

COMPUTE command, 4-11, 8-41

AVG function, 4-16

computing a summary on different columns, 4-20

COUNT function, 4-16

LABEL clause, 4-17, 4-19, 8-42

listing all definitions, 4-22, 8-43

MAXIMUM function, 4-16

maximum LABEL length, 8-42

MINIMUM function, 4-16

NUMBER function, 4-16

OF clause, 4-16

ON column clause, 4-16, 8-42

ON expr clause, 8-42

ON REPORT clause, 4-19, 8-42

ON ROW clause, 8-42

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

printing multiple summaries on same column, 4-21

printing summary lines at ends of reports, 4-19

printing summary lines on a break, 4-16

referencing a SELECT expression in OF, 8-42

referencing a SELECT expression in ON, 8-43

removing definitions, 4-22, 8-28

STD function, 4-16

SUM function, 4-16

used to format a REFCURSOR variable, 8-147

VARIANCE function, 4-16

computed column, GL-6

COMPUTES clause, 8-28

CONCAT variable, 3-26, 8-103

concurrency

instances, multiple, 8-134

configuration, GL-6

configuration files, GL-6

connect, GL-6

CONNECT command, 6-2, 6-3, 8-47

and @ ("at" sign), 6-3, 8-47

changing password, 8-47, 8-48, 8-77

connect identifier, 6-3

INTERNAL, 8-47

service name, 6-3

SYSDBA clause, 7-9, 8-48

SYSOPER clause, 7-9, 8-48

username/password, 6-2, 6-3, 6-4, 8-47

CONNECT command (SQL)

disabling, E-5

connect identifier, 6-3, 8-47, GL-6

in CONNECT command, 8-47

in COPY command, 8-49

in DESCRIBE command, 8-56

in SQLPLUS command, 7-9

CONTINUE clause

WHENEVER OSERROR, 8-151

WHENEVER SQLERROR, 8-153

continuing a long SQL*Plus command, 2-12, 8-1

conventions, command syntax, 1-3

COPY command, 6-4, 8-49

and @ ("at" sign), 6-5, 8-49

and ARRAYSIZE variable, 6-8, 8-51

and COPYCOMMIT variable, 6-8, 8-51

and LONG variable, 6-8, 8-51

APPEND clause, 6-7, 8-50

copying data between databases, 6-4

copying data between tables on one database, 6-9

CREATE clause, 6-6, 8-50

creating a table, 6-6, 8-50

destination table, 6-5, 8-50

determining actions, 6-5

determining source rows and columns, 6-6, 8-51

disabling, E-5

FROM clause, 6-5, 8-49

INSERT clause, 6-7, 8-50

inserting data in a table, 6-7, 8-50

interpreting messages, 6-8

mandatory connect identifier, 8-50

naming the source table with SELECT, 6-6, 8-51

query, 6-6, 8-51

referring to another user's table, 6-8

REPLACE clause, 6-6, 8-50

replacing data in a table, 6-6, 8-50

sample command, 6-5, 6-6

service name, 6-5, 6-7, 6-9

specifying column names for destination, 6-5, 8-50

specifying the data to copy, 6-6, 8-51

TO clause, 6-5, 8-49

username/password, 6-5, 6-7, 6-9, 8-49

USING clause, 6-6, 8-51

when a commit is performed, 8-51

COPYCOMMIT variable, 8-103

relationship to COPY command, 6-8, 8-51

COPYTYPECHECK variable, 8-103

COUNT function, 4-16

CREATE clause

in COPY command, 6-6, 8-50

CREATE command

disabling, E-6

entering PL/SQL, 2-8

creating flat files, 4-34

creating the PRODUCT_USER_PROFILE table, E-2

current line, GL-7

cursor variables, 8-146

Data Control Language, GL-8

Data Definition Language, GL-8

data dictionary, GL-8

Data Manipulation Language, GL-8

data security, GL-8

database, GL-7

connect identifier, 8-47

dismounted, GL-9

failure, GL-7

link, GL-7

local, GL-12

mounting, 8-134

object, GL-7

open, GL-15

opening, 8-134

schema, GL-19

server, GL-7

specification, GL-8

string, GL-8

transaction, GL-24

USERID, GL-24

username, GL-24

database administrator, 1-6, 5-2, GL-7

database changes, saving automatically, 2-13, 8-100

DATABASE clause, 8-83

database files

recovering, 8-82

database name at startup, 8-133

databases

and RECOVERY command, 8-82

connecting to default, 6-2, 8-47

connecting to remote, 6-3, 8-47

copying data between, 6-4, 8-49

copying data between tables on a single, 6-9

disconnecting without leaving SQL*Plus, 6-2, 8-63

mounting, 5-3

opening, 5-3

recovering, 5-5, 8-82

shutting down, 5-2, 5-3

starting, 5-2

DATAFILE clause, 8-84

datatype, GL-9

LONG, GL-13

NCHAR, GL-14

NCLOB, GL-14

NUMBER, GL-14

NVARCHAR2, GL-15

RAW, GL-18

VARCHAR, GL-24

VARCHAR2, GL-25

DATE

datatype, GL-9

date

Julian, GL-12

DATE clause, 8-10

DATE columns

changing format, 4-6, 8-33, 8-39

default format, 4-6

date, storing current in variable for titles, 4-30, 8-35, 8-38

DB2, 8-103

DBA, 5-2, GL-7

DBA mode, 8-133

DBA privilege, 8-133

DBMS_APPLICATION_INFO package, 8-99

DCL, GL-8

DDL, GL-8

DECLARE command

disabling, E-6

DECLARE command (PL/SQL), 2-10

default, GL-9

database, GL-9

DEFAULT clause, 8-11

DEFINE command, 3-21, 8-52, GL-24

and host system editor, 3-8, 8-53

CHAR values, 8-52

substitution variables, 3-24, 8-52

DEFINE variable, 3-26, 8-103

DEL command, 3-2, 3-7, 8-54

using an asterisk, 3-2, 8-54

DELETE command

disabling, E-6

DEMOBLD, 1-7

DEMODROP, 1-7

DEPT table, 1-5

DESCRIBE command (SQL*Plus), 2-16, 8-56

connect_identifier, 8-56

PL/SQL properties listed by, 8-57

table properties listed by, 8-56

directory, GL-9

DISABLED keyword, disabling commands, E-4

disabling

PL/SQL commands, E-6

SQL commands, E-4

SQL*Plus commands, E-4

DISCONNECT command, 6-2, 8-63

dismounted database, GL-9

display

format, GL-9

width, GL-10

DML, GL-8

DOCUMENT command

Obsolete commands

DOCUMENT, F-2

obsolete commands

DOCUMENT, F-3

REMARK as newer version of, F-4

DOCUMENT variable, F-2, F-5

DROP command

disabling, E-6

DUAL table, GL-10

DUPLICATES clause, 8-22

ECHO variable, 3-16, 8-104

EDIT command, 3-7, 8-64

creating command files with, 3-11

defining _EDITOR, 3-8, 8-64

disabling, E-5

modifying command files, 3-18, 8-64

setting default file name, 8-104

EDITFILE variable, 8-104

editor, GL-10

EMBEDDED variable, 8-104

EMP table, 1-5

empty line, displaying, 8-78

end user, GL-10

enhancement list,release 8.1, B-2

entities, HTML, 4-47

ENTMAP, 7-5

ENTMAP clause, 4-47, 7-5, 8-31

error message, GL-10

error messages, interpreting, 2-18

errors, making line containing current, 3-4

escape characters, definition of, 8-104

ESCAPE variable, 3-26, 8-104

example

embedded CGI report, 4-42

interactive HTML report, 4-39, 4-41

EXCLUSIVE clause, 8-133

EXECUTE command, 8-66

disabling, E-5

executing

a CREATE command, 2-8

execution statistics

including in report, 8-101

EXIT clause

WHENEVER OSERROR, 8-151

WHENEVER SQLERROR, 8-153

EXIT command, 2-4, 8-67

:BindVariable clause, 8-67

COMMIT clause, 8-67

disabling, E-5

FAILURE clause, 8-67

in a command file, 8-132

ROLLBACK clause, 8-68

use with SET MARKUP, 4-39

WARNING clause, 8-67

exit, conditional, 8-151, 8-153

expression, GL-10

extension, 8-96, 8-111, 8-137, GL-10

FAILURE clause, 8-67

FEEDBACK variable, 8-105

file, GL-10

file extension, 8-96, 8-111, 8-137

file extensions, 3-20

file names

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

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

in EDIT command, 8-64

in GET command, 8-69

in SAVE command, 3-8, 8-96

in SPOOL command, 4-34, 8-130

in SQLPLUS command, 7-10

in START command, 8-131

file type, GL-11

filename, GL-11

files

command files, 3-8

flat, 4-34

FLAGGER variable, 8-105

flat file, 4-34

FLUSH variable, 8-105

FOLD_AFTER clause, 8-32

FOLD_BEFORE clause, 8-32

footers

aligning elements, 8-92

displaying at bottom of page, 8-89

displaying system-maintained values, 8-91

formatting elements, 8-92

indenting, 8-92

listing current definition, 8-89

setting at the end of reports, 4-22

suppressing definition, 8-92

FORCE clause, 8-133

form feed, GL-11

format, GL-11

column, GL-24

mask, GL-11

model, GL-11

FORMAT clause, 8-10, 8-32

in ATTRIBUTE command, 8-18

in COLUMN command, 4-5, 4-6

in REPHEADER and REPFOOTER commands, 8-92

in TTITLE and BTITLE commands, 4-27, 8-142

format models, number, 4-5, 8-34

formfeed, to begin a new page, 4-31, 8-107

formula column, GL-11

FROM clause, 8-83

FROM clause (SQL*Plus), 6-5, 8-49

function, GL-11

GET command, 3-15, 8-69

disabling, E-5

LIST clause, 8-69

modifying command files, 3-18

NOLIST clause, 8-69

retrieving command files, 3-15, 8-69

GLOGIN.SQL, 3-19, 3-38, 3-41, 7-10

See also

GRANT command, E-2

disabling, E-6

HEAD clause, 7-4

HEAD option, 7-4

headers

aligning elements, 4-24

displaying at top of page, 8-91

displaying system-maintained values, 8-91

setting at the start of reports, 4-22

suppressing, 4-24

heading, GL-11

HEADING clause, 4-2, 8-35

HEADING variable, 8-105

headings

aligning elements, 8-92

column headings, 8-105

formatting elements, 8-92

indenting, 8-92

listing current definition, 8-93

suppressing definition, 8-92

HEADSEP variable, 8-106

use in COLUMN command, 4-3, 8-35

HELP command, 8-70

help, online, 2-5, 7-12, 8-70

HIDE clause, 8-11

HOST command, 2-16, 8-71

disabling, E-5

listing command file names with, 3-9

host computer, GL-11

host operating system

command prompt, 2-3

editor, 3-7, 8-64

file, loading into buffer, 8-69

running commands from SQL*Plus, 2-16, 8-71

HTML, 4-38, 4-42, GL-12

clause, 7-4

entities, 4-47

option, 7-4

spooling to file, 7-6

tag, 4-38

hyphen

continuing a long SQL*Plus command, 2-12, 8-1

IMMEDIATE mode, 8-128

infinity sign (~), 8-35

initialization parameters

displaying, 8-124

INIT.ORA file

parameter file, 8-133

input

accepting [Return], 3-31, 8-78

accepting values from the user, 3-28, 8-10

INPUT command, 3-2, 3-5, 8-73

entering several lines, 8-73

using with SAVE to create command files, 3-9

INSERT clause, 6-7, 8-50

INSERT command

disabling, E-6

instance, GL-12

failure, GL-7

recovery, GL-12

INSTANCE variable, 8-106

instances

multiple, sharing a database, 8-134

shutting down, 8-128

starting, 8-133

INTERNAL

See

Julian date, GL-12

justification, GL-12

JUSTIFY clause, 8-35

keyboard, significance of keys on, 2-2

keys

[Backspace] key, 2-2

[Cancel] key, 2-2

[Interrupt] key, 2-2

[Pause] key, 2-2

[Resume] key, 2-2

[Return] key, 2-2

label, GL-12

LABEL variable

SHOW command, F-2, F-7

labels

in COMPUTE command, 4-17, 8-42

layout object

width, GL-25

LEFT clause, 4-25, 8-92, 8-141

LGWR, GL-13

LIKE clause, 4-8, 8-18, 8-35

limits, SQL*Plus, C-1

line numbers, for SQL commands, 2-6

line wrapping, GL-25

lines

adding at beginning of buffer, 8-73

adding at end of buffer, 8-73

adding new after current, 3-5, 8-73

appending text to, 3-6, 8-12

changing width, 4-32, 8-106

deleting all in buffer, 8-54

deleting from buffer, 3-7, 8-54

determining which is current, 3-3

editing current, 3-3

listing all in buffer, 3-2, 8-75

removing blanks at end, 8-111

LINESIZE variable, 4-24, 4-32, 8-106

LIST clause, 8-13, 8-69

LIST command, 3-2, 8-75

determining current line, 3-3, 8-75

making last line current, 3-4, 8-75

using an asterisk, 3-2, 8-75

LNO clause, 8-124

LOBOFFSET variable, 8-107

local database, GL-12

LOCK TABLE command

disabling, E-6

log in, GL-13

log off, GL-13

log on, GL-13

log out, GL-13

Log Writer, GL-13

LOG_ARCHIVE_DEST parameter, 8-13

LOGFILE clause, 8-84

logging off

conditionally, 8-151, 8-153

Oracle, 6-2, 8-63

SQL*Plus, 2-4, 8-67

logging on

Oracle, 6-2, 6-3, 8-47

SQL*Plus, 2-4

LOGIN.SQL, 3-19, 7-10

including SET commands, 3-19

sample commands to include, 3-19

See also

storing current date in variable for titles, 4-30

logon string, GL-13

LONG columns

changing format, 4-6, 8-32

default format, 8-32

setting maximum width, 8-107

setting retrieval size, 8-107

LONG datatype, GL-13

LONG variable, 8-107

effect on COPY command, 6-8, 8-51

LONGCHUNKSIZE variable, 4-7, 8-32, 8-107

-MARKUP, 4-38, 4-42, 7-3

SPOOL clause, 7-4

SQLPLUS command clause, 7-4

MARKUP, 4-38, 7-3, 8-107, GL-13

BODY clause, 7-4

ENTMAP clause, 7-5

example, 8-117

HEAD clause, 7-4

PREFORMAT clause, 7-7

SPOOL clause, 7-4

TABLE clause, 7-5

mask format, GL-11

MAXDATA variable, F-2, F-6

MAXIMUM function, 4-16

media recovery, 8-134

message, sending to screen, 3-28, 8-80

MINIMUM function, 4-16

model format, GL-11

MOUNT clause, 8-134

mounted, GL-13

mounting

shared databases, 8-134

mounting a database, 8-134

multi-threaded server, GL-14

NCHAR clause

VARIABLE command, 8-145

NCHAR columns

changing format, 4-6, 8-32

default format, 4-6, 8-32

NCHAR datatype, GL-14

NCLOB clause

VARIABLE command, 8-146

NCLOB columns

changing format, 4-6, 8-32

default format, 8-32

setting maximum width, 8-107

setting retrieval position, 8-107

setting retrieval size, 8-107

NCLOB datatype, GL-14

negative infinity sign (-~), 8-35

Net8, GL-14, GL-21

connect identifier, 8-47

protocol, 6-3

network, GL-14

NEW_VALUE clause, 4-29, 8-35

storing current date in variable for titles, 4-30, 8-35, 8-38

NEWLINE clause, 8-35

NEWPAGE command, F-2, F-4

NEWPAGE variable, 4-31, 8-107

NEXT clause, 8-14

NLS_DATE_FORMAT, 8-10, 8-39

NOAUDIT command

disabling, E-6

NOLIST clause, 8-69

NOLOG, 7-10

/NOLOG option, 7-10

NOMOUNT clause, 8-134

NONE clause

WHENEVER OSERROR, 8-151

WHENEVER SQLERROR, 8-153

NOPARALLEL clause, 8-86

NOPRINT clause, 4-17, 4-29, 8-36

NOPROMPT clause, 8-11

NORMAL mode, 8-128

NULL clause, 8-36

NULL value, GL-14

null values

setting text displayed, 8-36, 8-107

NULL variable, 8-107

NUMBER clause, 3-30, 8-10

VARIABLE command, 8-145

NUMBER columns

changing format, 4-4, 8-33

default format, 4-4, 8-34

NUMBER datatype, GL-14

number formats

$, 4-5

0, 4-5

9, 4-5

comma, 4-5

setting default, 8-108

NUMBER function, 4-16

NUMFORMAT clause

in LOGIN.SQL, 3-19

NUMFORMAT variable, 8-108

NUMWIDTH variable, 8-108

effect on NUMBER column format, 4-4, 8-34

NVARCHAR2 columns

changing format, 4-6, 8-32

default format, 4-6, 8-32

NVARCHAR2 datatype, GL-15

object, GL-15

object type, GL-15

object-relational model, GL-15

objects

describing, 8-104

obsolete commands

BTITLE, F-3

COLUMN command DEFAULT clause, F-3

NEWPAGE, F-2, F-4

SET command BUFFER variable, F-4

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

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

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

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

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

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

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

TTITLE command old form, F-7

OF clause, 4-16

OFF clause, 8-37

in ATTRIBUTE command, 8-18

in COLUMN command, 4-9, 8-37

in REPFOOTER commands, 8-92

in REPHEADER commands, 8-92

in SPOOL command, 4-34, 8-130

in TTITLE and BTITLE commands, 4-28, 8-141

OLD_VALUE clause, 4-30, 8-36

ON clause

in ATTRIBUTE command, 8-18

in COLUMN command, 4-9, 8-37

in TTITLE and BTITLE commands, 4-28

ON column clause

in BREAK command, 4-12, 8-19

in COMPUTE command, 4-16, 8-42

ON expr clause

in BREAK command, 8-20

in COMPUTE command, 8-42

ON REPORT clause

in BREAK command, 4-19, 8-21

in COMPUTE command, 4-19, 8-42

ON ROW clause

in BREAK command, 4-13, 8-21

in COMPUTE command, 8-42

online help, 2-5, 7-12, 8-70

online redo log, GL-15

OPEN clause, 8-134

open database, GL-15

opening a database, 8-134

operating system, GL-15

Oracle

USERID, GL-24

Oracle Server, GL-16

ORDER BY clause

displaying column values in titles, 4-29

displaying values together in output, 4-11

OUT clause, 4-35, 8-130

output, GL-16

formatting white space in, 8-111

pausing during display, 2-17, 8-108

query results, 1-2

output file, GL-16

packages, GL-16

page, GL-16

PAGE clause, 8-91

page number, including in titles, 4-14, 4-27

pages

changing length, 4-31, 8-108

default dimensions, 4-31

matching dimensions to screen or paper size, 4-31

setting dimensions, 4-31

PAGESIZE variable, 2-7, 4-32, 8-108

PAGESIZEclause

in LOGIN.SQL, 3-19

PARALLEL clause, 8-134

parallel server, GL-16

parameter, GL-16

width, GL-25

parameter file, GL-16

parameter files (INIT.ORA files)

specifying alternate, 8-133

parameters, 3-27, 8-5, 8-131

PARAMETERS clause, 8-124

password, 1-6, GL-17

changing with the PASSWORD command, 8-77

in CONNECT command, 6-2, 6-3, 8-47

in COPY command, 6-5, 6-7, 6-9

in SQLPLUS command, 2-3, 6-4, 7-9

PASSWORD command, 8-47, 8-77

disabling, E-5

paths, creating

Installation and User's Guide, 8-51

PAUSE command, 3-31, 8-78

in LOGIN.SQL, 3-19

PAUSE variable, 2-17, 8-108

performance

of SQL statements, 3-36

performance, over dial-up lines, 8-111

Period (.)

terminating PL/SQL blocks, 8-102

period (.)

terminating PL/SQL blocks, 2-10

PLAN_TABLE table, 3-37

PL/SQL, 1-2, 2-10, GL-17

blocks, PL/SQL, 2-10

executing, 8-66

formatting output in SQL*Plus, 8-146

listing definitions, 2-17

mode in SQL*Plus, 2-8

within SQL commands, 2-8

PLUSTRACE role, 3-37

PNO clause, 8-125

pound sign (#), 8-35

PREFORMAT, 7-7

PREFORMAT clause, 7-7

print

spooling, GL-20

PRINT clause, 8-36

PRINT command, 8-79

printing

bind variables automatically, 8-101

REFCURSOR variables, 8-147

SPOOL command, 8-130

procedure, GL-17

process, GL-17

PRODUCT_USER_PROFILE table, E-2

prompt, GL-17

PROMPT clause, 3-29, 8-11

PROMPT command, 3-28, 8-80

customizing prompts for value, 3-30

prompts for value

bypassing with parameters, 3-27

customizing, 3-30

through ACCEPT, 3-28

through substitution variables, 3-23

PUPBLD.SQL, E-2

queries, 1-2

displaying number of records retrieved, 2-7, 8-105

in COPY command, 6-6, 8-51

query, GL-17

results, GL-18, GL-19

query execution path

including in report, 8-101

query results, 1-2

displaying on-screen, 2-6

sending to a printer, 4-35, 8-130

storing in a file, 4-34, 8-130

QUIT command, 8-67

See also

RAW datatype, GL-18

RDBMS, GL-18

record, GL-18, GL-19

record separators, printing, 4-9, 8-108

RECOVER

clause, 8-134

recover, GL-18

RECOVER command, 8-82

AUTOMATIC clause, 8-82

CANCEL clause, 8-84

CONTINUE clause, 8-84

DATABASE clause, 8-83

DATAFILE clause, 8-84

FROM clause, 8-83

LOGFILE clause, 8-84

NOPARALLEL clause, 8-86

STANDBY DATABASE clause, 8-83

STANDBY DATAFILE clause, 8-84

STANDBY TABLESPACE clause, 8-84

TABLESPACE clause, 8-84

UNTIL CANCEL clause, 8-83

UNTIL CHANGE clause, 8-83

UNTIL CONTROLFILE clause, 8-84

UNTIL TIME clause, 8-83

USING BACKUP CONTROL FILE clause, 8-84

recovery

RECOVER command, 8-82

RECOVERY command

and database recovery, 5-5

RECSEP variable, 4-9, 8-108

RECSEPCHAR variable, 4-9, 8-108

redo log, GL-15, GL-18

file, GL-18

redo Log Files

ARCHIVE LOG command, 8-13

REFCURSOR bind variables, 3-33

in a stored function, 3-33

REFCURSOR clause

VARIABLE command, 8-146

Relational Database Management System, GL-18

RELEASE clause, 8-125

remark, GL-18

REMARK command, 3-12, 8-88, GL-18

remote computer, GL-19

remote database, GL-19

RENAME command

disabling, E-6

REPFOOTER clause, 8-125

REPFOOTER command, 4-22, 8-89

aligning footer elements, 8-92

BOLD clause, 8-92

CENTER clause, 8-92

COL clause, 8-92

FORMAT clause, 8-92

indenting report footers, 8-92

LEFT clause, 8-92

OFF clause, 8-92

RIGHT clause, 8-92

SKIP clause, 8-92

suppressing current definition, 8-92

TAB clause, 8-92

REPHEADER clause, 8-125

REPHEADER command, 4-22, 8-91

aligning header elements, 4-24

aligning heading elements, 8-92

BOLD clause, 8-92

CENTER clause, 8-92

COL clause, 8-92

FORMAT clause, 8-92

indenting headings, 8-92

LEFT clause, 8-92

OFF clause, 8-92

PAGE clause, 8-91

RIGHT clause, 8-92

SKIP clause, 8-92

suppressing current definition, 8-92

TAB clause, 8-92

REPLACE clause

in COPY command, 6-6, 8-50

in SAVE command, 3-18, 8-96

report

breaks, 8-19

title, F-2

reports, 1-2, GL-19

CGI scripts, 4-42

clarifying with spacing and summary lines, 4-11

columns, 8-31

creating bottom titles, 4-22, 8-24, F-2

creating footers, 8-89

creating headers, 8-91

creating headers and footers, 4-22

creating master/detail, 4-29, 8-36

creating top titles, 4-22, 8-140, F-2

displaying, 8-101

embedded CGI example, 4-42

embedded using SQLPLUS -MARKUP, 4-42

formatting column headings, 4-2, 8-30

formatting columns, 4-4, 4-6, 8-30

interactive HTML example, 4-39, 4-41

interactive using SET MARKUP HTML, 4-38

line wrapping, GL-25

on the web, 4-38, 4-42

SILENT mode, 4-46

starting on a new page, 8-104

subtotal, GL-22

summary, GL-22

summary line, GL-22

title, 8-140, GL-24

reserved word, GL-19

RESTRICT, 7-8, 8-133, E-8

RETRY clause, 8-134

return code, specifying, 3-18, 8-68, 8-154

REVOKE command, E-2

disabling, E-6

RIGHT clause, 4-25, 8-92, 8-141

roles, E-7, GL-19

disabling, E-7

re-enabling, E-7

rollback, GL-19

ROLLBACK clause, 8-68

WHENEVER OSERROR, 8-151

WHENEVER SQLERROR, 8-153

row, GL-18, GL-19

rows

performing computations on, 4-15, 8-41

setting number retrieved at one time, 8-100

setting the number after which COPY commits, 8-103

RUN command, 2-10, 8-95

disabling, E-5

executing current PL/SQL block, 2-10

executing current SQL command or PL/SQL block, 2-10

making last line current, 3-4

similar to / (slash) command, 2-10, 8-95

sample tables, 1-4

access to, 1-7

DEMOBLD, 1-7

DEMODROP, 1-7

SAVE command, 3-8, 8-96

APPEND clause, 3-18, 8-96

CREATE clause, 8-96

disabling, E-5

modifying command files, 3-18

REPLACE clause, 3-18, 8-96

storing commands in command files, 3-8, 8-96

using with INPUT to create command files, 3-10

saving environment attributes, 8-137

SCAN variable, F-2, F-6

schema, GL-19

SCREEN clause, 3-31, 8-28

screen, clearing, 3-31, 8-28

script, GL-21

CGI, 4-42, GL-6

search paths

Installation and User's Guide, 8-51

Security

RESTRICT, 7-8, E-8

security

changing password, 8-77

embedded web reports, 4-43

PRODUCT_USER_PROFILE table, E-2

security level, GL-19

select, GL-20

SELECT command

and BREAK command, 4-11, 8-20, 8-21

and COLUMN command, 8-31

and COMPUTE command, 4-11

and COPY command, 6-6, 8-51

and DEFINE command, 8-52

and ORDER BY clause, 4-11

disabling, E-6

storing current date in variable for titles, 4-30

SELECT list, GL-20

SELECT statement, GL-20

formatting results, 3-33

semicolon (;)

in PL/SQL blocks, 2-10

in SQL commands, 2-6, 2-8

in SQL*Plus commands, 2-13, 8-1

not needed when inputting a command file, 3-10

not stored in buffer, 3-3

Server, GL-16

server, GL-20

SERVEROUTPUT variable, 8-109

service Name

in COPY command, 6-9

service name

in CONNECT command, 6-3

in COPY command, 6-5, 6-7

in SQLPLUS command, 6-4

session, GL-20

SET AUTOTRACE, 3-36

SET clause, 8-137

SET command, 2-13, 3-20, 4-38, 8-98, GL-23

APPINFO variable, 8-99

ARRAYSIZE variable, 6-8, 8-100

AUTOCOMMIT variable, 2-14, 8-100

AUTOPRINT variable, 8-101, 8-146

AUTORECOVERY variable, 8-101

AUTOTRACE variable, 8-101

BLOCKTERMINATOR variable, 8-102

BUFFER variable, F-4

CLOSECURSOR variable, F-2, F-5

CMDSEP variable, 8-102

COLSEP variable, 4-34, 8-102

COMPATIBILITY clause, 3-19

COMPATIBILITY variable, 8-103

CONCAT variable, 3-26, 8-103

COPYCOMMIT variable, 6-8, 8-103

COPYTYPECHECK variable, 8-103

DEFINE clause, 3-26

DEFINE variable, 8-103

DESCRIBE variable, 8-104

disabling, E-5

DOCUMENT variable, F-2, F-5

ECHO variable, 3-16, 8-104

EDITFILE variable, 8-104

EMBEDDED variable, 8-104

ESCAPE variable, 3-26, 8-104

FEEDBACK variable, 8-105

FLAGGER variable, 8-105

FLUSH variable, 8-105

HEADING variable, 8-105

HEADSEP variable, 4-3, 8-106

INSTANCE variable, 8-106

LINESIZE variable, 4-24, 4-32, 8-106

LOBOFFSET variable, 8-107

LOGSOURCE variable, 8-107

LONG variable, 6-8, 8-107

LONGCHUNKSIZE variable, 8-107

MARKUP clause, 8-107

MAXDATA variable, F-2, F-6

NEWPAGE variable, 4-31, 8-107

NULL variable, 8-107

NUMFORMAT clause, 3-19

NUMFORMAT variable, 8-108

NUMWIDTH variable, 4-4, 8-34, 8-108

PAGESIZE clause, 3-19

PAGESIZE variable, 2-7, 4-32, 8-108

PAUSE clause, 3-19

PAUSE variable, 2-17, 8-108

RECSEP variable, 4-9, 8-108

RECSEPCHAR variable, 4-9, 8-108

SCAN variable, F-2, F-6

SERVEROUTPUT variable, 8-109

SHIFTINOUT clause, 3-19

SHIFTINOUT variable, 8-109

SPACE variable, F-2, F-6

SQLBLANKLINES variable, 8-110

SQLCASE variable, 8-110

SQLCONTINUE variable, 8-110

SQLNUMBER variable, 8-110

SQLPREFIX variable, 8-110

SQLPROMPT variable, 8-110

SQLTERMINATOR variable, 8-110

SUFFIX variable, 8-111

TAB variable, 8-111

TERMOUT variable, 4-30, 8-111

TIME clause, 3-19

TIME variable, 8-111

TIMING variable, 8-111

TRIMOUT variable, 8-111

TRIMSPOOL variable, 8-112

TRUNCATE variable, F-2, F-7

UNDERLINE variable, 4-3, 8-112

used to format a REFCURSOR variable, 8-147

VERIFY clause, 3-23

VERIFY variable, 3-26, 8-112

WRAP variable, 4-7, 8-112

SET command variables

system variables, 2-13

SET MARKUP

BODY clause, 7-4

embedded CGI example, 4-42

ENTMAP clause, 4-47, 7-5

HEAD clause, 7-4

HTML, 7-4

interactive HTML example, 4-39, 4-41

PREFORMAT clause, 7-7

See also

SPOOL clause, 7-4

TABLE clause, 7-5

SET ROLE command

disabling, E-6

SET TRANSACTION command

disabling, E-6

SGA, GL-23

SGA clause, 8-125

shared disk systems

mounting shared, 8-134

shared mode

database, 8-134

SHIFTINOUT clause

in LOGIN.SQL, 3-19

SHIFTINOUT variable, 8-109

SHOW clause, 8-138

SHOW command, 2-13, 8-123, GL-23

ALL clause, 8-123

BTITLE clause, 8-124

ERRORS clause, 8-124

LABEL variable, F-2, F-7

listing current page dimensions, 4-33

LNO clause, 8-124

PNO clause, 8-125

RELEASE clause, 8-125

REPFOOTER clause, 8-125

REPHEADER clause, 8-125

SPOOL clause, 8-125

SQLCODE clause, 8-125

TTITLE clause, 8-125

USER clause, 8-125

SHOWMODE variable, 8-109

SHUTDOWN command, 8-128

ABORT, 8-128

IMMEDIATE, 8-128

NORMAL, 8-128

-SILENT option, 4-46, 7-8

site profile

GLOGIN.SQL, 7-10

LOGIN.SQL, 7-10

See also

SKIP clause

in BREAK command, 4-13, 8-21

in REPHEADER and REPFOOTER commands, 8-92

in TTITLE and BTITLE commands, 4-25, 8-141

used to place blank lines before bottom title, 4-25

SKIP PAGE clause, 4-13, 4-14, 8-22

slash (/) command, 8-9

using with files loaded with GET command, 8-69

SPACE variable, F-2, F-6

SPOOL clause, 7-4, 7-6, 8-125

SPOOL command, 4-33, 8-130, GL-20

disabling, E-5

file name, 4-34, 8-130

OFF clause, 4-34, 8-130

OUT clause, 4-35, 8-130

to HTML file, 7-6

turning spooling off, 4-34, 8-130

use with SET MARKUP, 4-39

spooling, GL-20

SQL, GL-20

buffer, GL-21

command, GL-21

query, GL-17

query results, GL-18

reports, GL-19

rollback, GL-19

script, GL-21

select, GL-20

statement, GL-21

transaction, GL-24

SQL buffer, 2-9

SQL clause, 8-29

SQL commands, list of major, D-1

SQL database language, 1-2

SQL DML statements

reporting on, 8-101

SQL*Loader, GL-21

SQL*Net, GL-14, GL-21

SQL*Plus, GL-21

basic concepts, 1-2

command prompt, 2-4

command summary, 8-2

database administration, 5-2

exiting, 2-4, 8-67

exiting conditionally, 8-151, 8-153

limits, C-1

LOGIN.SQL, 3-19

obsolete command alternatives, F-2

overview, 1-2

running commands in batch mode, 3-18, 8-68

setting up environment, 3-19

shortcuts to starting, 2-4

starting, 2-3, 7-2

substitution variable, GL-22

variable, GL-25

what you need to run, 1-6

who can use, 1-3

SQLBLANKLINES variable, 8-110

SQLCASE variable, 8-110

SQLCODE clause, 8-125

SHOW command, 8-125

SQLCONTINUE variable, 8-110

SQLNUMBER variable, 8-110

SQLPLUS command, 2-3, 4-42, 7-2

- clause, 7-2

-? clause, 7-3

and @ ("at" sign), 3-17, 6-4, 7-2

and EXIT FAILURE, 7-11

BODY option, 7-4

connect identifier, 7-9

connecting to a remote database, 6-4

display syntax, 7-2

ENTMAP option, 7-5

HEAD option, 7-4

HTML option, 7-4

-MARKUP clause, 7-4

-MARKUP option, 7-3

-MARKUP SPOOL clause, 7-4

/NOLOG clause, 7-10

PREFORMAT option, 7-7

RESTRICT, 7-8, E-8

running command files, 3-17

service name, 6-4, 7-9

-SILENT clause, 7-8

-SILENT option, 4-46, 7-8

SPOOL clause, 7-6

syntax, 7-2

SYSDBA clause, 7-9

TABLE option, 7-5

unsuccessful connection, 7-10

username/password, 2-3, 7-9

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

SQLPREFIX variable, 8-110

SQLPROMPT variable, 8-110

SQL.SQLCODE

using in EXIT command, 8-67

SQLTERMINATOR, 8-110

SQLTERMINATOR variable, 8-71, 8-110

STANDBY DATAFILE clause, 8-84

STANDBY TABLESPACE clause, 8-84

START clause, 8-14, 8-138

START command, 3-16, 8-131, GL-24

arguments, 3-27, 8-131

command file, 3-16, 8-131

disabling, E-5

passing parameters to a command file, 3-27, 8-131

similar to @ ("at" sign) command, 3-16, 8-6, 8-132

similar to @@ (double "at" sign) command, 8-7, 8-132

starting SQL*Plus, 2-3

shortcuts, 2-4

STARTUP command, 8-133

EXCLUSIVE clause, 8-133

FORCE clause, 8-133

MOUNT clause, 8-134

NOMOUNT clause, 8-134

OPEN clause, 8-134

PARALLEL clause, 8-134

PFILE clause, 8-133

RECOVER clause, 8-134

RESTRICT clause, 8-133

RETRY clause, 8-134

SHARED clause, 8-134

specifying a database, 8-134

statement

SQL, GL-21

statistics, 3-38

STD function, 4-16

STOP clause, 8-14, 8-138

STORE command, 3-20, 8-137

SET clause, 8-137

stored functions, 3-33

stored procedures

creating, 2-8

string, GL-21

Structured Query Language, GL-20

substitution variables, 3-22, GL-22, GL-25

appending characters immediately after, 3-24

avoiding unnecessary prompts for value, 3-24

concatenation character, 8-103

DEFINE command, 3-24, 8-52

prefixing, 8-103, F-2

restrictions, 3-26

single and double ampersands, 3-24

system variables used with, 3-26

undefined, 3-23

where and how to use, 3-22

subtotal, GL-22

SUFFIX variable, 8-111

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

used with EDIT command, 8-64

used with GET command, 8-69

used with SAVE command, 8-96

used with START command, 8-131

SUM function, 4-16

summary, GL-22

summary lines, GL-22

computing and printing, 4-15, 8-41

computing and printing at ends of reports, 4-19

computing same type on different columns, 4-20

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

printing multiple on same break column, 4-21

syntax, GL-22

conventions, 1-3

COPY command, 6-5

syntax rules

SQL commands, 2-7

SQL*Plus commands, 2-12

SYSDATE, 4-31

SYSDBA, GL-22

SYSDBA clause, 8-48

SYSOPER, GL-22

SYSOPER clause, 7-9, 8-48

system administrator, GL-22

system editor, GL-22

System Global Area, GL-23

SYSTEM username, GL-23

system variables, 2-13, 8-112, GL-23

changing current settings, 8-98

listing current settings, 2-13, 8-123

listing old and new values, 8-109

storing and restoring, 3-20

used with substitution variables, 3-26

system-maintained values

displaying in headers and footers, 8-91

displaying in titles, 4-27, 8-140

formatting in titles, 4-28

TAB clause, 8-92, 8-141

TAB variable, 8-111

TABLE clause, 7-5

TABLE option, 7-5

tables, 1-2, GL-23

access to sample, 1-7

alias, GL-23

controlling destination when copying, 6-6, 8-50

copying values between, 6-4, 6-9, 8-49

DEPT, 1-5

EMP, 1-4

listing column definitions, 2-16, 8-56

referring to another user's when copying, 6-8

sample, 1-4

TABLESPACE clause, 8-84

tablespaces

recovering, 8-82

tag, HTML, 4-38

TERMOUT variable, 8-111

storing current date in variable for titles, 4-30

using with SPOOL command, 8-130

text, 7-4, 7-5

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

changing old to new with CHANGE, 3-3, 8-25

clearing from buffer, 3-2, 8-28

text editor, GL-23

text editor, host operating system, 3-7, 8-64

TIME clause

in LOGIN.SQL, 3-19

TIME variable, 8-111

timer, GL-24

TIMING clause, 8-29

TIMING command, 2-15, 8-138

deleting all areas created by, 8-29

deleting current area, 8-138

SHOW clause, 8-138

START clause, 8-138

STOP clause, 8-138

TIMING variable, 8-111

titles, GL-24

aligning elements, 4-24, 8-141

displaying at bottom of page, 4-22, 8-24, F-2

displaying at top of page, 4-22, 8-140, F-2

displaying column values, 4-29, 8-35, 8-36

displaying current date, 4-30, 8-35, 8-38

displaying page number, 4-27, 8-143

displaying system-maintained values, 4-27, 8-140

formatting elements, 8-142

formatting system-maintained values in, 4-28

indenting, 4-26, 8-141

listing current definition, 4-28, 8-24, 8-142

restoring definition, 4-28

setting at start or end of report, 4-22

setting lines from top of page to top title, 4-31, 8-107, F-2

setting lines from top title to end of page, 8-108

setting top and bottom, 4-22, 8-24, 8-140, F-2

spacing between last row and bottom title, 4-25

suppressing definition, 4-28, 8-141

TO clause, 6-5, 8-49

tracing statements, 3-36

for performance statistics, 3-38

for query execution path, 3-38

using a database link, 3-40

with parallel query option, 3-41

transaction, GL-24

transaction rollback, GL-19

TRIMOUT variable, 8-111

TRIMSPOOL variable, 8-112

truncate, GL-24

TRUNCATE command

disabling, E-6

TRUNCATE variable, F-2, F-7

TRUNCATED clause, 4-7, 8-37

TTITLE clause, 8-125

TTITLE command, 4-22, 8-140, GL-24

aligning title elements, 4-24, 8-141

BOLD clause, 8-141

CENTER clause, 4-25, 8-141

COL clause, 4-26, 8-141

FORMAT clause, 4-27, 8-142

indenting titles, 4-26, 8-141

LEFT clause, 4-25, 8-141

listing current definition, 4-28, 8-142

OFF clause, 4-28, 8-141

old form, F-7

ON clause, 4-28

referencing column value variable, 4-29, 8-35

restoring current definition, 4-28

RIGHT clause, 4-25, 8-141

SKIP clause, 4-25, 8-141

suppressing current definition, 4-28, 8-141

TAB clause, 8-141

tuning, 3-36

type

column, GL-24

UNDEFINE command, 3-22, 8-144

and DEFINE command, 8-52

UNDERLINE variable, 4-3, 8-112

UNTIL CANCEL clause, 8-83

UNTIL CHANGE clause, 8-83

UNTIL CONTROLFILE clause, 8-84

UNTIL TIME clause, 8-83

UPDATE command

disabling, E-6

USER clause, 8-125

user profile, 3-19

LOGIN.SQL, 7-10

See also

user variables, 3-21, GL-24

defining, 3-21, 8-52

deleting, 3-22, 8-144

displaying in headers and footers, 8-91

displaying in titles, 8-140

in ACCEPT command, 3-28, 8-10

listing definition of one, 3-21, 8-52

listing definitions of all, 3-21, 8-52

USERID, GL-24

username, 1-6, GL-23, GL-24

connecting under different, 6-2, 8-47

in CONNECT command, 6-2, 6-3, 8-47

in COPY command, 6-5, 6-7, 6-9

in SQLPLUS command, 2-3, 6-4, 7-9

userprofile

GLOGIN.SQL, 7-10

USING BACKUP CONTROL FILE clause, 8-84

USING clause, 6-6, 8-51

V$SESSION virtual table, 8-99

V$SQLAREA virtual table, 8-100

VARCHAR columns

changing format, 4-6

default format, 4-6, 8-32

VARCHAR datatype, GL-24

VARCHAR2 clause

VARIABLE command, 8-145

VARCHAR2 columns

changing format, 4-6, 8-32

default format, 4-6

VARCHAR2 datatype, GL-25

VARIABLE command, 8-145

CHAR clause, 8-145

CLOB clause, 8-146

NCHAR clause, 8-145

NCLOB clause, 8-146

NUMBER clause, 8-145

REFCURSOR clause, 8-146

VARCHAR2 clause, 8-145

variable clause, 8-145

variables, GL-22, GL-23, GL-25

bind variables, 3-31

substitution variables, 3-22

system variables, 2-13

user variables, 8-52

VARIANCE function, 4-16

VERIFY clause, 3-23

VERIFY variable, 3-26, 8-112

WARNING clause, 8-67

web

outputting reports, 4-38

web browser, 4-38

WHENEVER OSERROR command, 8-151

COMMIT clause, 8-151

CONTINUE clause, 8-151

EXIT clause, 8-151

NONE clause, 8-151

ROLLBACK clause, 8-151

WHENEVER SQLERROR command, 3-18, 8-153

COMMIT clause, 8-153

CONTINUE clause, 8-153

EXIT clause, 8-153

NONE clause, 8-153

ROLLBACK clause, 8-153

width, GL-25

WORD_WRAPPED clause, 4-7, 4-10, 8-37

WRAP variable, 4-7, 8-112

WRAPPED clause, 4-7, 8-37

wrapping, GL-25