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), 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
• ; (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]

  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

  [

• [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
• 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]
• 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]
• CLEAR command
  • BREAKS clause [2]
  • BUFFER clause [2] [3]
  • COLUMNS clause [2]
  • COMPUTES clause [2]
  • SCREEN clause [2]
  • SQL clause
  • TIMING clause
• CLOSECURSOR variable
• 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]
  • 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]
  • setting printing to off or on [2]
  • specifying values to be computed
  • starting new lines
  • storing values in variables [2]
  • suppressing display attributes [2]
  • 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]
  • database specification
  • username/password [2] [3] [4]
• 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]
  • 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
• CRT files, changing default
• CRT variable
• 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]
  • 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
  • changing default CRT
  • 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 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]
• Forms, running from SQL*Plus [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]
• 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]
• 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

• MAXDATA variable
• MAXIMUM function
• Media Objects
• Message, sending to screen [2]
• MINIMUM function
• MLSLABEL columns
  • changing format
  • default format [2]
• Mobile Agents

  N

• 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]

  O

• OF clause [2]
• OFF clause, 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 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 Office
• 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
  • 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 maximum width SQL*Plus can process
  • 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]
• RUNFORM 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, 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
  • CLOSECURSOR variable
  • CMDSEP variable
  • COLSEP variable [2]
  • COMPATIBILITY variable [2]
  • CONCAT variable [2]
  • COPYCOMMIT variable [2]
  • COPYTYPECHECK variable
  • CRT 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]
  • LONG variable [2] [3]
  • LONGCHUNKSIZE variable
  • MAXDATA 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
  • 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
• 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*Forms, invoking from SQL*Plus [2]
• 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]
  • -? clause
  • -SILENT clause
  • /NOLOG clause
  • and @ ("at" sign) [2] [3]
  • and EXIT FAILURE
  • connecting to a remote database
  • database specification [2] [3]
  • 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 [2]
  • 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
• VALIDATE INDEX command, disabling
• VARCHAR columns
  • changing format
  • default format [2]
• VARCHAR2 clause, VARIABLE command
• VARCHAR2 columns
  • changing format
  • default format
• VARIABLE command
  • CHAR 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
• WebServer Option
• 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