Index

customizing prompts for value, 3-28

CHAR clause, 8-11

NOPROMPT clause, 8-12

NUMBER clause, 3-29

PROMPT clause, 3-28, 8-12

Access, denying and granting, E-2

ALIAS clause, 8-33

in ATTRIBUTE command, 8-19

ALL clause, 8-123

ALTER command

in parameters, 3-25, 8-6, 8-130

Ampersands (&)

substitution variables, 3-20

ANALYZE command

in COPY command, 6-7, 8-52

APPEND clause

in SAVE command, 3-16, 8-98

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

APPINFO variable, 8-101

ARCH background process, 8-16

ARCHIVE LOG command, 5-4, 8-15

ARCHIVE LOG mode, 5-4

Arguments, in START command, 3-25, 8-130

ARRAYSIZE variable, 8-102

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

Attribute

display characteristics, 8-19

ATTRIBUTE command, 8-19

ALIAS clause, 8-19

and CLEAR COLUMN command, 8-20

CLEAR clause, 8-20

clearing columns, 8-30, 8-33

controlling an attribute's display charcteristics, 8-20

entering multiple, 8-20

FORMAT clause, 8-20

LIKE clause, 8-20

listing all attributes' display characteristics, 8-19

listing an attribute's display characteristics, 8-19

OFF clause, 8-20

ON clause, 8-20

restoring column display attributes, 8-20

suppressing column display attributes, 8-20

AUDIT command

AUTOCOMMIT variable, 2-14, 8-102

AUTOMATIC clause, 8-85

AUTOPRINT variable, 8-103

AUTORECOVERY variable, 8-103

AUTOTRACE variable, 3-35

AVG function, 4-17

Background processes

startup after abnormal termination, 8-127

Batch mode, 3-17, 8-70

displaying automatically, 8-103, 8-145

in PL/SQL blocks, 8-145

in SQL statements, 8-145

in the COPY command, 8-145

REFCURSOR, 3-32

Blank line

in PL/SQL blocks, 2-10

in SQL commands, 2-8

Blank lines

preserving in SQL commands, 8-111

Blocks, PL/SQL, 1-2

continuing, 2-10

editing in buffer, 3-2

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

entering and executing, 2-10

listing current in buffer, 3-3

run from SQL buffer, 2-10

saving current, 3-8, 8-98

setting character used to end, 8-104

stored in SQL buffer, 2-10

storing in command files, 3-8

timing statistics, 8-113

within SQL commands, 2-9

BLOCKTERMINATOR variable, 8-104

BOLD clause, 8-94, 8-140

Break columns, 4-11, 8-21

inserting space when value changes, 4-13

specifying multiple, 4-14

suppressing duplicate values in, 4-12

BREAK command, 4-11, 8-21

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

clearing BREAKS, 4-16

displaying column values in titles, 4-30

DUPLICATES clause, 8-24

inserting space after every row, 4-14

inserting space when break column changes, 4-13

listing current break definition, 4-16, 8-24

ON column clause, 4-12, 8-21

ON expr clause, 8-23

ON REPORT clause, 4-20, 8-23

ON ROW clause, 4-14, 8-23

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

printing summary lines at ends of reports, 4-20

removing definition, 8-30

SKIP clause, 4-14, 8-23

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

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

suppressing duplicate values, 4-12

used in conjunction with COMPUTE, 4-16, 8-21, 8-22, 8-23, 8-45

used in conjunction with SET COLSEP, 8-105

listing current, 4-16, 8-24

Break definition

removing current, 4-16, 8-30

BREAKS clause, 4-16, 8-30

BTITLE clause, 8-124

BTITLE command, 4-23, 8-26

aligning title elements, 8-140

indenting titles, 8-140

LEFT clause, 8-140

most often used clauses, 4-23

OFF clause, 8-140

old form, F-2

printing blank lines before bottom title, 4-27

referencing column value variable, 8-38

RIGHT clause, 8-140

SKIP clause, 8-140

suppressing current definition, 8-140

TAB clause, 8-140

TTITLE command, 8-26

Buffer, 2-10

BUFFER clause, 3-2, 3-9, 8-30

BUFFER variable, F-3

CANCEL clause, 8-87

CENTER clause, 4-24, 4-26, 8-94, 8-140

CHANGE command, 3-2, 3-4, 8-27

CHAR clause, 8-11

CHAR columns

CLEAR clause, 4-9, 8-33

BUFFER clause, 3-2, 3-9, 8-30

CLEAR command, 8-30

BREAKS clause, 4-16, 8-30

COLUMNS clause, 4-9, 8-30

COMPUTES clause, 4-22, 8-30

SCREEN clause, 3-30, 8-30

SQL clause, 8-31

TIMING clause, 8-31

CLOB clause

VARIABLE command, 8-145

CLOB columns

setting maximum width, 8-109

default format, 8-34

