Library
Product
Contents
Index
Index
@
@
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
@
# Pound sign
$, number format
& (ampersand), substitution variables
* (asterisk), in DEL command
[
2
]
in LIST command
[
2
]
- (hyphen) clause
- (hyphen), continuing a long SQL*Plus command
[
2
]
-- (comment delimiter)
-? clause
-SILENT clause
-~ Negative infinity sign
. (period)
/ (slash) command
entered at buffer line-number prompt
[
2
]
entered at command prompt
[
2
]
executing current PL/SQL block
executing current SQL command
similar to RUN
[
2
] [
3
]
/ (slash), default logon
[
2
]
/*...*/ (comment delimiters)
/NOLOG option
0, number format
9, number format
: (colon), bind variables
:BindVariable clause, EXIT command
; (semicolon)
@ ("at" sign) command
[
2
] [
3
]
arguments
command file
[
2
]
passing parameters to a command file
similar to START
[
2
] [
3
]
@ ("at" sign), in CONNECT command
[
2
]
in COPY command
[
2
]
in SQLPLUS command
[
2
] [
3
]
@@ (double "at" sign) command
[
2
]
command file
similar to START
[
2
]
[Backspace] key
[Cancel] key
[
2
]
[Interrupt] key
[Pause] key
[
2
]
[Resume] key
[Return] key
_EDITOR, in EDIT command
[
2
]
ACCEPT command
[
2
]
and DEFINE command
CHAR clause
customizing prompts for value
DATE clause
DEFAULT clause
FORMAT clause
HIDE clause
NOPROMPT clause
NUMBER clause
PROMPT clause
[
2
]
Access, denying and granting
ALIAS clause
in ATTRIBUTE command
ALL clause
ALTER command, disabling
Ampersands (&), in parameters
[
2
] [
3
]
substitution variables
ANALYZE command, disabling
APPEND clause, in COPY command
[
2
]
in SAVE command
[
2
]
APPEND command
[
2
] [
3
]
APPINFO variable
Arguments, in START command
[
2
]
ARRAYSIZE variable
relationship to COPY command
[
2
]
ATTRIBUTE command
ALIAS clause
and CLEAR COLUMN command
CLEAR clause
clearing columns
[
2
]
controlling an attribute's display charcteristics
entering multiple
FORMAT clause
LIKE clause
listing all attributes' display characteristics
listing an attribute's display characteristics
OFF clause
ON clause
restoring column display attributes
suppressing column display attributes
Attribute, display characteristics
AUDIT command, disabling
AUTOCOMMIT variable
[
2
]
AUTOPRINT variable
AUTOTRACE variable
[
2
]
AVG function
B
Batch mode
[
2
]
BEGIN command
disabling
Bind variables
creating
displaying
displaying automatically
[
2
]
in PL/SQL blocks
in SQL statements
in the COPY command
REFCURSOR
Blank line
in PL/SQL blocks
in SQL commands
Blocks, PL/SQL
continuing
editing in buffer
editing with host system editor
[
2
]
entering and executing
listing current in buffer
run from SQL buffer
saving current
[
2
]
setting character used to end
stored in SQL buffer
storing in command files
timing statistics
within SQL commands
BLOCKTERMINATOR variable
BOLD clause
[
2
]
Break columns
[
2
]
inserting space when value changes
specifying multiple
suppressing duplicate values in
BREAK command
[
2
]
and SQL ORDER BY clause
[
2
] [
3
] [
4
]
clearing BREAKS
displaying column values in titles
DUPLICATES clause
inserting space after every row
inserting space when break column changes
listing current break definition
[
2
]
NODUPLICATES clause
ON column clause
[
2
]
ON expr clause
ON REPORT clause
[
2
]
ON ROW clause
[
2
]
printing "grand" and "sub" summaries
printing summary lines at ends of reports
removing definition
SKIP clause
[
2
]
SKIP PAGE clause
[
2
] [
3
] [
4
]
specifying multiple break columns
[
2
]
storing current date in variable for titles
suppressing duplicate values
[
2
]
used in conjunction with SET COLSEP
used in conjunction with COMPUTE
[
2
] [
3
] [
4
] [
5
] [
6
]
used to format a REFCURSOR variable
Break definition, listing current
[
2
]
removing current
[
2
]
BREAKS clause
[
2
]
BTITLE clause
BTITLE command
[
2
]
aligning title elements
BOLD clause
CENTER clause
COL clause
FORMAT clause
indenting titles
LEFT clause
most often used clauses
OFF clause
old form
ON clause
printing blank lines before bottom title
referencing column value variable
restoring current definition
RIGHT clause
SKIP clause
suppressing current definition
TAB clause
TTITLE command
Buffer
BUFFER clause
[
2
] [
3
]
BUFFER variable
Buffer, appending text to a line in
[
2
]
delete a single line
delete the current line
delete the last line
deleting a range of lines
[
2
]
deleting a single line
deleting all lines
[
2
] [
3
]
deleting lines from
[
2
]
deleting the current line
deleting the last line
executing contents
[
2
] [
3
]
inserting new line in
[
2
]
listing a range of lines
[
2
]
listing a single line
[
2
]
listing all lines
[
2
]
listing contents
[
2
]
listing the current line
[
2
]
listing the last line
[
2
]
loading contents into host system editor
[
2
]
saving contents
[
2
]
C
CENTER clause
[
2
] [
3
] [
4
]
CHANGE command
[
2
] [
3
]
CHAR clause
VARIABLE command
CHAR columns, changing format
[
2
]
default format
[
2
]
CLEAR clause
[
2
]
in ATTRIBUTE command
CLEAR command
BREAKS clause
[
2
]
BUFFER clause
[
2
] [
3
]
COLUMNS clause
[
2
]
COMPUTES clause
[
2
]
SCREEN clause
[
2
]
SQL clause
TIMING clause
CLOB clause, VARIABLE command
CLOB columns, changing format
[
2
]
default format
[
2
]
setting maximum width
setting retrieval position
setting retrieval size
CMDSEP variable
COL clause
[
2
] [
3
] [
4
]
Colons (:), bind variables
COLSEP variable
COLUMN command
[
2
]
ALIAS clause
and BREAK command
and DEFINE command
CLEAR clause
[
2
]
DEFAULT clause
displaying column values in bottom titles
[
2
]
displaying column values in top titles
[
2
]
entering multiple
FOLD_AFTER clause
FOLD_BEFORE clause
FORMAT clause
[
2
] [
3
]
formatting columns
formatting NUMBER columns
[
2
]
HEADING clause
[
2
]
HEADSEP character
JUSTIFY clause
LIKE clause
[
2
]
listing a column's display attributes
[
2
]
listing all columns' display attributes
[
2
]
NEW_VALUE clause
[
2
] [
3
]
NEWLINE clause
NOPRINT clause
[
2
]
NULL clause
OFF clause
[
2
]
OLD_VALUE clause
[
2
]
ON clause
[
2
]
PRINT clause
resetting a column to default display
[
2
]
restoring column display attributes
[
2
]
storing current date in variable for titles
[
2
]
suppressing column display attributes
[
2
]
TRUNCATED clause
[
2
]
used to format a REFCURSOR variable
WORD_WRAPPED clause
[
2
] [
3
]
WRAPPED clause
[
2
]
Column headings
aligning
changing
[
2
]
changing character used to underline
[
2
]
changing to two or more words
[
2
]
displaying on more than one line
[
2
]
suppressing printing in a report
when truncated
when truncated for CHAR and LONG columns
when truncated for DATE columns
when truncated for NUMBER columns
Column separator
COLUMNS clause
[
2
]
Columns
assigning aliases
computing summary lines
[
2
]
copying display attributes
[
2
] [
3
]
copying values between tables
[
2
] [
3
]
displaying values in bottom titles
[
2
]
displaying values in top titles
[
2
]
formatting CHAR, LONG, and DATE
formatting CHAR, VARCHAR, LONG, and DATE
formatting in reports
[
2
]
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL
formatting NUMBER
[
2
]
listing display attributes for all
[
2
]
listing display attributes for one
[
2
]
names in destination table when copying
[
2
]
printing line after values that overflow
[
2
]
resetting a column to default display
[
2
]
resetting all columns to default display
[
2
]
restoring display attributes
[
2
] [
3
]
setting printing to off or on
[
2
]
specifying values to be computed
starting new lines
storing values in variables
[
2
]
suppressing display attributes
[
2
] [
3
]
truncating display for all when value overflows
[
2
]
truncating display for one when value overflows
[
2
]
wrapping display for all when value overflows
[
2
]
wrapping display for one when value overflows
[
2
]
wrapping whole words for one
Comma, number format
Command file extension
[
2
] [
3
]
Command files
aborting and exiting with a return code
[
2
] [
3
]
allowing end-user input
creating with a system editor
creating with INPUT and SAVE
creating with SAVE
[
2
]
editing with GET and SAVE
editing with host system editor
[
2
]
in @ ("at" sign) command
[
2
]
in @@ (double "at" sign) command
in EDIT command
[
2
]
in GET command
[
2
]
in SAVE command
[
2
] [
3
]
in SQLPLUS command
[
2
]
in START command
[
2
]
including comments in
[
2
]
including more than one PL/SQL block
[
2
]
including more than one SQL command
[
2
]
listing names with HOST command
nesting
passing parameters to
[
2
] [
3
]
registering
retrieving
[
2
]
running
[
2
] [
3
]
running a series in sequence
running as you start SQL*Plus
[
2
]
running in batch mode
[
2
]
running nested
saving contents of buffer in
[
2
]
Command prompt
host operating system
SQL*Plus
Commands
case
collecting timing statistics on
[
2
]
disabling
host operating system, running from SQL*Plus
[
2
]
listing current in buffer
re-enabling
spaces
SQL*Plus
command summary
continuing on additional lines
[
2
]
editing at command prompt
ending
[
2
]
entering and executing
entering during SQL command entry
SQL
editing in buffer
editing with host system editor
[
2
]
ending
entering and executing
entering without executing
executing current
[
2
] [
3
]
following syntax
list of major
listing current in buffer
saving current
[
2
]
setting character used to end and run
stopping while running
storing in command files
syntax conventions
tabs
types of
variables that affect running
writing interactive
Comments, including in command files
[
2
]
using -- to create
using /*...*/ to create
using REMARK to create
[
2
]
COMMIT clause
WHENEVER OSERROR
WHENEVER SQLERROR
COMMIT command
COMPATIBILITY variable
in LOGIN.SQL
COMPUTE command
[
2
]
AVG function
computing a summary on different columns
COUNT function
LABEL clause
[
2
] [
3
]
listing all definitions
[
2
]
MAXIMUM function
maximum LABEL length
MINIMUM function
NUMBER function
OF clause
[
2
]
ON column clause
[
2
]
ON expr clause
ON REPORT clause
[
2
]
ON ROW clause
printing "grand" and "sub" summaries
printing multiple summaries on same column
printing summary lines at ends of reports
printing summary lines on a break
[
2
]
referencing a SELECT expression in OF
referencing a SELECT expression in ON
removing definitions
[
2
]
STD function
SUM function
used to format a REFCURSOR variable
VARIANCE function
COMPUTES clause
[
2
]
CONCAT variable
[
2
] [
3
]
CONNECT command (SQL), disabling
CONNECT command (SQL*Plus)
[
2
] [
3
]
and @ ("at" sign)
[
2
]
changing password
[
2
]
database specification
username/password
[
2
] [
3
] [
4
]
CONNECT command, changing password
CONTINUE clause
WHENEVER OSERROR
WHENEVER SQLERROR
Continuing a long SQL*Plus command
[
2
]
Conventions, command syntax
COPY command
[
2
]
and @ ("at" sign)
[
2
]
and ARRAYSIZE variable
[
2
]
and COPYCOMMIT variable
[
2
]
and LONG variable
[
2
]
APPEND clause
[
2
]
copying data between databases
copying data between tables on one database
CREATE clause
[
2
]
creating a table
[
2
] [
3
]
database specification
[
2
] [
3
]
destination table
[
2
]
determining actions
determining source rows and columns
[
2
]
disabling
error messages
FROM clause
[
2
]
INSERT clause
[
2
]
inserting data in a table
[
2
] [
3
]
interpreting messages
mandatory database specification
naming the source table with SELECT
[
2
]
query
[
2
]
referring to another user's table
REPLACE clause
[
2
]
replacing data in a table
[
2
]
sample command
[
2
]
specifying column names for destination
[
2
]
specifying the data to copy
[
2
]
TO clause
[
2
]
username/password
[
2
] [
3
] [
4
] [
5
]
USING clause
[
2
]
when a commit is performed
COPYCOMMIT variable
relationship to COPY command
[
2
]
COPYTYPECHECK variable
COUNT function
CREATE clause, in COPY command
[
2
]
in SAVE command
CREATE command
disabling
entering PL/SQL
Creating flat files
Creating the PRODUCT_USER_PROFILE table
Cursor Variables
D
Database administrator
Database changes, saving automatically
[
2
]
Database link names, in DESCRIBE command
Database specifications
in CONNECT command
in COPY command
[
2
] [
3
]
in SQLPLUS command
[
2
]
Databases, connecting to default
[
2
]
connecting to remote
[
2
]
copying data between
[
2
]
copying data between tables on a single
disconnecting without leaving SQL*Plus
[
2
]
DATE clause
DATE columns, changing format
[
2
] [
3
]
default format
Date, storing current in variable for titles
[
2
] [
3
]
DB2
CHAR
DATE
DBMS_APPLICATION_INFO package
DECLARE command (PL/SQL)
DECLARE command, disabling
DEFAULT clause
[
2
]
DEFINE command
[
2
]
and host system editor
[
2
]
CHAR values
substitution variables
[
2
]
DEFINE variable
[
2
]
DEL command
[
2
] [
3
]
using an asterisk
[
2
]
DELETE command, disabling
DEMOBLD
DEMODROP
DEPT table
DESCRIBE command (SQL*Plus)
[
2
]
database link name
PL/SQL properties listed by
table properties listed by
Designer/2000
Developer/2000
DISABLED keyword, disabling commands
Disabling
PL/SQL commands
SQL commands
SQL*Plus commands
DISCONNECT command
[
2
]
Discoverer/2000
DOCUMENT command
REMARK as newer version of
DOCUMENT variable
DROP command, disabling
DUPLICATES clause
E
ECHO variable
[
2
]
EDIT command
[
2
]
creating command files with
defining _EDITOR
[
2
]
disabling
modifying command files
[
2
]
setting default file name
EDITFILE variable
EMBEDDED variable
EMP table
Empty line, displaying
Enhancement list, Release 3.3
Error messages, interpreting
Errors, making line containing current
Escape characters, definition of
ESCAPE variable
[
2
]
EXECUTE command
disabling
Executing, a CREATE command
Execution statistics, including in report
EXIT clause
WHENEVER OSERROR
WHENEVER SQLERROR
EXIT command
[
2
]
:BindVariable clause
COMMIT clause
disabling
FAILURE clause
in a command file
ROLLBACK clause
SUCCESS clause
WARNING clause
Exit, conditional
[
2
]
Extension
[
2
] [
3
]
F
FAILURE clause
FEEDBACK variable
File extension
[
2
] [
3
]
File extensions
File names
in @ ("at" sign) command
in @@ (double "at" sign) command
in EDIT command
in GET command
in SAVE command
[
2
]
in SPOOL command
[
2
]
in SQLPLUS command
in START command
Files
command files
flat
FLAGGER variable
Flat file
FLUSH variable
FOLD_AFTER clause
FOLD_BEFORE clause
Footers
aligning elements
displaying at bottom of page
displaying page number
displaying system-maintained values
formatting elements
indenting
listing current definition
restoring definition
setting at the end of reports
suppressing definition
FORMAT clause
in ATTRIBUTE command
in COLUMN command
[
2
] [
3
]
in REPHEADER and REPFOOTER commands
in TTITLE and BTITLE commands
[
2
]
Format models, number
[
2
] [
3
]
Formfeed, to begin a new page
[
2
]
FROM clause (SQL*Plus)
[
2
]
G
Gateways
GET command
[
2
]
disabling
LIST clause
modifying command files
NOLIST clause
retrieving command files
[
2
]
GLOGIN.SQL
[
2
] [
3
] [
4
]
GRANT command
disabling
H
Headers
aligning elements
displaying at top of page
displaying page number
displaying system-maintained values
setting at the start of reports
suppressing
HEADING clause
[
2
]
HEADING variable
Headings
aligning elements
column headings
formatting elements
indenting
listing current definition
restoring definition
suppressing definition
HEADSEP variable
use in COLUMN command
[
2
]
Help command
Help, online
[
2
] [
3
]
HIDE clause
HOST command
[
2
]
disabling
listing command file names with
Host operating system
command prompt
editor
[
2
]
file, loading into buffer
running commands from SQL*Plus
[
2
]
hyphen, continuing a long SQL*Plus command
[
2
]
I
Infinity sign (~)
INPUT command
[
2
] [
3
]
entering several lines
using with SAVE to create command files
Input, accepting [Return]
[
2
]
accepting values from the user
[
2
]
INSERT clause
[
2
]
INSERT command, disabling
J
JUSTIFY clause
K
Keyboard, significance of keys on
Keys
[Backspace] key
[Cancel] key
[Interrupt] key
[Pause] key
[Resume] key
[Return] key
L
Labels, in COMPUTE command
[
2
]
LEFT clause
[
2
] [
3
] [
4
]
LIKE clause
[
2
] [
3
]
Limits, SQL*Plus
Line numbers, for SQL commands
Lines
adding at beginning of buffer
adding at end of buffer
adding new after current
[
2
]
appending text to
[
2
]
changing width
[
2
]
deleting all in buffer
deleting from buffer
[
2
]
determining which is current
editing current
LINESIZE variable
[
2
] [
3
]
Lines, listing all in buffer
[
2
]
removing blanks at end
LIST clause
LIST command
[
2
]
determining current line
[
2
]
making last line current
[
2
]
using an asterisk
[
2
]
LNO clause
[
2
] [
3
]
LOBOFFSET variable
LOCK TABLE command, disabling
Logging off, conditionally
[
2
]
Oracle
[
2
]
SQL*Plus
[
2
]
Logging on, Oracle
[
2
] [
3
]
SQL*Plus
[
2
]
LOGIN.SQL
[
2
]
including SET commands
sample commands to include
storing current date in variable for titles
LONG columns, changing format
[
2
]
default format
[
2
]
setting maximum width
setting retrieval size
LONG variable
[
2
]
effect on COPY command
[
2
]
LONGCHUNKSIZE variable
[
2
] [
3
]
M
MAXIMUM function
Media Objects
Message, sending to screen
[
2
]
MINIMUM function
MLSLABEL columns
changing format
default format
[
2
]
Mobile Agents
N
NCHAR clause, VARIABLE command
NCHAR columns, changing format
[
2
] [
3
]
default format
[
2
] [
3
]
NCLOB clause, VARIABLE command
NCLOB columns, changing format
[
2
]
default format
[
2
]
setting maximum width
setting retrieval position
setting retrieval size
Negative infinity sign (-~)
NEW_VALUE clause
[
2
]
storing current date in variable for titles
[
2
] [
3
]
NEWLINE clause
NEWPAGE command
NEWPAGE variable
[
2
]
NLS_DATE_FORMAT
[
2
]
NOAUDIT command, disabling
NODUPLICATES clause
NOLIST clause
NOLOG option
NONE clause
WHENEVER OSERROR
WHENEVER SQLERROR
NOPRINT clause
[
2
] [
3
]
NOPROMPT clause
NULL clause
Null values, setting text displayed
[
2
]
NULL variable
NUMBER clause
[
2
]
VARIABLE command
NUMBER columns, changing format
[
2
]
default format
[
2
]
Number formats
$
0
9
comma
setting default
NUMBER function
NUMFORMAT variable
in LOGIN.SQL
NUMWIDTH variable
effect on NUMBER column format
[
2
]
NVARCHAR2 columns, changing format
[
2
]
default format
[
2
]
O
OF clause
[
2
]
OFF clause
in ATTRIBUTE command
in COLUMN command
[
2
]
in REPHEADER and REPFOOTER commands
in SPOOL command
[
2
]
in TTITLE and BTITLE commands
[
2
]
OLD_VALUE clause
[
2
]
ON clause
in ATTRIBUTE command
in COLUMN command
[
2
]
in REPHEADER and REPFOOTER commands
in TTITLE and BTITLE commands
[
2
]
ON column clause, in BREAK command
[
2
]
in COMPUTE command
[
2
]
ON expr clause
in BREAK command
in COMPUTE command
ON REPORT clause, in BREAK command
[
2
]
in COMPUTE command
[
2
]
ON ROW clause, in BREAK command
[
2
]
in COMPUTE command
Online help
[
2
] [
3
]
Oracle InterOffice
Oracle Web Application Server
ORDER BY clause
displaying column values in titles
displaying values together in output
OUT clause
[
2
]
Output
formatting white space in
pausing during display
[
2
]
query results
P
PAGE clause
Page number, including in titles
[
2
]
Page number
including in headers and footers
including in titles
Pages, changing length
[
2
]
default dimensions
PAGESIZE variable
[
2
] [
3
]
in LOGIN.SQL
Pages
matching dimensions to screen or paper size
setting dimensions
Parameters
[
2
] [
3
]
Password
PASSWORD command
[
2
]
disabling
Password
changing with the PASSWORD command
in CONNECT command
[
2
] [
3
]
in COPY command
[
2
] [
3
] [
4
]
in SQLPLUS command
[
2
] [
3
]
Paths, creating, Installation and User's Guide
PAUSE command
[
2
]
in LOGIN.SQL
PAUSE variable
[
2
]
Performance, over dial-up lines
Performance, of SQL statements
Period (.), terminating PL/SQL blocks
PL/SQL
[
2
]
blocks, PL/SQL
executing
formatting output in SQL*Plus
listing definitions
mode in SQL*Plus
within SQL commands
PLAN_TABLE table
[
2
]
PLUSTRACE role
PLUSTRCE.SQL
PNO clause
[
2
] [
3
]
Pound sign (#)
PRINT clause
PRINT command
Printing
bind variables automatically
REFCURSOR variables
SPOOL command
PRODUCT_USER_PROFILE table
Programmer/2000
PROMPT clause
[
2
]
PROMPT command
[
2
]
customizing prompts for value
Prompts for value
bypassing with parameters
customizing
through ACCEPT
through substitution variables
PUPBLD.SQL
Q
Queries
displaying number of records retrieved
[
2
]
in COPY command
[
2
]
Query execution path, including in report
Query results
displaying on-screen
sending to a printer
[
2
]
storing in a file
[
2
]
QUIT command
disabling
in a command file
R
RAW MLSLABEL columns
changing format
default format
[
2
]
Record separators, printing
[
2
]
RECSEP variable
[
2
]
RECSEPCHAR variable
[
2
]
REFCURSOR bind variables
in a stored function
REFCURSOR clause, VARIABLE command
RELEASE clause
[
2
] [
3
]
REMARK command
[
2
]
RENAME command, disabling
REPFOOTER clause
REPFOOTER command
[
2
]
aligning footer elements
BOLD clause
CENTER clause
COL clause
FORMAT clause
indenting report footers
LEFT clause
most often used clauses
OFF clause
ON clause
restoring current definition
RIGHT clause
SKIP clause
suppressing current definition
TAB clause
REPHEADER clause
REPHEADER command
[
2
]
aligning header elements
aligning heading elements
BOLD clause
CENTER clause
[
2
]
COL clause
[
2
]
FORMAT clause
indenting headings
LEFT clause
[
2
]
most often used clauses
OFF clause
ON clause
PAGE clause
restoring current definition
RIGHT clause
[
2
]
SKIP clause
[
2
]
suppressing current definition
TAB clause
REPLACE clause, in COPY command
[
2
]
in SAVE command
[
2
]
Report breaks, BREAK command
Report columns, Columns
Report titles, Titles
Reports
clarifying with spacing and summary lines
creating bottom titles
[
2
]
creating footers
creating headers
creating headers and footers
creating master/detail
[
2
] [
3
]
creating top titles
[
2
]
displaying
formatting column headings
[
2
]
formatting columns
[
2
] [
3
]
starting on a new page
Return code, specifying
[
2
] [
3
]
REVOKE command
disabling
RIGHT clause
[
2
] [
3
] [
4
]
Roles
disabling
re-enabling
ROLLBACK clause
WHENEVER OSERROR
WHENEVER SQLERROR
ROWLABEL columns
changing format
default format
Rows, performing computations on
[
2
]
setting number retrieved at one time
setting the number after which COPY commits
RUN command
[
2
]
disabling
executing current PL/SQL block
executing current SQL command or PL/SQL block
making last line current
similar to / (slash) command
[
2
]
S
Sample tables
access to
DEMOBLD
DEMODROP
SAVE command
[
2
]
APPEND clause
[
2
]
CREATE clause
disabling
modifying command files
REPLACE clause
[
2
]
storing commands in command files
[
2
]
using with INPUT to create command files
Saving environment attributes
SCAN variable
SCREEN clause
[
2
]
Screen, clearing
[
2
]
Search paths, Installation and User's Guide
Security
changing password
PRODUCT_USER_PROFILE table
SELECT command, and BREAK command
[
2
] [
3
] [
4
]
and COLUMN command
and COMPUTE command
[
2
]
and COPY command
[
2
]
and DEFINE command
and ORDER BY clause
disabling
storing current date in variable for titles
SELECT statement, formatting results
Semicolon (;)
in PL/SQL blocks
in SQL commands
[
2
]
in SQL*Plus commands
[
2
]
not needed when inputting a command file
not stored in buffer
SERVEROUTPUT variable
SET AUTOTRACE
SET clause
SET command
[
2
] [
3
]
SET command variables, system variables
SET command
APPINFO variable
ARRAYSIZE variable
[
2
]
AUTOCOMMIT variable
[
2
]
AUTOPRINT variable
[
2
]
AUTOTRACE variable
BLOCKTERMINATOR variable
BUFFER variable
CMDSEP variable
COLSEP variable
[
2
]
COMPATIBILITY variable
[
2
]
CONCAT variable
[
2
]
COPYCOMMIT variable
[
2
]
COPYTYPECHECK variable
DEFINE variable
[
2
]
disabling
DOCUMENT variable
ECHO variable
[
2
]
EDITFILE variable
EMBEDDED variable
ESCAPE variable
[
2
]
FEEDBACK variable
FLAGGER variable
FLUSH variable
HEADING variable
HEADSEP variable
[
2
]
LINESIZE variable
[
2
] [
3
]
LOBOFFSET variable
LONG variable
[
2
] [
3
]
LONGCHUNKSIZE variable
NEWPAGE variable
[
2
]
NULL variable
NUMFORMAT variable
[
2
]
NUMWIDTH variable
[
2
] [
3
]
PAGESIZE variable
[
2
] [
3
] [
4
]
PAUSE variable
[
2
] [
3
]
RECSEP variable
[
2
]
RECSEPCHAR variable
[
2
]
SCAN variable
SERVEROUTPUT variable
SHIFTINOUT variable
[
2
]
SPACE variable
SQLCASE variable
SQLCONTINUE variable
SQLNUMBER variable
SQLPREFIX variable
SQLPROMPT variable
SQLTERMINATOR variable
SUFFIX variable
TAB variable
TERMOUT variable
[
2
]
TIME variable
[
2
]
TIMING variable
TRIMOUT variable
TRIMSPOOL variable
TRUNCATE variable
UNDERLINE variable
[
2
]
used to format a REFCURSOR variable
VERIFY variable
[
2
] [
3
]
WRAP variable
[
2
]
SET ROLE command, disabling
SET TRANSACTION command, disabling
SHIFTINOUT variable
in LOGIN.SQL
SHOW clause
SHOW command
[
2
]
ALL clause
BTITLE clause
ERRORS clause
LABEL clause
listing current page dimensions
LNO clause
PNO clause
RELEASE clause
REPFOOTER clause
REPHEADER clause
SPOOL clause
SQLCODE clause
TTITLE clause
USER clause
SHOWMODE variable
SILENT clause
Site Profile
SKIP clause, in BREAK command
[
2
] [
3
]
in REPHEADER and REPFOOTER commands
in TTITLE and BTITLE commands
[
2
]
in TTITLE, BTITLE, REPHEADER and REPFOOTER commands
used to place blank lines before bottom title
SKIP PAGE clause
[
2
] [
3
]
Slash (/) command
using with files loaded with GET command
SPACE variable
Spatial Data Option
SPOOL clause
SPOOL command
[
2
]
disabling
file name
[
2
]
OFF clause
[
2
]
OUT clause
[
2
]
turning spooling off
[
2
]
SQL buffer
SQL clause
SQL commands, list of major
SQL database language
SQL DML statements, reporting on
SQL*Net protocol
SQL*Plus
basic concepts
command prompt
command summary
exiting
[
2
]
exiting conditionally
[
2
]
limits
LOGIN.SQL
overview
running commands in batch mode
[
2
]
setting up environment
shortcuts to starting
starting
[
2
]
what you need to run
who can use
SQL.LNO
referencing in report headers and footers
referencing in report titles
SQL.PNO, referencing in report titles
SQL.PNO
referencing in headers titles and footers
referencing in report titles
SQL.RELEASE
referencing in report headers and footers
referencing in report titles
SQL.SQLCODE
referencing in report headers and footers
referencing in report titles
using in EXIT command
SQL.USER
referencing in report headers and footers
referencing in report titles
SQLCASE variable
SQLCODE clause
[
2
] [
3
]
SQLCONTINUE variable
SQLNUMBER variable
SQLPLUS command
[
2
]
- (hyphen) clause
-? clause
-SILENT clause
/NOLOG clause
and @ ("at" sign)
[
2
] [
3
]
and EXIT FAILURE
connecting to a remote database
database specification
[
2
] [
3
]
display syntax
running command files
unsuccessful connection
username/password
[
2
]
SQLPREFIX variable
SQLPROMPT variable
SQLTERMINATOR variable
[
2
]
START clause
START command
[
2
]
arguments
[
2
]
command file
[
2
]
disabling
passing parameters to a command file
[
2
]
similar to @ ("at" sign) command
[
2
] [
3
]
similar to @@ (double "at" sign) command
[
2
]
Starting SQL*Plus
shortcuts
Statistics
STD function
STOP clause
STORE command
[
2
]
SET clause
Stored functions
Stored procedures, creating
Substitution variables
appending characters immediately after
avoiding unnecessary prompts for value
concatenation character
DEFINE command
[
2
]
prefixing
restrictions
single and double ampersands
system variables used with
undefined
where and how to use
SUCCESS clause
SUFFIX variable
used with @ ("at" sign) command
used with @@ (double "at" sign) command
used with EDIT command
used with GET command
used with SAVE command
used with START command
SUM function
Summary lines, computing and printing
[
2
]
computing and printing at ends of reports
computing same type on different columns
printing "grand" and "sub" summaries (totals)
printing multiple on same break column
Syntax rules
SQL commands
SQL*Plus commands
Syntax
conventions
COPY command
SYSDATE
System variables
[
2
]
changing current settings
listing current settings
[
2
]
listing old and new values
storing and restoring
used with substitution variables
System-maintained values
displaying in headers and footers
displaying in titles
[
2
]
formatting in titles
T
TAB clause
[
2
]
TAB variable
Tables
access to sample
controlling destination when copying
[
2
]
copying values between
[
2
] [
3
]
DEPT
EMP
listing column definitions
[
2
]
referring to another user's when copying
sample
TERMOUT variable
storing current date in variable for titles
using with SPOOL command
Text editor, host operating system
[
2
]
Text Server Option
Text, adding to current line with APPEND
[
2
]
changing old to new with CHANGE
[
2
]
clearing from buffer
[
2
]
TIME variable
in LOGIN.SQL
TIMING clause
TIMING command
[
2
]
deleting all areas created by
deleting current area
SHOW clause
START clause
STOP clause
TIMING variable
Titles, aligning elements
[
2
]
displaying at bottom of page
[
2
]
displaying at top of page
[
2
]
displaying column values
[
2
] [
3
]
displaying current date
[
2
] [
3
]
displaying page number
[
2
] [
3
]
displaying system-maintained values
[
2
]
formatting elements
formatting system-maintained values in
indenting
[
2
]
listing current definition
[
2
] [
3
]
restoring definition
[
2
]
setting at start or end of report
setting lines from top of page to top title
[
2
]
setting lines from top title to end of page
setting top and bottom
[
2
] [
3
]
spacing between last row and bottom title
suppressing definition
[
2
]
TO clause
[
2
]
Tracing Statements
for performance statistics
for query execution path
using a database link
with parallel query option
without displaying query data
TRIMOUT variable
TRIMSPOOL variable
TRUNCATE command, disabling
TRUNCATE variable
TRUNCATED clause
[
2
]
Trusted Oracle columns
changing format
default format
[
2
]
TTITLE clause
TTITLE command
[
2
]
aligning title elements
[
2
]
BOLD clause
CENTER clause
[
2
] [
3
]
COL clause
[
2
] [
3
]
FORMAT clause
[
2
]
indenting titles
[
2
]
LEFT clause
[
2
] [
3
]
listing current definition
[
2
]
most often used clauses
OFF clause
[
2
]
old form
ON clause
[
2
]
referencing column value variable
[
2
]
restoring current definition
[
2
]
RIGHT clause
[
2
] [
3
]
SKIP clause
[
2
] [
3
]
suppressing current definition
[
2
]
TAB clause
Tuning
U
UNDEFINE command
[
2
]
and DEFINE command
variable clause
UNDERLINE variable
[
2
]
UPDATE command, disabling
USER clause
[
2
] [
3
]
User Profile
[
2
] [
3
]
User variables
defining
[
2
]
deleting
[
2
]
displaying in headers and footers
displaying in titles
in ACCEPT command
[
2
]
listing definition of one
[
2
]
listing definitions of all
[
2
]
Username
connecting under different
[
2
]
in CONNECT command
[
2
] [
3
]
in COPY command
[
2
] [
3
] [
4
]
in SQLPLUS command
[
2
] [
3
]
USING clause
[
2
]
UTLXPLAN.SQL
V
V$SESSION virtual table
V$SQLAREA virtual table
VARCHAR columns
changing format
default format
[
2
]
VARCHAR2 clause, VARIABLE command
VARCHAR2 columns, changing format
[
2
]
default format
VARIABLE command
CHAR clause
CLOB clause
NCHAR clause
NCLOB clause
NUMBER clause
REFCURSOR clause
VARCHAR2 clause
variable clause
Variables
bind variables
substitution variables
system variables
user variables
VARIANCE function
VERIFY variable
[
2
] [
3
]
W
WARNING clause
WHENEVER OSERROR command
COMMIT clause
CONTINUE clause
EXIT clause
NONE clause
ROLLBACK clause
WHENEVER SQLERROR command
[
2
]
COMMIT clause
CONTINUE clause
EXIT clause
NONE clause
ROLLBACK clause
WORD_WRAPPED clause
[
2
] [
3
]
WRAP variable
[
2
]
WRAPPED clause
[
2
]
X
Y
Z
[
\
]
^
_
`
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
~ Infinity sign
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents
Index
