Home / Database / Oracle Database Online Documentation 12c Release 1 (12.1) / Database Administration
SQL*Plus® User's Guide and Reference
ContentsOpens a new window
Opens a new window
Page 82 of 82

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  FOpens a new window  GOpens a new window  HOpens a new window  IOpens a new window  JOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  QOpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  VOpens a new window  WOpens a new window  XOpens a new window 

Symbols

 -- (comment delimiter), 5.3.3Opens a new window
 - (hyphen)
clause, 3.5.1.1Opens a new window
continuing a long SQL*Plus command, 4.6.1.1Opens a new window, 12Opens a new window
 . (period), 4.5Opens a new window
 / (slash) command
default logon, 3.5.2Opens a new window, 12Opens a new window
entered at buffer line-number prompt, 4.4.1.2Opens a new window, 12Opens a new window
entered at command prompt, 12Opens a new window
executing current PL/SQL block, 4.5Opens a new window
similar to RUN, 12Opens a new window, 12Opens a new window
usage, 12Opens a new window
# pound sign
overflow indication, 12Opens a new window
SET SQLPREFIX character, 12Opens a new window
$ number format, 6.1.2.2Opens a new window
& (ampersand)
disabling substitution variables, 5.9.4Opens a new window
substitution variables, 5.9Opens a new window
&&, 5.9.2Opens a new window
* (asterisk)
in DEL command, 5.2Opens a new window, 12Opens a new window
in LIST command, 5.2Opens a new window, 12Opens a new window
/*...*/ (comment delimiters), 5.3.2Opens a new window
: (colon)
bind variables, 5.12Opens a new window
:BindVariable clause
EXIT command, 12Opens a new window
; (semicolon), 4.4Opens a new window, 5.2Opens a new window, 12Opens a new window
@ (at sign)
command, 2.2.3.1Opens a new window, 5.4Opens a new window, 12Opens a new window
command arguments, 12Opens a new window, 12Opens a new window
in CONNECT command, 12Opens a new window
in COPY command, B.1Opens a new window, B.2.1Opens a new window
in SQLPLUS command, 3.5Opens a new window
passing parameters to a script, 12Opens a new window, 12Opens a new window
script, 5.4Opens a new window, 12Opens a new window
similar to START, 5.4Opens a new window, 12Opens a new window
@ at sign)
similar to START, 12Opens a new window
@@ (double at sign) command, 2.2.3.1Opens a new window, 12Opens a new window
script, 12Opens a new window
similar to START, 12Opens a new window, 12Opens a new window
_CONNECT_IDENTIFIER predefined variable, 2.2.2.1Opens a new window, 12Opens a new window, 12Opens a new window
_DATE predefined variable, 12Opens a new window, 12Opens a new window
_EDITOR predefined variable, 5.1.1Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
_EDITOR substitution variable, 12Opens a new window
_EDITOR, in EDIT command, 5.1.1Opens a new window, 12Opens a new window, 12Opens a new window
_O_RELEASE predefined variable, 12Opens a new window, 12Opens a new window
_O_VERSION predefined variable, 12Opens a new window, 12Opens a new window
_PRIVILEGE predefined variable, 12Opens a new window, 12Opens a new window
_RC predefined variable, 12Opens a new window
_SQLPLUS_RELEASE predefined variable, 12Opens a new window, 12Opens a new window, 12Opens a new window
_USER predefined variable, 12Opens a new window, 12Opens a new window
~ infinity sign, 12Opens a new window
-~ negative infinity sign, 12Opens a new window

Numerics

0, number format, 6.1.2.2Opens a new window
9, number format, 6.1.2.2Opens a new window

A

ABOpens a new window  ACOpens a new window  ALOpens a new window  AMOpens a new window  ANOpens a new window  APOpens a new window  AROpens a new window  ASOpens a new window  ATOpens a new window  AUOpens a new window 
ABORT mode, 12Opens a new window
abort query, 4.8Opens a new window
ACCEPT command, 5.11.1Opens a new window, 12Opens a new window, 12Opens a new window
and DEFINE command, 12Opens a new window
BINARY_DOUBLE clause, 12Opens a new window, 12Opens a new window
BINARY_FLOAT clause, 12Opens a new window, 12Opens a new window
customizing prompts for value, 5.11.2Opens a new window
DATE clause, 12Opens a new window
DEFAULT clause, 12Opens a new window
FORMAT clause, 12Opens a new window
HIDE clause, 12Opens a new window
NOPROMPT clause, 12Opens a new window
NUMBER clause, 5.11.2Opens a new window
PROMPT clause, 5.11.1Opens a new window, 12Opens a new window
access, denying and granting, 9.1Opens a new window
alias, 3.2.2Opens a new window
ALIAS clause, 12Opens a new window, 12Opens a new window
in ATTRIBUTE command, 12Opens a new window
ALL clause, 12Opens a new window
ALTER command
disabling, 9.2Opens a new window
ampersands &(amp;)
in parameters, 5.10Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
substitution variables, 5.9Opens a new window
ANALYZE command
disabling, 9.2Opens a new window
APPEND clause
in COPY command, B.1.1Opens a new window, B.2.2Opens a new window
in SAVE command, 12Opens a new window, 12Opens a new window
APPEND command, 5.2Opens a new window, 5.2.3Opens a new window, 12Opens a new window
APPINFO clause, 8.5.2Opens a new window, 12Opens a new window
ARCHIVE LOG
command, 10.3.1Opens a new window, 12Opens a new window
mode, 10.3.1Opens a new window
argument
in START command, 5.10Opens a new window
ARRAYSIZE variable, 8.5.3Opens a new window, 12Opens a new window, 12Opens a new window
relationship to COPY command, B.1.2Opens a new window, B.2.3Opens a new window
ASSOCIATE command
disabling, 9.2Opens a new window
ATTRIBUTE command, 12Opens a new window
ALIAS clause, 12Opens a new window
and CLEAR COLUMN command, 12Opens a new window
CLEAR clause, 12Opens a new window
clearing columns, 12Opens a new window, 12Opens a new window
controlling display characteristics, 12Opens a new window
display characteristics, 12Opens a new window
entering multiple, 12Opens a new window
FORMAT clause, 12Opens a new window
LIKE clause, 12Opens a new window
listing attribute display characteristics, 12Opens a new window, 12Opens a new window
OFF clause, 12Opens a new window
ON clause, 12Opens a new window
restoring column display attributes, 12Opens a new window
suppressing column display attributes, 12Opens a new window
AUDIT command
disabling, 9.2Opens a new window
AUTOCOMMIT variable, 4.11Opens a new window, 12Opens a new window, 12Opens a new window
AUTOMATIC clause, 12Opens a new window
AUTOPRINT variable, 12Opens a new window, 12Opens a new window
AUTORECOVERY variable, 12Opens a new window, 12Opens a new window, 12Opens a new window
autotrace report, 8.1.1Opens a new window
AUTOTRACE variable, 8.1.1Opens a new window, 12Opens a new window, 12Opens a new window

B

BAOpens a new window  BEOpens a new window  BFOpens a new window  BIOpens a new window  BLOpens a new window  BOOpens a new window  BROpens a new window  BTOpens a new window  BUOpens a new window 
background process
startup after abnormal termination, 12Opens a new window
BASEURI variable, 12Opens a new window
BASEURI XQUERY option, 12Opens a new window
basic OCI package, D.1.1Opens a new window
batch jobs, authenticating users in, 3.1.1Opens a new window
batch mode, 12Opens a new window
BEGIN command, 4.5Opens a new window
disabling, 9.2Opens a new window
BFILE clause
VARIABLE command, 12Opens a new window
BINARY_DOUBLE clause
ACCEPT command, 12Opens a new window, 12Opens a new window
VARIABLE command, 12Opens a new window
BINARY_FLOAT clause
ACCEPT command, 12Opens a new window, 12Opens a new window
VARIABLE command, 12Opens a new window
bind variables, 5.12Opens a new window
creating, 12Opens a new window
displaying, 12Opens a new window
displaying automatically, 12Opens a new window, 12Opens a new window
in PL/SQL blocks, 12Opens a new window
in SQL statements, 12Opens a new window
in the COPY command, 12Opens a new window
blank line
in PL/SQL blocks, 4.5Opens a new window
in SQL commands, 4.4.1.2Opens a new window
preserving in SQL commands, 12Opens a new window, 12Opens a new window
BLOB
column width, 6.1.3.1Opens a new window
formating in reports, 6.1.3Opens a new window
BLOB clause
VARIABLE command, 12Opens a new window
BLOB columns
default format, 12Opens a new window
setting maximum width, 12Opens a new window, 12Opens a new window
setting retrieval position, 12Opens a new window, 12Opens a new window
setting retrieval size, 8.5.7Opens a new window, 12Opens a new window, 12Opens a new window
blocks, PL/SQL
continuing, 4.5Opens a new window
editing in buffer, 5.2Opens a new window
editing with system editor, 5.1Opens a new window, 12Opens a new window
entering and executing, 4.5Opens a new window
listing current in buffer, 5.2.1Opens a new window
saving current, 12Opens a new window
setting character used to end, 12Opens a new window, 12Opens a new window
stored in SQL buffer, 4.5Opens a new window
timing statistics, 12Opens a new window
within SQL commands, 4.5.1Opens a new window
BLOCKTERMINATOR, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
BODY clause, 3.5.1.5Opens a new window
BODY option, 3.5.1.5Opens a new window
BOLD clause, 12Opens a new window, 12Opens a new window
break columns, 6.2Opens a new window, 12Opens a new window
inserting space when value changes, 6.2.2Opens a new window
specifying multiple, 6.2.4Opens a new window
suppressing duplicate values in, 6.2.1Opens a new window
BREAK command, 6.2Opens a new window, 12Opens a new window
and SQL ORDER BY clause, 6.2Opens a new window, 6.2.1Opens a new window, 6.2.4Opens a new window, 12Opens a new window
clearing BREAKS, 6.2.5Opens a new window
displaying column values in titles, 6.3.4Opens a new window
DUPLICATES clause, 12Opens a new window
inserting space after every row, 6.2.3Opens a new window
inserting space when break column changes, 6.2.2Opens a new window
listing current break definition, 6.2.5Opens a new window, 12Opens a new window
ON column clause, 6.2.1Opens a new window, 12Opens a new window
ON expr clause, 12Opens a new window
ON REPORT clause, 6.2.7Opens a new window, 12Opens a new window
ON ROW clause, 6.2.3Opens a new window, 12Opens a new window
printing grand and sub summaries, 6.2.7Opens a new window
printing summary lines at ends of reports, 6.2.7Opens a new window
removing definition, 12Opens a new window
SKIP clause, 6.2.3Opens a new window, 12Opens a new window
SKIP PAGE clause, 6.2.2Opens a new window, 6.2.2Opens a new window, 6.2.3Opens a new window, 12Opens a new window
specifying multiple break columns, 6.2.4Opens a new window, 12Opens a new window
suppressing duplicate values, 6.2.1Opens a new window
used in conjunction with COMPUTE, 6.2.6Opens a new window
used in conjunction with SET COLSEP, 12Opens a new window
used to format a REFCURSOR variable, 12Opens a new window
used with COMPUTE, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
break definition
listing current, 6.2.5Opens a new window, 12Opens a new window
removing current, 6.2.5Opens a new window, 12Opens a new window
BREAKS clause, 6.2.5Opens a new window, 12Opens a new window
browser, web, 7.1.1Opens a new window
BTITLE clause, 12Opens a new window
BTITLE command, 6.3.1Opens a new window, 12Opens a new window
aligning title elements, 12Opens a new window
BOLD clause, 12Opens a new window
CENTER clause, 12Opens a new window
COL clause, 12Opens a new window
FORMAT clause, 12Opens a new window
indenting titles, 12Opens a new window
LEFT clause, 12Opens a new window
OFF clause, 12Opens a new window
old form, C.2Opens a new window
printing blank lines before bottom title, 6.3.1.1Opens a new window
referencing column value variable, 12Opens a new window
RIGHT clause, 12Opens a new window
SKIP clause, 12Opens a new window
suppressing current definition, 12Opens a new window
TAB clause, 12Opens a new window
TTITLE command, 12Opens a new window
buffer, 4.1.1Opens a new window
appending text to a line in, 5.2.3Opens a new window, 12Opens a new window
delete a single line, 5.2Opens a new window
delete the current line, 5.2Opens a new window
delete the last line, 5.2Opens a new window
deleting a range of lines, 5.2Opens a new window, 12Opens a new window
deleting a single line, 12Opens a new window
deleting all lines, 5.2Opens a new window, 12Opens a new window, 12Opens a new window
deleting lines from, 5.2.5Opens a new window, 12Opens a new window
deleting the current line, 12Opens a new window
deleting the last line, 12Opens a new window
executing contents, 12Opens a new window, 12Opens a new window
inserting new line in, 5.2.4Opens a new window, 12Opens a new window
listing a range of lines, 5.2Opens a new window, 12Opens a new window
listing a single line, 5.2Opens a new window, 12Opens a new window
listing all lines, 5.2Opens a new window, 12Opens a new window
listing contents, 5.2.1Opens a new window, 12Opens a new window
listing the current line, 5.2Opens a new window, 12Opens a new window
listing the last line, 5.2Opens a new window, 12Opens a new window
loading into system editor, 12Opens a new window
saving contents, 12Opens a new window
BUFFER clause, 5.1.1Opens a new window, 5.2Opens a new window, 12Opens a new window
BUFFER variable, C.6Opens a new window

