Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W  X  

Symbols

  • _CONNECT_IDENTIFIER predefined variable 1 , 2
  • _DATE predefined variable 1
  • _EDITOR, in EDIT command 1 , 2 , 3
  • _EDITOR predefined variable 1 , 2 , 4
  • _EDITOR substitution variable 1
  • _O_RELEASE predefined variable 1
  • _O_VERSION predefined variable 1
  • _PRIVILEGE predefined variable 1
  • _RC predefined variable 1
  • _SQLPLUS_RELEASE predefined variable 1
  • _USER predefined variable 1
  • ; (semicolon) 1 , 2 , 3
  • /*...*/ (comment delimiters) 1
  • ~ infinity sign 1
  • -~ negative infinity sign 1
  • ((amp))((amp)) 1
  • ((amp)) (ampersand)
    • disabling substitution variables 1
    • substitution variables 1
  • ((colon)) (colon)
    • bind variables 1
  • ((colon))BindVariable clause
    • EXIT command 1
  • ((nbsp))/ (slash) command
    • default logon 1 , 2
    • entered at buffer line-number prompt 1 , 2
    • entered at command prompt 1
    • executing current PL/SQL block 1
    • similar to RUN 1 , 2
    • usage 1
  • ((nbsp)). (period) 1
  • ((nbsp))-- (comment delimiter) 1
  • ((nbsp))- (hyphen)
    • clause 1
    • continuing a long SQL*Plus command 1 , 2
  • @ (at sign)
    • command 1 , 2 , 3
    • command arguments 1 , 2
    • in CONNECT command 1
    • in COPY command 1 , 2
    • in SQLPLUS command 1
    • passing parameters to a script 1 , 2
    • script 1 , 2
    • similar to START 1 , 2
  • @@ (double at sign) command
    • script 1
    • similar to START 1 , 2
  • @ at sign)
    • similar to START 1
  • $ number format 1
  • * (asterisk)
    • in DEL command 1 , 2
    • in LIST command 1 , 2
  • # pound sign
    • overflow indication 1
    • SET SQLPREFIX character 1
  • -AC option 1
  • -MARKUP
    • SQLPLUS command clause 1 , 3
  • -SILENT option 1 , 2

Numerics

  • 0, number format 1
  • 9, number format 1

A

  • ABORT mode 1
  • abort query 1
  • ACCEPT command
    • and DEFINE command 1
    • BINARY_DOUBLE clause 1 , 2
    • BINARY_FLOAT clause 1 , 2
    • customizing prompts for value 1
    • DATE clause 1
    • DEFAULT clause 1
    • FORMAT clause 1
    • HIDE clause 1
    • NOPROMPT clause 1
    • NUMBER clause 1
    • PROMPT clause 1 , 2
  • access, denying and granting 1
  • alias 1
  • ALIAS clause
    • in ATTRIBUTE command 1
  • ALL clause 1
  • ampersands (((amp)))
    • in parameters 1 , 2 , 3 , 4
    • substitution variables 1
  • APPEND clause
    • in COPY command 1 , 2
    • in SAVE command 1 , 2
  • APPEND command 1 , 2 , 3
  • APPINFO clause 1 , 2
  • ARCHIVE LOG
    • command 1 , 2
    • mode 1
  • argument
    • in START command 1
  • ARRAYSIZE variable
    • relationship to COPY command 1 , 2
  • ATTRIBUTE command
    • ALIAS clause 1
    • and CLEAR COLUMN command 1
    • CLEAR clause 1
    • clearing columns 1 , 2
    • controlling display characteristics 1
    • display characteristics 1
    • entering multiple 1
    • FORMAT clause 1
    • LIKE clause 1
    • listing attribute display characteristics 1
    • OFF clause 1
    • ON clause 1
    • restoring column display attributes 1
    • suppressing column display attributes 1
  • AUTOCOMMIT variable 1 , 2 , 3
  • AUTOMATIC clause 1
  • AUTOPRINT variable 1 , 2
  • AUTORECOVERY variable 1 , 3
  • autotrace report 1
  • AUTOTRACE variable 1 , 2

B

  • background process
    • startup after abnormal termination 1
  • BASEURI variable 1
  • BASEURI XQUERY option 1
  • basic OCI package 1
  • batch jobs, authenticating users in 1
  • batch mode 1
  • BEGIN command 1
  • BINARY_DOUBLE clause
    • ACCEPT command 1 , 2
    • VARIABLE command 1
  • BINARY_FLOAT clause
    • ACCEPT command 1 , 2
    • VARIABLE command 1
  • bind variables
    • creating 1
    • displaying 1
    • displaying automatically 1 , 2
    • in PL/SQL blocks 1
    • in SQL statements 1
    • in the COPY command 1
  • blank line
    • in PL/SQL blocks 1
    • in SQL commands 1
    • preserving in SQL commands 1 , 2
  • BLOB
    • column width 1
    • formating in reports 1
  • BLOB columns
    • default format 1
    • setting maximum width 1 , 2
    • setting retrieval position 1 , 2
    • setting retrieval size 1 , 2 , 3
  • blocks, PL/SQL
    • continuing 1
    • editing in buffer 1
    • editing with system editor 1 , 2
    • entering and executing 1
    • listing current in buffer 1
    • saving current 1
    • setting character used to end 1 , 2
    • stored in SQL buffer 1
    • timing statistics 1
    • within SQL commands 1
  • BLOCKTERMINATOR 1 , 2 , 3 , 4
  • BODY clause 1
  • BODY option 1
  • BOLD clause 1 , 2
  • break columns
    • inserting space when value changes 1
    • specifying multiple 1
    • suppressing duplicate values in 1
  • BREAK command
    • and SQL ORDER BY clause 1 , 2 , 3 , 4
    • clearing BREAKS 1
    • displaying column values in titles 1
    • DUPLICATES clause 1
    • inserting space after every row 1
    • inserting space when break column changes 1
    • listing current break definition 1 , 2
    • ON column clause 1 , 2
    • ON expr clause 1
    • ON REPORT clause 1 , 2
    • ON ROW clause 1 , 2
    • printing grand and sub summaries 1
    • printing summary lines at ends of reports 1
    • removing definition 1
    • SKIP clause 1 , 2
    • SKIP PAGE clause 1 , 3 , 4
    • specifying multiple break columns 1 , 2
    • suppressing duplicate values 1
    • used in conjunction with COMPUTE 1
    • used in conjunction with SET COLSEP 1
    • used to format a REFCURSOR variable 1
    • used with COMPUTE 1 , 5
  • break definition
    • listing current 1 , 2
    • removing current 1 , 2
  • BREAKS clause 1 , 2
  • browser, web 1
  • BTITLE clause 1
  • BTITLE command
    • aligning title elements 1
    • BOLD clause 1
    • CENTER clause 1
    • COL clause 1
    • FORMAT clause 1
    • indenting titles 1
    • LEFT clause 1
    • OFF clause 1
    • old form 1
    • printing blank lines before bottom title 1
    • referencing column value variable 1
    • RIGHT clause 1
    • SKIP clause 1
    • suppressing current definition 1
    • TAB clause 1
    • TTITLE command 1
  • buffer
    • appending text to a line in 1 , 2
    • delete a single line 1
    • delete the current line 1
    • delete the last line 1
    • deleting all lines 1 , 2 , 3
    • deleting a range of lines 1 , 2
    • deleting a single line 1
    • deleting lines from 1 , 2
    • deleting the current line 1
    • deleting the last line 1
    • executing contents 1 , 2
    • inserting new line in 1 , 2
    • listing all lines 1 , 2
    • listing a range of lines 1 , 2
    • listing a single line 1 , 2
    • listing contents 1 , 2
    • listing the current line 1 , 2
    • listing the last line 1 , 2
    • loading into system editor 1
    • saving contents 1
  • BUFFER clause 1 , 2 , 3
  • BUFFER variable 1