setting retrieval position, 8-109

setting retrieval size, 8-109

CMDSEP variable, 8-104

COL clause, 4-24, 4-27, 8-94, 8-140

Colons (:)

bind variables, 3-30

COLSEP variable, 8-104

COLUMN command, 4-2, 8-32

ALIAS clause, 8-33

and BREAK command, 8-23

displaying column values in bottom titles, 4-31, 8-38

CLEAR clause, 4-9, 8-33

DEFAULT clause, F-2

displaying column values in top titles, 4-30, 8-37

entering multiple, 8-39

FOLD_AFTER clause, 8-33

FOLD_BEFORE clause, 8-33

FORMAT clause, 4-5, 4-7, 8-34

formatting columns, 4-7

formatting NUMBER columns, 4-5, 8-34

HEADING clause, 4-2, 8-36

HEADSEP character, 8-36

JUSTIFY clause, 8-37

LIKE clause, 4-8, 8-37

listing a column's display attributes, 4-9, 8-32

listing all columns' display attributes, 8-32

listing all columnsdisplayattributes', 4-9

NEW_VALUE clause, 4-30, 4-32, 8-37

NEWLINE clause, 8-37

NOPRINT clause, 4-30, 8-38

NULL clause, 8-38

OFF clause, 4-10, 8-38

OLD_VALUE clause, 4-31, 8-38

ON clause, 4-10, 8-38

PRINT clause, 8-38

resetting a column to default display, 4-9, 8-33

restoring column display attributes, 4-10, 8-38

storing current date in variable for titles, 4-32, 8-40

suppressing column display attributes, 4-10, 8-38

TRUNCATED clause, 4-8, 8-38

WORD_WRAPPED clause, 4-8, 4-10, 8-38

WRAPPED clause, 4-8, 8-38

Column headings

aligning, 8-37

changing, 4-2, 8-36

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

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

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

suppressing printing in a report, 8-107

when truncated, 8-34

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-104

Columns

assigning aliases, 8-33

computing summary lines, 4-16, 8-43

copying display attributes, 4-8, 8-20, 8-37

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

displaying values in bottom titles, 4-31, 8-38

displaying values in top titles, 4-30, 8-37

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

formatting in reports, 4-2, 8-32

formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 8-34

formatting NUMBER, 4-5, 8-34

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

listing display attributes for one, 4-9, 8-32

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

printing line after values that overflow, 4-10, 8-110

resetting a column to default display, 4-9, 8-33

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

restoring display attributes, 4-10, 8-20, 8-38

setting printing to off or on, 4-30, 8-38

starting new lines, 8-37

storing values in variables, 4-30, 8-37

suppressing display attributes, 4-10, 8-20, 8-38

truncating display for all when value overflows, 4-8, 8-114

truncating display for one when value overflows, 4-8, 8-38

wrapping display for all when value overflows, 4-8, 8-114

wrapping display for one when value overflows, 4-8, 8-38

wrapping whole words for one, 4-10

COLUMNS clause, 4-9, 8-30

Comma, number format, 4-5

Command file extension, 8-98, 8-112, 8-136

Command files, 3-8

aborting and exiting with a return code, 3-17, 8-151, 8-153

allowing end-user input, 3-19

creating with a system editor, 3-11

creating with INPUT and SAVE, 3-9

creating with SAVE, 3-8, 8-98

editing with GET and SAVE, 3-16

editing with host system editor, 3-16, 8-66

in @ ("at" sign) command, 3-14, 8-6

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

in EDIT command, 3-16, 8-66

in GET command, 3-13, 8-71

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

in SQLPLUS command, 3-15, 7-2

in START command, 3-14, 8-130

including comments in, 3-11, 8-90

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

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

listing names with HOST command, 3-9

nesting, 3-15

passing parameters to, 3-25, 8-6, 8-130

registering, 8-101

retrieving, 3-13, 8-71

running, 3-14, 8-6, 8-130

running a series in sequence, 3-15

running as you start SQL*Plus, 3-15, 7-2

running in batch mode, 3-17, 8-70

running nested, 8-8

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

Command prompt

host operating system, 2-3

SQL*Plus, 2-4

Commands, 1-2

case, 2-5

collecting timing statistics on, 2-16, 8-137

disabling, E-4

host operating system, running from SQL*Plus, 2-16, 8-74

listing current in buffer, 8-77

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-66

ending, 2-8

entering and executing, 2-6

entering without executing, 2-8

executing current, 2-10, 8-10, 8-97

following syntax, 2-7

list of major, D-1

listing current in buffer, 3-3

saving current, 3-8, 8-98

setting character used to end and run, 8-112

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-112

stopping while running, 2-15

storing in command files, 3-8

syntax conventions, 1-4

tabs, 2-5

types of, 2-5

variables that affect running, 2-13

writing interactive, 3-19

Comments

including in command files, 3-11, 8-90