C

CAOpens a new window  CEOpens a new window  CHOpens a new window  CLOpens a new window  CMOpens a new window  COOpens a new window  CROpens a new window  CUOpens a new window 
CALL command
disabling, 9.2Opens a new window
CANCEL clause, 12Opens a new window, 12Opens a new window
Cancel key, 4.8Opens a new window
cancel query, 4.8Opens a new window
CENTER clause, 6.3.1.1Opens a new window, 12Opens a new window, 12Opens a new window
CHANGE command, 5.2Opens a new window, 5.2.2Opens a new window, 12Opens a new window
CHAR clause
VARIABLE command, 12Opens a new window
CHAR columns
changing format, 12Opens a new window
default format, 6.1.3.1Opens a new window
definition from DESCRIBE, 12Opens a new window
charset
SQL*Plus Instant Client, D.1.2Opens a new window
CLEAR clause, 6.1.5Opens a new window, 12Opens a new window
in ATTRIBUTE command, 12Opens a new window
CLEAR command, 12Opens a new window
BREAKS clause, 6.2.5Opens a new window, 12Opens a new window
BUFFER clause, 5.1.1Opens a new window, 5.2Opens a new window, 12Opens a new window
COLUMNS clause, 12Opens a new window
COMPUTES clause, 12Opens a new window
SCREEN clause, 5.11.4Opens a new window, 12Opens a new window
SQL clause, 12Opens a new window
TIMING clause, 12Opens a new window
CLOB clause
VARIABLE command, 12Opens a new window
CLOB columns
changing format, 12Opens a new window
default format, 12Opens a new window
setting maximum width, 12Opens a new window, 12Opens a new window
setting retrieval position, 12Opens a new window, 12Opens a new window
setting retrieval size, 8.5.7Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
CLOSECURSOR variable, C.1Opens a new window, C.8Opens a new window
CMDSEP variable, 12Opens a new window, 12Opens a new window
COL clause, 6.3.1.2Opens a new window, 12Opens a new window, 12Opens a new window
COLINVISIBLE variable, 12Opens a new window
colons &(colon;)
bind variables, 5.12Opens a new window
COLSEP variable, 12Opens a new window, 12Opens a new window
COLUMN command, 6.1Opens a new window, 12Opens a new window
ALIAS clause, 12Opens a new window
and BREAK command, 12Opens a new window
and DEFINE command, 12Opens a new window
CLEAR clause, 6.1.5Opens a new window, 12Opens a new window, 12Opens a new window
DEFAULT clause, C.3Opens a new window
displaying column values in bottom titles, 6.3.4Opens a new window, 12Opens a new window
displaying column values in top titles, 6.3.4Opens a new window, 12Opens a new window
entering multiple, 12Opens a new window
ENTMAP clause, 12Opens a new window
FOLD_AFTER clause, 12Opens a new window, 12Opens a new window, 12Opens a new window
FOLD_BEFORE clause, 12Opens a new window, 12Opens a new window
FORMAT clause, 6.1.2.2Opens a new window, 6.1.3.2Opens a new window, 12Opens a new window, 12Opens a new window
formatting a REFCURSOR variable, 12Opens a new window
formatting NUMBER columns, 6.1.2.1Opens a new window, 12Opens a new window
HEADING clause, 6.1.1.2Opens a new window, 12Opens a new window, 12Opens a new window
HEADSEP character, 12Opens a new window
JUSTIFY clause, 12Opens a new window
LIKE clause, 6.1.4Opens a new window, 12Opens a new window, 12Opens a new window
listing column display attributes, 6.1.5Opens a new window, 6.1.5Opens a new window, 12Opens a new window, 12Opens a new window
NEW_VALUE clause, 6.3.4Opens a new window, 12Opens a new window, 12Opens a new window
NEWLINE clause, 12Opens a new window, 12Opens a new window
NOPRINT clause, 6.3.4Opens a new window, 8.5.1Opens a new window, 12Opens a new window
NULL clause, 12Opens a new window, 12Opens a new window
OFF clause, 6.1.6Opens a new window, 12Opens a new window
OLD_VALUE clause, 6.3.4Opens a new window, 12Opens a new window, 12Opens a new window
ON clause, 6.1.6Opens a new window, 12Opens a new window
PRINT clause, 12Opens a new window
resetting a column to default display, C.1Opens a new window
resetting to default display, 6.1.5Opens a new window, 12Opens a new window, C.1Opens a new window
restoring column display attributes, 6.1.6Opens a new window, 12Opens a new window
storing current date in variable for titles, 12Opens a new window
suppressing column display attributes, 6.1.6Opens a new window, 12Opens a new window
TRUNCATED clause, 6.1.3.2Opens a new window, 12Opens a new window
WORD_WRAPPED clause, 6.1.3.2Opens a new window, 6.1.7Opens a new window, 12Opens a new window
WRAPPED clause, 6.1.3.2Opens a new window, 12Opens a new window
column headings
aligning, 12Opens a new window
changing, 6.1.1.1Opens a new window, 12Opens a new window
changing character used to underline, 12Opens a new window, 12Opens a new window
changing to two or more words, 6.1.1.2Opens a new window, 12Opens a new window
displaying on more than one line, 6.1.1.2Opens a new window, 12Opens a new window
suppressing printing in a report, 12Opens a new window, 12Opens a new window
when truncated, 12Opens a new window
when truncated for CHAR and LONG columns, 6.1.3.2Opens a new window
when truncated for DATE columns, 6.1.3.2Opens a new window
when truncated for NUMBER columns, 6.1.2.1Opens a new window
column separator, 12Opens a new window, 12Opens a new window, C.1Opens a new window
columns
assigning aliases, 12Opens a new window
computing summary lines, 6.2.6Opens a new window, 12Opens a new window
copying display attributes, 6.1.4Opens a new window, 12Opens a new window, 12Opens a new window
copying values between tables, B.1Opens a new window, B.2Opens a new window, B.3Opens a new window
displaying values in bottom titles, 6.3.4Opens a new window, 12Opens a new window
displaying values in top titles, 6.3.4Opens a new window, 12Opens a new window
formatting CHAR, VARCHAR, LONG, and DATE, 12Opens a new window
formatting in reports, 6.1Opens a new window, 12Opens a new window
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 12Opens a new window
formatting NUMBER, 6.1.2.1Opens a new window, 12Opens a new window
listing display attributes for all, 6.1.5Opens a new window, 12Opens a new window
listing display attributes for one, 6.1.5Opens a new window, 12Opens a new window
names in destination table when copying, B.1.1Opens a new window, B.2.1Opens a new window
printing line after values that overflow, 6.1.7Opens a new window, 12Opens a new window, 12Opens a new window
resetting a column to default display, 6.1.5Opens a new window, 12Opens a new window, C.1Opens a new window, C.1Opens a new window
resetting all columns to default display, 12Opens a new window
restoring display attributes, 6.1.6Opens a new window, 12Opens a new window, 12Opens a new window
setting printing to off or on, 6.3.4Opens a new window, 8.5.1Opens a new window, 12Opens a new window
starting new lines, 12Opens a new window
storing values in variables, 6.3.4Opens a new window, 12Opens a new window
suppressing display attributes, 6.1.6Opens a new window, 12Opens a new window, 12Opens a new window
truncating display for all when value overflows, 6.1.3.2Opens a new window, 12Opens a new window
truncating display for one when value overflows, 6.1.3.2Opens a new window, 12Opens a new window
wrapping display for all when value overflows, 6.1.3.2Opens a new window, 12Opens a new window
wrapping display for one when value overflows, 6.1.3.2Opens a new window, 12Opens a new window
wrapping whole words for one, 6.1.7Opens a new window
COLUMNS clause, 12Opens a new window
comma, number format, 6.1.2.2Opens a new window
command files
aborting and exiting with a return code, 5.6Opens a new window, 12Opens a new window, 12Opens a new window
creating with a system editor, 5.1.1Opens a new window
creating with SAVE, 12Opens a new window, 12Opens a new window
editing with system editor, 12Opens a new window
in @ (at sign) command, 5.4Opens a new window, 12Opens a new window
in EDIT command, 12Opens a new window
in GET command, 12Opens a new window
in SAVE command, 5.1.1Opens a new window, 12Opens a new window
in SQLPLUS command, 3.5.3Opens a new window, 5.4.1Opens a new window
in START command, 5.4Opens a new window, 12Opens a new window
including comments in, 5.3Opens a new window, 12Opens a new window
including more than one PL/SQL block, 5.1.1Opens a new window
including more than one SQL command, 5.1.1Opens a new window
nesting, 5.5Opens a new window
passing parameters to, 5.10Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
registering, 12Opens a new window, 12Opens a new window
retrieving, 12Opens a new window
running, 5.4Opens a new window, 12Opens a new window, 12Opens a new window
running a series in sequence, 5.5Opens a new window
running as you start SQL*Plus, 3.5.3Opens a new window, 5.4.1Opens a new window
running in batch mode, 5.6Opens a new window, 12Opens a new window
uniform resource locator, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
command prompt
SET SQLPROMPT, 8.5.10Opens a new window, 12Opens a new window, 12Opens a new window
SQL*Plus, 3.3.1Opens a new window
command-line
configuring globalization support, 11.1Opens a new window
installing help, 2.2.4Opens a new window
command-line interface
changing face and size, 1.2Opens a new window
commands
collecting timing statistics on, 8.2Opens a new window, 12Opens a new window
disabled in schema, 13.1Opens a new window
disabling, 9.2Opens a new window
echo on screen, 12Opens a new window
host, running from SQL*Plus, 4.9Opens a new window, 12Opens a new window
listing current in buffer, 12Opens a new window
re-enabling, 9.2Opens a new window
spaces, 4.1Opens a new window
SQL
continuing on additional lines, 4.4.1.1Opens a new window
editing in buffer, 5.2Opens a new window
editing with system editor, 12Opens a new window
ending, 4.4.1.2Opens a new window
entering and executing, 4.4Opens a new window
entering without executing, 4.4.1.2Opens a new window
executing current, 12Opens a new window, 12Opens a new window
following syntax, 4.4.1Opens a new window
listing current in buffer, 5.2.1Opens a new window
saving current, 12Opens a new window
setting character used to end and run, 12Opens a new window
SQL*Plus
command summary, 12Opens a new window
continuing on additional lines, 4.6.1.1Opens a new window, 12Opens a new window
ending, 4.6.1Opens a new window, 12Opens a new window
entering and executing, 4.6Opens a new window
entering during SQL command entry, 12Opens a new window
obsolete command alternatives, C.1Opens a new window
stopping while running, 4.8Opens a new window
tabs, 4.1Opens a new window
types of, 4.1Opens a new window
variables that affect running, 4.7Opens a new window
COMMENT command
disabling, 9.2Opens a new window
comments
including in command files, C.1Opens a new window
including in scripts, 5.3Opens a new window, 12Opens a new window, C.1Opens a new window
using -- to create, 5.3.3Opens a new window
using /*...*/ to create, 5.3.2Opens a new window
using REMARK, C.1Opens a new window
using REMARK to create, 5.3.1Opens a new window, 12Opens a new window, C.1Opens a new window
COMMIT clause, 12Opens a new window
WHENEVER OSERROR, 12Opens a new window
WHENEVER SQLERROR, 12Opens a new window
COMMIT command, 4.11Opens a new window
disabling, 9.2Opens a new window
communication between tiers, PrefaceOpens a new window
COMPATIBILITY variable, C.1Opens a new window, C.7Opens a new window
compilation errors, 4.5.1Opens a new window, 12Opens a new window, 13.1Opens a new window
COMPUTE command, 6.2Opens a new window, 12Opens a new window
computing a summary on different columns, 6.2.8Opens a new window
LABEL clause, 6.2.6Opens a new window, 6.2.7Opens a new window, 12Opens a new window
listing all definitions, 6.2.9Opens a new window, 12Opens a new window
maximum LABEL length, 12Opens a new window
OF clause, 6.2.6Opens a new window
ON, 12Opens a new window
ON column clause, 6.2.6Opens a new window, 12Opens a new window
ON expr clause, 12Opens a new window
ON REPORT clause, 6.2.7Opens a new window, 12Opens a new window
printing grand and sub summaries, 6.2.7Opens a new window
printing multiple summaries on same column, 6.2.8Opens a new window
printing summary lines at ends of reports, 6.2.7Opens a new window
printing summary lines on a break, 6.2.6Opens a new window
referencing a SELECT expression in OF, 12Opens a new window
referencing a SELECT expression in ON, 12Opens a new window
removing definitions, 6.2.9Opens a new window, 12Opens a new window
used to format a REFCURSOR variable, 12Opens a new window
COMPUTES clause, 12Opens a new window
CON_ID clause, 12Opens a new window
CON_NAME clause, 12Opens a new window
CONCAT variable, 5.9.4Opens a new window, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
configuration
globalization support
configuring
Oracle Net, 2.2.5Opens a new window
SQL*Plus, 2Opens a new window
CONNECT / feature, 3.1.1Opens a new window
CONNECT command, 3.1Opens a new window, 12Opens a new window
and @ (at sign), 12Opens a new window
changing password, 12Opens a new window, 12Opens a new window, 12Opens a new window
SYSASM clause, 12Opens a new window
SYSBACKUP clause, 12Opens a new window
SYSDBA clause, 12Opens a new window, 12Opens a new window, 12Opens a new window
SYSDG clause, 12Opens a new window
SYSKM clause, 12Opens a new window
SYSOPER clause, 12Opens a new window
username/password, 12Opens a new window
connect identifier, 12Opens a new window
in CONNECT command, 12Opens a new window
in COPY command, B.1Opens a new window
in DESCRIBE command, 12Opens a new window
in SQLPLUS command, 3.5.2Opens a new window
connection identifier, 3.2.1Opens a new window
easy or abbreviated, 3.2.3Opens a new window
full, 3.2.2Opens a new window
net service name, 3.2.2Opens a new window
CONTEXT variable, 12Opens a new window
CONTEXT XQUERY option, 12Opens a new window
CONTINUE clause
WHENEVER OSERROR, 12Opens a new window
WHENEVER SQLERROR, 12Opens a new window
continuing a long SQL*Plus command, 4.6.1.1Opens a new window, 12Opens a new window
COPY command, 12Opens a new window, B.1Opens a new window, B.2Opens a new window
and @ (at sign), B.1Opens a new window, B.2.1Opens a new window
and ARRAYSIZE variable, B.1.2Opens a new window, B.2.3Opens a new window
and COPYCOMMIT variable, B.1.2Opens a new window, B.2.3Opens a new window
and LONG variable, B.1.2Opens a new window, B.2.3Opens a new window
APPEND clause, B.1.1Opens a new window, B.2.2Opens a new window
copying data between databases, B.2Opens a new window
copying data between tables on one database, B.3Opens a new window
CREATE clause, B.1.1Opens a new window, B.2.2Opens a new window
creating a table, B.1.1Opens a new window, B.2.2Opens a new window, B.2.2Opens a new window
destination table, B.1.1Opens a new window, B.2.1Opens a new window
determining actions, B.2.1Opens a new window
determining source rows and columns, B.1.1Opens a new window, B.2.1Opens a new window
error messages, 13.2Opens a new window
FROM clause, B.2.1Opens a new window
INSERT clause, B.1.1Opens a new window, B.2.2Opens a new window
inserting data in a table, B.1.1Opens a new window, B.2.2Opens a new window, B.2.2Opens a new window
interpreting messages, B.2.3Opens a new window
mandatory connect identifier, B.1.1Opens a new window
naming the source table with SELECT, B.1.1Opens a new window, B.2.1Opens a new window
query, B.1.1Opens a new window, B.2.1Opens a new window
referring to another user’s table, B.2.4Opens a new window
REPLACE clause, B.1.1Opens a new window, B.2.2Opens a new window
replacing data in a table, B.1.1Opens a new window, B.2.2Opens a new window
sample command, B.2.1Opens a new window, B.2.1Opens a new window
service name, B.2.1Opens a new window, B.2.2Opens a new window, B.3Opens a new window
specifying columns for destination, B.1.1Opens a new window, B.2.1Opens a new window
specifying the data to copy, B.1.1Opens a new window, B.2.1Opens a new window
TO clause, B.2.1Opens a new window
username/password, B.1.1Opens a new window, B.2.1Opens a new window, B.2.2Opens a new window, B.3Opens a new window
USING clause, B.1.1Opens a new window, B.2.1Opens a new window
COPYCOMMIT variable, 12Opens a new window, 12Opens a new window
relationship to COPY command, B.1.2Opens a new window, B.2.3Opens a new window
COPYTYPECHECK variable, 12Opens a new window, 12Opens a new window
CREATE clause
in COPY command, B.1.1Opens a new window, B.2.2Opens a new window
CREATE command
disabling, 9.2Opens a new window
entering PL/SQL, 4.5.1Opens a new window
creating a PLAN_TABLE, 8.1.1Opens a new window
creating flat files, 6.4.1Opens a new window
creating PLUSTRACE role, 8.1.1Opens a new window
creating sample tables, PrefaceOpens a new window
creating the PRODUCT_USER_PROFILE table, 9.1.1Opens a new window
cursor variables, 12Opens a new window