C

  • CANCEL clause 1
  • Cancel key 1
  • cancel query 1
  • CENTER clause 1 , 2 , 3
  • CHANGE command 1 , 2 , 3
  • CHAR clause
    • VARIABLE command 1
  • CHAR columns
    • changing format 1
    • default format 1
    • definition from DESCRIBE 1
  • charset
    • SQL*Plus Instant Client 1
  • CLEAR clause
    • in ATTRIBUTE command 1
  • CLEAR command
    • BREAKS clause 1 , 2
    • BUFFER clause 1 , 2 , 3
    • COLUMNS clause 1
    • COMPUTES clause 1
    • SCREEN clause 1 , 2
    • SQL clause 1
    • TIMING clause 1
  • CLOB clause
    • VARIABLE command 1
  • CLOB columns
    • changing format 1
    • default format 1
    • setting maximum width 1 , 2
    • setting retrieval position 1 , 2
    • setting retrieval size 1 , 2 , 3
  • CLOSECURSOR variable 1 , 2
  • CMDSEP variable 1 , 2
  • COL clause 1 , 2 , 3
  • COLINVISIBLE variable 1
  • colons (((colon)))
    • bind variables 1
  • COLSEP variable 1 , 2
  • COLUMN command
    • ALIAS clause 1
    • and BREAK command 1
    • and DEFINE command 1
    • CLEAR clause 1 , 2
    • DEFAULT clause 1
    • displaying column values in bottom titles 1 , 2
    • displaying column values in top titles 1 , 2
    • entering multiple 1
    • ENTMAP clause 1
    • FOLD_AFTER clause 1
    • FOLD_BEFORE clause 1
    • FORMAT clause 1 , 2 , 3
    • formatting a REFCURSOR variable 1
    • formatting NUMBER columns 1 , 2
    • HEADING clause 1 , 2
    • HEADSEP character 1
    • JUSTIFY clause 1
    • LIKE clause 1 , 2
    • listing column display attributes 1 , 3
    • NEW_VALUE clause 1 , 2
    • NEWLINE clause 1
    • NOPRINT clause 1 , 2 , 3
    • NULL clause 1
    • OFF clause 1 , 2
    • OLD_VALUE clause 1 , 2
    • ON clause 1 , 2
    • PRINT clause 1
    • resetting a column to default display 1
    • resetting to default display 1 , 2 , 3
    • restoring column display attributes 1 , 2
    • storing current date in variable for titles 1
    • suppressing column display attributes 1 , 2
    • TRUNCATED clause 1 , 2
    • WORD_WRAPPED clause 1 , 2 , 3
    • WRAPPED clause 1 , 2
  • column headings
    • aligning 1
    • changing 1 , 2
    • changing character used to underline 1 , 2
    • changing to two or more words 1 , 2
    • displaying on more than one line 1 , 2
    • suppressing printing in a report 1 , 2
    • when truncated 1
    • when truncated for CHAR and LONG columns 1
    • when truncated for DATE columns 1
    • when truncated for NUMBER columns 1
  • columns
    • assigning aliases 1
    • computing summary lines 1 , 2
    • copying display attributes 1 , 2 , 3
    • copying values between tables 1 , 2 , 3
    • displaying values in bottom titles 1 , 2
    • displaying values in top titles 1 , 2
    • formatting CHAR, VARCHAR, LONG, and DATE 1
    • formatting in reports 1 , 2
    • formatting MLSLABEL, RAW MLSLABEL, ROWLABEL 1
    • formatting NUMBER 1 , 2
    • listing display attributes for all 1 , 2
    • listing display attributes for one 1 , 2
    • names in destination table when copying 1 , 2
    • printing line after values that overflow 1 , 2 , 3
    • resetting a column to default display 1 , 2 , 3
    • resetting all columns to default display 1
    • restoring display attributes 1 , 2 , 3
    • setting printing to off or on 1 , 2 , 3
    • starting new lines 1
    • storing values in variables 1 , 2
    • suppressing display attributes 1 , 2 , 3
    • truncating display for all when value overflows 1 , 2
    • truncating display for one when value overflows 1 , 2
    • wrapping display for all when value overflows 1 , 2
    • wrapping display for one when value overflows 1 , 2
    • wrapping whole words for one 1
  • COLUMNS clause 1
  • column separator 1 , 2 , 3
  • comma, number format 1
  • command files
    • aborting and exiting with a return code 1 , 2 , 3
    • creating with a system editor 1
    • creating with SAVE 1 , 2
    • editing with system editor 1
    • in @ (at sign) command 1 , 2
    • including comments in 1 , 2
    • including more than one PL/SQL block 1
    • including more than one SQL command 1
    • in EDIT command 1
    • in GET command 1
    • in SAVE command 1 , 2
    • in SQLPLUS command 1 , 2
    • in START command 1 , 2
    • nesting 1
    • passing parameters to 1 , 2 , 3 , 4
    • registering 1 , 2
    • retrieving 1
    • running 1 , 2 , 3
    • running a series in sequence 1
    • running as you start SQL*Plus 1 , 2
    • running in batch mode 1 , 2
    • uniform resource locator 1 , 2 , 4
  • command history
    • SQL*Plus 1
  • command-line
    • configuring globalization support 1
    • installing help 1
  • command-line interface
    • changing face and size 1
  • command prompt
    • SET SQLPROMPT 1 , 2 , 3
    • SQL*Plus 1
  • commands
    • collecting timing statistics on 1 , 2
    • disabled in schema 1
    • disabling 1
    • echo on screen 1
    • host, running from SQL*Plus 1 , 2
    • listing current in buffer 1
    • re-enabling 1
    • spaces 1
    • SQL
      • continuing on additional lines 1
      • editing in buffer 1
      • editing with system editor 1
      • ending 1
      • entering and executing 1
      • entering without executing 1
      • executing current 1 , 2
      • following syntax 1
      • listing current in buffer 1
      • saving current 1
      • setting character used to end and run 1
    • SQL*Plus
      • command summary 1
      • continuing on additional lines 1 , 2
      • ending 1 , 2
      • entering and executing 1
      • entering during SQL command entry 1
      • obsolete command alternatives 1
    • stopping while running 1
    • tabs 1
    • types of 1
    • variables that affect running 1
  • comments
    • including in command files 1
    • including in scripts 1 , 2 , 3
    • using /*...*/ to create 1
    • using REMARK 1
    • using REMARK to create 1 , 2 , 3
    • using -- to create 1
  • COMMIT clause
    • WHENEVER OSERROR 1
    • WHENEVER SQLERROR 1
  • COMMIT command 1
  • communication between tiers 1
  • COMPATIBILITY variable 1 , 2
  • compilation errors 1 , 2 , 3
  • COMPUTE command
    • computing a summary on different columns 1
    • LABEL clause 1 , 2 , 3
    • listing all definitions 1 , 2
    • maximum LABEL length 1
    • OF clause 1
    • ON 1
    • ON column clause 1 , 2
    • ON expr clause 1
    • ON REPORT clause 1 , 2
    • printing grand and sub summaries 1
    • printing multiple summaries on same column 1
    • printing summary lines at ends of reports 1
    • printing summary lines on a break 1
    • referencing a SELECT expression in OF 1
    • referencing a SELECT expression in ON 1
    • removing definitions 1 , 2
    • used to format a REFCURSOR variable 1
  • COMPUTES clause 1
  • CON_ID clause 1
  • CON_NAME clause 1
  • CONCAT variable 1 , 3 , 5
  • configuration
    • globalization support 1
  • configuring
    • Oracle Net 1
    • SQL*Plus 1
  • CONNECT / feature 1
  • CONNECT command
    • and @ (at sign) 1
    • changing password 1 , 3
    • SYSASM clause 1
    • SYSBACKUP clause 1
    • SYSDBA clause 1
    • SYSDG clause 1
    • SYSKM clause 1
    • SYSOPER clause 1
    • SYSRAC clause 1
    • username/password 1
  • connect identifier
    • in CONNECT command 1
    • in COPY command 1
    • in DESCRIBE command 1
    • in SQLPLUS command 1
  • connection identifier
    • easy or abbreviated 1
    • full 1
    • net service name 1
  • CONTEXT variable 1
  • CONTEXT XQUERY option 1
  • CONTINUE clause
    • WHENEVER OSERROR 1
    • WHENEVER SQLERROR 1
  • continuing a long SQL*Plus command 1 , 2
  • COPY command
    • and @ (at sign) 1 , 2
    • and ARRAYSIZE variable 1 , 2
    • and COPYCOMMIT variable 1 , 2
    • and LONG variable 1 , 2
    • APPEND clause 1 , 2
    • copying data between databases 1
    • copying data between tables on one database 1
    • CREATE clause 1 , 2
    • creating a table 1 , 2
    • destination table 1 , 2
    • determining actions 1
    • determining source rows and columns 1 , 2
    • error messages 1
    • FROM clause 1
    • INSERT clause 1 , 2
    • inserting data in a table 1 , 2
    • interpreting messages 1
    • mandatory connect identifier 1
    • naming the source table with SELECT 1 , 2
    • query 1 , 2
    • referring to another user’s table 1
    • REPLACE clause 1 , 2
    • replacing data in a table 1 , 2
    • sample command 1
    • service name 1 , 2 , 3
    • specifying columns for destination 1 , 2
    • specifying the data to copy 1 , 2
    • TO clause 1
    • username/password 1 , 2 , 3 , 4
    • USING clause 1 , 2
  • COPYCOMMIT variable
    • relationship to COPY command 1 , 2
  • COPYTYPECHECK variable 1 , 2
  • CREATE clause
    • in COPY command 1 , 2
  • CREATE command
    • entering PL/SQL 1
  • creating a PLAN_TABLE 1
  • creating flat files 1
  • creating PLUSTRACE role 1
  • creating sample tables 1
  • creating the PRODUCT_USER_PROFILE table 1
  • CSV
    • clause 1 , 2
    • option 1
  • csv, outputting reports 1
  • cursor variables 1