using -- to create, 3-12

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

using REMARK to create, 3-11, 8-90

COMMIT clause, 8-69

COMMIT command, 2-14

COMPATIBILITY clause

COMPATIBILITY variable, 8-105

COMPUTE command, 4-11, 8-43

AVG function, 4-17

computing a summary on different columns, 4-21

COUNT function, 4-17

LABEL clause, 4-17, 4-20, 8-44

listing all definitions, 4-22, 8-45

MAXIMUM function, 4-17

maximum LABEL length, 8-44

MINIMUM function, 4-17

NUMBER function, 4-17

OF clause, 4-16

ON column clause, 4-16, 8-44

ON expr clause, 8-44

ON REPORT clause, 4-20, 8-44

ON ROW clause, 8-44

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

printing multiple summaries on same column, 4-21

printing summary lines at ends of reports, 4-20

printing summary lines on a break, 4-16

referencing a SELECT expression in OF, 8-44

referencing a SELECT expression in ON, 8-45

removing definitions, 4-23, 8-30

STD function, 4-17

SUM function, 4-17

COMPUTES clause, 4-22, 8-30

VARIANCE function, 4-17

CONCAT variable, 3-25, 8-105

Concurrency

instances, multiple, 8-133

CONNECT command

changing password, 8-79

SYSDBA clause, 8-50

CONNECT command (SQL)

CONNECT command (SQL*Plus), 6-2, 6-3, 8-49

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

changing password, 8-49, 8-50

service name, 6-3

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

CONTINUE clause

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

Conventions, command syntax, 1-4

COPY command, 6-4, 8-51

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

and ARRAYSIZE variable, 6-8, 8-53

and COPYCOMMIT variable, 6-8, 8-53

and LONG variable, 6-8, 8-53

APPEND clause, 6-7, 8-52

copying data between databases, 6-4

copying data between tables on one database, 6-9

CREATE clause, 6-7, 8-52

creating a table, 6-6, 6-7, 8-52

destination table, 6-5, 8-51

determining actions, 6-5

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

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

FROM clause, 6-5, 8-52

INSERT clause, 6-7, 8-52

interpreting messages, 6-8

mandatory net service name, 8-51

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

query, 6-6, 8-52

referring to another user's table, 6-8

REPLACE clause, 6-6, 8-52

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

sample command, 6-5, 6-6

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

specifying column names for destination, 8-51

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

TO clause, 6-5, 8-52

username/password, 6-5, 6-7, 6-9, 8-51, 8-52

USING clause, 6-6, 8-52

when a commit is performed, 8-53

Copy command

specifying column names for destination, 6-5

COPYCOMMIT variable, 8-105

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

COPYTYPECHECK variable, 8-105

COUNT function, 4-17

CREATE clause

in COPY command, 6-7, 8-52

CREATE command

Creating the PRODUCT_USER_PROFILE table, E-2

entering PL/SQL, 2-9

Creating flat files, 4-36

Cursor Variables, 8-145

Database

mounting, 8-132

opening, 8-132

Database administrator, 1-7, 5-2

Database changes, saving automatically, 2-14, 8-102

DATABASE clause, 8-86

Database files

recovering, 8-85

Database name

at startup, 8-132

Databases

and RECOVERY command, 8-85

connecting to default, 6-2, 8-49

connecting to remote, 6-3, 8-49

copying data between, 6-4, 8-51

copying data between tables on a single, 6-9

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

mounting, 5-3

opening, 5-3

recovering, 5-5, 8-85

shutting down, 5-2, 5-3

starting, 5-2

DATAFILE clause, 8-87

DATE clause, 8-11

DATE columns

changing format, 4-7, 8-34, 8-41

default format, 4-6

Date, storing current in variable for titles, 4-32, 8-37, 8-40

DB2, 8-105

DBA mode, 8-132

DBA privilege, 8-132

DBMS_APPLICATION_INFO package, 8-101

DECLARE command

DECLARE command (PL/SQL), 2-10

DEFAULT clause, 8-12, F-2

DEFINE command, 3-19, 8-54

and host system editor, 3-7, 8-55

CHAR values, 8-54

substitution variables, 3-23, 8-54

DEFINE variable, 3-25, 8-105

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

using an asterisk, 3-2, 8-56

DELETE command

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

net service name, 8-58

PL/SQL properties listed by, 8-59

table properties listed by, 8-58

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-65

DOCUMENT command, F-2

REMARK as newer version of, F-3

DOCUMENT variable, F-4

DROP command

ECHO variable, 3-14, 8-106

DUPLICATES clause, 8-24

EDIT command, 3-7, 8-66

creating command files with, 3-11

defining _EDITOR, 3-7, 8-66

modifying command files, 3-16, 8-66

setting default file name, 8-106

EDITFILE variable, 8-106

EMBEDDED variable, 8-106