D

DAOpens a new window  DBOpens a new window  DEOpens a new window  DIOpens a new window  DOOpens a new window  DROpens a new window  DUOpens a new window 
database
administrator, 10.1Opens a new window
connect identifier, 12Opens a new window
mounting, 12Opens a new window, 12Opens a new window
opening, 12Opens a new window, 12Opens a new window
database changes, saving automatically, 12Opens a new window, 12Opens a new window
DATABASE clause, 12Opens a new window
database files
recovering, 12Opens a new window
database name at startup, 12Opens a new window
database schema, 8.1.1Opens a new window
DESCRIBE parameter, 12Opens a new window
SHOW, 12Opens a new window, 12Opens a new window
databases
connecting to default, 12Opens a new window
connecting to remote, 12Opens a new window
copying data between, B.1Opens a new window, B.2Opens a new window
copying data between tables on a single, B.3Opens a new window
disconnecting without leaving SQL*Plus, 3.1Opens a new window, 12Opens a new window
mounting, 10.2.1Opens a new window
opening, 10.2.1Opens a new window
recovering, 10.4Opens a new window, 12Opens a new window
shutting down, 10.2Opens a new window, 10.2.3Opens a new window
starting, 10.2Opens a new window
DATAFILE clause, 12Opens a new window
DATE
column definition from DESCRIBE, 12Opens a new window
DATE clause, 12Opens a new window
DATE columns
changing format, 12Opens a new window, 12Opens a new window
default format, 6.1.3.1Opens a new window
date, storing current in variable for titles, 6.3.5Opens a new window, 12Opens a new window, 12Opens a new window
DB2, 12Opens a new window, 12Opens a new window
DBA, 10.1Opens a new window
mode, 12Opens a new window
privilege, 12Opens a new window
DBMS output, 8.5.9Opens a new window, 12Opens a new window
DBMS_APPLICATION_INFO package, 8.5.2Opens a new window, 12Opens a new window, 12Opens a new window
DECLARE command
disabling, 9.2Opens a new window
PL/SQL, 4.5Opens a new window
DEFAULT clause, 12Opens a new window
DEFINE command, 5.7Opens a new window, 12Opens a new window
and system editor, 5.1.1Opens a new window, 12Opens a new window
and UNDEFINE command, 5.7Opens a new window, 12Opens a new window
CHAR values, 12Opens a new window
SET DEFINE ON|OFF, 12Opens a new window, 12Opens a new window
substitution variables, 12Opens a new window
DEFINE variable
See substitution variable
DEL command, 5.2Opens a new window, 5.2.5Opens a new window, 12Opens a new window
using an asterisk, 5.2Opens a new window, 12Opens a new window
DELETE command
disabling, 9.2Opens a new window
DESCRIBE command (SQL*Plus), 4.2Opens a new window, 12Opens a new window
connect_identifier, 12Opens a new window
PL/SQL properties listed by, 12Opens a new window
table properties listed by, 12Opens a new window
DISABLED keyword, disabling commands, 9.1.3Opens a new window
disabling
PL/SQL commands, 9.2Opens a new window
SQL commands, 9.2Opens a new window
SQL*Plus commands, 9.2Opens a new window
DISASSOCIATE command
disabling, 9.2Opens a new window
DISCONNECT command, 3.1Opens a new window, 12Opens a new window
DOCUMENT command, C.1Opens a new window, C.4Opens a new window
REMARK as newer version of, C.4Opens a new window, C.4Opens a new window
DOCUMENT variable, C.1Opens a new window, C.9Opens a new window
DROP command
disabling, 9.2Opens a new window
DUPLICATES clause, 12Opens a new window

E

ECOpens a new window  EDOpens a new window  EMOpens a new window  ENOpens a new window  EROpens a new window  ESOpens a new window  EXOpens a new window 
ECHO
SET command, 12Opens a new window
ECHO variable, 5.4Opens a new window, 12Opens a new window, 12Opens a new window
Ed on UNIX, 12Opens a new window
EDIT command, 5.1.1Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
creating scripts with, 5.1.1Opens a new window
defining _EDITOR, 12Opens a new window
modifying scripts, 12Opens a new window
setting default file name, 12Opens a new window, 12Opens a new window
EDITFILE variable, 12Opens a new window, 12Opens a new window
edition, 3.5.2Opens a new window, 12Opens a new window
in CONNECT command, 12Opens a new window
in SQLPLUS command, 3.5.2Opens a new window, 3.5.2Opens a new window
EDITOR operating system variable, 12Opens a new window
EMBEDDED variable, 12Opens a new window, 12Opens a new window
entities, HTML, 7.1.3Opens a new window
ENTMAP, 3.5.1.5Opens a new window
ENTMAP clause, 3.5.1.5Opens a new window, 7.1.3Opens a new window, 12Opens a new window
environment variables
LD_LIBRARY_PATH, 2.1Opens a new window
LOCAL, 2.1Opens a new window
NLS_LANG, 2.1Opens a new window
ORA_EDITION, 2.1Opens a new window
ORA_NLS10, 2.1Opens a new window
ORACLE_HOME, 2.1Opens a new window
ORACLE_PATH, 2.1Opens a new window
ORACLE_SID, 2.1Opens a new window
PATH, 2.1Opens a new window
SQL*Plus, 2.1Opens a new window
SQLPATH, 2.1Opens a new window
TNS_ADMIN, 2.1Opens a new window
TWO_TASK, 2.1Opens a new window
error
SQL*Plus Instant Client unsupported charset, D.1.2.1Opens a new window
error messages
COPY command, 13.2Opens a new window
interpreting, 4.12Opens a new window
sqlplus, 13.1Opens a new window
ERRORLOGGING variable, 12Opens a new window
errors
compilation errors, 4.5.1Opens a new window, 12Opens a new window, 13.1Opens a new window
making line containing current, 5.2.2Opens a new window
escape characters, definition of, 12Opens a new window, 12Opens a new window
ESCAPE variable, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
ESCCHAR variable, 12Opens a new window
example
interactive HTML report, 7.1.1Opens a new window, 7.1.1Opens a new window
EXECUTE command, 12Opens a new window
executing
a CREATE command, 4.5.1Opens a new window
execution plan, 8.1.2Opens a new window
execution statistics
including in report, 12Opens a new window
EXIT clause
WHENEVER OSERROR, 12Opens a new window
WHENEVER SQLERROR, 12Opens a new window
EXIT command, 3.4Opens a new window, 12Opens a new window
:BindVariable clause, 12Opens a new window
COMMIT clause, 12Opens a new window
FAILURE clause, 12Opens a new window
in a script, 12Opens a new window
ROLLBACK clause, 12Opens a new window
use with SET MARKUP, 7.1.1Opens a new window
WARNING clause, 12Opens a new window
exit, conditional, 12Opens a new window
EXITCOMMIT variable, 12Opens a new window
EXPLAIN command
disabling, 9.2Opens a new window
extension, 12Opens a new window, 12Opens a new window, 12Opens a new window