D

  • database
    • administrator 1
    • connect identifier 1
    • mounting 1
    • opening 1
  • database changes, saving automatically 1 , 2
  • DATABASE clause 1
  • database files
    • recovering 1
  • database name at startup 1
  • databases
    • connecting to default 1
    • connecting to remote 1
    • copying data between 1 , 2
    • copying data between tables on a single 1
    • disconnecting without leaving SQL*Plus 1 , 2
    • mounting 1
    • opening 1
    • recovering 1 , 2
    • shutting down 1 , 2
    • starting 1
  • database schema
    • DESCRIBE parameter 1
    • SHOW 1
  • DATAFILE clause 1
  • DATE
    • column definition from DESCRIBE 1
  • date, storing current in variable for titles 1 , 2
  • DATE clause 1
  • DATE columns
    • changing format 1
    • default format 1
  • DB2 1
  • DBA
    • mode 1
    • privilege 1
  • DBMS_APPLICATION_INFO package 1 , 2 , 3
  • DBMS output 1 , 2
  • DECLARE command
    • PL/SQL 1
  • DEFAULT clause 1
  • DEFINE command
    • and system editor 1 , 2
    • and UNDEFINE command 1 , 2
    • CHAR values 1
    • SET DEFINE ON|OFF 1 , 2
    • substitution variables 1
  • DEFINE variable
    • See: substitution variable
  • DEL[ETE] clause 1
  • DEL command
    • using an asterisk 1 , 2
  • DELIMITER clause 1
  • DESCRIBE command (SQL*Plus)
    • connect_identifier 1
    • PL/SQL properties listed by 1
    • table properties listed by 1
  • DISABLED keyword, disabling commands 1
  • disabling
    • PL/SQL commands 1
    • SQL*Plus commands 1
    • SQL commands 1
  • DISCONNECT command 1 , 2
  • DOCUMENT command
    • REMARK as newer version of 1
  • DOCUMENT variable 1 , 2
  • DUPLICATES clause 1

E

  • ECHO
    • SET command 1
  • ECHO variable 1 , 2 , 3
  • EDIT clause 1
  • EDIT command
    • creating scripts with 1
    • defining _EDITOR 1
    • modifying scripts 1
    • setting default file name 1 , 2
  • EDITFILE variable 1 , 2
  • edition
    • in CONNECT command 1
    • in SQLPLUS command 1
  • EDITOR operating system variable 1
  • Ed on UNIX 1
  • EMBEDDED variable 1 , 2
  • entities, HTML 1
  • ENTMAP 1
  • ENTMAP clause 1 , 2 , 3
  • environment variables
    • LD_LIBRARY_PATH 1
    • LOCAL 1
    • NLS_LANG 1
    • ORA_EDITION 1
    • ORA_NLS10 1
    • ORACLE_HOME 1
    • ORACLE_PATH 1
    • ORACLE_SID 1
    • PATH 1
    • SQL*Plus 1
    • SQLPATH 1
    • TNS_ADMIN 1
    • TWO_TASK 1
  • error
    • SQL*Plus Instant Client unsupported charset 1
  • ERRORLOGGING variable 1
  • error messages
    • COPY command 1
    • interpreting 1
    • sqlplus 1
  • errors
    • compilation errors 1 , 2 , 3
    • making line containing current 1
  • escape characters, definition of 1 , 2
  • ESCAPE variable 1 , 2 , 6
  • ESCCHAR variable 1
  • example
    • CSV report 1
    • interactive HTML report 1
  • EXECUTE command 1
  • executing
    • a CREATE command 1
  • execution plan 1
  • execution statistics
    • including in report 1
  • exit, conditional 1
  • EXIT clause
    • WHENEVER OSERROR 1
    • WHENEVER SQLERROR 1
  • EXIT command
    • ((colon))BindVariable clause 1
    • COMMIT clause 1
    • FAILURE clause 1
    • in a script 1
    • ROLLBACK clause 1
    • use with SET MARKUP 1
    • WARNING clause 1
  • EXITCOMMIT variable 1
  • extension 1 , 2 , 3