EMP table, 1-6

Empty line, displaying, 8-81

Enhancement list, Release 8.1, B-2

Error messages, interpreting, 2-18

Errors, making line containing current, 3-4

Escape characters, definition of, 8-106

ESCAPE variable, 3-25, 8-106

EXCLUSIVE clause, 8-133

EXECUTE command, 8-68

including in report, 8-103

Executing

a CREATE command, 2-9

Execution statistics

EXIT clause

:BindVariable clause, 8-69

EXIT command, 2-4, 8-69

COMMIT clause, 8-69

Exit, conditional, 8-150, 8-152

FAILURE clause, 8-69

in a command file, 8-131

ROLLBACK clause, 8-69

WARNING clause, 8-69

Extension, 8-98, 8-112, 8-136

FAILURE clause, 8-69

FEEDBACK variable, 8-107

File extension, 8-98, 8-112, 8-136

File extensions, 3-18

File names

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

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

in EDIT command, 8-66

in GET command, 8-71

in SAVE command, 3-8, 8-98

in SPOOL command, 4-35, 8-129

in SQLPLUS command, 7-2

in START command, 8-130

Files

command files, 3-8

flat, 4-36

FLAGGER variable, 8-107

Flat file, 4-36

FLUSH variable, 8-107

FOLD_AFTER clause, 8-33

FOLD_BEFORE clause, 8-33

Footers

aligning elements, 8-94

displaying at bottom of page, 8-91

displaying system-maintained values, 8-93

formatting elements, 8-94

indenting, 8-94

listing current definition, 8-91

setting at the end of reports, 4-23

suppressing definition, 8-94

FORCE clause, 8-132

FORMAT clause, 8-11

in COLUMN command, 4-5, 4-7, 8-34

in REPHEADER and REPFOOTER commands, 8-94

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

Format models, number, 4-5, 8-36

Formfeed, to begin a new page, 4-33, 8-109

FROM clause, 8-86

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

GET command, 3-13, 8-71

modifying command files, 3-16

LIST clause, 8-71

NOLIST clause, 8-71

retrieving command files, 3-13, 8-71

GLOGIN.SQL, 3-17, 3-36, 3-40, 7-3

GRANT command, E-2

displaying at top of page, 8-93

Headers

aligning elements, 4-26

displaying system-maintained values, 8-93

setting at the start of reports, 4-23

suppressing, 4-25

HEADING clause, 4-2, 8-36

HEADING variable, 8-107

Headings

aligning elements, 8-94

column headings, 8-107

formatting elements, 8-94

indenting, 8-94

listing current definition, 8-95

suppressing definition, 8-94

HEADSEP variable, 8-108

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

Help command, 8-73

Help, online, 2-6, 7-5, 8-73

HIDE clause, 8-12

HOST command, 2-16, 8-74

listing command file names with, 3-9

Host operating system

command prompt, 2-3

editor, 3-7, 8-66

file, loading into buffer, 8-71

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

Hyphen

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

IMMEDIATE mode, 8-127

Infinity sign (~), 8-36

Initialization parameters

displaying, 8-124

INIT.ORA file

Parameter file, 8-132

Input

accepting [Return], 3-30, 8-81

accepting values from the user, 3-27, 8-11

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

entering several lines, 8-75

using with SAVE to create command files, 3-9

INSERT clause, 6-7, 8-52

INSERT command

multiple, sharing a database, 8-133

INSTANCE variable, 8-108

Instances

shutting down, 8-127

starting, 8-132

JDeveloper Suite, 1-3

JUSTIFY clause, 8-37

Keyboard, significance of keys on, 2-2

Keys

Labels

in COMPUTE command, 4-17, 8-44

LEFT clause, 4-24, 4-26, 8-94, 8-140

LIKE clause, 4-8, 8-20, 8-37

Limits, SQL*Plus, C-1

Line numbers, for SQL commands, 2-6

Lines

adding at beginning of buffer, 8-75

adding at end of buffer, 8-75

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

appending text to, 3-6, 8-13

changing width, 4-33, 8-108

deleting all in buffer, 8-56

deleting from buffer, 3-7, 8-56

determining which is current, 3-4

editing current, 3-4

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

removing blanks at end, 8-113

LINESIZE variable, 4-26, 4-33, 8-108

LIST clause, 8-15, 8-71

LIST command, 3-2, 8-77

determining current line, 3-4, 8-77

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

using an asterisk, 3-2, 8-77

LNO clause, 8-124

LOBOFFSET variable, 8-109

LOCK TABLE command

LOG_ARCHIVE_DEST parameter, 8-15

LOGFILE clause, 8-87

Logging off

conditionally, 8-150, 8-152

Oracle, 6-2, 8-65

SQL*Plus, 2-4, 8-69

Logging on

Oracle, 6-2, 6-3, 8-49

SQL*Plus, 2-4, 7-2