F

FAOpens a new window  FEOpens a new window  FIOpens a new window  FLOpens a new window  FOOpens a new window  FROpens a new window 
FAILURE clause, 12Opens a new window
FEEDBACK variable, 12Opens a new window, 12Opens a new window
file extensions, 2.2.3Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
file names
in @ (at sign) command, 12Opens a new window
in @@ (double at sign) command, 12Opens a new window
in EDIT command, 12Opens a new window
in GET command, 12Opens a new window
in SAVE command, 12Opens a new window
in SPOOL command, 6.4.2Opens a new window, 12Opens a new window
in SQLPLUS command, 3.5.3Opens a new window
files
flat, 6.4.1Opens a new window
required for SQL*Plus Instant Client, D.2.3Opens a new window
FLAGGER variable, 12Opens a new window, 12Opens a new window
FLASHBACK command
disabling, 9.2Opens a new window
flat file, 6.4.1Opens a new window
FLUSH variable, 8.5.5Opens a new window, 12Opens a new window, 12Opens a new window
FOLD_AFTER clause, 12Opens a new window
FOLD_BEFORE clause, 12Opens a new window
font
changing face and size in command-line, 1.2Opens a new window
footers
aligning elements, 12Opens a new window
displaying at bottom of page, 12Opens a new window
displaying system-maintained values, 12Opens a new window
formatting elements, 12Opens a new window
indenting, 12Opens a new window
listing current definition, 12Opens a new window
setting at the end of reports, 6.3Opens a new window
suppressing definition, 12Opens a new window
FORCE clause, 12Opens a new window
FORMAT clause, 12Opens a new window, 12Opens a new window
in ATTRIBUTE command, 12Opens a new window
in COLUMN command, 6.1.2.2Opens a new window, 6.1.3.2Opens a new window
in REPHEADER and REPFOOTER commands, 12Opens a new window
in TTITLE and BTITLE commands, 6.3.2Opens a new window, 12Opens a new window
format models, number, 6.1.2.2Opens a new window, 12Opens a new window
formfeed, to begin a new page, 6.3.6Opens a new window, 12Opens a new window
FROM clause, 12Opens a new window, B.2.1Opens a new window

G

GEOpens a new window  GLOpens a new window  GROpens a new window 
GET command, 12Opens a new window
LIST clause, 12Opens a new window
NOLIST clause, 12Opens a new window
retrieving scripts, 12Opens a new window
globalization support
Oracle10g, 11.3Opens a new window
glogin
profile, 12Opens a new window
See also login.sql
site profile, 2.2Opens a new window, 2.2.1Opens a new window, 2.2.2.1Opens a new window, 3.5.1.8Opens a new window, 12Opens a new window
GRANT command, 9.1Opens a new window
disabling, 9.2Opens a new window

H

HEOpens a new window  HIOpens a new window  HOOpens a new window  HTOpens a new window  HYOpens a new window 
HEAD clause, 3.5.1.5Opens a new window
HEAD option, 3.5.1.5Opens a new window
headers
aligning elements, 6.3.1.1Opens a new window
displaying at top of page, 12Opens a new window
displaying system-maintained values, 12Opens a new window
setting at the start of reports, 6.3Opens a new window
suppressing, 6.3.1Opens a new window
HEADING clause, 6.1.1.2Opens a new window, 12Opens a new window
HEADING variable, 12Opens a new window
headings
aligning elements, 12Opens a new window
column headings, 12Opens a new window
formatting elements, 12Opens a new window
indenting, 12Opens a new window
listing current definition, 12Opens a new window
suppressing definition, 12Opens a new window
HEADSEP variable, 12Opens a new window, 12Opens a new window
use in COLUMN command, 6.1.1.2Opens a new window
help
installing command-line, 2.2.4Opens a new window
online, 3.3.2Opens a new window, 12Opens a new window
HELP command, ? command, 12Opens a new window
HIDE clause, 12Opens a new window
HOST command, 4.9Opens a new window, 12Opens a new window
HTML, 7.1.1Opens a new window
clause, 3.5.1.5Opens a new window
entities, 7.1.3Opens a new window
option, 3.5.1.5Opens a new window
spooling to file, 3.5.1.5Opens a new window
tag, 7.1Opens a new window
hyphen
continuing a long SQL*Plus command, 4.6.1.1Opens a new window, 12Opens a new window

I

IMOpens a new window  INOpens a new window 
IMMEDIATE mode, 12Opens a new window
infinity sign (~), 12Opens a new window
initialization parameters
displaying, 12Opens a new window, 12Opens a new window
INIT.ORA file
parameter file, 12Opens a new window
input
accepting values from the user, 5.11.1Opens a new window, 12Opens a new window
INPUT command, 5.2Opens a new window, 5.2.4Opens a new window, 12Opens a new window
entering several lines, 12Opens a new window
INSERT clause, B.1.1Opens a new window, B.2.2Opens a new window
INSERT command
disabling, 9.2Opens a new window
installation
SQL*Plus Instant Client, DOpens a new window
SQL*Plus Instant Client by copying, D.1Opens a new window
SQL*Plus Instant Client by copying from 10g Client, D.3Opens a new window
SQL*Plus Instant Client by download from OTN, D.1Opens a new window, D.2Opens a new window
SQL*Plus Instant Client on Linux, D.2.1Opens a new window
SQL*Plus Instant Client on UNIX or Windows, D.2.2Opens a new window
SQL*Plus Instant Client UNIX and Linux files to copy, D.3.1Opens a new window
SQL*Plus Instant Client Windows files to copy, D.3.2Opens a new window
installation by copying, D.1Opens a new window
installation by copying from 10g Client, D.3Opens a new window
installation by download from OTN, D.1Opens a new window, D.2Opens a new window
installation on Linux, D.2.1Opens a new window
installation on UNIX or Windows, D.2.2Opens a new window
installation, UNIX and Linux files to copy, D.3.1Opens a new window
installation, Windows files to copy, D.3.2Opens a new window
INSTANCE variable, 12Opens a new window, 12Opens a new window
instances
shutting down, 12Opens a new window
starting, 12Opens a new window
Instant Client
SQL*Plus, DOpens a new window
Instant Client packages, D.1Opens a new window

J

JAOpens a new window  JUOpens a new window 
Japanese
JUSTIFY clause, 12Opens a new window, 12Opens a new window

L

LAOpens a new window  LDOpens a new window  LEOpens a new window  LIOpens a new window  LNOpens a new window  LOOpens a new window 
LABEL variable
SHOW command, C.1Opens a new window
labels
in COMPUTE command, 6.2.6Opens a new window, 12Opens a new window
language
SQL*Plus Instant Client, D.1.2Opens a new window
LD_LIBRARY_PATH
environment variables, 2.1Opens a new window
LEFT clause, 6.3.1.1Opens a new window, 12Opens a new window, 12Opens a new window
lightweight OCI package, D.1.2Opens a new window
LIKE clause, 6.1.4Opens a new window, 12Opens a new window, 12Opens a new window
limits, SQL*Plus, AOpens a new window
lines
adding at beginning of buffer, 12Opens a new window
adding at end of buffer, 12Opens a new window
adding new after current, 5.2.4Opens a new window, 12Opens a new window
appending text to, 5.2.3Opens a new window, 12Opens a new window
changing width, 6.3.6Opens a new window, 8.5.6Opens a new window, 12Opens a new window, 12Opens a new window
deleting all in buffer, 12Opens a new window
deleting from buffer, 5.2.5Opens a new window, 12Opens a new window
determining which is current, 5.2.2Opens a new window
editing current, 5.2.2Opens a new window
listing all in buffer, 5.2Opens a new window, 12Opens a new window
removing blanks at end, 12Opens a new window
LINESIZE variable, 6.3.1.1Opens a new window, 6.3.6Opens a new window, 12Opens a new window, 12Opens a new window
Linux
installing SQL*Plus Instant Client, D.2.1Opens a new window
SQL*Plus Instant Client files to copy, D.3.1Opens a new window
LIST clause, 12Opens a new window, 12Opens a new window
LIST command, 5.2Opens a new window, 12Opens a new window
determining current line, 5.2.2Opens a new window, 12Opens a new window
making last line current, 5.2.2Opens a new window, 12Opens a new window
using an asterisk, 5.2Opens a new window, 12Opens a new window
LNO clause, 12Opens a new window
LOBOFFSET variable, 12Opens a new window, 12Opens a new window
LOCAL
environment variables, 2.1Opens a new window
LOCK TABLE command
disabling, 9.2Opens a new window
LOG_ARCHIVE_DEST parameter, 12Opens a new window
LOGFILE clause, 12Opens a new window
logging off
conditionally, 12Opens a new window, 12Opens a new window
Oracle Database, 3.1Opens a new window, 12Opens a new window
SQL*Plus, 3.4Opens a new window, 12Opens a new window
logging on
Oracle Database, 12Opens a new window
SQL*Plus, 3.3.1Opens a new window
login
user profile, 2.2.2.1Opens a new window
login.sql, 2.2.2Opens a new window
LONG
column definition from DESCRIBE, 12Opens a new window
LONG columns
changing format, 12Opens a new window
default format, 12Opens a new window
setting maximum width, 12Opens a new window, 12Opens a new window, 12Opens a new window
setting retrieval size, 8.5.7Opens a new window, 8.5.7Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
LONG variable, 12Opens a new window, 12Opens a new window
effect on COPY command, B.1.2Opens a new window, B.2.3Opens a new window
LONGCHUNKSIZE variable, 6.1.3.1Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
LONGRAW
column definition from DESCRIBE, 12Opens a new window

M

MAOpens a new window  MEOpens a new window  MOOpens a new window 
-MARKUP, 3.5.1.5Opens a new window, 3.5.1.5Opens a new window, 7.1Opens a new window, 7.1Opens a new window, 12Opens a new window
BODY clause, 3.5.1.5Opens a new window
ENTMAP clause, 3.5.1.5Opens a new window
HEAD clause, 3.5.1.5Opens a new window
PREFORMAT clause, 3.5.1.5Opens a new window
SQLPLUS command clause, 3.5.1.5Opens a new window
TABLE clause, 3.5.1.5Opens a new window
MAXDATA variable, C.1Opens a new window, C.10Opens a new window
media recovery, 12Opens a new window
MERGE command
disabling, 9.2Opens a new window
message, sending to screen, 5.11.1Opens a new window, 12Opens a new window
MOUNT clause, 12Opens a new window
mounting a database, 12Opens a new window

N