F

  • FAILURE clause 1
  • FEEDBACK variable 1 , 2
  • file extensions 1 , 2 , 3 , 4
  • file names
    • in @ (at sign) command 1
    • in @@ (double at sign) command 1
    • in EDIT command 1
    • in GET command 1
    • in SAVE command 1
    • in SPOOL command 1 , 2
    • in SQLPLUS command 1
  • files
    • flat 1
    • required for SQL*Plus Instant Client 1
  • FLAGGER variable 1 , 2
  • flat file 1
  • FLUSH variable 1 , 2 , 3
  • FOLD_AFTER clause 1
  • FOLD_BEFORE clause 1
  • font
    • changing face and size in command-line 1
  • footers
    • aligning elements 1
    • displaying at bottom of page 1
    • displaying system-maintained values 1
    • formatting elements 1
    • indenting 1
    • listing current definition 1
    • setting at the end of reports 1
    • suppressing definition 1
  • FORCE clause 1
  • FORMAT clause
    • in ATTRIBUTE command 1
    • in COLUMN command 1 , 2
    • in REPHEADER and REPFOOTER commands 1
    • in TTITLE and BTITLE commands 1 , 2
  • format models, number 1 , 2
  • formfeed, to begin a new page 1 , 2
  • FROM clause 1 , 2

G

  • GET command
    • LIST clause 1
    • NOLIST clause 1
    • retrieving scripts 1
  • globalization support
    • Oracle10g 1
  • glogin
    • profile 1
    • site profile 1 , 2 , 3 , 4 , 5
  • GRANT command 1

H

  • HEAD clause 1
  • headers
    • aligning elements 1
    • displaying at top of page 1
    • displaying system-maintained values 1
    • setting at the start of reports 1
    • suppressing 1
  • HEADING clause 1 , 2
  • headings
    • aligning elements 1
    • column headings 1
    • formatting elements 1
    • indenting 1
    • listing current definition 1
    • suppressing definition 1
  • HEADING variable 1
  • HEAD option 1
  • HEADSEP variable
    • use in COLUMN command 1
  • help
    • installing command-line 1
    • online 1 , 2
  • HELP command, ? command 1
  • HIDE clause 1
  • HISTORY clause 1
  • HISTORY command
    • CLEAR clause 1
    • DEL[ETE] clause 1
    • EDIT clause 1
    • LIST clause 1
    • RUN clause 1
  • HISTORY variable 1
  • HOST command 1 , 2
  • HTML
    • clause 1
    • entities 1
    • option 1
    • spooling to file 1
    • tag 1
  • hyphen
    • continuing a long SQL*Plus command 1 , 2

I

  • IMMEDIATE mode 1
  • infinity sign (~) 1
  • INIT.ORA file
    • parameter file 1
  • initialization parameters
    • displaying 1
  • input
    • accepting [Return] 1
    • accepting values from the user 1 , 2
  • INPUT command
    • entering several lines 1
  • INSERT clause 1 , 2
  • installation
    • SQL*Plus Instant Client 1
    • SQL*Plus Instant Client by copying 1
    • SQL*Plus Instant Client by copying from 10g Client 1
    • SQL*Plus Instant Client by download from OTN 1 , 2
    • SQL*Plus Instant Client on Linux 1
    • SQL*Plus Instant Client on UNIX or Windows 1
    • SQL*Plus Instant Client UNIX and Linux files to copy 1
    • SQL*Plus Instant Client Windows files to copy 1
  • installation, UNIX and Linux files to copy 1
  • installation, Windows files to copy 1
  • installation by copying 1
  • installation by copying from 10g Client 1
  • installation by download from OTN 1 , 2
  • installation on Linux 1
  • installation on UNIX or Windows 1
  • instances
    • shutting down 1
    • starting 1
  • INSTANCE variable 1 , 2
  • Instant Client
    • SQL*Plus 1
  • Instant Client packages 1

J

  • Japanese 1
  • JUSTIFY clause 1

L

  • labels
    • in COMPUTE command 1 , 2
  • LABEL variable
    • SHOW command 1
  • language
    • SQL*Plus Instant Client 1
  • LD_LIBRARY_PATH
    • environment variables 1
  • LEFT clause 1 , 2 , 3
  • lightweight OCI package 1
  • LIKE clause 1 , 2 , 3
  • limits, SQL*Plus 1
  • lines
    • adding at beginning of buffer 1
    • adding at end of buffer 1
    • adding new after current 1 , 2
    • appending text to 1 , 2
    • changing width 1 , 2 , 3 , 4
    • deleting all in buffer 1
    • deleting from buffer 1 , 2
    • determining which is current 1
    • editing current 1
    • listing all in buffer 1 , 2
    • removing blanks at end 1
  • LINESIZE variable 1 , 2 , 3 , 4
  • Linux
    • installing SQL*Plus Instant Client 1
    • SQL*Plus Instant Client files to copy 1
  • LIST clause 1 , 2 , 3
  • LIST command
    • determining current line 1 , 2
    • making last line current 1 , 2
    • using an asterisk 1 , 2
  • LNO clause 1
  • LOB data
    • setting prefetch size 1
  • LOBOFFSET variable 1 , 2
  • LOBPREFETCH clause 1
  • LOBPREFETCH variable 1
  • LOCAL
    • environment variables 1
  • LOG_ARCHIVE_DEST parameter 1
  • LOGFILE clause 1
  • logging off
    • conditionally 1 , 2
    • Oracle Database 1 , 2
    • SQL*Plus 1 , 2
  • logging on
    • Oracle Database 1
    • SQL*Plus 1
  • login
    • user profile 1
  • login.sql 1
  • LONG
    • column definition from DESCRIBE 1
  • LONGCHUNKSIZE variable 1 , 2 , 3 , 4 , 5
  • LONG columns
    • changing format 1
    • default format 1
    • setting maximum width 1 , 2
    • setting retrieval size 1 , 3 , 4
  • LONGRAW
    • column definition from DESCRIBE 1
  • LONG variable
    • effect on COPY command 1 , 2

M

  • MARKUP
    • BODY clause 1
    • DELIMITER clause 1
    • ENTMAP clause 1
    • HEAD clause 1
    • PREFORMAT clause 1
    • QUOTE clause 1
    • TABLE clause 1
  • MAXDATA variable 1 , 2
  • media recovery 1
  • message, sending to screen 1 , 2
  • MOUNT clause 1
  • mounting a database 1

N

  • national language support 1
    • See also: globalization support
  • NCHAR clause
    • VARIABLE command 1
  • NCHAR columns
    • changing format 1
    • default format 1 , 3
  • NCLOB clause
    • VARIABLE command 1
  • NCLOB columns
    • changing format 1
    • default format 1
    • setting maximum width 1 , 2
    • setting retrieval position 1 , 2
    • setting retrieval size 1 , 2 , 3
  • negative infinity sign (-~) 1
  • net service name 1 , 2
  • NEW_VALUE clause
    • storing current date in variable for titles 1
  • NEWLINE clause 1
  • NEWPAGE command 1 , 2
  • NEWPAGE variable 1 , 2 , 3
  • NLS 1
  • NLS_DATE_FORMAT 1 , 2
  • NLS_LANG
    • charset parameter for Instant Client 1
    • environment variables 1
    • language parameter for Instant Client 1
    • SQL*Plus Instant Client 1
    • territory parameter for Instant Client 1
  • NODE variable 1
  • NODE XQUERY option 1
  • NOLIST clause 1
  • NOLOG 1 , 2
  • nolongontime 1
  • NOMOUNT clause 1
  • NONE clause
    • WHENEVER OSERROR 1
    • WHENEVER SQLERROR 1
  • NOPARALLEL clause 1
  • NOPRINT clause 1 , 2 , 3 , 4
  • NOPROMPT clause 1
  • NORMAL mode 1
  • Notepad on Windows 1
  • NULL clause 1
  • null values
    • setting text displayed 1 , 2 , 3
  • NULL variable 1 , 2
  • NUMBER
    • column definition from DESCRIBE 1
  • NUMBER clause
    • VARIABLE command 1
  • NUMBER columns
    • changing format 1 , 2
    • default format 1 , 2
  • number formats
    • $ 1
    • 0 1
    • 9 1
    • comma 1
    • setting default 1 , 3 , 4
  • NUMFORMAT clause
    • in LOGIN.SQL 1
  • NUMFORMAT variable 1 , 2
  • NUMWIDTH variable
    • effect on NUMBER column format 1 , 2
  • NVARCHAR2 columns
    • changing format 1
    • default format 1 , 2