LOGIN.SQL, 3-17, 7-4

including SET commands, 3-17

sample commands to include, 3-17

LONG columns

setting maximum width, 8-109

default format, 8-34

setting retrieval size, 8-109

LONG variable, 8-109

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

LONGCHUNKSIZE variable, 4-7, 8-34, 8-109

MAXIMUM function, 4-17

Media recovery, 8-133

Message, sending to screen, 3-27, 8-83

MINIMUM function, 4-17

MOUNT clause, 8-132

Mounting

shared databases, 8-133

Mounting a database, 8-132

NCHAR clause

NCHAR columns

NCLOB clause

VARIABLE command, 8-145

NCLOB columns

setting maximum width, 8-109

default format, 8-34

setting retrieval position, 8-109

setting retrieval size, 8-109

Negative infinity sign (-~), 8-36

Net service names

in DESCRIBE command, 8-58

Net8 protocol, 6-3

NEW_VALUE clause, 4-30, 8-37

storing current date in variable for titles, 4-32, 8-37, 8-40

NEWLINE clause, 8-37

NEWPAGE command, F-3

NEWPAGE variable, 4-33, 8-109

NEXT clause, 8-16

NLS_DATE_FORMAT, 8-11, 8-41

NOAUDIT command

NOLIST clause, 8-71

/NOLOG option, 7-3

NOMOUNT clause, 8-133

NONE clause

NOPRINT clause, 4-17, 4-30, 8-38

NOPARALLEL clause, 8-88

NOPROMPT clause, 8-12

NORMAL mode, 8-127

NULL clause, 8-38

Null values

setting text displayed, 8-38, 8-109

NULL variable, 8-109

NUMBER clause, 3-29, 8-11

changing format, 4-5, 8-34

NUMBER columns

default format, 4-4, 8-36

Number formats

$, 4-5

0, 4-5

9, 4-5

comma, 4-5

setting default, 8-109

NUMBER function, 4-17

NUMFORMAT clause

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

NUMFORMAT variable, 8-109

NUMWIDTH variable, 8-109

NVARCHAR2 columns

Objects

describing, 8-106

OF clause, 4-16

OFF clause

in COLUMN command, 4-10, 8-38

in REPHEADER and REPFOOTER commands, 8-94

in SPOOL command, 4-35, 8-129

in TTITLE and BTITLE commands, 4-30, 8-140

OLD_VALUE clause, 4-31, 8-38

ON clause

in COLUMN command, 4-10, 8-38

in TTITLE and BTITLE commands, 4-30

ON column clause

in BREAK command, 4-12, 8-21

in COMPUTE command, 4-16, 8-44

ON expr clause

in BREAK command, 8-23

in COMPUTE command, 8-44

ON REPORT clause

in BREAK command, 4-20, 8-23

in COMPUTE command, 4-20, 8-44

ON ROW clause

in BREAK command, 4-14, 8-23

in COMPUTE command, 8-44

Online help, 2-6, 7-5, 8-73

OPEN clause, 8-132

Opening a database, 8-132

Oracle Application Server, 1-3

Oracle Designer, 1-3

Oracle Developer, 1-3

Oracle Discoverer, 1-3

Oracle Enterprise Developer Suite, 1-3

Oracle Express, 1-4

Oracle Media Objects, 1-4

Oracle Mobile Agents, 1-4

Oracle Programmer, 1-3

Oracle Reports, 1-3

Oracle Workflow, 1-3

ORDER BY clause

displaying column values in titles, 4-30

displaying values together in output, 4-11

OUT clause, 4-36, 8-129

Output

formatting white space in, 8-113

pausing during display, 2-17, 8-110

query results, 1-2

PAGE clause, 8-93

Page number, including in titles, 4-15, 4-28

Pages

changing length, 4-33, 8-110

default dimensions, 4-32

matching dimensions to screen or paper size, 4-33

setting dimensions, 4-32

PAGESIZE variable, 2-7, 4-33, 8-110

PAGESIZEclause

PARALLEL DEGREE clause, 8-87

PARALLEL clause, 8-133

PARALLEL DEGREE DEFAULT clause, 8-87

PARALLEL INSTANCES clause, 8-88

PARALLEL INSTANCES DEFAULT clause, 8-88

Parameter files (INIT.ORA files)

specifying alternate, 8-132

Parameters, 3-25, 8-6, 8-130

PARAMETERS clause, 8-124

Password, 1-7

changing with the PASSWORD command, 8-79

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

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

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

PASSWORD command, 8-49, 8-79

Installation and User's Guide, 8-53

Paths, creating

PAUSE command, 3-30, 8-81

PAUSE variable, 2-17, 8-110

Performance

of SQL statements, 3-35

Performance, over dial-up lines, 8-113

Period (.)

terminating PL/SQL blocks, 2-10

PLAN_TABLE table, 3-36