NAOpens a new window  NCOpens a new window  NEOpens a new window  NLOpens a new window  NOOpens a new window  NUOpens a new window  NVOpens a new window 
national language support
See also globalization support
NCHAR clause
VARIABLE command, 12Opens a new window
NCHAR columns
changing format, 12Opens a new window
default format, 6.1.3.1Opens a new window, 6.1.3.1Opens a new window, 12Opens a new window
NCLOB clause
VARIABLE command, 12Opens a new window
NCLOB columns
changing format, 12Opens a new window
default format, 12Opens a new window
setting maximum width, 12Opens a new window, 12Opens a new window
setting retrieval position, 12Opens a new window, 12Opens a new window
setting retrieval size, 8.5.7Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
negative infinity sign (-~), 12Opens a new window
net service name, 3.2.1Opens a new window, 3.2.2Opens a new window
NEW_VALUE clause, 6.3.4Opens a new window, 12Opens a new window
storing current date in variable for titles, 12Opens a new window
NEWLINE clause, 12Opens a new window
NEWPAGE command, C.1Opens a new window, C.5Opens a new window
NEWPAGE variable, 6.3.6Opens a new window, 12Opens a new window, 12Opens a new window
NLS
NLS_DATE_FORMAT, 12Opens a new window, 12Opens a new window
NLS_LANG
charset parameter for Instant Client, D.1.2Opens a new window
environment variables, 2.1Opens a new window
language parameter for Instant Client, D.1.2Opens a new window
SQL*Plus Instant Client, D.1.2Opens a new window
territory parameter for Instant Client, D.1.2Opens a new window
NOAUDIT command
disabling, 9.2Opens a new window
NODE variable, 12Opens a new window
NODE XQUERY option, 12Opens a new window
NOLIST clause, 12Opens a new window
NOLOG, 3.2.4Opens a new window, 3.5.2Opens a new window
nolongontime, 3.5.1.7Opens a new window
NOMOUNT clause, 12Opens a new window
NONE clause
WHENEVER OSERROR, 12Opens a new window
WHENEVER SQLERROR, 12Opens a new window
NOPARALLEL clause, 12Opens a new window
NOPRINT clause, 6.2.6Opens a new window, 6.3.4Opens a new window, 8.5.1Opens a new window, 12Opens a new window
NOPROMPT clause, 12Opens a new window
NORMAL mode, 12Opens a new window
Notepad on Windows, 12Opens a new window
NULL clause, 12Opens a new window
null values
setting text displayed, 12Opens a new window, 12Opens a new window, 12Opens a new window
NULL variable, 12Opens a new window, 12Opens a new window
NUMBER
column definition from DESCRIBE, 12Opens a new window
NUMBER clause, 5.11.2Opens a new window
VARIABLE command, 12Opens a new window
NUMBER columns
changing format, 6.1.2.1Opens a new window, 12Opens a new window
default format, 6.1.2.1Opens a new window, 12Opens a new window
number formats
$, 6.1.2.2Opens a new window
0, 6.1.2.2Opens a new window
9, 6.1.2.2Opens a new window
comma, 6.1.2.2Opens a new window
setting default, 5.9.4Opens a new window, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window
NUMFORMAT clause
in LOGIN.SQL, 2.2.2.1Opens a new window
NUMFORMAT variable, 12Opens a new window, 12Opens a new window
NUMWIDTH variable, 12Opens a new window, 12Opens a new window
effect on NUMBER column format, 6.1.2.1Opens a new window, 12Opens a new window
NVARCHAR2 columns
changing format, 12Opens a new window
default format, 6.1.3.1Opens a new window, 12Opens a new window

O

OBOpens a new window  OCOpens a new window  OFOpens a new window  OLOpens a new window  ONOpens a new window  OPOpens a new window  OROpens a new window  OUOpens a new window 
objects, describing, 12Opens a new window
obsolete commands
BTITLE, C.2Opens a new window
COLUMN command DEFAULT clause, C.3Opens a new window
DOCUMENT, C.1Opens a new window, C.4Opens a new window
NEWPAGE, C.1Opens a new window, C.5Opens a new window
SET command BUFFER variable, C.6Opens a new window
SET command CLOSECURSOR variable, C.1Opens a new window, C.8Opens a new window
SET command COMPATIBILITY variable, C.1Opens a new window, C.7Opens a new window
SET command DOCUMENT variable, C.1Opens a new window, C.9Opens a new window
SET command MAXDATA variable, C.1Opens a new window, C.10Opens a new window
SET command SCAN variable, C.1Opens a new window, C.11Opens a new window
SET command SPACE variable, C.1Opens a new window, C.12Opens a new window
SET command TRUNCATE variable, C.1Opens a new window, C.13Opens a new window
SHOW command LABEL variable, C.1Opens a new window
TTITLE command old form, C.14Opens a new window
OCI Instant Client, DOpens a new window
OCI package
basic, D.1.1Opens a new window
lightweight, D.1.2Opens a new window
OF clause, 6.2.6Opens a new window
OFF clause, 12Opens a new window
in ATTRIBUTE command, 12Opens a new window
in COLUMN command, 6.1.6Opens a new window, 12Opens a new window
in REPFOOTER commands, 12Opens a new window
in REPHEADER commands, 12Opens a new window
in SPOOL command, 6.4Opens a new window, 12Opens a new window
in TTITLE and BTITLE commands, 6.3.3Opens a new window, 12Opens a new window
OLD_VALUE clause, 6.3.4Opens a new window, 12Opens a new window
ON clause
in ATTRIBUTE command, 12Opens a new window
in COLUMN command, 6.1.6Opens a new window, 12Opens a new window
in TTITLE and BTITLE commands, 6.3.3Opens a new window
ON column clause
in BREAK command, 12Opens a new window
in COMPUTE command, 6.2.6Opens a new window, 12Opens a new window
ON expr clause
in BREAK command, 12Opens a new window
in COMPUTE command, 12Opens a new window
ON REPORT clause
in BREAK command, 6.2.7Opens a new window, 12Opens a new window
in COMPUTE command, 6.2.7Opens a new window, 12Opens a new window
ON ROW clause
in BREAK command, 6.2.3Opens a new window, 12Opens a new window
in COMPUTE command, 12Opens a new window
online help, 3.3.2Opens a new window, 3.3.2Opens a new window, 12Opens a new window
OPEN clause, 12Opens a new window
opening a database, 12Opens a new window
operating system
editor, 5.1.1Opens a new window, 12Opens a new window, 12Opens a new window
file, loading into buffer, 12Opens a new window
running commands from SQL*Plus, 4.9Opens a new window, 12Opens a new window
text editor, 5.1.1Opens a new window
ORA_EDITION
environment variables, 2.1Opens a new window
ORA_NLS10
environment variables, 2.1Opens a new window
Oracle Application Editions
edition, 3.5.2Opens a new window
Oracle Database Client, DOpens a new window
Oracle Net
configuring, 2.2.5Opens a new window
connect identifier, 12Opens a new window
Oracle Session Editions
edition, 12Opens a new window
ORACLE_HOME
environment variables, 2.1Opens a new window
ORACLE_PATH
environment variables, 2.1Opens a new window
ORACLE_SID
environment variables, 2.1Opens a new window
Oracle10g
globalization support, 11.3Opens a new window
ORDER BY clause
displaying column values in titles, 6.3.4Opens a new window
displaying values together in output, 6.2Opens a new window
ORDERING variable, 12Opens a new window
ORDERING XQUERY option, 12Opens a new window
OUT clause, 6.4.3Opens a new window, 12Opens a new window
output
formatting white space in, 8.5.11Opens a new window, 12Opens a new window
pausing during display, 4.10Opens a new window, 12Opens a new window

P