O

  • objects, describing 1
  • obsolete commands
    • BTITLE 1
    • COLUMN command DEFAULT clause 1
    • DOCUMENT 1 , 2
    • NEWPAGE 1 , 2
    • SET command BUFFER variable 1
    • SET command CLOSECURSOR variable 1 , 2
    • SET command COMPATIBILITY variable 1 , 2
    • SET command DOCUMENT variable 1 , 2
    • SET command MAXDATA variable 1 , 2
    • SET command SCAN variable 1 , 2
    • SET command SPACE variable 1 , 2
    • SET command TRUNCATE variable 1 , 2
    • SHOW command LABEL variable 1
    • TTITLE command old form 1
  • OCI Instant Client 1
  • OCI package
    • basic 1
    • lightweight 1
  • OF clause 1
  • OFF clause
    • in ATTRIBUTE command 1
    • in COLUMN command 1 , 2
    • in REPFOOTER commands 1
    • in REPHEADER commands 1
    • in SPOOL command 1 , 2
    • in TTITLE and BTITLE commands 1 , 2
  • OLD_VALUE clause 1 , 2
  • ON clause
    • in ATTRIBUTE command 1
    • in COLUMN command 1 , 2
    • in TTITLE and BTITLE commands 1
  • ON column clause
    • in BREAK command 1
    • in COMPUTE command 1 , 2
  • ON expr clause
    • in BREAK command 1
    • in COMPUTE command 1
  • online help 1 , 3
  • ON REPORT clause
    • in BREAK command 1 , 2
    • in COMPUTE command 1 , 2
  • ON ROW clause
    • in BREAK command 1 , 2
    • in COMPUTE command 1
  • OPEN clause 1
  • opening a database 1
  • operating system
    • editor 1 , 2 , 3
    • file, loading into buffer 1
    • running commands from SQL*Plus 1 , 2
    • text editor 1
  • ORA_EDITION
    • environment variables 1
  • ORA_NLS10
    • environment variables 1
  • ORACLE_HOME
    • environment variables 1
  • ORACLE_PATH
    • environment variables 1
  • ORACLE_SID
    • environment variables 1
  • Oracle10g
    • globalization support 1
  • Oracle Application Editions
    • edition 1
  • Oracle Database Client 1
  • Oracle Net
    • configuring 1
    • connect identifier 1
  • Oracle Session Editions
    • edition 1
  • ORDER BY clause
    • displaying column values in titles 1
    • displaying values together in output 1
  • ORDERING variable 1
  • ORDERING XQUERY option 1
  • OUT clause 1 , 2
  • output
    • formatting white space in 1 , 2
    • pausing during display 1 , 2