PL/SQL, 1-2, 2-10

blocks, PL/SQL, 2-10

executing, 8-68

formatting output in SQL*Plus, 8-145

listing definitions, 2-17

mode in SQL*Plus, 2-9

within SQL commands, 2-9

Printing

bind variables automatically, 8-103

REFCURSOR variables, 8-146

SPOOL command, 8-129

PRODUCT_USER_PROFILE table, E-2

PROMPT clause, 3-28, 8-12

PROMPT command, 3-27, 8-83

customizing prompts for value, 3-28

Prompts for value

bypassing with parameters, 3-25

customizing, 3-28

through ACCEPT, 3-27

through substitution variables, 3-21

PUPBLD.SQL, E-2

Queries, 1-2

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

in COPY command, 6-6, 8-52

Query execution path

including in report, 8-103

Query results, 1-2

displaying on-screen, 2-7

sending to a printer, 4-36, 8-129

storing in a file, 4-35, 8-129

QUIT command, 8-69

Record separators, printing, 4-10, 8-110

in a command file, 8-131

RECOVER clause, 8-133

RECOVER command, 8-85

Recovery

RECOVER command, 8-85

RECOVERY command

and database recovery, 5-5

RECSEP variable, 4-10, 8-110

RECSEPCHAR variable, 4-10, 8-110

Redo Log Files

ARCHIVE LOG command, 8-15

REFCURSOR bind variables, 3-32

in a stored function, 3-32

REFCURSOR clause

VARIABLE command, 8-145

RELEASE clause, 8-125

REMARK command, 3-11, 8-90

RENAME command

REPFOOTER command, 4-23, 8-91

REPFOOTER clause, 8-125

aligning footer elements, 8-94

indenting report footers, 8-94

LEFT clause, 8-94

most often used clauses, 4-23

OFF clause, 8-94

RIGHT clause, 8-94

SKIP clause, 8-94

suppressing current definition, 8-94

TAB clause, 8-94

REPHEADER clause, 8-125

REPHEADER command, 4-23, 8-93

REPLACE clause

in COPY command, 6-6, 8-52

in SAVE command, 3-16, 8-98

Report breaks

Report columns

Report titles

clarifying with spacing and summary lines, 4-11

creating bottom titles, 4-23, 8-26

creating footers, 8-91

creating headers, 8-93

creating headers and footers, 4-23

creating master/detail, 4-30, 8-37, 8-38

creating top titles, 4-23, 8-139

displaying, 8-103

formatting column headings, 4-2, 8-32

formatting columns, 4-4, 4-6, 8-32

starting on a new page, 8-106

RESTRICT clause, 8-132

RETRY clause, 8-133

Return code, specifying, 3-17, 8-70, 8-153

REVOKE command, E-2

RIGHT clause, 4-24, 4-26, 8-94, 8-140

Roles, E-8

disabling, E-7

re-enabling, E-7

ROLLBACK clause, 8-69

performing computations on, 4-16, 8-43

Rows

setting number retrieved at one time, 8-102

setting the number after which COPY commits, 8-105

RUN command, 2-10, 8-97

executing current PL/SQL block, 2-11

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

making last line current, 3-4

SAVE command, 3-8, 8-98

APPEND clause, 3-16, 8-98

modifying command files, 3-16

REPLACE clause, 3-16, 8-98

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

using with INPUT to create command files, 3-10

Saving environment attributes, 8-136

SCAN variable, F-5

SCREEN clause, 3-30, 8-30

Screen, clearing, 3-30, 8-30

Search paths

Installation and User's Guide, 8-53

Security

changing password, 8-79

PRODUCT_USER_PROFILE table, E-2

SELECT command

and BREAK command, 4-11, 8-22, 8-23

and COLUMN command, 8-33

and COMPUTE command, 4-11

and COPY command, 6-6, 8-52

and ORDER BY clause, 4-11

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

SELECT statement

formatting results, 3-32

Semicolon (;)

in PL/SQL blocks, 2-10

in SQL commands, 2-7, 2-8

not needed when inputting a command file, 3-10

not stored in buffer, 3-3

SERVEROUTPUT variable, 8-111

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-3

Service names

in SQLPLUS command, 7-3

SET AUTOTRACE, 3-35

SET clause, 8-136

SET command, 2-13, 3-18, 8-100

APPINFO variable, 8-101

ARRAYSIZE variable, 6-8, 8-102

AUTOCOMMIT variable, 2-14, 8-102

AUTOPRINT variable, 8-103, 8-145

AUTORECOVERY variable, 8-103

BLOCKTERMINATOR variable, 8-104

BUFFER variable, F-3

CMDSEP variable, 8-104

COLSEP variable, 4-36, 8-104

COMPATIBILITY clause, 3-17

COMPATIBILITY variable, 8-105

CONCAT variable, 3-25, 8-105

COPYCOMMIT variable, 6-8, 8-105

