Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
- -- (comment delimiter), 1
- - (hyphen)
- clause, 1
- continuing a long SQL*Plus command, 1,
2
- . (period), 1
- / (slash) command
- default logon, 1,
2
- entered at buffer line-number prompt, 1,
2
- entered at command prompt, 1,
2
- executing current PL/SQL block, 1
- executing current SQL command, 1
- similar to RUN, 1,
2,
3
- usage, 1
- # pound sign, 1
- $ number format, 1
- & (ampersand)
- substitution variables, 1
- &&, 1
- * (asterisk)
- in DEL command, 1,
2
- in LIST command, 1,
2
- /*...*/ (comment delimiters), 1
- : (colon)
- bind variables, 1
- :BindVariable clause
- EXIT command, 1
- ; (semicolon), 1
- @ ("at" sign)
- command, 1,
2,
3
- command arguments, 1
- command file, 1,
2
- in CONNECT command, 1,
2
- in COPY command, 1,
2
- in SQLPLUS command, 1,
2,
3
- passing parameters to a command file, 1
- similar to START, 1,
2,
3
- @@ (double "at" sign) command, 1,
2
- command file, 1
- similar to START, 1,
2
- [Cancel] key, 1
- _EDITOR, in EDIT command, 1,
2
- ~ infinity sign, 1
- -~ negative infinity sign, 1
- 0, number format, 1
- 3 tier, 1
- 9, number format, 1
A
- ABORT mode, 1
- abort query, 1
- ACCEPT command, 1,
2
- and DEFINE command, 1
- CHAR clause, 1
- customizing prompts for value, 1
- DATE clause, 1
- DEFAULT clause, 1
- FORMAT clause, 1
- HIDE clause, 1
- NOPROMPT clause, 1
- NUMBER clause, 1
- PROMPT clause, 1,
2
- access, denying and granting, 1
- ALIAS clause, 1
- in ATTRIBUTE command, 1
- ALL clause, 1
- ALTER command
- disabling, 1
- ampersands (&)
- in parameters, 1,
2,
3
- substitution variables, 1
- ANALYZE command
- disabling, 1
- APPEND clause
- in COPY command, 1,
2
- in SAVE command, 1,
2
- APPEND command, 1,
2,
3
- APPINFO clause, 1
- ARCH background process, 1
- ARCHIVE LOG
- command, 1,
2
- mode, 1
- argument
- in START command, 1,
2
- ARRAYSIZE variable, 1
- relationship to COPY command, 1,
2
- attribute
- display characteristics, 1
- ATTRIBUTE command, 1
- ALIAS clause, 1
- and CLEAR COLUMN command, 1
- CLEAR clause, 1
- clearing columns, 1,
2
- controlling display characteristics, 1
- entering multiple, 1
- FORMAT clause, 1
- LIKE clause, 1
- listing all attributes' display characteristics, 1
- listing an attribute's display characteristics, 1
- OFF clause, 1
- ON clause, 1
- restoring column display attributes, 1
- suppressing column display attributes, 1
- AUDIT command
- disabling, 1
- AUTOCOMMIT variable, 1,
2
- AUTOMATIC clause, 1
- AUTOPRINT variable, 1
- AUTORECOVERY variable, 1
- AUTOTRACE variable, 1,
2
- AVG function, 1
B
- background process
- startup after abnormal termination, 1
- batch mode, 1,
2
- BEGIN command, 1
- disabling, 1
- bind variables, 1
- creating, 1
- displaying, 1
- displaying automatically, 1,
2
- in PL/SQL blocks, 1
- in SQL statements, 1
- in the COPY command, 1
- REFCURSOR, 1
- blank line
- in PL/SQL blocks, 1
- in SQL commands, 1
- preserving in SQL commands, 1
- blocks, PL/SQL, 1
- continuing, 1
- editing in buffer, 1
- editing with host system editor, 1,
2
- entering and executing, 1
- listing current in buffer, 1
- run from SQL buffer, 1
- saving current, 1,
2
- setting character used to end, 1
- stored in SQL buffer, 1
- storing in command files, 1
- timing statistics, 1
- within SQL commands, 1
- BLOCKTERMINATOR, 1,
2,
3
- BODY clause, 1
- BODY option, 1
- BOLD clause, 1,
2
- break columns, 1,
2
- inserting space when value changes, 1
- specifying multiple, 1
- suppressing duplicate values in, 1
- BREAK command, 1,
2
- and SQL ORDER BY clause, 1,
2,
3,
4
- clearing BREAKS, 1
- displaying column values in titles, 1
- BREAK command (continued)
- DUPLICATES clause, 1
- inserting space after every row, 1
- inserting space when break column changes, 1
- listing current break definition, 1,
2
- ON column clause, 1,
2
- ON expr clause, 1
- ON REPORT clause, 1,
2
- ON ROW clause, 1,
2
- printing "grand" and "sub" summaries, 1
- printing summary lines at ends of reports, 1
- removing definition, 1
- SKIP clause, 1,
2
- SKIP PAGE clause, 1,
2,
3
- specifying multiple break columns, 1,
2
- storing current date in variable for titles, 1
- suppressing duplicate values, 1
- used in conjunction with COMPUTE, 1,
2,
3,
4
- used in conjunction with SET COLSEP, 1
- used to format a REFCURSOR variable, 1
- break definition
- listing current, 1,
2
- removing current, 1,
2
- BREAKS clause, 1,
2
- browser, web, 1
- BTITLE clause, 1
- BTITLE command, 1,
2
- aligning title elements, 1
- BOLD clause, 1
- CENTER clause, 1
- COL clause, 1
- FORMAT clause, 1
- indenting titles, 1
- LEFT clause, 1
- OFF clause, 1
- old form, 1
- printing blank lines before bottom title, 1
- referencing column value variable, 1
- RIGHT clause, 1
- SKIP clause, 1
- suppressing current definition, 1
- TAB clause, 1
- TTITLE command, 1
- buffer, 1
- appending text to a line in, 1,
2
- delete a single line, 1
- delete the current line, 1
- delete the last line, 1
- deleting a range of lines, 1,
2
- deleting a single line, 1
- deleting all lines, 1,
2,
3
- deleting lines from, 1,
2
- deleting the current line, 1
- deleting the last line, 1
- executing contents, 1,
2,
3
- inserting new line in, 1,
2
- listing a range of lines, 1,
2
- listing a single line, 1,
2
- listing all lines, 1,
2
- listing contents, 1,
2
- listing the current line, 1,
2
- listing the last line, 1,
2
- loading into host system editor, 1,
2
- saving contents, 1,
2
- BUFFER clause, 1,
2,
3
- BUFFER variable, 1
C
- CANCEL clause, 1,
2
- cancel query, 1
- CENTER clause, 1,
2,
3
- CHANGE command, 1,
2,
3
- CHAR clause, 1
- VARIABLE command, 1
- CHAR columns
- changing format, 1,
2
- default format, 1,
2
- CLEAR clause, 1,
2
- in ATTRIBUTE command, 1
- CLEAR command, 1
- BREAKS clause, 1,
2
- BUFFER clause, 1,
2,
3
- COLUMNS clause, 1,
2
- COMPUTES clause, 1
- SCREEN clause, 1,
2
- SQL clause, 1
- TIMING clause, 1
- CLOB clause
- VARIABLE command, 1
- CLOB columns
- changing format, 1,
2
- default format, 1
- setting maximum width, 1
- setting retrieval position, 1
- setting retrieval size, 1
- CLOSECURSOR variable, 1,
2
- CMDSEP variable, 1
- COL clause, 1,
2,
3
- colons (:)
- bind variables, 1
- COLSEP variable, 1
- COLUMN command, 1,
2
- ALIAS clause, 1
- and BREAK command, 1
- and DEFINE command, 1
- CLEAR clause, 1,
2
- DEFAULT clause, 1
- displaying column values in bottom titles, 1,
2
- displaying column values in top titles, 1,
2
- entering multiple, 1
- ENTMAP clause, 1
- FOLD_AFTER clause, 1,
2
- FOLD_BEFORE clause, 1
- FORMAT clause, 1,
2,
3
- formatting columns, 1
- formatting NUMBER columns, 1,
2
- HEADING clause, 1,
2
- HEADSEP character, 1
- JUSTIFY clause, 1
- LIKE clause, 1,
2
- listing column display attributes, 1,
2
- NEW_VALUE clause, 1,
2,
3
- NEWLINE clause, 1
- NOPRINT clause, 1,
2
- NULL clause, 1
- OFF clause, 1,
2
- OLD_VALUE clause, 1,
2
- ON clause, 1,
2
- PRINT clause, 1
- resetting to default display, 1,
2,
3
- restoring column display attributes, 1,
2
- storing current date in variable for titles, 1,
2
- suppressing column display attributes, 1,
2
- TRUNCATED clause, 1,
2
- used to format a REFCURSOR variable, 1
- WORD_WRAPPED clause, 1,
2,
3
- WRAPPED clause, 1,
2
- column headings
- aligning, 1
- changing, 1,
2
- changing character used to underline, 1,
2
- changing to two or more words, 1,
2
- displaying on more than one line, 1,
2
- suppressing printing in a report, 1
- when truncated, 1
- when truncated for CHAR and LONG columns, 1
- when truncated for DATE columns, 1
- when truncated for NUMBER columns, 1
- column separator, 1,
2
- columns
- assigning aliases, 1
- computing summary lines, 1,
2
- copying display attributes, 1,
2,
3
- copying values between tables, 1,
2,
3
- displaying values in bottom titles, 1,
2
- displaying values in top titles, 1,
2
- formatting CHAR, VARCHAR, LONG, and DATE, 1
- formatting in reports, 1,
2
- formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 1
- formatting NUMBER, 1,
2
- listing display attributes for all, 1,
2
- listing display attributes for one, 1,
2
- names in destination table when copying, 1,
2
- printing line after values that overflow, 1,
2
- resetting a column to default display, 1,
2,
3
- resetting all columns to default display, 1,
2
- restoring display attributes, 1,
2,
3
- columns (continued)
- setting printing to off or on, 1,
2
- starting new lines, 1
- storing values in variables, 1,
2
- suppressing display attributes, 1,
2,
3
- truncating display for all when value overflows, 1,
2
- truncating display for one when value overflows, 1,
2
- wrapping display for all when value overflows, 1,
2
- wrapping display for one when value overflows, 1,
2
- wrapping whole words for one, 1
- COLUMNS clause, 1,
2
- comma, number format, 1
- command file extension, 1,
2,
3
- command files, 1
- aborting and exiting with a return code, 1,
2,
3
- allowing end-user input, 1
- creating with a system editor, 1
- creating with INPUT and SAVE, 1
- creating with SAVE, 1,
2
- editing with GET and SAVE, 1
- editing with host system editor, 1,
2
- in @ ("at" sign) command, 1,
2
- in @@ (double "at" sign) command, 1
- in EDIT command, 1,
2
- in GET command, 1,
2
- in SAVE command, 1,
2,
3
- in SQLPLUS command, 1,
2
- in START command, 1,
2
- including comments in, 1,
2
- including more than one PL/SQL block, 1
- including more than one SQL command, 1
- listing names with HOST command, 1
- nesting, 1
- passing parameters to, 1,
2,
3
- registering, 1
- retrieving, 1,
2
- running, 1,
2,
3
- running a series in sequence, 1
- running as you start SQL*Plus, 1,
2
- running in batch mode, 1,
2
- running nested, 1
- saving contents of buffer in, 1,
2
- uniform resource identifier, 1,
2,
3
- command prompt
- host operating system, 1
- SET SQLPROMPT, 1
- SQL*Plus, 1
- commands, 1
- collecting timing statistics on, 1,
2
- disabling, 1
- host, running from SQL*Plus, 1,
2
- listing current in buffer, 1
- re-enabling, 1
- spaces, 1
- SQL
- continuing on additional lines, 1
- editing in buffer, 1
- editing with host system editor, 1,
2
- ending, 1
- entering and executing, 1
- entering without executing, 1
- executing current, 1,
2,
3
- following syntax, 1
- list of major, 1
- listing current in buffer, 1
- saving current, 1,
2
- setting character used to end and run, 1
- SQL*Plus
- abbreviations, 1
- command summary, 1
- continuing on additional lines, 1,
2
- editing at command prompt, 1
- ending, 1,
2
- entering and executing, 1
- entering during SQL command entry, 1
- obsolete command alternatives, 1
- stopping while running, 1
- storing in command files, 1
- tabs, 1
- types of, 1
- variables that affect running, 1
- writing interactive, 1
- comments
- including in command files, 1,
2,
3
- using -- to create, 1
- comments (continued)
- using /*...*/ to create, 1
- using REMARK to create, 1,
2,
3
- COMMIT clause, 1
- WHENEVER OSERROR, 1
- WHENEVER SQLERROR, 1
- COMMIT command, 1
- COMPATIBILITY variable, 1
- COMPUTE command, 1,
2
- AVG function, 1
- computing a summary on different columns, 1
- COUNT function, 1
- LABEL clause, 1,
2,
3
- listing all definitions, 1,
2
- MAXIMUM function, 1
- maximum LABEL length, 1
- MINIMUM function, 1
- NUMBER function, 1
- OF clause, 1
- ON column clause, 1,
2
- ON expr clause, 1
- ON REPORT clause, 1,
2
- ON ROW clause, 1
- printing "grand" and "sub" summaries, 1
- printing multiple summaries on same column, 1
- printing summary lines at ends of reports, 1
- printing summary lines on a break, 1
- referencing a SELECT expression in OF, 1
- referencing a SELECT expression in ON, 1
- removing definitions, 1,
2
- STD function, 1
- SUM function, 1
- used to format a REFCURSOR variable, 1
- VARIANCE function, 1
- COMPUTES clause, 1
- CONCAT variable, 1,
2
- CONNECT command, 1,
2,
3
- and @ ("at" sign), 1,
2
- changing password, 1,
2,
3
- connect identifier, 1
- service name, 1
- SYSDBA clause, 1,
2
- SYSOPER clause, 1,
2
- username/password, 1,
2,
3,
4
- CONNECT command (SQL)
- disabling, 1
- connect identifier, 1,
2
- in CONNECT command, 1
- in COPY command, 1
- in DESCRIBE command, 1
- in SQLPLUS command, 1
- CONTINUE clause
- WHENEVER OSERROR, 1
- WHENEVER SQLERROR, 1
- continuing a long SQL*Plus command, 1,
2
- COPY command, 1,
2
- and @ ("at" sign), 1,
2
- and ARRAYSIZE variable, 1,
2
- and COPYCOMMIT variable, 1,
2
- and LONG variable, 1,
2
- APPEND clause, 1,
2
- copying data between databases, 1
- copying data between tables on one database, 1
- CREATE clause, 1,
2
- creating a table, 1,
2
- destination table, 1,
2
- determining actions, 1
- determining source rows and columns, 1,
2
- disabling, 1
- FROM clause, 1,
2
- INSERT clause, 1,
2
- inserting data in a table, 1,
2
- interpreting messages, 1
- mandatory connect identifier, 1
- naming the source table with SELECT, 1,
2
- query, 1,
2
- referring to another user's table, 1
- REPLACE clause, 1,
2
- replacing data in a table, 1,
2
- sample command, 1,
2
- service name, 1,
2,
3
- specifying columns for destination, 1,
2
- specifying the data to copy, 1,
2
- TO clause, 1,
2
- username/password, 1,
2,
3,
4
- USING clause, 1,
2
- when a commit is performed, 1
- COPYCOMMIT variable, 1
- relationship to COPY command, 1,
2
- COPYTYPECHECK variable, 1
- COUNT function, 1
- CREATE clause
- in COPY command, 1,
2
- CREATE command
- disabling, 1
- entering PL/SQL, 1
- creating flat files, 1
- creating the PRODUCT_USER_PROFILE table, 1
- cursor variables, 1
D
- database
- connect identifier, 1
- mounting, 1
- opening, 1
- database administrator, 1,
2
- database changes, saving automatically, 1,
2
- DATABASE clause, 1
- database files
- recovering, 1
- database name at startup, 1
- databases
- connecting to default, 1,
2
- connecting to remote, 1,
2
- copying data between, 1,
2
- copying data between tables on a single, 1
- disconnecting without leaving SQL*Plus, 1,
2
- mounting, 1
- opening, 1
- recovering, 1,
2
- shutting down, 1,
2
- starting, 1
- DATAFILE clause, 1
- DATE clause, 1
- DATE columns
- changing format, 1,
2,
3
- default format, 1
- date, storing current in variable for titles, 1,
2,
3
- DB2, 1
- DBA, 1
- DBA mode, 1
- DBA privilege, 1
- DBMS_APPLICATION_INFO package, 1
- DECLARE command
- disabling, 1
- DECLARE command (PL/SQL), 1
- DEFAULT clause, 1
- default logins
- created at installation, 1
- DEFINE command, 1,
2
- and host system editor, 1,
2
- and UNDEFINE command, 1,
2
- CHAR values, 1
- SET DEFINE ON|OFF, 1
- substitution variables, 1,
2
- DEFINE variable, 1,
2
- DEL command, 1,
2,
3
- using an asterisk, 1,
2
- DELETE command
- disabling, 1
- DESCRIBE command (SQL*Plus), 1,
2
- connect_identifier, 1
- PL/SQL properties listed by, 1
- table properties listed by, 1
- DISABLED keyword, disabling commands, 1
- disabling
- PL/SQL commands, 1
- SQL commands, 1
- SQL*Plus commands, 1
- DISCONNECT command, 1,
2
- DOCUMENT command
- obsolete commands
- DOCUMENT, 1,
2
- REMARK as newer version of, 1
- DOCUMENT variable, 1,
2
- DROP command
- disabling, 1
- DUPLICATES clause, 1
- dynamic reports, 1
E
- ECHO variable, 1,
2
- EDIT command, 1,
2
- creating command files with, 1
- defining _EDITOR, 1,
2
- disabling, 1
- modifying command files, 1,
2
- setting default file name, 1
- EDITFILE variable, 1
- EMBEDDED variable, 1
- EMP table, 1
- empty line, displaying, 1
- Enhancement list, Release 8.1, 1
- entities, HTML, 1
- ENTMAP, 1
- ENTMAP clause, 1,
2,
3
- error messages, interpreting, 1
- errors, making line containing current, 1
- escape characters, definition of, 1
- ESCAPE variable, 1,
2
- example
- embedded CGI report, 1
- interactive HTML report, 1,
2
- EXECUTE command, 1
- disabling, 1
- executing
- a CREATE command, 1
- execution statistics
- including in report, 1
- EXIT clause
- WHENEVER OSERROR, 1
- WHENEVER SQLERROR, 1
- EXIT command, 1,
2
- :BindVariable clause, 1
- COMMIT clause, 1
- disabling, 1
- FAILURE clause, 1
- in a command file, 1
- ROLLBACK clause, 1
- use with SET MARKUP, 1
- WARNING clause, 1
- exit, conditional, 1,
2
- extension, 1,
2,
3
F
- FAILURE clause, 1
- FEEDBACK variable, 1
- file extension, 1,
2,
3
- file extensions, 1
- file names
- in @ ("at" sign) command, 1
- in @@ (double "at" sign) command, 1
- in EDIT command, 1
- in GET command, 1
- in SAVE command, 1,
2
- in SPOOL command, 1,
2
- in SQLPLUS command, 1
- in START command, 1
- files
- command files, 1
- flat, 1
- FLAGGER variable, 1
- flat file, 1
- FLUSH variable, 1
- FOLD_AFTER clause, 1
- FOLD_BEFORE clause, 1
- footers
- aligning elements, 1
- displaying at bottom of page, 1
- displaying system-maintained values, 1
- formatting elements, 1
- indenting, 1
- listing current definition, 1
- setting at the end of reports, 1
- suppressing definition, 1
- FORCE clause, 1
- FORMAT clause, 1,
2
- in ATTRIBUTE command, 1
- in COLUMN command, 1,
2
- in REPHEADER and REPFOOTER commands, 1
- in TTITLE and BTITLE commands, 1,
2
- format models, number, 1,
2
- formfeed, to begin a new page, 1,
2
- FROM clause, 1
- FROM clause (SQL*Plus), 1,
2
G
- GET command, 1,
2
- disabling, 1
- LIST clause, 1
- modifying command files, 1
- NOLIST clause, 1
- retrieving command files, 1,
2
- GLOGIN.SQL, 1,
2,
3,
4
- 1
- GRANT command, 1
- disabling, 1
H
- HEAD clause, 1
- HEAD option, 1
- headers
- aligning elements, 1
- displaying at top of page, 1
- displaying system-maintained values, 1
- setting at the start of reports, 1
- suppressing, 1
- HEADING clause, 1,
2
- HEADING variable, 1
- headings
- aligning elements, 1
- column headings, 1
- formatting elements, 1
- indenting, 1
- listing current definition, 1
- suppressing definition, 1
- HEADSEP variable, 1
- use in COLUMN command, 1,
2
- HELP command, 1
- help, online, 1,
2,
3
- HIDE clause, 1
- HOST command, 1,
2
- disabling, 1
- listing command file names with, 1
- host operating system
- command prompt, 1
- editor, 1,
2
- file, loading into buffer, 1
- running commands from SQL*Plus, 1,
2
- HTML, 1
- clause, 1
- entities, 1
- option, 1
- spooling to file, 1
- tag, 1
- hyphen
- continuing a long SQL*Plus command, 1,
2
I
- IMMEDIATE mode, 1
- infinity sign (~), 1
- initialization parameters
- displaying, 1
- INIT.ORA file
- parameter file, 1
- input
- accepting [Return], 1,
2
- accepting values from the user, 1,
2
- INPUT command, 1,
2,
3
- entering several lines, 1
- using with SAVE to create command files, 1
- INSERT clause, 1,
2
- INSERT command
- disabling, 1
- installation
- default users created, 1
- INSTANCE variable, 1
- instances
- shutting down, 1
- starting, 1
- iSQL*Plus, 1
J
- JUSTIFY clause, 1
L
- LABEL variable
- SHOW command, 1,
2
- labels
- in COMPUTE command, 1,
2
- LEFT clause, 1,
2,
3
- LIKE clause, 1,
2,
3
- limits, SQL*Plus, 1
- line numbers, for SQL commands, 1
- lines
- adding at beginning of buffer, 1
- adding at end of buffer, 1
- adding new after current, 1,
2
- appending text to, 1,
2
- changing width, 1,
2
- deleting all in buffer, 1
- deleting from buffer, 1,
2
- determining which is current, 1
- editing current, 1
- listing all in buffer, 1,
2
- removing blanks at end, 1
- LINESIZE variable, 1,
2,
3
- LIST clause, 1,
2
- LIST command, 1,
2
- determining current line, 1,
2
- making last line current, 1,
2
- using an asterisk, 1,
2
- LNO clause, 1
- LOBOFFSET variable, 1
- LOCK TABLE command
- disabling, 1
- LOG_ARCHIVE_DEST parameter, 1
- LOGFILE clause, 1
- logging off
- conditionally, 1,
2
- Oracle, 1,
2
- SQL*Plus, 1,
2
- logging on
- default users created at installation, 1
- Oracle, 1,
2,
3
- SQL*Plus, 1
- LOGIN.SQL, 1,
2
- including SET commands, 1
- sample commands to include, 1
- 1
- storing current date in variable for titles, 1
- LONG columns
- changing format, 1,
2
- default format, 1
- setting maximum width, 1
- setting retrieval size, 1
- LONG variable, 1
- effect on COPY command, 1,
2
- LONGCHUNKSIZE variable, 1,
2,
3,
4
M
- -MARKUP, 1,
2
- SPOOL clause, 1
- SQLPLUS command clause, 1
- MARKUP, 1,
2,
3
- BODY clause, 1
- ENTMAP clause, 1
- example, 1
- HEAD clause, 1
- PREFORMAT clause, 1
- SPOOL clause, 1
- TABLE clause, 1
- MAXDATA variable, 1,
2
- MAXIMUM function, 1
- media recovery, 1
- message, sending to screen, 1,
2
- MINIMUM function, 1
- MOUNT clause, 1
- mounting a database, 1
N
- NCHAR clause
- VARIABLE command, 1
- NCHAR columns
- changing format, 1,
2
- default format, 1,
2
- NCLOB clause
- VARIABLE command, 1
- NCLOB columns
- changing format, 1,
2
- default format, 1
- setting maximum width, 1
- setting retrieval position, 1
- setting retrieval size, 1
- negative infinity sign (-~), 1
- NEW_VALUE clause, 1,
2
- storing current date in variable for titles, 1,
2
- NEWLINE clause, 1
- NEWPAGE command, 1,
2
- NEWPAGE variable, 1,
2
- NEXT clause, 1
- NLS_DATE_FORMAT, 1,
2
- NOAUDIT command
- disabling, 1
- NOLIST clause, 1
- NOLOG, 1
- /NOLOG option, 1
- NOMOUNT clause, 1
- NONE clause
- WHENEVER OSERROR, 1
- WHENEVER SQLERROR, 1
- NOPRINT clause, 1,
2,
3
- NOPROMPT clause, 1
- NORMAL mode, 1
- NULL clause, 1
- null values
- setting text displayed, 1,
2
- NULL variable, 1
- NUMBER clause, 1,
2
- VARIABLE command, 1
- NUMBER columns
- changing format, 1,
2
- default format, 1,
2
- number formats
- $, 1
- 0, 1
- 9, 1
- comma, 1
- setting default, 1
- NUMBER function, 1
- NUMFORMAT clause
- in LOGIN.SQL, 1
- NUMFORMAT variable, 1
- NUMWIDTH variable, 1
- effect on NUMBER column format, 1,
2
- NVARCHAR2 columns
- changing format, 1,
2
- default format, 1,
2
O
- objects, describing, 1
- obsolete commands
- BTITLE, 1
- COLUMN command DEFAULT clause, 1
- NEWPAGE, 1,
2
- SET command BUFFER variable, 1
- SET command CLOSECURSOR variable, 1,
2
- SET command DOCUMENT variable, 1,
2
- SET command MAXDATA variable, 1,
2
- SET command SCAN variable, 1,
2
- SET command SPACE variable, 1,
2
- SET command TRUNCATE variable, 1,
2
- SHOW command LABEL variable, 1,
2
- TTITLE command old form, 1
- OF clause, 1
- OFF clause, 1
- in ATTRIBUTE command, 1
- in COLUMN command, 1,
2
- in REPFOOTER commands, 1
- in REPHEADER commands, 1
- in SPOOL command, 1,
2
- in TTITLE and BTITLE commands, 1,
2
- OLD_VALUE clause, 1,
2
- ON clause
- in ATTRIBUTE command, 1
- in COLUMN command, 1,
2
- in TTITLE and BTITLE commands, 1
- ON column clause
- in BREAK command, 1,
2
- in COMPUTE command, 1,
2
- ON expr clause
- in BREAK command, 1
- in COMPUTE command, 1
- ON REPORT clause
- in BREAK command, 1,
2
- in COMPUTE command, 1,
2
- ON ROW clause
- in BREAK command, 1,
2
- in COMPUTE command, 1
- online help, 1,
2,
3
- OPEN clause, 1
- opening a database, 1
- Oracle Net
- connect identifier, 1
- protocol, 1
- ORDER BY clause
- displaying column values in titles, 1
- displaying values together in output, 1
- OUT clause, 1,
2
- output
- formatting white space in, 1
- pausing during display, 1,
2
- query results, 1
P
- PAGE clause, 1
- page number, including in titles, 1,
2
- pages
- changing length, 1,
2
- default dimensions, 1
- matching to screen or paper size, 1
- setting dimensions, 1
- PAGESIZE variable, 1,
2,
3
- PAGESIZEclause
- in LOGIN.SQL, 1
- parameter files (INIT.ORA files)
- specifying alternate, 1
- parameters, 1,
2,
3
- PARAMETERS clause, 1
- password, 1
- changing with the PASSWORD command, 1
- in CONNECT command, 1,
2,
3
- in COPY command, 1,
2,
3
- in SQLPLUS command, 1,
2,
3
- PASSWORD command, 1,
2
- disabling, 1
- PAUSE command, 1,
2
- in LOGIN.SQL, 1
- PAUSE variable, 1,
2
- performance
- of SQL statements, 1
- performance, over dial-up lines, 1
- Period (.)
- terminating PL/SQL blocks, 1
- period (.)
- terminating PL/SQL blocks, 1
- PLAN_TABLE table, 1
- PL/SQL, 1,
2
- blocks, PL/SQL, 1
- executing, 1
- formatting output in SQL*Plus, 1
- listing definitions, 1
- mode in SQL*Plus, 1
- within SQL commands, 1
- PLUSTRACE role, 1
- PNO clause, 1
- pound sign (#), 1
- PREFORMAT, 1
- PREFORMAT clause, 1
- PRINT clause, 1
- PRINT command, 1
- printing
- bind variables automatically, 1
- REFCURSOR variables, 1
- SPOOL command, 1
- PRODUCT_USER_PROFILE table, 1
- prompt
- SET SQLPROMPT, 1
- PROMPT clause, 1,
2
- PROMPT command, 1,
2
- customizing prompts for value, 1
- prompts for value
- bypassing with parameters, 1
- customizing, 1
- through ACCEPT, 1
- through substitution variables, 1
- PUPBLD.SQL, 1
Q
- queries, 1
- in COPY command, 1,
2
- show number of records retrieved, 1,
2
- query execution path
- including in report, 1
- query results, 1
- displaying on-screen, 1
- sending to a printer, 1,
2
- storing in a file, 1,
2
- QUIT command, 1
- 1
R
- record separators, printing, 1,
2
- RECOVER
- clause, 1
- RECOVER command, 1
- AUTOMATIC clause, 1
- CANCEL clause, 1,
2
- CONTINUE clause, 1
- DATABASE clause, 1
- FROM clause, 1
- LOGFILE clause, 1
- STANDBY DATABASE clause, 1
- STANDBY DATAFILE clause, 1
- STANDBY TABLESPACE clause, 1,
2
- UNTIL CANCEL clause, 1
- UNTIL CONTROLFILE clause, 1
- UNTIL TIME clause, 1
- USING BACKUP CONTROL FILE clause, 1
- recovery
- RECOVER command, 1
- RECOVERY command
- and database recovery, 1
- RECSEP variable, 1,
2
- RECSEPCHAR variable, 1,
2
- redo Log Files
- ARCHIVE LOG command, 1
- REFCURSOR bind variables, 1
- in a stored function, 1
- REFCURSOR clause
- VARIABLE command, 1
- RELEASE clause, 1
- REMARK command, 1,
2
- RENAME command
- disabling, 1
- REPFOOTER clause, 1
- REPFOOTER command, 1,
2
- aligning footer elements, 1
- BOLD clause, 1
- CENTER clause, 1
- COL clause, 1
- FORMAT clause, 1
- indenting report footers, 1
- LEFT clause, 1
- OFF clause, 1
- RIGHT clause, 1
- SKIP clause, 1
- suppressing current definition, 1
- TAB clause, 1
- REPHEADER clause, 1
- REPHEADER command, 1,
2
- aligning header elements, 1
- aligning heading elements, 1
- BOLD clause, 1
- CENTER clause, 1
- COL clause, 1
- FORMAT clause, 1
- indenting headings, 1
- LEFT clause, 1
- OFF clause, 1
- PAGE clause, 1
- RIGHT clause, 1
- SKIP clause, 1
- suppressing current definition, 1
- TAB clause, 1
- REPLACE clause
- in COPY command, 1,
2
- in SAVE command, 1,
2
- report
- breaks, 1
- title, 1
- reports, 1
- clarifying with spacing and summary lines, 1
- columns, 1
- creating bottom titles, 1,
2,
3
- creating footers, 1
- creating headers, 1
- creating headers and footers, 1
- creating master/detail, 1,
2
- creating top titles, 1,
2,
3
- displaying, 1
- dynamic, 1
- embedded CGI example, 1
- formatting column headings, 1,
2
- formatting columns, 1,
2,
3
- interactive HTML example, 1,
2
- on the web, 1
- SILENT mode, 1
- starting on a new page, 1
- title, 1
- RESTRICT, 1,
2,
3
- return code, specifying, 1,
2,
3
- REVOKE command, 1
- disabling, 1
- RIGHT clause, 1,
2,
3
- roles, 1
- disabling, 1
- re-enabling, 1
- ROLLBACK clause, 1
- WHENEVER OSERROR, 1
- WHENEVER SQLERROR, 1
- rows
- performing computations on, 1,
2
- setting number retrieved at one time, 1
- setting the number after which COPY commits, 1
- RUN command, 1,
2
- disabling, 1
- executing current PL/SQL block, 1
- executing current SQL command or PL/SQL block, 1
- making last line current, 1
- similar to / (slash) command, 1,
2
S
- sample tables
- access to, 1
- SAVE command, 1,
2
- APPEND clause, 1,
2
- CREATE clause, 1
- disabling, 1
- modifying command files, 1
- REPLACE clause, 1,
2
- storing commands in command files, 1,
2
- using with INPUT to create command files, 1
- saving environment attributes, 1
- SCAN variable, 1,
2
- SCREEN clause, 1,
2
- screen, clearing, 1,
2
- Security
- RESTRICT, 1,
2
- security
- changing password, 1
- embedded web reports, 1
- PRODUCT_USER_PROFILE table, 1
- SELECT command
- and BREAK command, 1,
2,
3
- and COLUMN command, 1
- and COMPUTE command, 1
- and COPY command, 1,
2
- and DEFINE command, 1
- and ORDER BY clause, 1
- disabling, 1
- storing current date in variable for titles, 1
- SELECT statement
- formatting results, 1
- semicolon (;)
- in PL/SQL blocks, 1
- in SQL commands, 1,
2
- in SQL*Plus commands, 1,
2
- not needed when inputting a command file, 1
- not stored in buffer, 1
- SERVEROUTPUT variable, 1
- service Name
- in COPY command, 1
- service name
- in CONNECT command, 1
- in COPY command, 1,
2
- in SQLPLUS command, 1
- SET AUTOTRACE, 1
- SET clause, 1
- SET command, 1,
2,
3
- APPINFO variable, 1
- ARRAYSIZE variable, 1,
2
- AUTOCOMMIT variable, 1,
2
- AUTOPRINT variable, 1,
2
- AUTORECOVERY variable, 1
- AUTOTRACE variable, 1
- BLOCKTERMINATOR variable, 1
- BUFFER variable, 1
- CLOSECURSOR variable, 1,
2
- CMDSEP variable, 1
- COLSEP variable, 1,
2
- COMPATIBILITY variable, 1
- CONCAT variable, 1,
2
- COPYCOMMIT variable, 1,
2
- COPYTYPECHECK variable, 1
- DEFINE clause, 1
- SET command (continued)
- DEFINE variable, 1
- DESCRIBE variable, 1
- disabling, 1
- DOCUMENT variable, 1,
2
- ECHO variable, 1,
2
- EDITFILE variable, 1
- EMBEDDED variable, 1
- ESCAPE variable, 1,
2
- FEEDBACK variable, 1
- FLAGGER variable, 1
- FLUSH variable, 1
- HEADING variable, 1
- HEADSEP variable, 1,
2
- INSTANCE variable, 1
- LINESIZE variable, 1,
2,
3
- LOBOFFSET variable, 1
- LOGSOURCE variable, 1
- LONG variable, 1,
2
- LONGCHUNKSIZE variable, 1
- MARKUP clause, 1
- MAXDATA variable, 1,
2
- NEWPAGE variable, 1,
2
- NULL variable, 1
- NUMFORMAT clause, 1
- NUMFORMAT variable, 1
- NUMWIDTH variable, 1,
2,
3
- PAGESIZE clause, 1
- PAGESIZE variable, 1,
2,
3
- PAUSE clause, 1
- PAUSE variable, 1,
2
- RECSEP variable, 1,
2
- RECSEPCHAR variable, 1,
2
- SCAN variable, 1,
2
- SERVEROUTPUT variable, 1
- SHIFTINOUT variable, 1
- SPACE variable, 1,
2
- SQLBLANKLINES variable, 1
- SQLCASE variable, 1
- SQLCONTINUE variable, 1
- SQLNUMBER variable, 1
- SQLPLUSCOMPATIBILITY variable, 1,
2
- SQLPREFIX variable, 1
- SQLPROMPT variable, 1
- SQLTERMINATOR variable, 1
- SUFFIX variable, 1
- TAB variable, 1
- TERMOUT variable, 1,
2
- TIME clause, 1
- TIME variable, 1
- TIMING variable, 1
- TRIMOUT variable, 1
- TRIMSPOOL variable, 1
- TRUNCATE variable, 1,
2
- UNDERLINE variable, 1,
2
- used to format a REFCURSOR variable, 1
- VERIFY clause, 1
- VERIFY variable, 1,
2
- WRAP variable, 1,
2
- SET command variables
- system variables, 1
- SET MARKUP
- BODY clause, 1
- embedded CGI example, 1
- ENTMAP clause, 1,
2
- HEAD clause, 1
- HTML, 1
- interactive HTML example, 1,
2
- PREFORMAT clause, 1
- 1
- SPOOL clause, 1
- TABLE clause, 1
- SET ROLE command
- disabling, 1
- SET TRANSACTION command
- disabling, 1
- SGA clause, 1
- SHIFTINOUT variable, 1
- SHOW clause, 1
- SHOW command, 1,
2
- ALL clause, 1
- BTITLE clause, 1
- ERRORS clause, 1
- LABEL variable, 1,
2
- listing current page dimensions, 1
- LNO clause, 1
- PNO clause, 1
- RELEASE clause, 1
- REPFOOTER clause, 1
- REPHEADER clause, 1
- SHOW command (continued)
- SPOOL clause, 1
- SQLCODE clause, 1
- TTITLE clause, 1
- USER clause, 1
- SHOWMODE variable, 1
- SHUTDOWN command, 1
- ABORT, 1
- IMMEDIATE, 1
- NORMAL, 1
- -SILENT option, 1,
2
- site profile
- GLOGIN.SQL, 1
- LOGIN.SQL, 1
- 1
- SKIP clause
- in BREAK command, 1,
2,
3
- in REPHEADER and REPFOOTER commands, 1
- in TTITLE and BTITLE commands, 1,
2
- used to place blank lines before bottom title, 1
- SKIP PAGE clause, 1,
2,
3
- slash (/) command, 1
- using with files loaded with GET command, 1
- SPACE variable, 1,
2
- SPOOL clause, 1,
2,
3
- SPOOL command, 1,
2
- disabling, 1
- file name, 1,
2
- OFF clause, 1,
2
- OUT clause, 1,
2
- to HTML file, 1
- turning spooling off, 1,
2
- use with SET MARKUP, 1
- SQL buffer, 1
- SQL clause, 1
- SQL commands, list of major, 1
- SQL database language, 1
- SQL DML statements
- reporting on, 1
- SQL*Plus
- basic concepts, 1
- command prompt, 1
- command summary, 1
- database administration, 1
- exiting, 1,
2
- exiting conditionally, 1,
2
- limits, 1
- LOGIN.SQL, 1
- obsolete command alternatives, 1
- overview, 1
- running commands in batch mode, 1,
2
- setting up environment, 1
- shortcuts to starting, 1
- starting, 1,
2
- what you need to run, 1
- who can use, 1
- SQLBLANKLINES variable, 1
- SQLCASE variable, 1
- SQLCODE clause, 1
- SHOW command, 1
- SQLCONTINUE variable, 1
- SQLNUMBER variable, 1,
2
- SQLPLUS command, 1,
2
- - clause, 1
- -? clause, 1
- and @ ("at" sign), 1,
2,
3
- and EXIT FAILURE, 1
- BODY option, 1
- connect identifier, 1
- connecting to a remote database, 1
- display syntax, 1
- ENTMAP option, 1
- HEAD option, 1
- HTML option, 1
- -MARKUP clause, 1
- -MARKUP option, 1
- -MARKUP SPOOL clause, 1
- /NOLOG clause, 1
- PREFORMAT option, 1
- RESTRICT, 1,
2
- running command files, 1
- service name, 1,
2
- -SILENT clause, 1
- -SILENT option, 1,
2
- SPOOL clause, 1
- syntax, 1
- SYSDBA clause, 1
- SQLPLUS command (continued)
- TABLE option, 1
- unsuccessful connection, 1
- username/password, 1,
2
- SQL.PNO, referencing in report titles, 1
- SQLPREFIX variable, 1
- SQLPROMPT variable, 1
- SQL.SQLCODE
- using in EXIT command, 1
- SQLTERMINATOR, 1
- SQLTERMINATOR variable, 1,
2
- STANDBY DATAFILE clause, 1
- STANDBY TABLESPACE clause, 1
- START clause, 1,
2
- START command, 1,
2
- arguments, 1,
2
- command file, 1,
2
- disabling, 1
- passing parameters to a command file, 1,
2
- similar to @ ("at" sign) command, 1,
2,
3
- similar to @@ (double "at" sign) command, 1,
2
- starting SQL*Plus, 1
- shortcuts, 1
- STARTUP command, 1
- FORCE clause, 1
- MOUNT clause, 1
- NOMOUNT clause, 1
- OPEN clause, 1
- PFILE clause, 1
- RECOVER clause, 1
- RESTRICT clause, 1
- specifying a database, 1
- statistics, 1
- STD function, 1
- STOP clause, 1,
2
- stop query, 1
- STORE command, 1,
2
- SET clause, 1
- stored functions, 1
- stored procedures
- creating, 1
- substitution variables, 1
- appending characters immediately after, 1
- avoiding unnecessary prompts for value, 1
- concatenation character, 1
- DEFINE command, 1,
2
- defined, 1
- prefixing, 1,
2
- restrictions, 1
- single and double ampersands, 1
- system variables used with, 1
- undefined, 1
- where and how to use, 1
- SUFFIX variable, 1
- used with @ ("at" sign) command, 1
- used with EDIT command, 1
- used with GET command, 1
- used with SAVE command, 1
- used with START command, 1
- SUM function, 1
- summary lines
- computing and printing, 1,
2
- computing and printing at ends of reports, 1
- computing same type on different columns, 1
- printing "grand" and "sub" summaries (totals), 1
- printing multiple on same break column, 1
- syntax
- COPY command, 1
- syntax rules
- SQL commands, 1
- SQL*Plus commands, 1
- SYSDATE, 1
- SYSDBA clause, 1
- SYSOPER clause, 1,
2
- system variables, 1,
2
- changing current settings, 1
- listing current settings, 1,
2
- listing old and new values, 1
- storing and restoring, 1
- used with substitution variables, 1
- system-maintained values
- displaying in headers and footers, 1
- displaying in titles, 1,
2
- formatting in titles, 1
T
- TAB clause, 1,
2
- TAB variable, 1
- TABLE clause, 1
- TABLE option, 1
- tables, 1
- access to sample, 1
- controlling destination when copying, 1,
2
- copying values between, 1,
2,
3
- listing column definitions, 1,
2
- referring to another user's when copying, 1
- TABLESPACE clause, 1
- tablespaces
- recovering, 1
- tag, HTML, 1
- TERMOUT variable, 1
- storing current date in variable for titles, 1
- using with SPOOL command, 1
- text, 1
- adding to current line with APPEND, 1,
2
- changing old to new with CHANGE, 1,
2
- clearing from buffer, 1,
2
- text editor, host operating system, 1,
2
- three-tier architecture, 1
- TIME clause
- in LOGIN.SQL, 1
- TIME variable, 1
- TIMING clause, 1
- TIMING command, 1,
2
- deleting all areas created by, 1
- deleting current area, 1
- SHOW clause, 1
- START clause, 1
- STOP clause, 1
- TIMING variable, 1
- titles
- aligning elements, 1,
2
- displaying at bottom of page, 1,
2,
3
- displaying at top of page, 1,
2,
3
- displaying column values, 1,
2,
3
- displaying current date, 1,
2,
3
- displaying page number, 1,
2
- displaying system-maintained values, 1,
2
- formatting elements, 1
- formatting system-maintained values in, 1
- indenting, 1,
2
- listing current definition, 1,
2,
3
- restoring definition, 1
- setting at start or end of report, 1
- setting lines from top of page to top title, 1,
2,
3
- setting lines from top title to end of page, 1
- setting top and bottom, 1,
2,
3,
4
- spacing between last row and bottom title, 1
- suppressing definition, 1,
2
- TO clause, 1,
2
- tracing statements, 1
- for performance statistics, 1
- for query execution path, 1
- using a database link, 1
- with parallel query option, 1
- TRIMOUT variable, 1
- TRIMSPOOL variable, 1
- TRUNCATE command
- disabling, 1
- TRUNCATE variable, 1,
2
- TRUNCATED clause, 1,
2
- TTITLE clause, 1
- TTITLE command, 1,
2
- aligning title elements, 1,
2
- BOLD clause, 1
- CENTER clause, 1,
2
- COL clause, 1,
2
- FORMAT clause, 1,
2
- indenting titles, 1,
2
- LEFT clause, 1,
2
- listing current definition, 1,
2
- OFF clause, 1,
2
- old form, 1
- ON clause, 1
- referencing column value variable, 1,
2
- restoring current definition, 1
- RIGHT clause, 1,
2
- SKIP clause, 1,
2
- suppressing current definition, 1,
2
- TAB clause, 1
- tuning, 1
U
- UNDEFINE command, 1,
2
- and DEFINE command, 1
- UNDERLINE variable, 1,
2
- UNTIL CANCEL clause, 1
- UNTIL CHANGE clause, 1
- UNTIL CONTROLFILE clause, 1
- UNTIL TIME clause, 1
- UPDATE command
- disabling, 1
- USER clause, 1
- user profile, 1
- LOGIN.SQL, 1
- 1
- user variables, 1
- defining, 1,
2
- deleting, 1,
2
- displaying in headers and footers, 1
- displaying in titles, 1
- in ACCEPT command, 1,
2
- listing definition of one, 1,
2
- listing definitions of all, 1,
2
- username, 1
- connecting under different, 1,
2
- created at installation, 1
- in CONNECT command, 1,
2,
3
- in COPY command, 1,
2,
3
- in SQLPLUS command, 1,
2,
3
- userprofile
- GLOGIN.SQL, 1
- USING BACKUP CONTROL FILE clause, 1
- USING clause, 1,
2
V
- V$SESSION virtual table, 1
- V$SQLAREA virtual table, 1
- VARCHAR columns
- changing format, 1
- default format, 1,
2
- VARCHAR2 clause
- VARIABLE command, 1
- VARCHAR2 columns
- changing format, 1,
2
- default format, 1
- VARIABLE command, 1
- CHAR clause, 1
- CLOB clause, 1
- NCHAR clause, 1
- NCLOB clause, 1
- NUMBER clause, 1
- REFCURSOR clause, 1
- VARCHAR2 clause, 1
- variable clause, 1
- variables
- bind variables, 1
- substitution variables, 1
- system variables, 1
- user variables, 1
- VARIANCE function, 1
- VERIFY clause, 1
- VERIFY variable, 1,
2
W
- WARNING clause, 1
- web
- outputting reports, 1
- web browser, 1
- WHENEVER OSERROR command, 1
- COMMIT clause, 1
- CONTINUE clause, 1
- EXIT clause, 1
- NONE clause, 1
- ROLLBACK clause, 1
- WHENEVER SQLERROR command, 1,
2
- COMMIT clause, 1
- CONTINUE clause, 1
- EXIT clause, 1
- NONE clause, 1
- ROLLBACK clause, 1
- WORD_WRAPPED clause, 1,
2,
3
- WRAP variable, 1,
2
- WRAPPED clause, 1,
2