P

  • packages
    • SQL*Plus and OCI for Instant Client 1
  • PAGE clause 1
  • page number, including in titles 1 , 2
  • pages
    • changing length 1 , 2 , 3 , 4
    • default dimensions 1
    • matching to screen or paper size 1
    • setting dimensions 1
  • PAGESIZE clause
    • in LOGIN.SQL 1
  • PAGESIZE variable 1 , 2 , 3 , 4 , 5
  • parameter
    • SQLPATH 1
  • parameter files (INIT.ORA files)
    • specifying alternate 1
  • PARAMETERS clause 1
  • password
    • changing with the PASSWORD command 1
    • in CONNECT command 1 , 2
    • in COPY command 1 , 2 , 3
    • in SQLPLUS command 1 , 2
    • viewable warning 1
  • PASSWORD command 1 , 2
  • PATH
    • environment variables 1
  • PAUSE command 1 , 2
  • PAUSE variable 1 , 2 , 3
  • PDBS clause 1
  • performance
    • of SQL statements 1
    • over dial-up lines 1
  • period (.)
    • terminating PL/SQL blocks 1 , 2 , 3
  • PL/SQL
    • blocks, PL/SQL 1
    • executing 1
    • formatting output in SQL*Plus 1
    • listing definitions 1
    • mode in SQL*Plus 1
    • within SQL commands 1
  • PLAN_TABLE
    • creating 1
    • table 1
  • PLUGGABLE DATABASE clause 1
  • PLUSTRACE
    • creating role 1
    • role 1
  • PNO clause 1
  • pound sign (#) 1
  • predefined variable
    • _CONNECT_IDENTIFIER 1 , 2
    • _DATE 1
    • _EDITOR 1 , 2 , 4
    • _O_RELEASE 1
    • _O_VERSION 1
    • _PRIVILEGE 1
    • _RC 1
    • _SQLPLUS_RELEASE 1
    • _USER 1
  • PREFORMAT 1
  • PREFORMAT clause 1
  • PRINT clause 1
  • PRINT command 1
  • printing
    • bind variables automatically 1
    • REFCURSOR variables 1
    • SPOOL command 1
  • Product User Profile table 1
  • prompt
    • SET SQLPROMPT 1 , 2 , 3
  • PROMPT clause 1 , 2
  • PROMPT command
    • customizing prompts for value 1
  • prompts for value
    • bypassing with parameters 1
    • customizing 1
    • through ACCEPT 1
    • through substitution variables 1
  • PUPBLD.SQL 1

Q

  • queries
    • in COPY command 1 , 2
    • show number of records retrieved 1 , 2 , 3
    • tracing 1 , 2
  • query execution path
    • including in report 1
  • query results
    • displaying on-screen 1
    • sending to a printer 1 , 2
    • storing in a file 1 , 2
  • QUIT command 1 , 2
    • See also: EXIT
  • QUOTE clause 1

R

  • RAW
    • column definition from DESCRIBE 1
  • record separators, printing 1 , 2 , 3
  • RECOVER clause 1
  • RECOVER command
    • and database recovery 1
    • AUTOMATIC clause 1
    • CANCEL clause 1
    • CONTINUE clause 1
    • DATABASE clause 1
    • FROM clause 1
    • LOGFILE clause 1
    • NOPARALLEL clause 1
    • SNAPSHOT TIME date clause 1
    • STANDBY DATABASE clause 1
    • STANDBY DATAFILE clause 1
    • STANDBY TABLESPACE clause 1
    • UNTIL CANCEL clause 1
    • UNTIL CONTROLFILE clause 1
    • UNTIL TIME clause 1
    • USING BACKUP CONTROL FILE clause 1
  • recovery
    • RECOVER command 1
  • RECSEPCHAR variable 1 , 2 , 3
  • RECSEP variable 1 , 2 , 3
  • REFCURSOR bind variables
    • in a stored function 1
  • REFCURSOR clause
    • VARIABLE command 1
  • registry
    • editor 1
  • registry entry
    • SQLPATH 1 , 2
  • RELEASE clause 1
  • REMARK command 1 , 2
  • removing sample tables 1
  • REPFOOTER clause 1
  • REPFOOTER command
    • aligning footer elements 1
    • BOLD clause 1
    • CENTER clause 1
    • COL clause 1
    • FORMAT clause 1
    • indenting report footers 1
    • LEFT clause 1
    • OFF clause 1
    • RIGHT clause 1
    • SKIP clause 1
    • suppressing current definition 1
    • TAB clause 1
  • REPHEADER clause 1
  • REPHEADER command
    • aligning header elements 1
    • aligning heading elements 1
    • BOLD clause 1
    • CENTER clause 1
    • COL clause 1
    • FORMAT clause 1
    • indenting headings 1
    • LEFT clause 1
    • OFF clause 1
    • PAGE clause 1
    • RIGHT clause 1
    • SKIP clause 1
    • suppressing current definition 1
    • TAB clause 1
  • REPLACE clause
    • in COPY command 1 , 2
    • in SAVE command 1 , 2
  • reports
    • autotrace 1
    • breaks 1
    • clarifying with spacing and summary lines 1
    • columns 1
    • creating bottom titles 1 , 2 , 3
    • creating footers 1
    • creating headers 1
    • creating headers and footers 1
    • creating master/detail 1 , 2
    • creating top titles 1 , 2 , 3
    • csv 1
    • CSV example 1
    • displaying 1 , 2
    • formatting column headings 1 , 2
    • formatting columns 1 , 2 , 3
    • interactive HTML example 1
    • on the web 1
    • SILENT mode 1
    • starting on a new page 1
    • title 1 , 2
  • RESTRICT 1 , 2 , 3
  • return code, specifying 1 , 2 , 3
  • REVOKE command 1
  • RIGHT clause 1 , 2 , 3
  • roles
    • disabling 1
    • re-enabling 1
  • ROLLBACK clause
    • WHENEVER OSERROR 1
    • WHENEVER SQLERROR 1
  • row data
    • setting prefetch size 1
  • ROWID
    • column definition from DESCRIBE 1
  • ROWPREFETCH clause 1
  • ROWPREFETCH variable 1
  • rows
    • performing computations on 1 , 2
    • setting number retrieved at one time 1 , 2 , 3
    • setting the number after which COPY commits 1
  • RUN clause 1
  • RUN command
    • executing current PL/SQL block 1
    • making last line current 1
    • similar to / (slash) command 1

S

  • sample schemas
    • see Oracle Database Sample Schemas guide 1
    • using HR in COLUMN example 1
    • using HR in examples 1 , 2
  • sample tables
    • access to 1
    • creating 1
    • removing 1
    • unlocking 1
  • SAVE command
    • APPEND clause 1
    • CREATE clause 1
    • REPLACE clause 1
    • storing commands in scripts 1
    • using with INPUT to create scripts 1
  • saving environment attributes 1
  • SCAN variable 1 , 2
  • schemas
    • command 1
    • database 1
    • DESCRIBE parameter 1
    • disabled commands 1
    • HR sample 1
    • installing own copy of HR 1
    • sample 1
    • SHOW parameter 1
    • unlocking HR 1
    • using HR in COLUMN example 1
    • using HR in examples 1 , 2
  • SCREEN clause 1 , 2
  • screens
    • clearing 1 , 2
  • scripts
    • extension 1 , 2 , 3
    • registering 1
  • scripts, authenticating users in 1
  • SECUREDCOL variable 1
  • security
    • changing password 1
    • nolongontime 1
    • password viewable 1
    • PRODUCT_USER_PROFILE table 1
    • RESTRICT 1 , 2
  • SELECT command
    • and BREAK command 1 , 2
    • and COLUMN command 1
    • and COMPUTE command 1
    • and COPY command 1 , 2
    • and DEFINE command 1
    • and ORDER BY clause 1
    • formatting results 1 , 2
  • semicolon (;)
    • in PL/SQL blocks 1
    • in SQL*Plus commands 1 , 2
    • in SQL commands 1 , 2
    • not stored in buffer 1
  • SERVEROUTPUT variable 1
  • service name
    • in COPY command 1 , 2 , 3
  • Session Editions 1
  • SET AUTOTRACE 1
  • SET clause 1
  • SET command
    • APPINFO variable 1 , 2
    • ARRAYSIZE variable 1 , 2 , 3 , 4
    • AUTOCOMMIT variable 1 , 2
    • AUTOPRINT variable 1 , 2 , 3
    • AUTORECOVERY variable 1 , 3
    • AUTOTRACE variable 1
    • BLOCKTERMINATOR variable 1 , 2
    • BUFFER variable 1
    • CLOSECURSOR variable 1 , 2
    • CMDSEP variable 1 , 2
    • COLINVISIBLE variable 1
    • COLSEP variable 1 , 2 , 3
    • COMPATIBILITY variable 1 , 2
    • CONCAT variable 1 , 3 , 4
    • COPYCOMMIT variable 1 , 2 , 3
    • COPYTYPECHECK variable 1 , 2
    • DEFINE clause 1
    • DEFINE variable 1
    • DESCRIBE variable 1 , 2
    • DOCUMENT variable 1 , 2
    • ECHO variable 1 , 2
    • EDITFILE variable 1 , 2
    • EMBEDDED variable 1 , 2
    • ERRORLOGGING variable 1
    • ESCAPE variable 1 , 2 , 6
    • ESCCHAR variable 1
    • EXITCOMMIT variable 1
    • FEEDBACK variable 1 , 2
    • FLAGGER variable 1 , 2
    • FLUSH variable 1 , 2 , 3
    • HEADING variable 1
    • HEADSEP variable 1 , 2 , 3
    • HISTORY variable 1
    • INSTANCE variable 1 , 2
    • LINESIZE variable 1 , 2 , 3 , 4
    • LOBOFFSET variable 1 , 2
    • LOBPREFETCH variable 1
    • LOGSOURCE variable 1 , 2
    • LONGCHUNKSIZE variable 1 , 2
    • LONG variable 1 , 2 , 3
    • MARKUP clause 1
    • MAXDATA variable 1 , 2
    • NEWPAGE variable 1 , 2 , 3
    • NULL variable 1 , 2
    • NUMFORMAT clause 1
    • NUMFORMAT variable 1 , 2
    • NUMWIDTH variable 1 , 2 , 3 , 4
    • PAGESIZE clause 1
    • PAGESIZE variable 1 , 2 , 3 , 4 , 5
    • PAUSE variable 1 , 2
    • RECSEPCHAR variable 1 , 2 , 3
    • RECSEP variable 1 , 2 , 3
    • ROWPREFETCH variable 1
    • SCAN variable 1 , 2
    • SECUREDCOL variable 1
    • SERVEROUTPUT variable 1
    • SHIFTINOUT variable 1 , 2
    • SPACE variable 1 , 2
    • SQLBLANKLINES variable 1
    • SQLCASE variable 1 , 2
    • SQLCONTINUE variable 1 , 2
    • SQLNUMBER variable 1 , 2
    • SQLPLUSCOMPATIBILITY variable 1 , 2
    • SQLPREFIX variable 1 , 2
    • SQLPROMPT variable 1 , 2 , 3
    • SQLTERMINATOR variable 1 , 2
    • STATEMENTCACHE variable 1
    • substitution variable 1
    • SUFFIX variable 1 , 2
    • TAB variable 1 , 2 , 3
    • TERMOUT variable 1 , 2 , 3
    • TIME variable 1 , 2
    • TIMING variable 1 , 2
    • TRIMOUT variable 1 , 2
    • TRIMSPOOL variable 1 , 2
    • TRUNCATE variable 1 , 2
    • UNDERLINE variable 1 , 2
    • used to format a REFCURSOR variable 1
    • VERIFY clause 1
    • VERIFY variable 1 , 3 , 4
    • WRAP variable 1 , 2 , 3
    • XMLOPTIMIZATIONCHECK variable 1 , 2
    • XQUERY BASEURI variable 1
    • XQUERY CONTEXT variable 1
    • XQUERY NODE variable 1
    • XQUERY ORDERING variable 1
  • SET HISTORY command 1
  • SET LOBPREFETCH command 1
  • SET MARKUP
    • BODY clause 1
    • CSV 1 , 2
    • CSV example 1
    • DELIMITER clause 1
    • ENTMAP clause 1 , 2
    • HEAD clause 1
    • HTML 1
    • interactive HTML example 1
    • PREFORMAT clause 1
    • QUOTE clause 1
    • TABLE clause 1
  • SET ROWPREFETCH command 1
  • SET STATEMENTCACHE command 1
  • SET system variable summary 1
  • SET variables 1
    • See: system variables
  • SET XQUERY BASEURI 1
  • SET XQUERY CONTEXT 1
  • SET XQUERY NODE 1
  • SET XQUERY ORDERING 1
  • SGA clause 1
  • SHIFTINOUT variable 1 , 2
  • SHOW
    • schema parameter 1
  • SHOW clause 1
  • SHOW command
    • ALL clause 1
    • BTITLE clause 1
    • CON_ID clause 1
    • CON_NAME clause 1
    • ERRORS clause 1
    • HISTORY clause 1
    • LABEL variable 1
    • listing current page dimensions 1
    • LNO clause 1
    • LOBPREFETCH clause 1
    • PDBS clause 1
    • PNO clause 1
    • RELEASE clause 1
    • REPFOOTER clause 1
    • REPHEADER clause 1
    • ROWPREFETCH clause 1
    • SPOOL clause 1
    • SQLCODE clause 1
    • STATEMENTCACHE clause 1
    • TTITLE clause 1
    • USER clause 1
    • XQUERY clause 1
  • SHOWMODE variable 1 , 3
  • SHUTDOWN command
    • ABORT 1
    • IMMEDIATE 1
    • NORMAL 1
    • TRANSACTIONAL LOCAL 1
  • site profile
    • glogin 1 , 2 , 3 , 4 , 5
  • SKIP clause
    • in BREAK command 1 , 2 , 3
    • in REPHEADER and REPFOOTER commands 1
    • in TTITLE and BTITLE commands 1 , 2
    • used to place blank lines before bottom title 1
  • SKIP PAGE clause 1 , 2 , 3
  • slash (/) command
    • files loaded with GET command 1
  • SPACE variable 1 , 2
  • SPOOL clause 1 , 2
  • SPOOL command
    • APPEND clause 1
    • CREATE clause 1
    • file name 1 , 2
    • OFF clause 1 , 2
    • OUT clause 1 , 2
    • REPLACE clause 1
    • to HTML file 1
    • turning spooling off 1 , 2
    • use with SET MARKUP 1
  • SQL.PNO, referencing in report titles 1
  • SQL.SQLCODE
    • using in EXIT command 1
  • SQL*Plus
    • command history 1
    • command prompt 1
    • command summary 1
    • configuring globalization support 1
    • configuring Oracle Net 1
    • database administration 1
    • environment variables 1
    • error messages 1
    • execution plan 1
    • exiting 1 , 2
    • limits 1
    • obsolete command alternatives 1
    • setting up environment 1
    • starting 1 , 2 , 3
    • statistics 1
    • system variables affecting performance 1
    • tuning 1
    • who can use 1
  • SQL*Plus and OCI packages 1
  • SQL*Plus command-line vs SQL*Plus Instant Client 1
  • SQL*Plus Instant Client
    • basic 1
    • installation 1
    • lightweight 1
    • NLS_LANG 1
    • NLS_LANG charset parameter 1
    • NLS_LANG language parameter 1
    • NLS_LANG territory parameter 1
    • required files in packages 1
    • unsupported charset error 1
  • SQLBLANKLINES variable 1 , 2
  • SQLCASE variable 1 , 2
  • SQL clause 1
  • SQLCODE clause
    • SHOW command 1
  • SQLCONTINUE variable 1 , 2
  • SQL DML statements
    • reporting on 1 , 2
  • SQLNUMBER variable 1 , 3 , 4
  • SQL optimizer 1
  • SQLPATH
    • environment variables 1
    • registry entry 1 , 2
  • SQLPLUS command
    • -? clause 1
    • /NOLOG clause 1
    • -AC clause 1
    • -AC option 1
    • and @ (at sign) 1
    • and EXIT FAILURE 1
    • Application Editions 1
    • BODY option 1
    • - clause 1
    • commands
      • SQLPLUS 1
    • connect identifier 1
    • CSV option 1
    • display syntax 1
    • edition 1
    • ENTMAP option 1
    • HEAD option 1
    • HTML option 1
    • -MARKUP clause 1 , 3
    • -MARKUP option 1
    • nolongontime 1
    • PREFORMAT option 1
    • RESTRICT 1 , 2
    • service name 1
    • -SILENT clause 1
    • -SILENT option 1 , 2
    • SPOOL clause 1
    • syntax 1
    • SYSASM clause 1
    • SYSBACKUP clause 1
    • SYSDBA clause 1
    • SYSDG clause 1
    • SYSKM clause 1
    • SYSOPER clause 1
    • SYSRAC clause 1
    • TABLE option 1
    • unsuccessful connection 1
    • username/password 1 , 2
  • SQLPREFIX variable 1 , 2
  • SQLPROMPT variable 1 , 2 , 3
  • SQLTERMINATOR variable 1 , 2 , 3 , 4
  • STANDBY DATAFILE clause 1
  • STANDBY TABLESPACE clause 1
  • START clause 1
  • START command
    • arguments 1
    • passing parameters to a script 1
    • script 1 , 2
    • similar to @ (at sign) command 1 , 2 , 3
    • similar to @@ (double at sign) command 1
  • starting
    • SQL*Plus 1 , 2 , 3
  • STARTUP command
    • DOWNGRADE clause 1
    • FORCE clause 1
    • MOUNT clause 1
    • NOMOUNT clause 1
    • OPEN clause 1
    • PFILE clause 1
    • PLUGGABLE DATABASE clause 1
    • RECOVER clause 1
    • RESTRICT clause 1
    • specifying a database 1
    • UPGRADE clause 1
  • statement cache
    • setting size 1
  • STATEMENTCACHE clause 1
  • STATEMENTCACHE variable 1
  • statistics
    • collecting TIMING statistics 1
  • STOP clause 1
  • stop query 1
  • STORE command
    • SET clause 1
  • stored functions 1
  • stored procedures
    • creating 1
  • subkey, registry 1
  • substitution variables
    • _EDITOR 1
    • appending characters immediately after 1
    • avoiding unnecessary prompts for value 1
    • concatenation character 1 , 2
    • DEFINE command 1
    • defining 1 , 2 , 3
    • deleting 1 , 2
    • displaying in headers and footers 1
    • displaying in titles 1
    • in ACCEPT command 1 , 2
    • listing definitions 1 , 3
    • parsing 1
    • prefixing 1 , 2
    • related system variables 1
    • restrictions 1
    • single and double ampersands 1
    • system variables used with 1
    • undefined 1
    • where and how to use 1
  • SUFFIX variable
    • used with EDIT command 1
    • used with GET command 1
    • used with SAVE command 1
    • used with START command 1
  • SUM function 1
  • summary lines
    • computing and printing 1 , 2
    • computing and printing at ends of reports 1
    • computing same type on different columns 1
    • printing grand and sub summaries (totals) 1
    • printing multiple on same break column 1
  • syntax
    • COPY command 1
  • syntax rules
    • SQL*Plus commands 1
    • SQL commands 1
  • SYSASM clause 1 , 2
  • SYSBACKUP clause 1 , 2
  • SYSDBA clause 1 , 3
  • SYSDG clause 1 , 2
  • SYSKM clause 1 , 2
  • SYSOPER clause 1 , 2
  • SYSRAC clause 1 , 2
  • system-maintained values
    • displaying in headers and footers 1
    • displaying in titles 1 , 2
    • formatting in titles 1
  • system variables
    • affecting SQL*Plus performance 1
    • affecting substitution variables 1
    • listing current settings 1 , 2
    • listing old and new values 1 , 2
    • storing and restoring 1
    • summary of SET commands 1

T

  • TAB clause 1 , 2
  • TABLE clause 1
  • TABLE option 1
  • tables
    • access to sample 1
    • controlling destination when copying 1 , 2
    • copying values between 1 , 2
    • listing column definitions 1 , 2
    • referring to another user’s when copying 1
  • TABLESPACE clause 1
  • tablespaces, recovering 1
  • TAB variable 1 , 2 , 3
  • tag, HTML 1
  • TERMOUT variable
    • using with SPOOL command 1
  • territory
    • SQL*Plus Instant Client 1
  • text
    • adding to current line with APPEND 1 , 2
    • changing old to new with CHANGE 1 , 2
    • clearing from buffer 1 , 2
  • text editor
    • operating system 1 , 2
  • TIME variable 1 , 2
  • TIMING clause 1
  • TIMING command
    • deleting all areas created by 1
    • deleting current area 1
    • SHOW clause 1
    • START clause 1
    • STOP clause 1
  • TIMING variable 1 , 2
  • titles
    • aligning elements 1 , 2
    • displaying at bottom of page 1 , 2 , 3
    • displaying at top of page 1 , 2 , 3
    • displaying column values 1 , 2
    • displaying current date 1 , 2
    • displaying page number 1 , 2
    • displaying system-maintained values 1 , 2
    • formatting elements 1
    • formatting system-maintained values in 1
    • indenting 1 , 2
    • listing current definition 1 , 2 , 3
    • restoring definition 1
    • setting at start or end of report 1
    • setting lines from top of page to top title 1 , 2 , 3 , 4
    • setting lines from top title to end of page 1 , 2 , 3
    • setting top and bottom 1 , 2 , 3 , 4
    • spacing between last row and bottom title 1
    • suppressing definition 1 , 2
  • TNS_ADMIN
    • environment variables 1
  • TO clause 1
  • tracing queries 1 , 2
  • tracing statements
    • for performance statistics 1
    • for query execution path 1
    • with parallel query option 1
  • TRIMOUT variable 1 , 2
  • TRIMSPOOL variable 1 , 2
  • TRUNCATED clause 1 , 2
  • TRUNCATE variable 1 , 2
  • TTITLE clause 1
  • TTITLE command
    • aligning title elements 1 , 2
    • BOLD clause 1
    • CENTER clause 1 , 2
    • COL clause 1 , 2
    • FORMAT clause 1 , 2
    • indenting titles 1 , 2
    • LEFT clause 1 , 2
    • listing current definition 1 , 2
    • OFF clause 1 , 2
    • old form 1
    • ON clause 1
    • referencing column value variable 1 , 2
    • restoring current definition 1
    • RIGHT clause 1 , 2
    • SKIP clause 1 , 2
    • suppressing current definition 1 , 2
    • TAB clause 1
  • tuning
    • SET APPINFO OFF 1
    • SET ARRAYSIZE 1
    • SET DEFINE OFF 1
    • SET FLUSH OFF 1
    • SET TRIMOUT ON 1
    • SET TRIMSPOOL ON 1
    • SQL*Plus 1
    • system variables 1
  • TWO_TASK
    • environment variables 1

U

  • UNDEFINE command
    • and DEFINE command 1
  • UNDERLINE variable 1 , 2
  • unicode 1
  • UNIX
    • ed 1
    • installing SQL*Plus Instant Client 1
    • SQL*Plus Instant Client files to copy 1
  • unlocking sample tables 1
  • UNTIL CANCEL clause 1
  • UNTIL CHANGE clause 1
  • UNTIL CONTROLFILE clause 1
  • UNTIL TIME clause 1
  • USER clause 1
  • username
    • connecting under different 1 , 2
    • in CONNECT command 1 , 2
    • in COPY command 1 , 2 , 3
    • in SQLPLUS command 1 , 2
  • user profile
    • glogin.sql 1
    • login.sql 1 , 2
  • user variable
    • See: substitution variable
  • USING BACKUP CONTROL FILE clause 1
  • USING clause 1 , 2
  • UTF-8 1

V

  • V$SESSION virtual table 1
  • V$SQLAREA virtual table 1
  • VARCHAR2
    • column definition from DESCRIBE 1
  • VARCHAR2 clause
    • VARIABLE command 1
  • VARCHAR2 columns
    • changing format 1
    • default format 1
  • VARCHAR columns
    • default format 1
  • VARIABLE command
    • BINARY_DOUBLE clause 1
    • BINARY_FLOAT clause 1
    • CHAR clause 1
    • CLOB clause 1
    • NCHAR clause 1
    • NCLOB clause 1
    • NUMBER clause 1
    • REFCURSOR clause 1
    • value clause 1
    • VARCHAR2 clause 1
    • variable clause 1
  • variables
    • bind variables 1
    • substitution variables 1
    • system variables 1
  • VERIFY clause 1
  • VERIFY variable 1 , 3 , 4

W

  • WARNING clause 1
  • web, outputting reports 1
  • web browser 1
  • WHENEVER OSERROR command
    • COMMIT clause 1
    • CONTINUE clause 1
    • EXIT clause 1
    • NONE clause 1
    • ROLLBACK clause 1
  • WHENEVER SQLERROR command
    • COMMIT clause 1
    • CONTINUE clause 1
    • EXIT clause 1
    • NONE clause 1
    • ROLLBACK clause 1
  • Windows
    • installing SQL*Plus Instant Client 1
    • notepad 1
    • SQL*Plus Instant Client files to copy 1
  • WORD_WRAPPED clause 1 , 2 , 3
  • WRAPPED clause 1 , 2
  • WRAP variable 1 , 2 , 3

X

  • XMLOPTIMIZATIONCHECK variable 1 , 2
  • XMLType
    • column definition from DESCRIBE 1
    • column formatting 1
    • column width 1
    • creating 1
    • formatting in reports 1
    • inserting values 1
    • selecting data 1
    • setting column retrieval size 1 , 2
    • setting maximum column width 1
  • XQUERY clause 1
  • XQUERY command 1
  • XQUERY options
    • BASEURI 1
    • CONTEXT 1
    • NODE 1
    • ORDERING 1