COPYTYPECHECK variable, 8-105

DEFINE clause, 3-25

DEFINE variable, 8-105

DESCRIBE variable, 8-106

ECHO variable, 3-14, 8-106

DOCUMENT variable, F-4

EDITFILE variable, 8-106

EMBEDDED variable, 8-106

ESCAPE variable, 3-25, 8-106

FEEDBACK variable, 8-107

FLAGGER variable, 8-107

FLUSH variable, 8-107

HEADING variable, 8-107

HEADSEP variable, 4-3, 8-108

INSTANCE variable, 8-108

LINESIZE variable, 4-26, 4-33, 8-108

LOBOFFSET variable, 8-109

LOGSOURCE variable, 8-109

LONG variable, 6-8, 8-109

LONGCHUNKSIZE variable, 8-109

MAXDATA variable, F-5

NEWPAGE variable, 4-33, 8-109

NULL variable, 8-109

NUMFORMAT clause, 3-17

NUMFORMAT variable, 8-109

NUMWIDTH variable, 4-4, 8-36, 8-109

PAGESIZE clause, 3-17

PAGESIZE variable, 2-7, 4-33, 8-110

PAUSE clause, 3-17

PAUSE variable, 2-17, 8-110

RECSEP variable, 4-10, 8-110

RECSEPCHAR variable, 4-10, 8-110

SCAN variable, F-5

SERVEROUTPUT variable, 8-111

SHIFTINOUT clause, 3-18

SHIFTINOUT variable, 8-111

SPACE variable, F-5

SQLBLANKLINES variable, 8-111

SQLCASE variable, 8-112

SQLCONTINUE variable, 8-112

SQLNUMBER variable, 8-112

SQLPREFIX variable, 8-112

SQLPROMPT variable, 8-112

SQLTERMINATOR variable, 8-112

SUFFIX variable, 8-112

TAB variable, 8-113

TERMOUT variable, 4-32, 8-113

TIME clause, 3-18

TIME variable, 8-113

TIMING variable, 8-113

TRIMOUT variable, 8-113

TRIMSPOOL variable, 8-113

TRUNCATE variable, F-6

UNDERLINE variable, 4-3, 8-113

VERIFY variable, 3-25, 8-114

VERIFY clause, 3-21

WRAP variable, 4-8, 8-114

SET command variables

system variables, 2-13

SET ROLE command

SET TRANSACTION command

SHIFTINOUT variable, 8-111

SGA clause, 8-125

Shared disk systems

mounting shared, 8-133

Shared mode

database, 8-133

SHIFTINOUT clause

in LOGIN.SQL, 3-18

SHOW clause, 8-137

SHOW command, 2-14, 8-123

ALL clause, 8-123

BTITLE clause, 8-124

ERRORS clause, 8-124

listing current page dimensions, 4-35

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-111

SHUTDOWN command, 8-127

ABORT variable, 8-127

IMMEDIATE variable, 8-127

NORMAL variable, 8-127

TRANSACTIONAL variable, 8-127

-SILENT clause, 7-2

Site Profile, 7-3

SKIP clause

in BREAK command, 4-13, 4-14, 8-23

in REPHEADER and REPFOOTER commands, 8-94

in TTITLE and BTITLE commands, 4-26, 8-140

in TTITLE, BTITLE, REPHEADER and REPFOOTER commands, 4-24

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

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

Slash (/) command, 8-10

using with files loaded with GET command, 8-71

SPACE variable, F-5

SPOOL clause, 8-125

SPOOL command, 4-35, 8-129

turning spooling off, 4-35, 8-129

file name, 4-35, 8-129

OFF clause, 4-35, 8-129

OUT clause, 4-36, 8-129

SQL buffer, 2-10

SQL clause, 8-31

SQL commands, list of major, D-1

SQL database language, 1-2

SQL DML statements

SQL*Plus

database administration, 5-2

exiting, 2-4, 8-69

exiting conditionally, 8-150, 8-152

limits, C-1

LOGIN.SQL, 3-17

overview, 1-2

running commands in batch mode, 3-17, 8-70

setting up environment, 3-17

shortcuts to starting, 2-4

starting, 2-3, 7-2

what you need to run, 1-7

who can use, 1-3

SQLBLANKLINES variable, 8-111

SQLCASE variable, 8-112

SQLCODE clause, 8-125

SQLCONTINUE variable, 8-112

SQLNUMBER variable, 8-112

SQLPLUS command, 2-3, 7-2

- (hyphen) clause, 7-3

-? clause, 7-3

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

and EXIT FAILURE, 7-4

connecting to a remote database, 6-3

display syntax, 7-3

/NOLOG clause, 7-3

running command files, 3-15

service name, 6-3, 6-4, 7-3

-SILENT clause, 7-2

unsuccessful connection, 7-4

username/password, 2-4, 7-2

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