PAOpens a new window  PDOpens a new window  PEOpens a new window  PLOpens a new window  PNOpens a new window  POOpens a new window  PROpens a new window  PUOpens a new window 
packages
SQL*Plus and OCI for Instant Client, D.1Opens a new window
PAGE clause, 12Opens a new window
page number, including in titles, 6.2.4Opens a new window, 6.3.2Opens a new window
pages
changing length, 6.3.6Opens a new window, 8.5.8Opens a new window, 12Opens a new window, 12Opens a new window
default dimensions, 6.3.6Opens a new window
matching to screen or paper size, 6.3.6Opens a new window
setting dimensions, 6.3.6Opens a new window
PAGESIZE clause
in LOGIN.SQL, 2.2.2.1Opens a new window
PAGESIZE variable, 4.4Opens a new window, 6.3.6Opens a new window, 8.5.8Opens a new window, 12Opens a new window, 12Opens a new window
parameter, 5.10Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
SQLPATH, 2.1.1Opens a new window
parameter files (INIT.ORA files)
specifying alternate, 12Opens a new window
PARAMETERS clause, 12Opens a new window, 12Opens a new window
password
changing with the PASSWORD command, 12Opens a new window
in CONNECT command, 3.1Opens a new window, 12Opens a new window
in COPY command, B.2.1Opens a new window, B.2.2Opens a new window, B.3Opens a new window
in SQLPLUS command, 3.3.1Opens a new window, 3.5.2Opens a new window
viewable warning, 3.5.2Opens a new window
PASSWORD command, 12Opens a new window, 12Opens a new window
PATH
environment variables, 2.1Opens a new window
PAUSE command, 5.11.3Opens a new window, 12Opens a new window
PAUSE variable, 4.10Opens a new window, 12Opens a new window, 12Opens a new window
PDBS clause, 12Opens a new window
performance
of SQL statements, 8.1Opens a new window
over dial-up lines, 12Opens a new window
period (.)
terminating PL/SQL blocks, 4.5Opens a new window, 12Opens a new window, 12Opens a new window
PLAN_TABLE
creating, 8.1.1Opens a new window
table, 8.1.1Opens a new window
PL/SQL, 4.5Opens a new window
blocks, PL/SQL, 4.5Opens a new window
executing, 12Opens a new window
formatting output in SQL*Plus, 12Opens a new window
listing definitions, 4.3Opens a new window
mode in SQL*Plus, 4.5.1Opens a new window
within SQL commands, 4.5.1Opens a new window
PLUGGABLE DATABASE clause, 12Opens a new window
PLUSTRACE
creating role, 8.1.1Opens a new window
role, 8.1.1Opens a new window
PNO clause, 12Opens a new window
pound sign (#), 12Opens a new window
predefined variable
_CONNECT_IDENTIFIER, 2.2.2.1Opens a new window, 12Opens a new window, 12Opens a new window
_DATE, 12Opens a new window, 12Opens a new window
_EDITOR, 5.1.1Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
_O_RELEASE, 12Opens a new window, 12Opens a new window
_O_VERSION, 12Opens a new window, 12Opens a new window
_PRIVILEGE, 12Opens a new window, 12Opens a new window
_RC, 12Opens a new window
_SQLPLUS_RELEASE, 12Opens a new window, 12Opens a new window, 12Opens a new window
_USER, 12Opens a new window, 12Opens a new window
PREFORMAT, 3.5.1.5Opens a new window
PREFORMAT clause, 3.5.1.5Opens a new window
PRINT clause, 12Opens a new window
PRINT command, 12Opens a new window
printing
bind variables automatically, 12Opens a new window
REFCURSOR variables, 12Opens a new window
SPOOL command, 12Opens a new window
Product User Profile table, 9.1Opens a new window
prompt
SET SQLPROMPT, 8.5.10Opens a new window, 12Opens a new window, 12Opens a new window
PROMPT clause, 5.11.1Opens a new window, 12Opens a new window
PROMPT command, 5.11.1Opens a new window, 12Opens a new window
customizing prompts for value, 5.11.2Opens a new window
prompts for value
bypassing with parameters, 5.10Opens a new window
customizing, 5.11.2Opens a new window
through ACCEPT, 5.11.1Opens a new window
through substitution variables, 5.9.1Opens a new window
PUPBLD.SQL, 9.1.1Opens a new window
PURGE command
disabling, 9.2Opens a new window

Q

QUOpens a new window 
queries
in COPY command, B.1.1Opens a new window, B.2.1Opens a new window
show number of records retrieved, 4.4Opens a new window, 12Opens a new window, 12Opens a new window
tracing, 8.3Opens a new window, 8.4Opens a new window
query execution path
including in report, 12Opens a new window
query results
displaying on-screen, 4.4Opens a new window
sending to a printer, 6.4.3Opens a new window, 12Opens a new window
storing in a file, 6.4.2Opens a new window, 12Opens a new window
QUIT command, 12Opens a new window
See also EXIT

R

RAOpens a new window  REOpens a new window 
RAW
column definition from DESCRIBE, 12Opens a new window
record separators, printing, 6.1.7Opens a new window, 12Opens a new window, 12Opens a new window
RECOVER clause, 12Opens a new window
RECOVER command, 12Opens a new window
and database recovery, 10.4Opens a new window
AUTOMATIC clause, 12Opens a new window
CANCEL clause, 12Opens a new window, 12Opens a new window
CONTINUE clause, 12Opens a new window
DATABASE clause, 12Opens a new window
FROM clause, 12Opens a new window
LOGFILE clause, 12Opens a new window
NOPARALLEL clause, 12Opens a new window
SNAPSHOT TIME date clause, 12Opens a new window
STANDBY DATABASE clause, 12Opens a new window
STANDBY DATAFILE clause, 12Opens a new window
STANDBY TABLESPACE clause, 12Opens a new window, 12Opens a new window
UNTIL CANCEL clause, 12Opens a new window
UNTIL CONTROLFILE clause, 12Opens a new window
UNTIL TIME clause, 12Opens a new window
USING BACKUP CONTROL FILE clause, 12Opens a new window
recovery
RECOVER command, 12Opens a new window
RECSEP variable, 6.1.7Opens a new window, 12Opens a new window, 12Opens a new window
RECSEPCHAR variable, 6.1.7Opens a new window, 12Opens a new window, 12Opens a new window
REFCURSOR bind variables
in a stored function, 5.13Opens a new window
REFCURSOR clause
VARIABLE command, 12Opens a new window
registry
editor, 2.1.1Opens a new window
registry entry
SQLPATH, 2.1Opens a new window, 2.1.1Opens a new window
RELEASE clause, 12Opens a new window
REMARK command, 5.3.1Opens a new window, 12Opens a new window
removing sample tables, PrefaceOpens a new window
RENAME command
disabling, 9.2Opens a new window
REPFOOTER clause, 12Opens a new window
REPFOOTER command, 6.3.1Opens a new window, 12Opens a new window
aligning footer elements, 12Opens a new window
BOLD clause, 12Opens a new window
CENTER clause, 12Opens a new window
COL clause, 12Opens a new window
FORMAT clause, 12Opens a new window
indenting report footers, 12Opens a new window
LEFT clause, 12Opens a new window
OFF clause, 12Opens a new window
RIGHT clause, 12Opens a new window
SKIP clause, 12Opens a new window
suppressing current definition, 12Opens a new window
TAB clause, 12Opens a new window
REPHEADER clause, 12Opens a new window
REPHEADER command, 6.3.1Opens a new window, 12Opens a new window
aligning header elements, 6.3.1.1Opens a new window
aligning heading elements, 12Opens a new window
BOLD clause, 12Opens a new window
CENTER clause, 12Opens a new window
COL clause, 12Opens a new window
FORMAT clause, 12Opens a new window
indenting headings, 12Opens a new window
LEFT clause, 12Opens a new window
OFF clause, 12Opens a new window
PAGE clause, 12Opens a new window
RIGHT clause, 12Opens a new window
SKIP clause, 12Opens a new window
suppressing current definition, 12Opens a new window
TAB clause, 12Opens a new window
REPLACE clause
in COPY command, B.1.1Opens a new window, B.2.2Opens a new window
in SAVE command, 12Opens a new window, 12Opens a new window
reports
autotrace, 8.1.1Opens a new window
breaks, 12Opens a new window
clarifying with spacing and summary lines, 6.2Opens a new window
columns, 12Opens a new window
creating bottom titles, 6.3Opens a new window, 12Opens a new window, C.1Opens a new window, C.1Opens a new window
creating footers, 12Opens a new window
creating headers, 12Opens a new window
creating headers and footers, 6.3Opens a new window
creating master/detail, 6.3.4Opens a new window, 12Opens a new window, 12Opens a new window
creating top titles, 6.3Opens a new window, 12Opens a new window, C.1Opens a new window
displaying, 12Opens a new window, 12Opens a new window
formatting column headings, 6.1.1.2Opens a new window, 12Opens a new window
formatting columns, 6.1.2.1Opens a new window, 6.1.3.1Opens a new window, 12Opens a new window
interactive HTML example, 7.1.1Opens a new window, 7.1.1Opens a new window
on the web, 7.1Opens a new window
SILENT mode, 7.1.2Opens a new window
starting on a new page, 12Opens a new window
title, 12Opens a new window, C.1Opens a new window
RESTRICT, 3.5.1.8Opens a new window, 9.4Opens a new window, 12Opens a new window
return code, specifying, 5.6Opens a new window, 12Opens a new window, 12Opens a new window
input
accepting [Return], 5.11.3Opens a new window
REVOKE command, 9.1Opens a new window
disabling, 9.2Opens a new window
RIGHT clause, 6.3.1.1Opens a new window, 12Opens a new window, 12Opens a new window
roles, 9.3Opens a new window
disabling, 9.3.2Opens a new window
re-enabling, 9.3.2Opens a new window
ROLLBACK clause, 12Opens a new window
WHENEVER OSERROR, 12Opens a new window
WHENEVER SQLERROR, 12Opens a new window
ROLLBACK command
disabling, 9.2Opens a new window
ROWID
column definition from DESCRIBE, 12Opens a new window
rows
performing computations on, 6.2.6Opens a new window, 12Opens a new window
setting number retrieved at one time, 8.5.3Opens a new window, 12Opens a new window, 12Opens a new window
setting the number after which COPY commits, 12Opens a new window
RUN command, 12Opens a new window
executing current PL/SQL block, 4.5Opens a new window
making last line current, 5.2.2Opens a new window
similar to / (slash) command, 12Opens a new window

S

sample schemas, PrefaceOpens a new window, PrefaceOpens a new window, PrefaceOpens a new window, PrefaceOpens a new window, PrefaceOpens a new window
see Oracle Database Sample Schemas guide, PrefaceOpens a new window
using HR in COLUMN example, 12Opens a new window
using HR in examples, 5Opens a new window, 6Opens a new window
sample tables
access to, PrefaceOpens a new window
creating, PrefaceOpens a new window
removing, PrefaceOpens a new window
unlocking, PrefaceOpens a new window
SAVE command, 12Opens a new window
APPEND clause, 12Opens a new window
CREATE clause, 12Opens a new window
REPLACE clause, 12Opens a new window
storing commands in scripts, 12Opens a new window
using with INPUT to create scripts, 5.1.1Opens a new window
SAVEPOINT command
disabling, 9.2Opens a new window
saving environment attributes, 12Opens a new window
SCAN variable, C.1Opens a new window, C.11Opens a new window
schemas
command, 13.1Opens a new window
database, 8.1.1Opens a new window
DESCRIBE parameter, 12Opens a new window
disabled commands, 13.1Opens a new window
HR sample, PrefaceOpens a new window, PrefaceOpens a new window
installing own copy of HR, PrefaceOpens a new window
sample, PrefaceOpens a new window
SHOW parameter, 12Opens a new window, 12Opens a new window
unlocking HR, PrefaceOpens a new window
using HR in COLUMN example, 12Opens a new window
using HR in examples, 5Opens a new window, 6Opens a new window
SCREEN clause, 5.11.4Opens a new window, 12Opens a new window
screens
clearing, 5.11.4Opens a new window, 12Opens a new window
scripts
extension, 12Opens a new window, 12Opens a new window, 12Opens a new window
registering, 8.5.2Opens a new window
scripts, authenticating users in, 3.1.1Opens a new window
SECUREDCOL variable, 12Opens a new window
security
changing password, 12Opens a new window
nolongontime, 3.5.1.7Opens a new window
password viewable, 3.5.2Opens a new window
PRODUCT_USER_PROFILE table, 9.1Opens a new window
RESTRICT, 3.5.1.8Opens a new window, 9.4Opens a new window
SELECT command
and BREAK command, 6.2Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
and COLUMN command, 12Opens a new window
and COMPUTE command, 6.2Opens a new window
and COPY command, B.1.1Opens a new window, B.2.1Opens a new window
and DEFINE command, 12Opens a new window
and ORDER BY clause, 6.2Opens a new window
disabling, 9.2Opens a new window
formatting results, 5.13Opens a new window, 5.14Opens a new window
semicolon (;)
in PL/SQL blocks, 4.5Opens a new window
in SQL commands, 4.4Opens a new window, 4.4.1.2Opens a new window
in SQL*Plus commands, 4.6.1Opens a new window, 12Opens a new window
not stored in buffer, 5.2.1Opens a new window
SERVEROUTPUT variable, 12Opens a new window
service name
in COPY command, B.2.1Opens a new window, B.2.2Opens a new window, B.3Opens a new window
Session Editions, 12Opens a new window
SET AUTOTRACE, 8.1.1Opens a new window
SET clause, 12Opens a new window
SET command, 2.2.3Opens a new window, 4.7Opens a new window, 12Opens a new window
APPINFO variable, 8.5.2Opens a new window, 12Opens a new window
ARRAYSIZE variable, 8.5.3Opens a new window, 12Opens a new window, 12Opens a new window, B.2.3Opens a new window
AUTOCOMMIT variable, 12Opens a new window, 12Opens a new window
AUTOPRINT variable, 12Opens a new window, 12Opens a new window, 12Opens a new window
AUTORECOVERY variable, 12Opens a new window, 12Opens a new window, 12Opens a new window
AUTOTRACE variable, 12Opens a new window, 12Opens a new window
BLOCKTERMINATOR variable, 12Opens a new window, 12Opens a new window
BUFFER variable, C.6Opens a new window
CLOSECURSOR variable, C.1Opens a new window, C.8Opens a new window
CMDSEP variable, 12Opens a new window, 12Opens a new window
COLINVISIBLE variable, 12Opens a new window
COLSEP variable, 6.4.1Opens a new window, 12Opens a new window, 12Opens a new window
COMPATIBILITY variable, C.1Opens a new window, C.7Opens a new window
CONCAT variable, 5.9.4Opens a new window, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window
COPYCOMMIT variable, 12Opens a new window, 12Opens a new window, B.2.3Opens a new window
COPYTYPECHECK variable, 12Opens a new window, 12Opens a new window
DEFINE clause, 5.9.4Opens a new window
DEFINE variable, 12Opens a new window
DESCRIBE variable, 12Opens a new window, 12Opens a new window
DOCUMENT variable, C.1Opens a new window, C.9Opens a new window
ECHO variable, 12Opens a new window, 12Opens a new window
EDITFILE variable, 12Opens a new window, 12Opens a new window
EMBEDDED variable, 12Opens a new window, 12Opens a new window
ERRORLOGGING variable, 12Opens a new window
ESCAPE variable, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
ESCCHAR variable, 12Opens a new window
EXITCOMMIT variable, 12Opens a new window
FEEDBACK variable, 12Opens a new window, 12Opens a new window
FLAGGER variable, 12Opens a new window, 12Opens a new window
FLUSH variable, 8.5.5Opens a new window, 12Opens a new window, 12Opens a new window
HEADING variable, 12Opens a new window
HEADSEP variable, 6.1.1.2Opens a new window, 12Opens a new window, 12Opens a new window
INSTANCE variable, 12Opens a new window, 12Opens a new window
LINESIZE variable, 6.3.1.1Opens a new window, 6.3.6Opens a new window, 12Opens a new window, 12Opens a new window
LOBOFFSET variable, 12Opens a new window, 12Opens a new window
LOGSOURCE variable, 12Opens a new window, 12Opens a new window
LONG variable, 12Opens a new window, 12Opens a new window, B.2.3Opens a new window
LONGCHUNKSIZE variable, 12Opens a new window, 12Opens a new window
MARKUP clause, 12Opens a new window
MAXDATA variable, C.1Opens a new window, C.10Opens a new window
NEWPAGE variable, 6.3.6Opens a new window, 12Opens a new window, 12Opens a new window
NULL variable, 12Opens a new window, 12Opens a new window
NUMFORMAT clause, 2.2.2.1Opens a new window
NUMFORMAT variable, 12Opens a new window, 12Opens a new window
NUMWIDTH variable, 6.1.2.1Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
PAGESIZE clause, 2.2.2.1Opens a new window
PAGESIZE variable, 4.4Opens a new window, 6.3.6Opens a new window, 8.5.8Opens a new window, 12Opens a new window, 12Opens a new window
PAUSE variable, 12Opens a new window, 12Opens a new window
RECSEP variable, 6.1.7Opens a new window, 12Opens a new window, 12Opens a new window
RECSEPCHAR variable, 6.1.7Opens a new window, 12Opens a new window, 12Opens a new window
SCAN variable, C.1Opens a new window, C.11Opens a new window
SECUREDCOL variable, 12Opens a new window
SERVEROUTPUT variable, 12Opens a new window
SHIFTINOUT variable, 12Opens a new window, 12Opens a new window
SPACE variable, C.1Opens a new window, C.12Opens a new window
SQLBLANKLINES variable, 12Opens a new window
SQLCASE variable, 12Opens a new window, 12Opens a new window
SQLCONTINUE variable, 12Opens a new window, 12Opens a new window
SQLNUMBER variable, 12Opens a new window, 12Opens a new window
SQLPLUSCOMPATIBILITY variable, 12Opens a new window, 12Opens a new window
SQLPREFIX variable, 12Opens a new window, 12Opens a new window
SQLPROMPT variable, 8.5.10Opens a new window, 12Opens a new window, 12Opens a new window
SQLTERMINATOR variable, 12Opens a new window, 12Opens a new window
substitution variable, 12Opens a new window
SUFFIX variable, 12Opens a new window, 12Opens a new window
TAB variable, 8.5.11Opens a new window, 12Opens a new window, 12Opens a new window
TERMOUT variable, 8.5.12Opens a new window, 12Opens a new window, 12Opens a new window
TIME variable, 12Opens a new window, 12Opens a new window
TIMING variable, 12Opens a new window, 12Opens a new window
TRIMOUT variable, 12Opens a new window, 12Opens a new window
TRIMSPOOL variable, 12Opens a new window, 12Opens a new window
TRUNCATE variable, C.1Opens a new window, C.13Opens a new window
UNDERLINE variable, 12Opens a new window, 12Opens a new window
used to format a REFCURSOR variable, 12Opens a new window
VERIFY clause, 5.9.1Opens a new window
VERIFY variable, 5.9.4Opens a new window, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window
WRAP variable, 6.1.3.2Opens a new window, 12Opens a new window, 12Opens a new window
XMLOPTIMIZATIONCHECK variable, 12Opens a new window, 12Opens a new window
XQUERY BASEURI variable, 12Opens a new window
XQUERY CONTEXT variable, 12Opens a new window
XQUERY NODE variable, 12Opens a new window
XQUERY ORDERING variable, 12Opens a new window
SET CONSTRAINTS command
disabling, 9.2Opens a new window
SET MARKUP
BODY clause, 3.5.1.5Opens a new window
ENTMAP clause, 3.5.1.5Opens a new window, 7.1.3Opens a new window
HEAD clause, 3.5.1.5Opens a new window
HTML, 3.5.1.5Opens a new window
interactive HTML example, 7.1.1Opens a new window, 7.1.1Opens a new window
PREFORMAT clause, 3.5.1.5Opens a new window
TABLE clause, 3.5.1.5Opens a new window
SET ROLE command
disabling, 9.2Opens a new window
SET system variable summary, 12Opens a new window
SET TRANSACTION command
disabling, 9.2Opens a new window
SET variables, 4.7Opens a new window
See system variables
SET XQUERY BASEURI, 12Opens a new window
SET XQUERY CONTEXT, 12Opens a new window
SET XQUERY NODE, 12Opens a new window
SET XQUERY ORDERING, 12Opens a new window
SGA clause, 12Opens a new window
SHIFTINOUT variable, 12Opens a new window, 12Opens a new window
SHOW
schema parameter, 12Opens a new window, 12Opens a new window
SHOW clause, 12Opens a new window
SHOW command, 4.7Opens a new window, 12Opens a new window
ALL clause, 12Opens a new window
BTITLE clause, 12Opens a new window
CON_ID clause, 12Opens a new window
CON_NAME clause, 12Opens a new window
ERRORS clause, 12Opens a new window
LABEL variable, C.1Opens a new window
listing current page dimensions, 6.3.6Opens a new window
LNO clause, 12Opens a new window
PDBS clause, 12Opens a new window
PNO clause, 12Opens a new window
RELEASE clause, 12Opens a new window
REPFOOTER clause, 12Opens a new window
REPHEADER clause, 12Opens a new window
SPOOL clause, 12Opens a new window
SQLCODE clause, 12Opens a new window
TTITLE clause, 12Opens a new window
USER clause, 12Opens a new window
XQUERY clause, 12Opens a new window
SHOWMODE variable, 12Opens a new window, 12Opens a new window, 12Opens a new window
SHUTDOWN command, 12Opens a new window, 12Opens a new window
ABORT, 12Opens a new window
IMMEDIATE, 12Opens a new window
NORMAL, 12Opens a new window
TRANSACTIONAL LOCAL, 12Opens a new window
-SILENT option, 3.5.1.9Opens a new window, 7.1.2Opens a new window
site profile
glogin, 2.2Opens a new window, 2.2.1Opens a new window, 2.2.2.1Opens a new window, 3.5.1.8Opens a new window, 12Opens a new window, 12Opens a new window
SKIP clause
in BREAK command, 6.2.2Opens a new window, 6.2.3Opens a new window, 12Opens a new window
in REPHEADER and REPFOOTER commands, 12Opens a new window
in TTITLE and BTITLE commands, 6.3.1.1Opens a new window, 12Opens a new window
used to place blank lines before bottom title, 6.3.1.1Opens a new window
SKIP PAGE clause, 6.2.2Opens a new window, 6.2.3Opens a new window, 12Opens a new window
slash (/) command, 12Opens a new window
files loaded with GET command, 12Opens a new window
SPACE variable, C.1Opens a new window, C.12Opens a new window
SPOOL clause, 3.5.1.5Opens a new window, 12Opens a new window
SPOOL command, 6.3.6Opens a new window, 12Opens a new window
APPEND clause, 12Opens a new window
CREATE clause, 12Opens a new window
file name, 6.4.2Opens a new window, 12Opens a new window
OFF clause, 6.4Opens a new window, 12Opens a new window
OUT clause, 6.4.3Opens a new window, 12Opens a new window
REPLACE clause, 12Opens a new window
to HTML file, 3.5.1.5Opens a new window
turning spooling off, 6.4Opens a new window, 12Opens a new window
use with SET MARKUP, 7.1.1Opens a new window
SQL clause, 12Opens a new window
SQL DML statements
reporting on, 12Opens a new window, 12Opens a new window
SQL optimizer, 8.1.2Opens a new window
SQL*Plus
command prompt, 3.3.1Opens a new window
command summary, 12Opens a new window
configuring globalization support, 11.1Opens a new window
configuring Oracle Net, 2.2.5Opens a new window
database administration, 10.1Opens a new window
environment variables, 2.1Opens a new window
error messages, 13.1Opens a new window
execution plan, 8.1.2Opens a new window
exiting, 3.4Opens a new window, 12Opens a new window, 12Opens a new window
limits, AOpens a new window
obsolete command alternatives, C.1Opens a new window
setting up environment, 2.2Opens a new window
starting, 3.3Opens a new window, 3.3.1Opens a new window, 3.5Opens a new window
statistics, 8.1.3Opens a new window
system variables affecting performance, 8.5Opens a new window
tuning, 8.1Opens a new window
who can use, PrefaceOpens a new window
SQL*Plus and OCI packages, D.1Opens a new window
SQL*Plus command-line vs SQL*Plus Instant Client, DOpens a new window
SQL*Plus Instant Client, DOpens a new window, DOpens a new window, D.1Opens a new window, D.1Opens a new window, D.2Opens a new window, D.2.1Opens a new window, D.2.2Opens a new window, D.3Opens a new window, D.3.1Opens a new window, D.3.2Opens a new window
basic, D.1.1Opens a new window
installation, DOpens a new window
lightweight, D.1.2Opens a new window
NLS_LANG, D.1.2Opens a new window
NLS_LANG charset parameter, D.1.2Opens a new window
NLS_LANG language parameter, D.1.2Opens a new window
NLS_LANG territory parameter, D.1.2Opens a new window
required files in packages, D.2.3Opens a new window
unsupported charset error, D.1.2.1Opens a new window
SQLBLANKLINES variable, 12Opens a new window, 12Opens a new window
SQLCASE variable, 12Opens a new window, 12Opens a new window
SQLCODE clause, 12Opens a new window
SHOW command, 12Opens a new window
SQLCONTINUE variable, 12Opens a new window, 12Opens a new window
SQL.PNO, referencing in report titles, 6.3.2Opens a new window
SQL.SQLCODE
using in EXIT command, 12Opens a new window
SQLNUMBER variable, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
SQLPATH
environment variables, 2.1Opens a new window
registry entry, 2.1Opens a new window, 2.1.1Opens a new window
SQLPLUS command, 3.3.1Opens a new window
- clause, 3.5.1.1Opens a new window
-? clause, 3.5.1.2Opens a new window
and @ (at sign), 3.5Opens a new window
and EXIT FAILURE, 3.4Opens a new window
Application Editions, 3.5.2Opens a new window
BODY option, 3.5.1.5Opens a new window
commands
SQLPLUS, 3.5Opens a new window
connect identifier, 3.5.2Opens a new window
display syntax, 3.5.1.1Opens a new window
edition, 3.5.2Opens a new window
ENTMAP option, 3.5.1.5Opens a new window
HEAD option, 3.5.1.5Opens a new window
HTML option, 3.5.1.5Opens a new window
-MARKUP clause, 3.5.1.5Opens a new window
-MARKUP option, 3.5.1.5Opens a new window
/NOLOG clause, 3.5.2Opens a new window
nolongontime, 3.5.1.7Opens a new window
PREFORMAT option, 3.5.1.5Opens a new window
RESTRICT, 3.5.1.8Opens a new window, 9.4Opens a new window
service name, 3.5.2Opens a new window
-SILENT clause, 3.5.1.9Opens a new window
-SILENT option, 3.5.1.9Opens a new window, 7.1.2Opens a new window
SPOOL clause, 3.5.1.5Opens a new window
syntax, 3.5Opens a new window
SYSASM clause, 3.5.2Opens a new window
SYSBACKUP clause, 3.5.2Opens a new window
SYSDBA clause, 3.5.2Opens a new window, 3.5.2Opens a new window
SYSDG clause, 3.5.2Opens a new window
SYSKM clause, 3.5.2Opens a new window
SYSOPER clause, 3.5.2Opens a new window
TABLE option, 3.5.1.5Opens a new window
unsuccessful connection, 3.4Opens a new window
username/password, 3.3.1Opens a new window, 3.5.2Opens a new window
SQLPREFIX variable, 12Opens a new window, 12Opens a new window
SQLPROMPT variable, 8.5.10Opens a new window, 12Opens a new window, 12Opens a new window
SQLTERMINATOR variable, 12Opens a new window, 12Opens a new window, 12Opens a new window, 12Opens a new window
STANDBY DATAFILE clause, 12Opens a new window
STANDBY TABLESPACE clause, 12Opens a new window
START clause, 12Opens a new window
START command, 5.4Opens a new window, 12Opens a new window
arguments, 5.10Opens a new window
passing parameters to a script, 5.10Opens a new window
script, 5.4Opens a new window, 12Opens a new window
similar to @ (at sign) command, 5.4Opens a new window, 12Opens a new window, 12Opens a new window
similar to @@ (double at sign) command, 12Opens a new window
starting
SQL*Plus, 1.1Opens a new window, 3.3Opens a new window, 3.3.1Opens a new window
STARTUP command, 12Opens a new window
DOWNGRADE clause, 12Opens a new window
FORCE clause, 12Opens a new window
MOUNT clause, 12Opens a new window
NOMOUNT clause, 12Opens a new window
OPEN clause, 12Opens a new window
PFILE clause, 12Opens a new window
PLUGGABLE DATABASE clause, 12Opens a new window
RECOVER clause, 12Opens a new window
RESTRICT clause, 12Opens a new window
specifying a database, 12Opens a new window
UPGRADE clause, 12Opens a new window
statistics, 8.1.3Opens a new window
collecting TIMING statistics, 8.2Opens a new window
STOP clause, 12Opens a new window
stop query, 4.8Opens a new window
STORE command, 2.2.3Opens a new window, 12Opens a new window
SET clause, 12Opens a new window
stored functions, 5.13Opens a new window
stored procedures
creating, 4.5.1Opens a new window
subkey, registry, 2.1.1Opens a new window
substitution variables, 5.7Opens a new window, 5.9Opens a new window, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window
_EDITOR, 12Opens a new window
appending characters immediately after, 5.9.1Opens a new window
avoiding unnecessary prompts for value, 5.9.2Opens a new window
concatenation character, 12Opens a new window, 12Opens a new window
DEFINE command, 12Opens a new window
defining, 5.7Opens a new window, 5.9.2Opens a new window, 12Opens a new window
deleting, 5.7Opens a new window, 12Opens a new window
displaying in headers and footers, 12Opens a new window
displaying in titles, 12Opens a new window
in ACCEPT command, 5.11.1Opens a new window, 12Opens a new window
listing definitions, 5.7Opens a new window, 5.7Opens a new window, 12Opens a new window, 12Opens a new window
parsing, 8.5.4Opens a new window
prefixing, 12Opens a new window, C.1Opens a new window
related system variables, 5.9.4Opens a new window
restrictions, 5.9.3Opens a new window
single and double ampersands, 5.9.2Opens a new window
system variables used with, 5.9.4Opens a new window
undefined, 5.9.1Opens a new window
where and how to use, 5.9.1Opens a new window
SUFFIX variable, 12Opens a new window, 12Opens a new window
used with EDIT command, 12Opens a new window
used with GET command, 12Opens a new window
used with SAVE command, 12Opens a new window
used with START command, 12Opens a new window
SUM function, 6.2.6Opens a new window
summary lines
computing and printing, 6.2.6Opens a new window, 12Opens a new window
computing and printing at ends of reports, 6.2.7Opens a new window
computing same type on different columns, 6.2.8Opens a new window
printing grand and sub summaries (totals), 6.2.7Opens a new window
printing multiple on same break column, 6.2.8Opens a new window
syntax
COPY command, B.2.1Opens a new window
syntax rules
SQL commands, 4.4.1Opens a new window
SQL*Plus commands, 4.6.1Opens a new window
SYSASM clause, 3.5.2Opens a new window, 12Opens a new window
SYSBACKUP clause, 3.5.2Opens a new window, 12Opens a new window
SYSDBA clause, 3.5.2Opens a new window, 3.5.2Opens a new window, 12Opens a new window, 12Opens a new window
SYSDG clause, 3.5.2Opens a new window, 12Opens a new window
SYSKM clause, 3.5.2Opens a new window, 12Opens a new window
SYSOPER clause, 3.5.2Opens a new window, 12Opens a new window
system variables, 4.7Opens a new window, 12Opens a new window
affecting SQL*Plus performance, 8.5Opens a new window
affecting substitution variables, 5.9.4Opens a new window
listing current settings, 4.7Opens a new window, 12Opens a new window
listing old and new values, 12Opens a new window, 12Opens a new window
storing and restoring, 2.2.3Opens a new window
summary of SET commands, 12Opens a new window
system-maintained values
displaying in headers and footers, 12Opens a new window
displaying in titles, 6.3.2Opens a new window, 12Opens a new window
formatting in titles, 6.3.2Opens a new window

T

TAB clause, 12Opens a new window, 12Opens a new window
TAB variable, 8.5.11Opens a new window, 12Opens a new window, 12Opens a new window
TABLE clause, 3.5.1.5Opens a new window
TABLE option, 3.5.1.5Opens a new window
tables
access to sample, PrefaceOpens a new window
controlling destination when copying, B.1.1Opens a new window, B.2.2Opens a new window
copying values between, B.2Opens a new window, B.3Opens a new window
listing column definitions, 4.2Opens a new window, 12Opens a new window
referring to another user’s when copying, B.2.4Opens a new window
TABLESPACE clause, 12Opens a new window
tablespaces, recovering, 12Opens a new window
tag, HTML, 7.1Opens a new window
TERMOUT variable, 8.5.12Opens a new window, 12Opens a new window, 12Opens a new window
using with SPOOL command, 12Opens a new window
territory
SQL*Plus Instant Client, D.1.2Opens a new window
text, 3.5.1.5Opens a new window, 3.5.1.5Opens a new window
adding to current line with APPEND, 5.2.3Opens a new window, 12Opens a new window
changing old to new with CHANGE, 5.2.2Opens a new window, 12Opens a new window
clearing from buffer, 5.2Opens a new window, 12Opens a new window
text editor
operating system, 5.1.1Opens a new window, 12Opens a new window
TIME variable, 12Opens a new window, 12Opens a new window
TIMING clause, 12Opens a new window
TIMING command, 8.2Opens a new window, 12Opens a new window
deleting all areas created by, 12Opens a new window
deleting current area, 12Opens a new window
SHOW clause, 12Opens a new window
START clause, 12Opens a new window
STOP clause, 12Opens a new window
TIMING variable, 12Opens a new window, 12Opens a new window
titles
aligning elements, 6.3.1.1Opens a new window, 12Opens a new window
displaying at bottom of page, 6.3Opens a new window, 12Opens a new window, C.1Opens a new window, C.1Opens a new window
displaying at top of page, 6.3Opens a new window, 12Opens a new window, C.1Opens a new window
displaying column values, 6.3.4Opens a new window, 12Opens a new window, 12Opens a new window
displaying current date, 6.3.5Opens a new window, 12Opens a new window, 12Opens a new window
displaying page number, 6.3.2Opens a new window, 12Opens a new window
displaying system-maintained values, 6.3.2Opens a new window, 12Opens a new window
formatting elements, 12Opens a new window
formatting system-maintained values in, 6.3.2Opens a new window
indenting, 6.3.1.2Opens a new window, 12Opens a new window
listing current definition, 6.3.3Opens a new window, 12Opens a new window, 12Opens a new window
restoring definition, 6.3.3Opens a new window
setting at start or end of report, 6.3Opens a new window
setting lines from top of page to top title, 6.3.6Opens a new window, 12Opens a new window, 12Opens a new window, C.1Opens a new window
setting lines from top title to end of page, 8.5.8Opens a new window, 12Opens a new window, 12Opens a new window
setting top and bottom, 6.3Opens a new window, 12Opens a new window, 12Opens a new window, C.1Opens a new window, C.1Opens a new window, C.1Opens a new window
spacing between last row and bottom title, 6.3.1.1Opens a new window
suppressing definition, 6.3.3Opens a new window, 12Opens a new window
TNS_ADMIN
environment variables, 2.1Opens a new window
TO clause, B.2.1Opens a new window
tracing queries, 8.3Opens a new window, 8.4Opens a new window
tracing statements
for performance statistics, 8.1.3Opens a new window
for query execution path, 8.1.3Opens a new window
with parallel query option, 8.3Opens a new window
TRIMOUT variable, 12Opens a new window, 12Opens a new window
TRIMSPOOL variable, 12Opens a new window, 12Opens a new window
TRUNCATE command
disabling, 9.2Opens a new window
TRUNCATE variable, C.1Opens a new window, C.13Opens a new window
TRUNCATED clause, 6.1.3.2Opens a new window, 12Opens a new window
TTITLE clause, 12Opens a new window
TTITLE command, 6.3.1Opens a new window, 12Opens a new window
aligning title elements, 6.3.1.1Opens a new window, 12Opens a new window
BOLD clause, 12Opens a new window
CENTER clause, 6.3.1.1Opens a new window, 12Opens a new window
COL clause, 6.3.1.2Opens a new window, 12Opens a new window
FORMAT clause, 6.3.2Opens a new window, 12Opens a new window
indenting titles, 6.3.1.2Opens a new window, 12Opens a new window
LEFT clause, 6.3.1.1Opens a new window, 12Opens a new window
listing current definition, 6.3.3Opens a new window, 12Opens a new window
OFF clause, 6.3.3Opens a new window, 12Opens a new window
old form, C.14Opens a new window
ON clause, 6.3.3Opens a new window
referencing column value variable, 6.3.4Opens a new window, 12Opens a new window
restoring current definition, 6.3.3Opens a new window
RIGHT clause, 6.3.1.1Opens a new window, 12Opens a new window
SKIP clause, 6.3.1.1Opens a new window, 12Opens a new window
suppressing current definition, 6.3.3Opens a new window, 12Opens a new window
TAB clause, 12Opens a new window
tuning
SET APPINFO OFF, 8.5.2Opens a new window
SET ARRAYSIZE, 8.5.3Opens a new window
SET DEFINE OFF, 8.5.4Opens a new window
SET FLUSH OFF, 8.5.5Opens a new window
SET TRIMOUT ON, 8.5.13Opens a new window
SET TRIMSPOOL ON, 8.5.13Opens a new window
SQL*Plus, 8.1Opens a new window
system variables, 8.5Opens a new window
TWO_TASK
environment variables, 2.1Opens a new window

U

UNDEFINE command, 5.7Opens a new window, 12Opens a new window
and DEFINE command, 12Opens a new window
UNDERLINE variable, 12Opens a new window, 12Opens a new window
unicode
UNIX
ed, 12Opens a new window
installing SQL*Plus Instant Client, D.2.2Opens a new window
SQL*Plus Instant Client files to copy, D.3.1Opens a new window
unlocking sample tables, PrefaceOpens a new window
UNTIL CANCEL clause, 12Opens a new window
UNTIL CHANGE clause, 12Opens a new window
UNTIL CONTROLFILE clause, 12Opens a new window
UNTIL TIME clause, 12Opens a new window
UPDATE command, disabling, 9.2Opens a new window
USER clause, 12Opens a new window
user profile, 2.2.2Opens a new window
glogin.sql, 2.2.2Opens a new window
login.sql, 2.2.2Opens a new window, 2.2.2.1Opens a new window
See also site profile
user variable
See substitution variable
username, 3.1Opens a new window
connecting under different, 3.1Opens a new window, 12Opens a new window
in CONNECT command, 3.1Opens a new window, 12Opens a new window
in COPY command, B.2.1Opens a new window, B.2.2Opens a new window, B.3Opens a new window
in SQLPLUS command, 3.3.1Opens a new window, 3.5.2Opens a new window
USING BACKUP CONTROL FILE clause, 12Opens a new window
USING clause, B.1.1Opens a new window, B.2.1Opens a new window
UTF-8

V

V$SESSION virtual table, 12Opens a new window
V$SQLAREA virtual table, 12Opens a new window
VALIDATE command
disabling, 9.2Opens a new window
VARCHAR columns
default format, 6.1.3.1Opens a new window
VARCHAR2
column definition from DESCRIBE, 12Opens a new window
VARCHAR2 clause
VARIABLE command, 12Opens a new window
VARCHAR2 columns
changing format, 12Opens a new window
default format, 6.1.3.1Opens a new window
VARIABLE command, 12Opens a new window
BFILE clause, 12Opens a new window
BINARY_DOUBLE clause, 12Opens a new window
BINARY_FLOAT clause, 12Opens a new window
BLOB clause, 12Opens a new window
CHAR clause, 12Opens a new window
CLOB clause, 12Opens a new window
NCHAR clause, 12Opens a new window
NCLOB clause, 12Opens a new window
NUMBER clause, 12Opens a new window
REFCURSOR clause, 12Opens a new window
VARCHAR2 clause, 12Opens a new window
variable clause, 12Opens a new window
variables
bind variables, 5.12Opens a new window
substitution variables, 12Opens a new window
system variables, 4.7Opens a new window
VERIFY clause, 5.9.1Opens a new window
VERIFY variable, 5.9.4Opens a new window, 5.9.4Opens a new window, 12Opens a new window, 12Opens a new window

W

WARNING clause, 12Opens a new window
web browser, 7.1.1Opens a new window
web, outputting reports, 7.1Opens a new window
WHENEVER OSERROR command, 12Opens a new window
COMMIT clause, 12Opens a new window
CONTINUE clause, 12Opens a new window
EXIT clause, 12Opens a new window
NONE clause, 12Opens a new window
ROLLBACK clause, 12Opens a new window
WHENEVER SQLERROR command, 12Opens a new window
COMMIT clause, 12Opens a new window
CONTINUE clause, 12Opens a new window
EXIT clause, 12Opens a new window
NONE clause, 12Opens a new window
ROLLBACK clause, 12Opens a new window
Windows
installing SQL*Plus Instant Client, D.2.2Opens a new window
notepad, 12Opens a new window
SQL*Plus Instant Client files to copy, D.3.2Opens a new window
WORD_WRAPPED clause, 6.1.3.2Opens a new window, 6.1.7Opens a new window, 12Opens a new window
WRAP variable, 6.1.3.2Opens a new window, 12Opens a new window, 12Opens a new window
WRAPPED clause, 6.1.3.2Opens a new window, 12Opens a new window, 12Opens a new window

X

XMLOPTIMIZATIONCHECK variable, 12Opens a new window, 12Opens a new window
XMLType
column definition from DESCRIBE, 12Opens a new window
column formatting, 6.1.3.2Opens a new window
column width, 6.1.3.1Opens a new window
creating, 6.1.3.2Opens a new window
formatting in reports, 6.1.3Opens a new window
inserting values, 6.1.3.2Opens a new window
selecting data, 6.1.3.2Opens a new window
setting column retrieval size, 8.5.7Opens a new window, 12Opens a new window
setting maximum column width, 12Opens a new window
XQUERY clause, 12Opens a new window
XQUERY command, 12Opens a new window
XQUERY options
BASEURI, 12Opens a new window
CONTEXT, 12Opens a new window
NODE, 12Opens a new window
ORDERING, 12Opens a new window
Previous PageOpens a new window
Page 82 of 82
Next Page