SQLPREFIX variable, 8-112

SQLPROMPT variable, 8-112

SQL.SQLCODE

using in EXIT command, 8-69

SQLTERMINATOR variable, 8-74, 8-112

STANDBY DATAFILE clause, 8-87

STANDBY TABLESPACE clause, 8-87

START clause, 8-16, 8-137

START command, 3-14, 8-130

arguments, 3-25, 8-130

command file, 3-14, 8-130

passing parameters to a command file, 3-25, 8-130

Starting SQL*Plus, 2-3

shortcuts, 2-4

STARTUP command, 8-132

EXCLUSIVE clause, 8-133

FORCE clause, 8-132

MOUNT clause, 8-132

NOMOUNT clause, 8-133

OPEN clause, 8-132

PARALLEL clause, 8-133

PFILE clause, 8-132

RECOVER clause, 8-133

RESTRICT clause, 8-132

RETRY clause, 8-133

SHARED clause, 8-133

specifying a database, 8-133

Statistics, 3-35

STD function, 4-17

STOP clause, 8-16, 8-137

STORE command, 3-18, 8-136

SET clause, 8-136

Stored functions, 3-32

Stored procedures

creating, 2-9

Substitution variables, 3-20

appending characters immediately after, 3-23

avoiding unnecessary prompts for value, 3-23

concatenation character, 8-105

DEFINE command, 3-23, 8-54

prefixing, 8-105

restrictions, 3-25

single and double ampersands, 3-23

system variables used with, 3-25

undefined, 3-21

where and how to use, 3-21

SUFFIX variable, 8-112

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

used with EDIT command, 8-66

used with GET command, 8-71

used with SAVE command, 8-98

used with START command, 8-130

SUM function, 4-17

Summary lines

computing and printing, 4-16, 8-43

computing and printing at ends of reports, 4-20

computing same type on different columns, 4-21

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

printing multiple on same break column, 4-21

Syntax

conventions, 1-4

COPY command, 6-5

Syntax rules

SQL commands, 2-7

SQL*Plus commands, 2-12

SYSDATE, 4-32

SYSDBA clause, 8-50

SYSOPER clause, 8-50

System variables, 2-13, 8-114

changing current settings, 8-100

listing current settings, 2-14, 8-123

listing old and new values, 8-111

storing and restoring, 3-18

used with substitution variables, 3-25

System-maintained values

displaying in headers and footers, 8-93

displaying in titles, 4-28, 8-139

formatting in titles, 4-29

TAB clause, 8-94, 8-140

TAB variable, 8-113

Tables, 1-2

access to sample, 1-8

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

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

DEPT, 1-6

EMP, 1-6

listing column definitions, 2-16, 8-58

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

sample, 1-5

TABLESPACE clause, 8-87

Tablespaces

recovering, 8-85

TERMOUT variable, 8-113

using with SPOOL command, 8-129

Text

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

changing old to new with CHANGE, 3-4, 8-28

clearing from buffer, 3-2, 8-30

Text editor, host operating system, 3-7, 8-66

TIME clause

in LOGIN.SQL, 3-18

TIME variable, 8-113

TIMING clause, 8-31

TIMING command, 2-16, 8-137

deleting all areas created by, 8-31

deleting current area, 8-137

SHOW clause, 8-137

START clause, 8-137

STOP clause, 8-137

TIMING variable, 8-113

Titles

TO clause, 6-5, 8-52

Tracing Statements, 3-35

for performance statistics, 3-37

for query execution path, 3-37

using a database link, 3-40

with parallel query option, 3-41

TRIMOUT variable, 8-113

TRIMSPOOL variable, 8-113

TRUNCATE command

TRUNCATED clause, 4-8, 8-38

TRUNCATE variable, F-6

TTITLE clause, 8-125

TTITLE command, 4-23, 8-139

Tuning, 3-35

UNDEFINE command, 3-20, 8-143

UNDERLINE variable, 4-3, 8-113

UNTIL CANCEL clause, 8-86

UNTIL CHANGE clause, 8-86

UNTIL CONTROLFILE clause, 8-87

UNTIL TIME clause, 8-86

UPDATE command

displaying in headers and footers, 8-93

USER clause, 8-125

User Profile, 3-17, 7-4

User variables, 3-19

defining, 3-19, 8-54

deleting, 3-20, 8-143

displaying in titles, 8-139

in ACCEPT command, 3-27, 8-11

listing definition of one, 3-20, 8-54

listing definitions of all, 3-20, 8-54

Username, 1-7

connecting under different, 6-2, 8-49

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

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

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

USING BACKUP CONTROL FILE clause, 8-86

USING clause, 6-6, 8-52

V$SESSION virtual table, 8-102

V$SQLAREA virtual table, 8-102

VARCHAR columns

changing format, 4-7

VARCHAR2 clause

VARCHAR2 columns

default format, 4-6