Index

A

A (APPEND) command, Line-Editing Commands, APPEND, APPEND
ABORT parameter (SHUTDOWN), SHUTDOWN ABORT, SHUTDOWN
aborting database instance, SHUTDOWN ABORT, SHUTDOWN
ACC[EPT] command, Prompting for Values, Using ACCEPT to get the table name, ACCEPT
in extract scripts, Make Your Extract Script User-Friendly
format specifications with, SQL*Plus Format Elements, Formatting Numbers, Formatting Character Strings, Formatting Dates
validating user input, Validating Input with ACCEPT, ACCEPTing date values
access method hints, Access method hints, Access method hints
administration, Administration with SQL*Plus, Other Things You Need to Know
automating routine tasks, Why Master SQL*Plus?
backup and recovery, Database Backup and Recovery, Other Things You Need to Know
RMAN for, Other Things You Need to Know
logging in as administrator, CONNECT, Connecting as SYSOPER or SYSDBA, CONNECT
looking at database, Looking at Your Database, Looking at Archive and Recovery Information
settings for, Database Administration Settings
starting/stopping databases, Starting and Stopping a Database, SHUTDOWN ABORT, SHUTDOWN, STARTUP
advancing to new page (reports), Setting the page advance
AFIEDT.BUF file, Invoking the Editor
ALI[AS] clause
ATTRIBUTE command, Formatting Object Columns, ATTRIBUTE
COLUMN command, The COLUMN command, COLUMN
ALL parameter
ARCHIVE LOG command, Manually archiving a log file, ARCHIVE LOG
SHOW command, The SHOW Command, SHOW
ALL views, The View Types: ALL, DBA, and USER, The View Types: ALL, DBA, and USER
ALL_COL_PRIVS view, The ALL_COL_PRIVS view, Table Security
ALL_CONSTRAINS view, The ALL_CONSTRAINTS view, Table Constraints
ALL_CONS_COLUMNS view, The ALL_CONS_COLUMNS view, Table Constraints, FOREIGN KEY constraints
ALL_INDEXES view, The ALL_INDEXES view, The ALL_INDEXES view, Indexes, The LIST_INDEXES.SQL script
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view, Indexes
ALL_SOURCE view, Describing Stored Functions and Procedures
ALL_SYNONYMS view, The ALL_SYNONYMS view, Looking at Synonyms
ALL_TABLES view, Describing a Table, The ALL_TABLES view, The ALL_TABLES view, Tables
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view, Tables
ALL_TAB_PRIVS view, The ALL_TAB_PRIVS view, Table Security
ALL_TRIGGERS view, The ALL_TRIGGERS view, Triggers
ALL_TRIGGER_COLS view, The ALL_TRIGGER_COLS view, Triggers
ALL_USERS view, Describing a Table
allocating cursors, The ANALYZE TABLE script revisited
ALL_ROWS hint, Optimizer goal hints
ALTER DATABASE command
archive log mode, Turning on archive log mode, Turning on archive log mode, Turning off archive log mode
ALTER SESSION command, formatting dates, Formatting the date
ALTER USER command, changing password with, PASSWORD
& (ampersand)
&& with substitution variables, Using Double-Ampersand Variables, A final caveat, Prompting for Values
changing for variable substitution, Changing the Substitution Variable Prefix Character
escaping, The Escape Character, Escaping an ampersand
marking variables, What Is a Substitution Variable?
prompting for variable values, Using Single-Ampersand Variables
ampersand (&)
&& with substitution variables, Using Double-Ampersand Variables, A final caveat, Prompting for Values
changing for variable substitution, Changing the Substitution Variable Prefix Character
escaping, The Escape Character, Escaping an ampersand
marking variables, What Is a Substitution Variable?
prompting for variable values, Using Single-Ampersand Variables
ANALYZE_TABLE.SQL (example), Generating a File of Commands, The ANALYZE TABLE script revisited, The ANALYZE TABLE script revisited
AND-EQUAL operation (EXPLAIN PLAN), Making sense of the results
AND_EQUAL hint, Access method hints
ANSI/ISO SQL92 syntax conformance checks, SET FLAGGER
A[PPEND] command, Line-Editing Commands, APPEND, APPEND
APPEND hint, Parallel execution hints
APP[END] parameter
COPY command, COPY
SAVE command, SAVE, SAVE, SAVE
STORE command, STORE
APPI[NFO] setting, SET APPINFO, SET APPINFO
application queries, testing, Testing application queries
application security (see security)
ARCH process, Looking at Archive and Recovery Information
starting, Starting the archive log process
archive destination value, Looking at Archive and Recovery Information, Displaying the archive log status
archive information, viewing, Looking at Archive and Recovery Information, SET LOGSOURCE
ARCHIVE LOG command, Looking at Archive and Recovery Information, Starting the archive log process, ARCHIVE LOG
archive log mode
turning off, Turning off archive log mode
turning on, Turning on archive log mode, Turning on archive log mode
ARCHIVELOG parameter (ALTER DATABASE), Turning on archive log mode
archiving databases, Archiving, Turning off archive log mode
ARRAY[SIZE] setting, SET ARRAYSIZE
AS keyword (CONNECT command), CONNECT, Connecting in an Administrative Role, CONNECT
* (asterisk)
identifying errors in SQL statements, If Your Statement Has an Error
line editing keyword, Line-Editing Commands, DEL, DEL, LIST
asterisk (*)
identifying errors in SQL statements, If Your Statement Has an Error
line editing keyword, Line-Editing Commands, DEL, DEL, LIST
@ command, Executing a Script, At Sign (@)
at sign (@)
@ command, Executing a Script, At Sign (@)
@@ command, Double At Sign (@@)
@@ command, Double At Sign (@@)
ATTRIBUTE command, Formatting Object Columns, Formatting Object Columns, ATTRIBUTE
AUFI (Advanced User Friendly Interface), History of SQL*Plus
authentication, Operating System Authentication
connecting using, Command-Line Options
AUTOEXEC.BAT file, loading with GET, GET
Automatic archival value, Looking at Archive and Recovery Information, Displaying the archive log status
AUTOP[RINT] setting, SET AUTOPRINT
autorecovery, Autorecovery, SET AUTORECOVERY
AUTORECOVERY setting, Autorecovery, SET AUTORECOVERY
AUTOT[RACE] setting, Using AUTOTRACE, Turning AUTOTRACE off, SET AUTOTRACE
AUTO[COMMIT] setting, SET AUTOCOMMIT
AVG parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
AVG_DATA_BLOCKS_PER_KEY column (ALL_INDEXES), The ALL_INDEXES view
AVG_LEAF_BLOCKS_PER_KEY column (ALL_INDEXES), The ALL_INDEXES view
AVG_ROW_LEN column (ALL_TABLES), The ALL_TABLES view
AVG_SPACE column (ALL_TABLES), The ALL_TABLES view
AVG_SPACE_FREELIST_BLOCKS column (ALL_TABLES), The ALL_TABLES view

B

BACKED_UP column (ALL_TABLES), The ALL_TABLES view
backing up databases, Database Backup and Recovery, Hot backups
cold backups, Backups, Cold backups
hot backups, Hot backups, Hot backups
RMAN (Recovery Manager), Other Things You Need to Know
(escape character), The Escape Character, Escaping an ampersand
backslash () as escape character, The Escape Character, Escaping an ampersand
BAD column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
BIN directory, The Working Directory
bind variables, Bind Variables, Testing application queries
declaring, Declaring Bind Variables, VARIABLE
displaying contents of, Displaying the Contents of a Bind Variable, SELECTing a bind variable
how to use, When and How to Use Bind Variables, Testing application queries
printing contents automatically, SET AUTOPRINT
substitution variables with, Using Bind Variables and Substitution Variables Together, From bind to substitution
BITMAP operation (EXPLAIN PLAN), Making sense of the results
blank lines in reports, Report output after formatting the columns, SET RECSEPCHAR
blank lines in SQL statements, SQLBLANKLINES
BLD_DB.SQL script file, Step 4: Run the BLD_DB.SQL script file
BLEVEL column (ALL_INDEXES), The ALL_INDEXES view
BLOCKS column (ALL_TABLES), The ALL_TABLES view
blocks, PL/SQL, What Is a PL/SQL Block?
executing, Executing a PL/SQL Block, Rules for entering PL/SQL blocks
execution error handling, The WHENEVER Command, PL/SQL errors and WHENEVER
execution errors, The WHENEVER Command, WHENEVER
output from execution, Where’s the output?, SET SERVEROUTPUT
syntax for, Rules for entering PL/SQL blocks
terminators for, BLOCKTERMINATOR
timing execution (see timers)
BLO[CKTERMINATOR] setting, BLOCKTERMINATOR
BOLD parameter
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
BOTH parameter (SET SHOWMODE), SET SHOWMODE
branching, Branching in SQL*Plus, Using a Scripting Language Instead
multilevel file structure for, Branching Using a Multilevel File Structure, Branching Using a Multilevel File Structure
PL/SQL for, Using PL/SQL, Using PL/SQL
scripting languages for, Using a Scripting Language Instead
simulating with REFCURSOR datatype, Using REFCURSOR Variables to Simulate Branching, Using REFCURSOR Variables to Simulate Branching
simulating with WHERE clause, Simulating Branching by Adjusting the WHERE Clause, Simulating Branching by Adjusting the WHERE Clause
SQL writing SQL, Using SQL to Write SQL, Using SQL to Write SQL
BRE[AK] command, Advanced Report Formatting, The BREAK Command, The BREAK Command, BREAK
grand totals in reports, Print Grand Totals
BRE[AKS] parameter (CLEAR), CLEAR
BTI[TLE] command, The bottom title, The bottom title, BTITLE
adding date to footers, Formatting the date
BTI[TLE] parameter (SHOW), The SHOW Command, SHOW
buffer, output, Where’s the output?
buffer, SQL, Running SQL Queries, The SQL Buffer, BUFFER
adding statements to, Getting a statement into the buffer
editing with text editor, The EDIT Command, Getting Back to SQL*Plus, EDIT
executing statements in, Executing the Statement in the Buffer, Doing It Again
line editing, Line Editing, Retyping a line
adding text to lines, APPEND
deleting lines, DEL
inserting lines, INPUT, Retyping a line
search-and-replace, CHANGE, CHANGE
viewing buffer contents, LIST, LIST
saving and retrieving, Saving and Retrieving the Buffer, GET
buffers
allowing operating system output buffers, SET FLUSH
switching, BUFFER
BUFFER_POOL column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
BUFF[ER] parameter (CLEAR), Line-Editing Commands, CLEAR
BUF[FER] setting, BUFFER

C

C (CHANGE) command, Line-Editing Commands, CHANGE, CHANGE, CHANGE
CACHE column (ALL_TABLES), The ALL_TABLES view
CACHE hint, Other hints
case (capitalization)
conversions, Listing Tables You Own, Branching Using a Multilevel File Structure
converting for server transmission, SQLCASE
displaying in output, SET SHIFTINOUT
CE[NTER] parameter
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
CHAIN_CNT column (ALL_TABLES), The ALL_TABLES view
C[HANGE] command, Line-Editing Commands, CHANGE, CHANGE, CHANGE
CHAR datatype, Building a control file for comma-delimited data, Declaring Bind Variables, VARIABLE
CHAR parameter (ACCEPT command), Syntax for the ACCEPT command
character sets
shift-insensitive, SET SHIFTINOUT
specifying, NLS_LANG
character strings (see strings)
CHARACTER_SET_NAME column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
CHECK constraints, CHECK constraints
checking syntax conformance, SET FLAGGER
CHOOSE hint, Optimizer goal hints
CLE[AR] parameter
ATTRIBUTE command, Formatting Object Columns, ATTRIBUTE
COLUMN command, The COLUMN command, COLUMN
CLOB datatype, Declaring Bind Variables, VARIABLE
printing, Printing CLOB variables, Printing CLOB variables
CLOSECUR[SOR] setting, SET CLOSECURSOR
CLOSE_CURSOR procedure (DMBS_SQL), The ANALYZE TABLE script revisited
CLUSTER hint, Access method hints
CLUSTERING_FACTOR column (ALL_INDEXES), The ALL_INDEXES view
CLUSTER_NAME column (ALL_TABLES), The ALL_TABLES view
CL[EAR] command, Line-Editing Commands, COMPUTE commands are cumulative, Stopping all timers, CLEAR
CMDS[EP] setting, CMDSEP
COL clause
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
cold database backups, Backups, Cold backups
COLSEP setting, Fixed-width, SET COLSEP
COL[UMN] command, The COLUMN command, Report output after formatting the columns, COLUMN
fixed-width data, creating, Fixed-width
format specifications with, SQL*Plus Format Elements, Formatting Character Strings
user variables, Retrieve the employee information into user variables
COLUMN_ID column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
COLUMN_LENGTH column (ALL_IND_COLUMNS), The ALL_IND_COLUMNS view
COLUMN_LIST column (ALL_TRIGGER_COLS), The ALL_TRIGGER_COLS view
COLUMN_NAME column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_CONS_COLUMNS view, The ALL_CONS_COLUMNS view
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view
ALL_TRIGGER_COLS view, The ALL_TRIGGER_COLS view
COLUMN_POSITION column (ALL_IND_COLUMNS), The ALL_IND_COLUMNS view
column separator (fixed-width files), Fixed-width, SET COLSEP
COLUMN_USAGE column (ALL_TRIGGER_COLS), The ALL_TRIGGER_COLS view
columns in fixed-width datafiles, Fixed-Width Files, Fixed-width, Fixed-width
SQL*Loader control for, Building a control file for fixed-width data
columns in reports
formatting, Step 2: Format the Columns, Report output after formatting the columns
headings for, Column headings, SET HEADING
line break characters, SET HEADSEP
underline characters, SET UNDERLINE
object types for, Formatting Object Columns, Formatting Object Columns
suppressing duplicate values, Suppressing Duplicate Column Values
COL[UMNS] parameter (CLEAR), CLEAR
columns, index
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view, Indexes
improving performance, Creating Indexes
columns, table
ALL_CONS_COLUMNS view, The ALL_CONS_COLUMNS view, Table Constraints
ALL_TAB_COLUMNS, Tables
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view
listing definitions, DESCRIBE, Listing Column Definitions for a Table, Running LIST_COLUMNS
referenced in triggers, The ALL_TRIGGER_COLS view, Triggers
update privileges to, The ALL_COL_PRIVS view, Table Security
width for number display, SET NUMWIDTH
COL[UMN] command
formatting PRINT command output, The PRINT command
comma-delimited files, Delimited Files, Comma-delimited, Comma-delimited
SQL*Loader control file for, Building a control file for comma-delimited data
command filename extension, default, SUFFIX
command prompt, customizing, SET SQLPROMPT, SET TIME
line numbers in, SQLNUMBER
multiline statements, SQLCONTINUE
command-line options, Command-Line Options, Command-Line Options
command-line version of SQL*Plus, Command-Line Versus GUI Versions
starting, Starting the Command-Line Version, Starting the Command-Line Version
commands, SQL (see SQL)
commands, SQL*Plus
basic (list), Some Basic SQL*Plus Commands, DISCONNECT
disabling, Limiting Access to Commands, Re-enabling a command
echoing to display, Turning Command Echoing Off
suppressing, Turning Command Echoing Off, SET ECHO
errors in, inability to detect, The WHENEVER Command
executing single PL/SQL commands, Executing a Single PL/SQL Command, EXECUTE
generating files of, Generating a File of Commands, Generating a File of Commands
help on, HELP
input settings, Input Settings, SUFFIX
line editing, Line-Editing Commands, Retyping a line
multiple on one line, CMDSEP
operational settings, Operational Settings, SET FLUSH
reference pages, SQLPLUS, WHENEVER
SQL buffer, Running SQL Queries, The SQL Buffer, BUFFER
SQL to generate, DDL, Using SQL to Write SQL, Using SQL to Write SQL, Generating a File of Commands, Generating a File of Commands
commands, Unix, Creating a Unix Command
comment delimiters (/*...*/), The /* and */ Delimiters, Comment Delimiters (/*...*/)
commenting scrips, Commenting Your Scripts, Substitution Within Comments
commit frequency during COPY, SET COPYCOMMIT
COMMIT parameter
EXIT command, EXIT
QUIT command, QUIT
WHENEVER command, WHENEVER
COMMIT statement, disabling feedback from, Turning Feedback Off
COMP[UTE] command, The COMPUTE Command, Print Grand Totals, COMPUTE
CLEAR COMPUTES command with, COMPUTE commands are cumulative
COMP[UTES] parameter (CLEAR), CLEAR
COMP[UTES] parameter (CLEAR), COMPUTE commands are cumulative
COM[PATIBILITY] setting, SET COMPATIBILITY
concatenation character, The Concatenation Character, Changing the concatenation character
CONCATENATION operation (EXPLAIN PLAN), Making sense of the results
conditional execution, Branching in SQL*Plus, Using a Scripting Language Instead
multilevel file structure for, Branching Using a Multilevel File Structure, Branching Using a Multilevel File Structure
PL/SQL for, Using PL/SQL, Using PL/SQL
scripting languages for, Using a Scripting Language Instead
simulating with REFCURSOR datatype, Using REFCURSOR Variables to Simulate Branching, Using REFCURSOR Variables to Simulate Branching
simulating with WHERE clause, Simulating Branching by Adjusting the WHERE Clause, Simulating Branching by Adjusting the WHERE Clause
SQL writing SQL, Using SQL to Write SQL, Using SQL to Write SQL
CONNECT BY operation (EXPLAIN PLAN), Making sense of the results
CONN[ECT] command, CONNECT, CONNECT, CONNECT
connecting as administrator, Connecting in an Administrative Role, Connecting as INTERNAL
connecting to database (see logging into database)
CONN[ECT] command
default database for, SET INSTANCE
constraints, table, Table Constraints
ALL_CONSTRAINTS view, The ALL_CONSTRAINTS view, Table Constraints
listing, Listing the Constraints for a Table, Running the LIST_CONSTRAINTS script
type of, Different Constraint Types Need Different Queries, FOREIGN KEY constraints
CONSTRAINT_NAME column
ALL_CONSTRAINTS view, The ALL_CONSTRAINTS view
ALL_CONS_COLUMNS view, The ALL_CONS_COLUMNS view
CONSTRAINT_TYPE column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
continuation character, SQLCONTINUE
CONTINUE parameter (WHENEVER), WHENEVER
control file, SQL*Loader, The control file, Building a control file for fixed-width data
comma-delimited data, Building a control file for comma-delimited data
fixed-width data, Building a control file for fixed-width data
control files, listing, Cold backups
CONTROL= option (SQLLDR80 command), Loading the data
CONTROL_FILES initialization parameter, Cold backups
CON[CAT] setting, Turning off the concatenation feature, SET CONCAT
COPY command, COPY
checking datatypes, SET COPYTYPECHECK
commit frequency during, SET COPYCOMMIT
COPYC[OMMIT] setting, SET COPYCOMMIT
copyright information, displaying, Logging into a database, Command-Line Options
COPYTYPECHECK setting, SET COPYTYPECHECK
COUNT operation (EXPLAIN PLAN), Making sense of the results
COU[NT] parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
crash recovery, SHUTDOWN ABORT, Archiving
CRE[ATE] parameter
SAVE command, SAVE
STORE command, STORE
CRE[ATE] parameter
COPY command, COPY
SAVE command, SAVE
CREATE TRIGGER statement, Looking at Trigger Definitions
CSV (Comma Separated Values) format, Delimited Files, Comma-delimited, Comma-delimited
current line (line editor), The Current Line
Current log sequence value, Looking at Archive and Recovery Information, Displaying the archive log status
cursor allocation, The ANALYZE TABLE script revisited
customizing environment, Customizing Your SQL*Plus Environment, The SHOW Command
environment variables, Environment Variable Settings, PLUS_DFLT
setting, Setting an Environment Variable, Windows 3.1
SQL*Plus-related (list), Environment Variables That Affect SQL*Plus, PLUS_DFLT
startup scripts, The Site and User Profiles, The User Profile

D

data
extracting, Extracting and Loading Data, Extracting the Data, Make Your Extract Script User-Friendly
formatting the data, Format the Data, DDL
formulating queries, Formulate the Query
spooling extract to files, Spool the Extract to a File, Spool the Extract to a File
SQL*Plus limitations, Limitations of SQL*Plus
user-friendly scripts for, Make Your Extract Script User-Friendly, Make Your Extract Script User-Friendly
reloading extracted data, Extracting and Loading Data, Reloading the Data, Loading the data
logging, Loading the data, Loading the data
data dictionary views, Oracle’s Data Dictionary Views, The ALL_COL_PRIVS view, Finding More Information
data format specifications, SQL*Plus Format Elements, Formatting Dates
database administration (see adminstration)
Database Buffers value, Looking at the SGA
Database log mode value, Looking at Archive and Recovery Information, Displaying the archive log status
DATABASE parameter (RECOVER), Full database recovery, RECOVER
database sample in this book, Creating and Loading the Sample Tables, Step 4: Run the BLD_DB.SQL script file
data model (ERD), The Data Model
data of, The Data, The PROJECT_HOURS table
loading, Loading the Sample Data, Step 4: Run the BLD_DB.SQL script file
tables, The Tables
databases
archive and recovery information, Looking at Archive and Recovery Information, SET LOGSOURCE
backup and recovery, Database Backup and Recovery, Other Things You Need to Know
committing changes automatically, SET AUTOCOMMIT
data dictionary views, Oracle’s Data Dictionary Views, The ALL_COL_PRIVS view
displaying names in command prompt, SET SQLPROMPT
initialization parameters, viewing, Looking at Initialization Parameters
logging into, Step 3: Log into your Oracle database, Logging into a database, Making a mistake on the logon dialog
as administrator, Connecting for Administrative Purposes, Connecting as INTERNAL
CONN[ECT] command, CONNECT, CONNECT, CONNECT
default database for, SET INSTANCE
startup scripts, SQL*Plus Settings You Can Control, The User Profile
troubleshooting (GUI version), Making a mistake on the logon dialog
operational settings, Operational Settings, SET FLUSH
passwords for, changing, PASSWORD, PASSWORD
remote, connecting to, Logging into a database, Making a mistake on the logon dialog, Starting the Command-Line Version
SGA (System Global Area), Looking at the SGA, Looking at the SGA, SHOW
starting and stopping, Starting and Stopping a Database, SHUTDOWN ABORT, SHUTDOWN, STARTUP
tables of (see tables)
viewing object information, The DESCRIBE Command, Why DESCRIBE Is Not Enough, DESCRIBE
DATAFILE parameter (RECOVER), Tablespace and datafile recovery, RECOVER
datatypes, Declaring Bind Variables
checking when COPYing, SET COPYTYPECHECK
function return values, viewing, Describing Stored Functions and Procedures
returning column information, Notes about the LIST_COLUMNS script
SQL*Loader, Building a control file for comma-delimited data
DATA_DEFAULT column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DATA_LENGTH column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DATA_PRECISION column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DATA_SCALE column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DATA_TYPE column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DATA_TYPE_MOD column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DATE datatype (SQL*Loader), Building a control file for comma-delimited data
DATE parameter (ACCEPT), Syntax for the ACCEPT command, ACCEPTing date values
dates
current, in report headers, Getting the Current Date into a Header, Formatting the date
formatting, Formatting the date, Formatting Dates, Formatting Dates
prompting for with ACCEPT, Syntax for the ACCEPT command, ACCEPTing date values
validating, ACCEPTing date values, ACCEPTing date values
DBA (see administration)
DBA views, The View Types: ALL, DBA, and USER, The View Types: ALL, DBA, and USER
DBA_COL_PRIVS_MADE view, Table Security
DBA_TAB_PRIVS_MADE view, Table Security
DBMS_APPLICATION_INFO package, SET APPINFO, SET APPINFO
DBMS_JOBS SUBMIT procedure, Calling PL/SQL procedures and functions from SQL*Plus
DBMS_SQL package
executing DDL statements, The ANALYZE TABLE script revisited
REFCURSOR variables with, Using REFCURSOR variables
DBMS_STANDARD package, PL/SQL errors and WHENEVER
DB_LINK column (ALL_SYNONYMS), The ALL_SYNONYMS view
DDL (Data Definition Language), DDL Files
DDL files, DDL Files, DDL, The ANALYZE TABLE script revisited, The ANALYZE TABLE script revisited
executing, Executing DDL and DML
product user profile and, Issues related to PL/SQL
DECIMAL EXTERNAL datatype, Building a control file for comma-delimited data
declaring bind variables, Declaring Bind Variables, VARIABLE
DECODE function
returning column information, Notes about the LIST_COLUMNS script
returning table owners/names, Notes about the LIST_COLUMNS script
translating case, Listing Tables You Own, Branching Using a Multilevel File Structure
DEF[AULT] clause (ACCEPT), Syntax for the ACCEPT command, ACCEPT
default directory, changing, The Working Directory
DEFAULT_LENGTH column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DEFERRABLE column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
DEFERRED column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
DEF[INE] command, The DEFINE and UNDEFINE Commands, Usage notes, DEFINE
defining user variables, The DEFINE and UNDEFINE Commands, Deleting a variable, DEFINE
DEF[INE] setting, Enabling and Disabling Substitution, SET DEFINE
DEGREE clause (RECOVER), RECOVER
DEGREE column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
DEL command, Line-Editing Commands, DEL, DEL
DELETE_RULE column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
deleting, Spooling to a file
(see also suppressing)
repeating values in report columns, Suppressing Duplicate Column Values
variable definitions, A final caveat, The UNDEFINE Command
deleting lines from SQL buffer, DEL
delimited files, Delimited Files, Comma-delimited, Comma-delimited
SQL*Loader control file for, Building a control file for comma-delimited data
DENSITY column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
DESC[RIBE] command, The DESCRIBE Command, Why DESCRIBE Is Not Enough, DESCRIBE
DESCRIPTION column (ALL_TRIGGERS), The ALL_TRIGGERS view, Looking at Trigger Definitions
DESC[RIBE] command, DESCRIBE
directory, working, The Working Directory, The Working Directory
disabling commands, Limiting Access to Commands
disabling roles, Limiting Access to Roles, Re-enabling a role
DISC[ONNECT] command, DISCONNECT, DISCONNECT
display output
echoing
commands, Turning Command Echoing Off
multiline comments, The /* and */ Delimiters
examining/listing user variables, Examining a variable
feedback, Turning Feedback Off
prompt text, customizing, The PROMPT Command, Using PROMPT to explain the output
suppressing all, Spooling to a file, Formatting the date, Turning Off All Terminal Output, SET TERMOUT
prompting for values and, When TERMOUT is off, When TERMOUT is off, Prompting for Values
suppressing query output when tracing, Suppressing the query output
verification, Turning Verification Off, SET VERIFY
DISTINCT_KEYS column (ALL_INDEXES), The ALL_INDEXES view
DML (Data Manipulation Language), DML Files
DML files, DML Files, DML
executing, Executing DDL and DML
DOCUMENT command (obsolete), History of SQL*Plus, SET DOCUMENT
DOC[UMENT] setting, SET DOCUMENT
double at sign (@@) command, Double At Sign (@@)
double hyphen (--) for comments, Double Hyphens (- -), Double Hyphen (- -)
downloading scripts to make sample database, Step 1: Download and unzip the script files
DRIVING_SITE hint, Join operation hints
DUAL table, Getting the date from Oracle
dumb terminals, Line Editing
DUP[LICATES] parameter (BREAK command), The BREAK Command, BREAK
dynamic performance views, Granting Access to the Performance Views
dynamic SQL statements, The ANALYZE TABLE script revisited, The ANALYZE TABLE script revisited

E

EA[CH] parameter (SET RECSEP), SET RECSEP
ECHO setting, Turning Command Echoing Off, SET ECHO
echoing
commands, Turning Command Echoing Off, SET ECHO
multline comments, The /* and */ Delimiters
ED[IT] command, The EDIT Command, Getting Back to SQL*Plus, EDIT
EDITF[ILE] setting, SET EDITFILE
ED[IT] command
work file name, SET EDITFILE
elapsed time (see timers)
embedded reports, SET EMBEDDED, SET EMBEDDED
EMB[EDDED] setting, SET EMBEDDED, SET EMBEDDED
EMPLOYEE entity (sample database), The Data Model
EMPLOYEE table (sample database), The EMPLOYEE table
data of, The EMPLOYEE table
EMPTY_BLOCKS column (ALL_TABLES), The ALL_TABLES view
enabling commands, Re-enabling a command
enabling roles, Re-enabling a role
Enterprise Manager, Why DESCRIBE Is Not Enough
ENTRY parameter (SET FLAGGER), SET FLAGGER
environment variables, SQL*Plus Settings You Can Control, Environment Variable Settings, PLUS_DFLT
setting, Setting an Environment Variable, Windows 3.1
SQL*Plus-related (list), Environment Variables That Affect SQL*Plus, PLUS_DFLT
ERD for sample database, The Data Model
error handling, Error Handling, WHENEVER OSERROR
errors, If Your Statement Has an Error
ERR[ORS] parameter (SHOW), The SHOW Command, SHOW
escape character, The Escape Character, Escaping an ampersand
escaping substitution variable prefix, SET ESCAPE
ESC[APE] setting, Turning on the escape feature, SET ESCAPE
EXCLUSIVE parameter (STARTUP), STARTUP
EXEC[UTE] command, Executing a Single PL/SQL Command, From substitution to bind, EXECUTE
EXECUTE function (DBMS_SQL), The ANALYZE TABLE script revisited
executing
DDL and DML commands, Executing DDL and DML
PL/SQL blocks, Executing a PL/SQL Block, Rules for entering PL/SQL blocks
reports, Executing the report
scripts, Executing a Script, Executing a Script
scripts at startup, Command-Line Options, Starting the SQL*Plus executable, Starting the SQL*Plus executable
single PL/SQL commands, Executing a Single PL/SQL Command, EXECUTE
SQL buffer statements, Executing the Statement in the Buffer, Doing It Again
execution plans, Using EXPLAIN PLAN, Making sense of the results
AUTOTRACE setting, Using AUTOTRACE, Turning AUTOTRACE off
creating plan table, Creating the Plan Table
improving performance, Improving on EXPLAIN PLAN Results, Other hints
judging results, Knowing Good Results from Bad
understanding, Interpreting the Results, Making sense of the results
execution statistics, Showing statistics and the plan
EXIT clause (WHATEVER), WHENEVER SQLERROR, WHENEVER OSERROR
EXIT clause (WHENEVER), WHENEVER, WHENEVER
EXIT command, EXIT, EXIT
exiting
SQL*Plus, EXIT, EXIT
text editors, Getting Back to SQL*Plus
EXPLAIN PLAN command, Why Master SQL*Plus?, Tuning and Timing, Using EXPLAIN PLAN, Making sense of the results
creating plan table, Creating the Plan Table
judging results, Knowing Good Results from Bad
syntax for, Explaining a Query
understanding execution plans, Interpreting the Results, Making sense of the results
export command (Unix), Unix
EXP[LAIN] parameter (SET AUTOTRACE), SET AUTOTRACE
external text editors, The EDIT Command, Getting Back to SQL*Plus, EDIT
extracting data, Extracting and Loading Data, Extracting the Data, Make Your Extract Script User-Friendly
formaluting queries, Formulate the Query
formatting the data, Format the Data, DDL
reloading extracted data, Reloading the Data, Loading the data
logging, Loading the data, Loading the data
spooling data to files, Spool the Extract to a File, Spool the Extract to a File
SQL*Plus limitations, Limitations of SQL*Plus
user-friendly scripts for, Make Your Extract Script User-Friendly, Make Your Extract Script User-Friendly

F

failure codes, WHENEVER SQLERROR, WHENEVER OSERROR
FAILURE option
WHENEVER OSERROR command, WHENEVER OSERROR
WHENEVER SQLERROR command, WHENEVER SQLERROR
FAILURE parameter
EXIT command, EXIT
QUIT command, QUIT
feedback
settings for, Feedback Settings, SET VERIFY
turning off, Turning Feedback Off, Spool the Extract to a File
FEED[BACK] setting, Spooling to a file, Turning Feedback Off, SET FEEDBACK
FEED[BACK] setting
spooling data to file, Spool the Extract to a File
filename extension, default, SUFFIX
files
control files, listing, Cold backups
default extension for command files, SUFFIX
editing with text editors, Invoking the Editor
generating files of commands, Generating a File of Commands, Generating a File of Commands
initialization file, Cold backups
multilevel file structure, Branching Using a Multilevel File Structure, Branching Using a Multilevel File Structure
password file, The Oracle Password File
recovery of, Tablespace and datafile recovery
redo log files, saving, Archiving, Turning off archive log mode
saving SQL buffer, Saving and Retrieving the Buffer, GET
search path, setting, SQLPATH
sending report output to, Spooling to a file, Spooling to a file
spooling data to, Spool the Extract to a File, Spool the Extract to a File
SQL*Loader control file, The control file, Building a control file for fixed-width data
startup scripts, SQL*Plus Settings You Can Control, The User Profile
types of output files, Types of Output Files, DDL Files
working directory, The Working Directory, The Working Directory
FILTER operation (EXPLAIN PLAN), Making sense of the results
FIRST ROW operation (EXPLAIN PLAN), Making sense of the results
FIRST_ROWS hint, Optimizer goal hints
Fixed Size value (SGA), Looking at the SGA
fixed-width files, Fixed-Width Files, Fixed-width, Fixed-width
SQL*Loader control for, Building a control file for fixed-width data
FLAGGER setting, SET FLAGGER
FLOAT datatype, Notes about the LIST_COLUMNS script
FLU[SH] setting, SET FLUSH
FOLD_A[FTER] parameter (COLUMN command), The COLUMN command, COLUMN
FOLD_B[EFORE] parameter (COLUMN command), The COLUMN command, COLUMN
font size for reports, How many lines on a page?
footers and headers
report pages, Step 3: Add Page Headers and Footers, Report output with page titles, BTITLE, TTITLE
current date in, Getting the Current Date into a Header, Formatting the date
embedded reports and, SET EMBEDDED
user variables, Modify the page heading to print the employee name and ID, Printing data in a page footer
reports, Report Headers and Footers, An example
FOR UPDATE operation (EXPLAIN PLAN), Making sense of the results
FORCE parameter (STARTUP), STARTUP
foreign key constraints, FOREIGN KEY constraints
columns specified in, The ALL_CONS_COLUMNS view, Table Constraints
FOR[MAT] clause
ACCEPT command, Syntax for the ACCEPT command, ACCEPT
ATTRIBUTE command, Formatting Object Columns, ATTRIBUTE
BTITLE command, The bottom title, BTITLE
COLUMN command, The COLUMN command, Column display formats, COLUMN
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
FORMAT parameter (SET SERVEROUTPUT), Where’s the output?
format specifications, SQL*Plus Format Elements, Formatting Dates
formatting
columns (see COLUMN command)
columns in reports, Step 2: Format the Columns, Report output after formatting the columns
data, SQL*Plus Format Elements, Formatting Dates
data to be extracted, Format the Data, DDL
dates, Formatting the date
LONG column lengths, SET LONG
master/detail reports, Master/Detail Formatting, Printing data in a page footer
numbers, SET NUMFORMAT
object columns (reports), Formatting Object Columns, Formatting Object Columns
PRINT command output, The PRINT command
report pages, Step 4: Format the Page, Setting the page advance
settings for, Report Output and Format Settings, SET WRAP
word wrap, Where’s the output?, SET WRAP, Formatting Character Strings
formulating queries
designing reports, Step 1: Formulate the Query
extracting data, Formulate the Query
forward slash (/)
executing SQL buffer, Executing the Statement in the Buffer, Doing It Again, Forward Slash (/)
terminating PL/SQL blocks, Rules for entering PL/SQL blocks
terminating SQL statements, Running SQL Queries
FREELISTS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
FREELIST_GROUPS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
FROM parameter (COPY), COPY
full database recovery, Full database recovery
FULL hint, Access method hints
FULL parameter (SET FLAGGER), SET FLAGGER
functions
bind variables with, Calling PL/SQL procedures and functions from SQL*Plus, Calling PL/SQL procedures and functions from SQL*Plus
viewing information about, Describing Stored Functions and Procedures

G

GENERATED column
ALL_CONSTRAINTS view, The ALL_CONSTRAINTS view
ALL_INDEXES view, The ALL_INDEXES view
generating files of commands, Generating a File of Commands, Generating a File of Commands
generating reports (see reports)
GET command, GET, GET
global login file, The Site Profile
glogin.sql script (site profile), SQL*Plus Settings You Can Control, The Site Profile
grand totals in reports, Print Grand Totals, Print Grand Totals
GRANTABLE column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_TAB_VIEWS view, The ALL_TAB_PRIVS view
GRANTEE column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_TAB_VIEWS view, The ALL_TAB_PRIVS view
GRANTOR column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_TAB_VIEWS view, The ALL_TAB_PRIVS view
grants (see privileges)
GROUP BY clause, BREAK with, Suppressing Duplicate Column Values
GUI version of SQL*Plus, Command-Line Versus GUI Versions
starting, Starting the GUI Version, Missing the Product User Profile

H

HASH hint, Access method hints
HASH JOIN operation (EXPLAIN PLAN), Making sense of the results
hash joins, Join operation hints
HASH_AJ hint, Access method hints
headers and footers
report pages, Step 3: Add Page Headers and Footers, Report output with page titles, BTITLE, TTITLE
current date in, Getting the Current Date into a Header, Formatting the date
embedded reports and, SET EMBEDDED
user variables, Modify the page heading to print the employee name and ID, Printing data in a page footer
reports, Report Headers and Footers, An example
headers, report, Report Headers and Footers, An example
HEA[DING] clause (COLUMN command), The COLUMN command, Column headings, COLUMN
headings for report columns, Column headings, SET HEADING
line break characters, SET HEADSEP
underline characters, SET UNDERLINE
HEADS[EP] setting, SET HEADSEP
HEA[DING] setting, SET HEADING
help
commenting scripts, Commenting Your Scripts, Substitution Within Comments
HELP command, HELP, HELP, HELP
HELP MENU command, HELP
HELP not accessible message, HELP
HIDE parameter (ACCEPT), Syntax for the ACCEPT command, ACCEPT
HIGH_VALUE column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
hints, Tuning and Timing, Using Hints, Other hints
access method hints, Access method hints, Access method hints
join operation hints, Join operation hints
join order hints, Join order hints
optimizer goal hints, Optimizer goal hints
parallel execution hints, Parallel execution hints
HO[ST] command, HOST
hot database backups, Hot backups, Hot backups
- command-line option, Command-Line Options
-- (hyphens) for comments, Double Hyphens (- -), Double Hyphen (- -)
-? command-line option, Command-Line Options
hyphens (--) for comments, Double Hyphens (- -), Double Hyphen (- -)

I

I (INPUT) command, Line-Editing Commands, INPUT, Retyping a line, INPUT
IBM’s System R, History of SQL*Plus
IF statement (see branching)
immediate database shutdown, SHUTDOWN IMMEDIATE, SHUTDOWN
IMMEDIATE parameter
SET AUTOCOMMIT command, SET AUTOCOMMIT
SHUTDOWN command, SHUTDOWN IMMEDIATE, SHUTDOWN
importing data (see reloading extracted data)
INCLUDE_COLUMN column (ALL_INDEXES), The ALL_INDEXES view
INDEX hint, Access method hints, Access method hints
INDEX operation (EXPLAIN PLAN), Making sense of the results
indexes, Indexes, Running the LIST_INDEXES.SQL script
ALL_INDEXES view, The ALL_INDEXES view, The ALL_INDEXES view, Indexes, The LIST_INDEXES.SQL script
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view, Indexes
describing one (example), The SHOW_INDEX.SQL script, Running the SHOW_INDEX script
improving performance with, Creating Indexes
into LONG columns, SET LOBOFFSET
listing, Listing Indexes for a Table
listing all (example), The LIST_INDEXES.SQL script, Running the LIST_INDEXES.SQL script
INDEX_ASC hint, Access method hints
INDEX_COMBINE hint, Access method hints
INDEX_DESC hint, Access method hints
INDEX_FFS hint, Access method hints
INDEX_NAME column
ALL_INDEXES view, The ALL_INDEXES view
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view
INDEX_OWNER column (ALL_IND_COLUMNS), The ALL_IND_COLUMNS view
INDEX_TYPE column (ALL_INDEXES), The ALL_INDEXES view
INFILE clause (LOAD DATA command), Building a control file for comma-delimited data
initialization file, Cold backups
initialization parameters, viewing, Looking at Initialization Parameters
INITIAL_EXTENT column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
INI_TRANS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
INLIST ITERATOR operation (EXPLAIN PLAN), Making sense of the results
input (see user input)
I[NPUT] command, Line-Editing Commands, INPUT, Retyping a line, INPUT
input settings, Input Settings, SUFFIX
INSERT parameter (COPY), COPY
INSERT privileges, Looking at Table Security
INSERT statements, file of, DML
inserting lines into SQL buffer, INPUT, Retyping a line
INSTANCE setting, SET INSTANCE
INSTANCES column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
INSTANCES parameter (RECOVER), RECOVER
INTEGER EXTERNAL datatype, Building a control file for comma-delimited data
INTERMED[IATE] parameter (SET FLAGGER), SET FLAGGER
INTERNAL keyword (CONNECT command), CONNECT
INTERNAL parameter (CONNECT), Connecting as INTERNAL, CONNECT
INTERNAL role
connecting as, Connecting as INTERNAL, CONNECT
password for, The Oracle Password File
INTERSECTION operation (EXPLAIN PLAN), Making sense of the results
INTO TABLE clause (LOAD DATA command), Building a control file for comma-delimited data
INV[ISIBLE] parameter (SET SHIFTINOUT), SET SHIFTINOUT
IOT_NAME column (ALL_TABLES), The ALL_TABLES view
IOT_TYPE column (ALL_TABLES), The ALL_TABLES view
iterating (see looping)

J

Jacobs, Ken, History of SQL*Plus
join operation hints, Join operation hints
join order hints, Join order hints
JUS[TIFY] parameter (COLUMN command), The COLUMN command, COLUMN

K

key constraints, columns specified in, The ALL_CONS_COLUMNS view, Table Constraints

L

L (LIST) command, Line-Editing Commands, LIST, LIST, LIST
LABEL clause (COMPUTE command), Syntax of the COMPUTE command, Print Grand Totals, Syntax of the COMPUTE command
labels (see names)
language-specific settings, NLS_LANG
large object settings, Large Object Settings, SET LONGCHUNKSIZE
LAST keyword (line editor), Line-Editing Commands, DEL, DEL, LIST
LAST_ANALYZED column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view
LAST_CHANGE column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
LEAF_BLOCKS column (ALL_INDEXES), The ALL_INDEXES view
LE[FT] parameter
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
length (see size)
LIKE clause
ATTRIBUTE command, Formatting Object Columns, ATTRIBUTE
COLUMN command, The COLUMN command, COLUMN
line breaks in column headings, SET HEADSEP
line breaks in reports, Advanced Report Formatting, The BREAK Command, The BREAK Command, BREAK
line editing, Line Editing, Retyping a line
adding text to lines, APPEND
deleting lines from buffer, DEL
inserting lines, INPUT, Retyping a line
search-and-replace, CHANGE, CHANGE
viewing buffer contents, LIST, LIST
line numbers in command prompt, SQLNUMBER
line width of report pages, Setting the line width, Revisit the report width and the width of the remaining fields, SET LINESIZE
lines per page (reports), Step 4: Format the Page, Setting the page advance, SET NEWPAGE, SET PAGESIZE
LIN[ESIZE] setting, SET LINESIZE
LIN[ESIZE] setting, Setting the line width, Revisit the report width and the width of the remaining fields
LIST_COLUMNS.SQL (example), Listing Column Definitions for a Table, Running LIST_COLUMNS
L[IST] command, Line-Editing Commands, LIST, LIST
LIST_CONSTRAINTS.SQL (example), Listing the Constraints for a Table, Running the LIST_CONSTRAINTS script
LIST_INDEXES.SQL (example), The LIST_INDEXES.SQL script, Running the LIST_INDEXES.SQL script
LIS[T] option (GET command), GET, GET
LIST parameter (ARCHIVE LOG), Looking at Archive and Recovery Information, Displaying the archive log status, ARCHIVE LOG
LIST_SYN.SQL (example), The LIST_SYN script, Running the LIST_SYN.SQL script
LIST_TRIGGERS.SQL (example), The LIST_TRIGGERS.SQL script, Running the LIST_TRIGGERS script
listing user variables, Examining a variable
LNO parameter (SHOW), The SHOW Command, SHOW
LOAD DATA command (SQL*Loader), Building a control file for comma-delimited data
loading extracted data, Extracting and Loading Data, Reloading the Data, Loading the data
logging, Loading the data, Loading the data
loading sample database, Loading the Sample Data, Step 4: Run the BLD_DB.SQL script file
LOBOF[FSET] setting, SET LOBOFFSET
LOCAL environment variable, LOCAL
LOCAL parameter (SET INSTANCE), SET INSTANCE
log information, viewing, Looking at Archive and Recovery Information, SET LOGSOURCE
LOG= option (SQLLDR80 command), Loading the data
LOGGING column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
logging into databases, Step 3: Log into your Oracle database, Logging into a database, Making a mistake on the logon dialog
as administrator, Connecting for Administrative Purposes, Connecting as INTERNAL
CONN[ECT] command, CONNECT, CONNECT, CONNECT
default database for, SET INSTANCE
startup scripts, SQL*Plus Settings You Can Control, The User Profile
troubleshooting (GUI version), Making a mistake on the logon dialog
logging SQL*Loader activity, Loading the data, Loading the data
login.sql script, SQL*Plus Settings You Can Control, The User Profile
LOGSOURCE parameter (SHOW), Looking at Archive and Recovery Information
LOGSOURCE setting, SET LOGSOURCE
LOG_ARCHIVE_DEST initialization parameter, Starting the archive log process
LOG_ARCHIVE_FORMAT initialization parameter, Displaying the archive log status
LONG datatype, settings for, Large Object Settings, SET LONGCHUNKSIZE
LONG setting, SET LONG
LONGC[HUNKSIZE] setting, SET LONGCHUNKSIZE
looping, Looping in SQL*Plus, The ANALYZE TABLE script revisited
generating files of commands, Generating a File of Commands, Generating a File of Commands
PL/SQL for, Looping Within PL/SQL, The ANALYZE TABLE script revisited
recursive execution, Recursive Execution, Recursive Execution
LOWER parameter (SET SQLCASE), SQLCASE
LOW_VALUE column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
LTRIM function, Fixed-width

M

manually archiving log files, Manually archiving a log file
margins for report pages, Step 4: Format the Page, Setting the page advance, SET NEWPAGE, SET PAGESIZE
master/detail reports, Master/Detail Formatting, Printing data in a page footer
MAXD[ATA] setting, SET MAXDATA
MAX[IMUM] parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
MAX_EXTENTS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
MAX_TRANS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
MERGE JOIN operation (EXPLAIN PLAN), Making sense of the results
merge joins, Join operation hints
MERGE_AJ hint, Access method hints
methodology for developing reports, Following a Methodology
MIN[IMUM] parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
MINUS operation (EXPLAIN PLAN), Making sense of the results
MIN_EXTENTS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
MIXED parameter (SET SQLCASE), SQLCASE
MOUNT parameter (STARTUP), Starting a Database, STARTUP
MOUNT state, The States of a Database
multilevel file structure, Branching Using a Multilevel File Structure, Branching Using a Multilevel File Structure
multiline comments in scripts, The /* and */ Delimiters, Comment Delimiters (/*...*/)

N

names
report headings, Column headings, SET HEADING
line break characters, SET HEADSEP
underline characters, SET UNDERLINE
report titles, Report Headers and Footers, An example
shortcuts for scripts, Creating the shortcut
substitution variables, Generalizing the report with substitution variables
tables, prompting users for, Using ACCEPT to get the table name
total and subtotal labels, Printing Subtotals, Print Grand Totals
work files, SET EDITFILE
NATIVE parameter (SET COMPATIBILITY), SET COMPATIBILITY
NCHAR datatype, Declaring Bind Variables, VARIABLE
NCLOB datatype, Declaring Bind Variables, VARIABLE
printing, Printing CLOB variables, Printing CLOB variables
negative numbers, Formatting Numbers
NESTED column (ALL_TABLES), The ALL_TABLES view
nested loops joins, Join operation hints
NESTED LOOPS operation (EXPLAIN PLAN), Making sense of the results
nesting scripts, Recursive Execution, Recursive Execution
nesting timers, Nesting timers
NEW_V[ALUE] clause (COLUMN), The COLUMN command, Retrieve the employee information into user variables, Getting the date from Oracle, COLUMN
NEW[LINE] parameter (COLUMN command), The COLUMN command
NEW[LINE] parameter (COLUMN), COLUMN
NEWP[AGE] setting, Step 4: Format the Page, Setting the page advance, SET NEWPAGE
Next log sequence to archive value, Looking at Archive and Recovery Information, Displaying the archive log status
NEXT parameter (ARCHIVE LOG), Manually archiving a log file, ARCHIVE LOG
NEXT_EXTENT column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
NLS_DATE_FORMAT parameter, Formatting the date
NLS_LANG environment variable, NLS_LANG
NOAPPEND hint, Parallel execution hints
NOARCHIVELOG parameter (ALTER DATABASE), Turning off archive log mode
NOCACHE hint, Other hints
NODUP[LICATES] parameter (BREAK command), The BREAK Command, Suppressing Duplicate Column Values, BREAK
NOL[IST] option (GET command), GET, GET
/NOLOG command-line option, Command-Line Options, Starting the SQL*Plus executable, Connecting as SYSOPER or SYSDBA, SQLPLUS
NOMOUNT parameter (STARTUP), Starting a Database, STARTUP
NOMOUNT state, The States of a Database
NONE parameter
SET NEWPAGE command, SET NEWPAGE
WHENEVER command, WHENEVER
NOPARALLEL parameter (RECOVER), RECOVER
NOPRI[NT] parameter (COLUMN), The COLUMN command, Retrieve the employee information into user variables, Printing Subtotals, COLUMN
NOPROMPT parameter (ACCEPT), Syntax for the ACCEPT command, ACCEPT
normal database shutdown, SHUTDOWN NORMAL, SHUTDOWN
NORMAL parameter (SHUTDOWN), SHUTDOWN NORMAL, SHUTDOWN
NO_MERGE hint, Join operation hints
NO_PARALLEL hint, Parallel execution hints
NUL[L] clause (COLUMN), The COLUMN command, COLUMN
NULL setting, SET NULL
null string as column separator, Fixed-width, SET COLSEP
NULLABLE column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
NULLIF clause (SQL*Loader), Building a control file for fixed-width data
NUM_BUCKETS column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
NUM_DISTINCT column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
NUM_FREELIST_BLOCKS column (ALL_TABLES), The ALL_TABLES view
NUM_NULLS column (ALL_TAB_COLUMNS), The ALL_TAB_COLUMNS view
NUM_ROWS column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
NUMBER datatype, Notes about the LIST_COLUMNS script, Declaring Bind Variables, VARIABLE
column width for displaying, SET NUMWIDTH
default formatting, SET NUMFORMAT
formatting, Formatting Numbers
validating, ACCEPTing numeric values, ACCEPTing numeric values
NUM[BER] parameter
ACCEPT command, Syntax for the ACCEPT command, ACCEPT
COMPUTE command, Syntax of the COMPUTE command, Syntax of the COMPUTE command
numbers, formatting, Formatting Numbers
NUMF[ORMAT] setting, SET NUMFORMAT
NUM[WIDTH] setting, SET NUMWIDTH
NVARCHAR2 datatype, VARIABLE
NVARCHAR2 variable, Declaring Bind Variables

O

object columns, formatting, Formatting Object Columns, Formatting Object Columns
object types, information about, Describing Packages and Object Types
OFF parameter
ATTRIBUTE command, Formatting Object Columns, ATTRIBUTE
BTITLE command, The bottom title, BTITLE
COLUMN command, The COLUMN command, COLUMN
REPFOOTER command, REPFOOTER
SET APPINO command, SET APPINFO
SET AUTOCOMMIT command, SET AUTOCOMMIT
SET AUTOPRINT command, SET AUTOPRINT
SET AUTORECOVERY command, SET AUTORECOVERY
SET AUTOTRACE command, SET AUTOTRACE
SET CMDSEP command, CMDSEP
SET CONCAT command, SET CONCAT
SET COPYTYPECHECK command, SET COPYTYPECHECK
SET DEFINE command, SET DEFINE
SET ECHO command, SET ECHO
SET EMBEDDED, SET EMBEDDED
SET ESCAPE command, SET ESCAPE
SET FEEDBACK command, SET FEEDBACK
SET FLAGGER command, SET FLAGGER
SET FLUSH command, SET FLUSH
SET HEADING command, SET HEADING
SET PAUSE command, SET PAUSE
SET RECSEP command, SET RECSEP
SET SCAN command, SET SCAN
SET SERVEROUTPUT command, SET SERVEROUTPUT
SET SHOWMODE command, SET SHOWMODE
SET SQLBLANKLINES command, SQLBLANKLINES
SET SQLNUMBER command, SQLNUMBER
SET SQLTERMINATOR command, SQLTERMINATOR
SET TAB command, SET TAB
SET TERMOUT command, SET TERMOUT
SET TIME command, SET TIME
SET TIMING command, SET TIMING
SET TRIMOUT command, SET TRIMOUT
SET TRIMSPOOL command, SET TRIMSPOOL
SET TRUNCATE command, SET TRUNCATE
SET UNDERLINE command, SET UNDERLINE
SET VERIFY command, SET VERIFY
SET WRAP command, SET WRAP
SPOOL command, Step 5: Print It!, SPOOL
TTITLE command, The top title, TTITLE
OLD_V[ALUE] clause (COLUMN command), The COLUMN command, Printing data in a page footer, COLUMN
Oldest online log sequence value, Looking at Archive and Recovery Information, Displaying the archive log status
ON clause (COMPUTE), Printing Subtotals, Print Grand Totals
ON parameter
ATTRIBUTE command, Formatting Object Columns, ATTRIBUTE
BTITLE command, The bottom title, BTITLE
COLUMN command, The COLUMN command, COLUMN
REPFOOTER command, REPFOOTER
SET APPINO command, SET APPINFO
SET AUTOCOMMIT command, SET AUTOCOMMIT
SET AUTOPRINT command, SET AUTOPRINT
SET AUTORECOVERY command, SET AUTORECOVERY
SET AUTOTRACE command, SET AUTOTRACE
SET CMDSEP command, CMDSEP
SET CONCAT command, SET CONCAT
SET COPYTYPECHECK command, SET COPYTYPECHECK
SET DEFINE command, SET DEFINE
SET ECHO command, SET ECHO
SET EMBEDDED, SET EMBEDDED
SET ESCAPE command, SET ESCAPE
SET FEEDBACK command, SET FEEDBACK
SET FLUSH command, SET FLUSH
SET HEADING command, SET HEADING
SET PAUSE command, SET PAUSE
SET SCAN command, SET SCAN
SET SERVEROUTPUT command, SET SERVEROUTPUT
SET SHOWMODE command, SET SHOWMODE
SET SQLBLANKLINES command, SQLBLANKLINES
SET SQLNUMBER command, SQLNUMBER
SET SQLTERMINATOR command, SQLTERMINATOR
SET TAB command, SET TAB
SET TERMOUT command, SET TERMOUT
SET TIME command, SET TIME
SET TIMING command, SET TIMING
SET TRIMOUT command, SET TRIMOUT
SET TRIMSPOOL command, SET TRIMSPOOL
SET TRUNCATE command, SET TRUNCATE
SET UNDERLINE command, SET UNDERLINE
SET VERIFY command, SET VERIFY
SET WRAP command, SET WRAP
TTITLE command, The top title, TTITLE
OPEN parameter (STARTUP), STARTUP
OPEN state, The States of a Database
OPEN_CURSOR procedure (DMBS_SQL), The ANALYZE TABLE script revisited
operating system authentication, Operating System Authentication
connecting using, Command-Line Options
operating systems, Which Platform and Version?
allowing output buffers, SET FLUSH
errors, WHENEVER OSERROR, WHENEVER OSERROR, WHENEVER
setting environment variables, Setting an Environment Variable, Windows 3.1
operational settings, Operational Settings, SET FLUSH
operational states of databases, The States of a Database
optimizer, Tuning and Timing
optimizer goal hints, Optimizer goal hints
OPTIONALLY ENCLOSED BY clause (SQL*Loader), Building a control file for comma-delimited data
Oracle BIN directory, The Working Directory
Oracle databases (see databases)
Oracle version, specifying, SET COMPATIBILITY
ORDER BY clause
BREAK command with, Suppressing Duplicate Column Values
union output, The UNION query
ORDERED hint, Join order hints
OSERROR parameter (WHENEVER), The WHENEVER Command, WHENEVER OSERROR, WHENEVER OSERROR, WHENEVER
OUT parameter
SPOOL command, SPOOL
OUT parameter (SPOOL command), Step 5: Print It!
output from PL/SQL execution, Where’s the output?, SET SERVEROUTPUT
output sorting (see ORDER BY clause)
output, scripts
allowing operating system buffers, SET FLUSH
displaying case, SET SHIFTINOUT
echoing
commands, turning off, Turning Command Echoing Off, SET ECHO
multiline comments, The /* and */ Delimiters
explaining with PROMPT commands, Using PROMPT to explain the output
pausing between pages, SET PAUSE
prompt text, customizing, The PROMPT Command, Using PROMPT to explain the output
settings for, Report Output and Format Settings, SET WRAP
suppressing from display
feedback, Turning Feedback Off, Spool the Extract to a File
prompting for values and, When TERMOUT is off, When TERMOUT is off, Prompting for Values
verification, Turning Verification Off, SET VERIFY
trailing spaces, suppressing, Spool the Extract to a File, SET TRIMOUT, SET TRIMSPOOL
types of output files, Types of Output Files, DDL Files
wrapping lines, Where’s the output?, SET WRAP, Formatting Character Strings
OWNER column
ALL_CONSTRAINTS view, The ALL_CONSTRAINTS view, FOREIGN KEY constraints
ALL_CONS_COLUMNS view, The ALL_CONS_COLUMNS view
ALL_INDEXES view, The ALL_INDEXES view
ALL_SYNONYMS view, The ALL_SYNONYMS view
ALL_TABLES view, The ALL_TABLES view
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view
ALL_TRIGGERS view, The ALL_TRIGGERS view

P

packages
bind variables with, Calling PL/SQL procedures and functions from SQL*Plus, Calling PL/SQL procedures and functions from SQL*Plus
viewing information about, Describing Packages and Object Types
packaging scripts, Packaging Your Script, Creating a Unix Command
page breaks in reports, Advanced Report Formatting, The BREAK Command, The BREAK Command, BREAK
page headers and footers (reports), Step 3: Add Page Headers and Footers, Report output with page titles, BTITLE, TTITLE
current date in, Getting the Current Date into a Header, Formatting the date
embedded reports and, SET EMBEDDED
user variables, Modify the page heading to print the employee name and ID, Printing data in a page footer
pages, report (see reports)
PAGES[IZE] setting, Step 4: Format the Page, Setting the page advance, SET PAGESIZE
spooling data to files, Spool the Extract to a File
paging though output, SET PAUSE
parallel execution hints, Parallel execution hints
PARALLEL hint, Parallel execution hints
PARALLEL parameter
RECOVER command, RECOVER
STARTUP command, STARTUP
parallel processing, Parallel execution hints
PARALLEL_INDEX hint, Parallel execution hints
PARAMETER[S] parameter (SHOW), Looking at Initialization Parameters, The SHOW Command, SHOW
PARSE procedure (DBMS_SQL), The ANALYZE TABLE script revisited
parsing user input, Parsing Input with SQL, Parsing Input with SQL
PARTITION operation (EXPLAIN PLAN), Making sense of the results
PARTITIONED column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
PASSW[ORD] command, PASSWORD, PASSWORD
password file, The Oracle Password File
passwords, changing, PASSWORD, PASSWORD
PAU[SE] command, PAUSE
PAU[SE] setting, SET PAUSE
pausing between output pages, SET PAUSE
PCT_FREE column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
PCT_INCREASE column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
PCT_THRESHOLD column (ALL_INDEXES), The ALL_INDEXES view
PCT_USED column (ALL_TABLES), The ALL_TABLES view
performance
AUTOTRACE setting, Using AUTOTRACE, Turning AUTOTRACE off
dynamic performance views, Granting Access to the Performance Views
EXPLAIN PLAN command, Tuning and Timing, Using EXPLAIN PLAN, Making sense of the results
creating plan table, Creating the Plan Table
judging results, Knowing Good Results from Bad
syntax for, Explaining a Query
understanding execution plans, Interpreting the Results, Making sense of the results
improving, Improving on EXPLAIN PLAN Results, Other hints
SET LONGC[HUNKSIZE] command, SET LONGCHUNKSIZE
timers, Tuning and Timing, Stopping all timers
tuning settings, Tuning and Timing Settings, SET TIMING
. (period)
concatenation character, The Concatenation Character, Changing the concatenation character
terminating PL/SQL blocks, Rules for entering PL/SQL blocks
period (.)
concatenation character, The Concatenation Character, Changing the concatenation character
terminating PL/SQL blocks, Rules for entering PL/SQL blocks
PFILE clause (STARTUP), Starting a Database, STARTUP
PL/SQL, Uses for SQL*Plus, SQL*Plus’s Relation to SQL, PL/SQL and the Oracle Database, Working with PL/SQL, Executing a Single PL/SQL Command
blocks, What Is a PL/SQL Block?
execution error handling, WHENEVER
execution errors, The WHENEVER Command
syntax for, Rules for entering PL/SQL blocks
terminators for, BLOCKTERMINATOR
branching, Using PL/SQL, Using PL/SQL
command help, HELP
error handling, The WHENEVER Command
executing
blocks, Executing a PL/SQL Block, Rules for entering PL/SQL blocks
output from, Where’s the output?, SET SERVEROUTPUT
single PL/SQL commands, Executing a Single PL/SQL Command, EXECUTE
looping, Looping Within PL/SQL, The ANALYZE TABLE script revisited
product user profile limitations, Issues related to PL/SQL
timing execution (see timers)
PL/SQL mode, Rules for entering PL/SQL blocks
plan table, Using EXPLAIN PLAN, Creating the Plan Table
interpreting, Interpreting the Results, Making sense of the results
platforms, Which Platform and Version?
operating system errors, WHENEVER OSERROR, WHENEVER OSERROR, WHENEVER
setting environment variables, Setting an Environment Variable, Windows 3.1
PLUS23 command, Starting the Command-Line Version
PLUS80 command, Starting the Command-Line Version, Command-Line Options
PLUS80 environment variable, PLUS80
PLUS80W command, Command-Line Options
PLUSTRACE role, Granting Access to the Performance Views
PLUSTRCE.SQL script, Granting Access to the Performance Views
PLUS_DFLT environment variable, PLUS_DFLT
PNO parameter (SHOW), The SHOW Command, SHOW
point-in-time recovery, Hot backups
POSITION column (ALL_CONS_COLUMNS), The ALL_CONS_COLUMNS view, PRIMARY KEY and UNIQUE constraints
position specification (SQL*Loader), Building a control file for fixed-width data
prefix character, SQLPREFIX
prefix character for substitution variables, SET DEFINE, SET ESCAPE
primary key constraints, PRIMARY KEY and UNIQUE constraints
columns specified in, The ALL_CONS_COLUMNS view, Table Constraints
PRI[NT] command, The PRINT command, Printing REFCURSOR variables, PRINT
PRI[NT] parameter (COLUMN command), The COLUMN command, COLUMN
printing
computed values in reports, Printing computed values
reports, Step 5: Print It!, Printing the file, SPOOL
(see also reports)
lines per page, How many lines on a page?, Setting the pagesize
subtotals and grand totals, Printing Subtotals, Print Grand Totals
printing variables, Displaying the Contents of a Bind Variable, SELECTing a bind variable
CLOB datatype, Printing CLOB variables, Printing CLOB variables
REFCURSOR datatype, Printing REFCURSOR variables, Printing REFCURSOR variables
printspecs, The top title
private synonyms, Looking at Synonyms
PRIVILEGE column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_TAB_VIEWS view, The ALL_TAB_PRIVS view
privileges, Table Security, Running the SHOW_SECURITY script
ALL_TAB_PRIVS view, The ALL_TAB_PRIVS view, Table Security
loading sample database for book, Loading the Sample Data
PRO80 environment variable, PRO80
procedures
bind variables with, Calling PL/SQL procedures and functions from SQL*Plus, Calling PL/SQL procedures and functions from SQL*Plus
viewing information about, Describing Stored Functions and Procedures
product user profile, Missing the Product User Profile, What Is the Product User Profile?, Listing restrictions for a particular user
commands that can be disabled, Commands that can be disabled
creating profile table, Creating the Profile Table, Creating the Profile Table
disabling commands access, Limiting Access to Commands, Re-enabling a command
disabling roles access, Limiting Access to Roles, Re-enabling a role
limitations, Product User Profile Limitations, Issues related to roles
reporting on, Reporting on the Product User Profile, Listing restrictions for a particular user
PRODUCT_PRIVS view, The PRODUCT_PROFILE Table, How the Product User Profile Works
PRODUCT_PROFILE table, What Is the Product User Profile?, The PRODUCT_PROFILE Table
creating, Creating the Profile Table, Creating the Profile Table
disabling commands, Limiting Access to Commands, Re-enabling a command
limiting roles access, Limiting Access to Roles, Re-enabling a role
PROJECT entity (sample database), The Data Model
PROJECT table (sample database), The PROJECT table
data of, The PROJECT table
PROJECTION operation (EXPLAIN PLAN), Making sense of the results
PROJECT_HOURS entity (sample database), The Data Model
PROJECT_HOURS table (sample database), The PROJECT_HOURS table
data of, The PROJECT_HOURS table
PROMPT clause (ACCEPT), Syntax for the ACCEPT command, ACCEPT
PRO[MPT] command, Prompting for Values, The PROMPT Command, Using PROMPT to explain the output, PROMPT
annotating scripts, Using PROMPT to summarize the script, Make Your Extract Script User-Friendly
prompt, SQL*Plus (see command prompt)
prompting users for values, Using Single-Ampersand Variables, Using PROMPT to explain the output
display text for, The PROMPT Command, Using PROMPT to explain the output
extract scripts, Make Your Extract Script User-Friendly
session-duration definitions, Using Double-Ampersand Variables, A final caveat
TERMOUT setting and, When TERMOUT is off, Prompting for Values
public synonyms, Looking at Synonyms
PUPBLD.SQL script, Creating the Profile Table, Creating the Profile Table
PUSH_SUBQ hint, Other hints

Q

queries, Running SQL Queries, Running SQL Queries
execution plan (see EXPLAIN PLAN command)
formulating
designing reports, Step 1: Formulate the Query
extracting data, Formulate the Query
rewriting to improve performance, Rewriting the Query
testing with bind variables, Testing application queries
timing (see timers)
unions, Taking Advantage of Unions, The final report
QUIT command, QUIT
quitting (see exiting)

R

R (RUN) command, Executing the Statement in the Buffer, Doing It Again, RUN
RAISE_APPLICATION_ERROR procedure (DBMS_STANDARD), PL/SQL errors and WHENEVER
RDBMS80 environment variable, RDBMS80
re-enabling commands, Re-enabling a command
re-enabling roles, Re-enabling a role
record separators, Report output after formatting the columns, SET RECSEP, SET RECSEPCHAR
RECOVER command, RECOVER
autorecovery and, Autorecovery
RECOVER DATABASE, Full database recovery, RECOVER
RECOVER DATAFILE, Tablespace and datafile recovery, RECOVER
RECOVER TABLESPACE, Tablespace and datafile recovery
RECOVER parameter (STARTUP), STARTUP
recovery process, Database Backup and Recovery, Hot backups, Recovery, Autorecovery
archiving, Archiving, Turning off archive log mode
autorecovery, Autorecovery, SET AUTORECOVERY
full database recovery, Full database recovery
restoring from cold backups, Cold backups
RMAN (Recovery Manager), Other Things You Need to Know
tablespace and datafiles, Tablespace and datafile recovery
viewing information on, Looking at Archive and Recovery Information, SET LOGSOURCE
RECSEP setting, Report output after formatting the columns, SET RECSEP
RECSEPCHAR parameter, SET RECSEPCHAR
recursive execution, Recursive Execution, Recursive Execution
Redo Buffers value, Looking at the SGA
redo log files, saving, Archiving, Turning off archive log mode
REFCURSOR datatype, Declaring Bind Variables, VARIABLE
bind variables with, Using REFCURSOR variables, Using REFCURSOR variables
printing, Printing REFCURSOR variables, Printing REFCURSOR variables
simulating branching with, Using REFCURSOR Variables to Simulate Branching, Using REFCURSOR Variables to Simulate Branching
REFERENCING_NAMES column (ALL_TRIGGERS), The ALL_TRIGGERS view
REGEDIT program (Windows), Windows 95/98/NT
registering command files, SET APPINFO, SET APPINFO
REL[EASE] parameter (SHOW), The SHOW Command, SHOW
reloading extracted data, Extracting and Loading Data, Reloading the Data, Loading the data
logging, Loading the data, Loading the data
REM[ARK] command, The REMARK Command, REMARK
remote databases, connecting to, Logging into a database, Making a mistake on the logon dialog, Starting the Command-Line Version
REMOTE operation (EXPLAIN PLAN), Making sense of the results
REPF[OOTER] command, Report Headers and Footers, An example, REPFOOTER
REPF[OOTER] parameter (SHOW), The SHOW Command, SHOW
REPH[EADER] command, Report Headers and Footers, An example, REPHEADER
REPH[EADER] parameter (SHOW), The SHOW Command, SHOW
REP[LACE] parameter
COPY command, COPY
SAVE command, SAVE
REPORT parameter
BREAK command, The BREAK Command, BREAK
COMPUTE command, Syntax of the COMPUTE command, Print Grand Totals, Print Grand Totals, Syntax of the COMPUTE command
reporting on execution plan, Using EXPLAIN PLAN, Making sense of the results
AUTOTRACE setting, Using AUTOTRACE, Turning AUTOTRACE off
creating plan table, Creating the Plan Table
improving results, Improving on EXPLAIN PLAN Results, Other hints
interpreting results, Interpreting the Results, Making sense of the results
judging results, Knowing Good Results from Bad
reports, Generating Reports with SQL*Plus, The final report
column formatting, Step 2: Format the Columns, Report output after formatting the columns
embedded, SET EMBEDDED, SET EMBEDDED
example of generating, Designing a Simple Report, Printing the file
executing, Executing the report
formulating queries for, Step 1: Formulate the Query
headers and footers, Report Headers and Footers, An example
line width (linesize), Setting the line width, Revisit the report width and the width of the remaining fields, SET LINESIZE
master/detail reports, Master/Detail Formatting, Printing data in a page footer
methodology for developing, Following a Methodology
object column formatting, Formatting Object Columns, Formatting Object Columns
output and format settings, Report Output and Format Settings, SET WRAP
page and line breaks, Advanced Report Formatting, The BREAK Command, The BREAK Command, BREAK
page format, Step 4: Format the Page, Setting the page advance
page headers and footers, Step 3: Add Page Headers and Footers, Report output with page titles, BTITLE, TTITLE
current date in, Getting the Current Date into a Header, Formatting the date
embedded reports and, SET EMBEDDED
user variables, Modify the page heading to print the employee name and ID, Printing data in a page footer
printing or saving to file, Step 5: Print It!, Printing the file, SPOOL
saving scripts for, Saving Your Work
sorting output (see ORDER BY clause)
summary reports, Summary Reports, Summary Reports
suppressing duplicate column values, Suppressing Duplicate Column Values
totals and subtotals, Totals and Subtotals, Print Grand Totals
unions with, Taking Advantage of Unions, The final report
word wrap, SET WRAP
REP[LACE] parameter
SAVE command, SAVE
STORE command, STORE
resolution of timers, Using SQL*Plus Timers
restoring lost databases, Database Backup and Recovery
from cold backups, Cold backups
from hot backups (recovery), Hot backups, Recovery, Autorecovery
RMAN (Recovery Manager), Other Things You Need to Know
viewing recovery information, Looking at Archive and Recovery Information, SET LOGSOURCE
RESTRICT parameter (STARTUP), Starting a Database, STARTUP
retrieving SQL buffer, Saving and Retrieving the Buffer, GET
RETRY parameter (STARTUP), STARTUP
R[IGHT] parameter
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
RMAN (Recovery Manager), Other Things You Need to Know
ROLE setting, Issues related to roles, Issues related to roles
roles
administrative, Privileges You Will Need
disabling, Limiting Access to Roles, Re-enabling a role
limitations of, Issues related to roles, Issues related to roles
ROLLBACK option (WHATEVER), WHENEVER SQLERROR, WHENEVER OSERROR
ROLLBACK parameter
EXIT command, EXIT
QUIT command, QUIT
WHENEVER command, WHENEVER
rollbacks at shutdown, SHUTDOWN IMMEDIATE, SHUTDOWN
ROW parameter
BREAK command, The BREAK Command, BREAK
COMPUTE command, Syntax of the COMPUTE command, Syntax of the COMPUTE command
ROWID hint, Access method hints
RULE hint, Optimizer goal hints
R[UN] command, Executing the Statement in the Buffer, Doing It Again, RUN
R_CONSTRAINT_NAME column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view, FOREIGN KEY constraints
R_OWNER column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view, FOREIGN KEY constraints

S

-S (SILENT) command-line option, Command-Line Options, SQLPLUS
sample database in this book, Creating and Loading the Sample Tables, Step 4: Run the BLD_DB.SQL script file
data model (ERD), The Data Model
data of, The Data, The PROJECT_HOURS table
loading, Loading the Sample Data, Step 4: Run the BLD_DB.SQL script file
tables, The Tables
SAMPLE_SIZE column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view
SAV[E] command, SAVE, SAVE
working directory, The Working Directory
saving
report-generation scripts, Saving Your Work
reports as files, Spooling to a file, Spooling to a file
SQL buffer, Saving and Retrieving the Buffer, GET
SCAN setting, SET SCAN
scripting languages, Using a Scripting Language Instead
scripts, Writing SQL*Plus Scripts, Substitution Within Comments
annotating with PROMPT commands, Using PROMPT to summarize the script, Make Your Extract Script User-Friendly
command echoing, turning off, Turning Command Echoing Off, SET ECHO
commenting, Commenting Your Scripts, Substitution Within Comments
to construct sample database, Step 1: Download and unzip the script files
executed at startup, SQL*Plus Settings You Can Control, The User Profile
executing, Executing a Script, Executing a Script
executing at startup, Command-Line Options, Starting the SQL*Plus executable, Starting the SQL*Plus executable
executing with @ command, Executing a Script, At Sign (@)
executing with @@ command, Double At Sign (@@)
feedback, turning off, Turning Feedback Off, Spool the Extract to a File
output and format settings, Report Output and Format Settings, SET WRAP
output from (see output, scripts)
packaging, Packaging Your Script, Creating a Unix Command
prompting users for values, Using Single-Ampersand Variables, Using PROMPT to explain the output
display text for, The PROMPT Command, Using PROMPT to explain the output
extract scripts, Make Your Extract Script User-Friendly
session-duration definitions, Using Double-Ampersand Variables, A final caveat
TERMOUT setting and, When TERMOUT is off, Prompting for Values
reasons to write, Why Write Scripts?
recursive execution, Recursive Execution, Recursive Execution
report-generation (see reports)
search path for, SQLPATH
substitution (user) variables, Using Substitution Variables, A final caveat
timing (see timers)
user input (see user input)
verification, turning off, Turning Verification Off, SET VERIFY
SCR[EEN] parameter (CLEAR), CLEAR
search path, setting, SQLPATH
search-and-replace
line editing, CHANGE, CHANGE
substitution (user) variables
reports, Master/Detail Formatting, Modify the page heading to print the employee name and ID
scripts, What Is a Substitution Variable?, A final caveat
within comments, Substitution Within Comments
SEARCH_CONDITION column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view, CHECK constraints
security
password file, The Oracle Password File
passwords (see passwords)
product user profile, Missing the Product User Profile, What Is the Product User Profile?, Listing restrictions for a particular user
creating profile table, Creating the Profile Table, Creating the Profile Table
disabling commands access, Limiting Access to Commands, Re-enabling a command
disabling roles access, Limiting Access to Roles, Re-enabling a role
limitations, Product User Profile Limitations, Issues related to roles
reporting on, Reporting on the Product User Profile, Listing restrictions for a particular user
table privileges, Table Security, Running the SHOW_SECURITY script
ALL_TAB_PRIVS view, Table Security
SELECT statement, Uses for SQL*Plus
feedback from, turning off, Turning Feedback Off
formatting returned data, The COLUMN command, Report output after formatting the columns
viewing bind variable contents, SELECTing a bind variable, SELECTing a bind variable
; (semicolon) to end SQL statements, Running SQL Queries, SQLTERMINATOR
text editors, Formatting Your Command
semicolon (;) to end SQL statements, Running SQL Queries, SQLTERMINATOR
in text editors, Formatting Your Command
SEQUENCE operation (EXPLAIN PLAN), Making sense of the results
SERVEROUT[PUT] setting, Where’s the output?, SET SERVEROUTPUT
SET command, The SET Command, SET INSTANCE, SET
SET APPI[NFO] command, SET APPINFO, SET APPINFO
SET ARRAY[SIZE] setting, SET ARRAYSIZE
SET AUTOP[RINT] command, SET AUTOPRINT
SET AUTORECOVERY command, Autorecovery, SET AUTORECOVERY
SET AUTOT[RACE] command, Using AUTOTRACE, Turning AUTOTRACE off, SET AUTOTRACE
SET AUTO[COMMIT] command, SET AUTOCOMMIT
SET BLO[CKTERMINATOR] command, BLOCKTERMINATOR
SET BUF[FER] command, BUFFER
SET CLOSECUR[SOR] command, SET CLOSECURSOR
SET CMDS[EP] command, CMDSEP
SET COLSEP command, Fixed-width, SET COLSEP
SET COM[PATIBILITY] command, SET COMPATIBILITY
SET CON[CAT] command, Turning off the concatenation feature, SET CONCAT
SET COPYC[OMMIT] command, SET COPYCOMMIT
SET COPYTYPECHECK command, SET COPYTYPECHECK
SET DEF[INE] command, Enabling and Disabling Substitution, SET DEFINE
SET DOC[UMENT] command, SET DOCUMENT
SET ECHO command, Turning Command Echoing Off, SET ECHO
SET EDITF[ILE] command, SET EDITFILE
SET EMB[EDDED] command, SET EMBEDDED, SET EMBEDDED
SET ESC[APE] command, Turning on the escape feature, SET ESCAPE
SET FEED[BACK] command, Spooling to a file, Turning Feedback Off, SET FEEDBACK
spooling data to file, Spool the Extract to a File
SET FLAGGER command, SET FLAGGER
SET FLU[SH] command, SET FLUSH
SET HEADS[EP] command, SET HEADSEP
SET HEA[DING] command, SET HEADING
SET INSTANCE command, SET INSTANCE
SET LIN[ESIZE] command, Setting the line width, Revisit the report width and the width of the remaining fields, SET LINESIZE
SET LOBOF[FSET] command, SET LOBOFFSET
SET LOGSOURCE command, SET LOGSOURCE
SET LONG command, SET LONG
SET LONGC[HUNKSIZE] command, SET LONGCHUNKSIZE
SET MAX[DATA] setting, SET MAXDATA
SET NEWP[AGE] command, Step 4: Format the Page, Setting the page advance, SET NEWPAGE
SET NULL command, SET NULL
SET NUMF[ORMAT] command, SET NUMFORMAT
SET NUM[WDTH] command, SET NUMWIDTH
SET PAGES[IZE] command, Step 4: Format the Page, Setting the page advance, SET PAGESIZE
spooling data to files, Spool the Extract to a File
SET parameter (STORE), STORE
SET PAU[SE] command, SET PAUSE
SET RECSEP command, Report output after formatting the columns, SET RECSEP
SET RECSEPCHAR parameter, SET RECSEPCHAR
SET ROLE command, Issues related to roles, Issues related to roles
SET SCAN command, SET SCAN
SET SERVEROUT[PUT] command, Where’s the output?, SET SERVEROUTPUT
SET SHIFT[INOUT] command, SET SHIFTINOUT
SET SHOW[MODE] command, SET SHOWMODE
SET SPACE command, Fixed-width, SET SPACE
SET SQLBLANKLINES command, SQLBLANKLINES
SET SQLCO[NTINUE] command, SQLCONTINUE
SET SQLC[ASE] command, SQLCASE
SET SQLN[UMBER] command, SQLNUMBER
SET SQLPRE[FIX] command, SQLPREFIX
SET SQLP[ROMPT] command, SET SQLPROMPT
SET SQLT[ERMINATOR] command, SQLTERMINATOR
SET SUF[FIX] command, SUFFIX
SET TAB command, History of SQL*Plus, SET TAB
SET TERM[OUT] command, Spooling to a file, Formatting the date, Turning Off All Terminal Output, SET TERMOUT
prompting for values and, When TERMOUT is off, When TERMOUT is off, Prompting for Values
SET TI[ME] command, SET TIME
SET TIMI[NG] command, The SET TIMING Command, SET TIMING
SET TRIMS[POOL] command, History of SQL*Plus, Spool the Extract to a File, SET TRIMSPOOL
SET TRIM[OUT] command, History of SQL*Plus, SET TRIMOUT
SET TRU[NCATE] command, SET TRUNCATE
SET UND[ERLINE] command, SET UNDERLINE
SET VER[IFY] command, Turning Verification Off, SET VERIFY
SET WRA[P] command, SET WRAP
setenv command (Unix), Unix
SGA (System Global Area), Looking at Your Database, Looking at the SGA
SGA parameter (SHOW), Looking at the SGA, The SHOW Command, SHOW
SHARED parameter (STARTUP), STARTUP
shift-insensitive character sets, SET SHIFTINOUT
SHIFT[INOUT] setting, SET SHIFTINOUT
shortcuts for scripts (Windows), Creating a Windows Shortcut, Creating the shortcut
SHO[W] command, Looking at Your Database, Looking at Archive and Recovery Information, The SHOW Command, The SHOW Command, SHOW
SHOW ERRORS, If Your Statement Has an Error, The SHOW Command
SHOW LOGSOURCE, Looking at Archive and Recovery Information
SHOW PARAMETERS, Looking at Initialization Parameters, SHOW
SHOW SGA, Looking at the SGA, Looking at the SGA, SHOW
SHOW parameter (TIMING), The TIMING Command, TIMING
SHOW[MODE] setting, SET SHOWMODE
SHOW_INDEX.SQL (example), The SHOW_INDEX.SQL script, Running the SHOW_INDEX script
SHOW_PLAN.SQL (example), The SHOW_PLAN script, Executing the SHOW_PLAN script
SHOW_SECURITY.SQL (example), Security Scripts, Running the SHOW_SECURITY script
SHOW_SYN.SQL (example), The SHOW_SYN.SQL script, Running the SHOW_SYN.SQL script
SHOW_TRIGGER.SQL (example), The SHOW_TRIGGER.SQL script, Running the SHOW_TRIGGER.SQL script
SHUTDOWN command, Starting and Stopping a Database, Stopping a Database, SHUTDOWN ABORT, SHUTDOWN
sign, number, Formatting Numbers
-S[ILENT] command-line option, Command-Line Options, SQLPLUS
silent mode, Command-Line Options, SQLPLUS
site profile script, SQL*Plus Settings You Can Control, The Site Profile
size
font size for reports, How many lines on a page?
line width (reports), Setting the line width, Revisit the report width and the width of the remaining fields, SET LINESIZE
page length, How many lines on a page?, Setting the pagesize
PL/SQL output buffer, Where’s the output?
total and subtotal label width, Printing Subtotals
SIZE parameter
SET SERVEROUTPUT command, SET SERVEROUTPUT
SIZE parameter (SET SERVEROUTPUT), Where’s the output?
S[KIP] clause
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
SKI[P] clause (BREAK command), The BREAK Command, Adding a line break, BREAK
SKI[P] PAGE clause (BREAK command), The BREAK Command, Adding a page break, BREAK
/ (slash)
executing SQL buffer, Executing the Statement in the Buffer, Doing It Again, Forward Slash (/)
terminating PL/SQL blocks, Rules for entering PL/SQL blocks
terminating SQL statements, Running SQL Queries
slash (/)
executing SQL buffer, Executing the Statement in the Buffer, Doing It Again, Forward Slash (/)
terminating PL/SQL blocks, Rules for entering PL/SQL blocks
terminating SQL statements, Running SQL Queries
/* and */ comment delimiters, The /* and */ Delimiters, Comment Delimiters (/*...*/)
SORT operation (EXPLAIN PLAN), Making sense of the results
sorting output (see ORDER BY clause)
SPACE setting, Fixed-width, SET SPACE
SP[OOL] command, Uses for SQL*Plus, Step 5: Print It!, Printing the file, Spool the Extract to a File, SPOOL
working directory, The Working Directory
SPOO[L] parameter (SHOW), The SHOW Command, SHOW
spooling extracted data to files, Spool the Extract to a File, Spool the Extract to a File
SQL, Running SQL Queries, Running SQL Queries
adding to SQL buffer, Getting a statement into the buffer
dynamic SQL statements, The ANALYZE TABLE script revisited, The ANALYZE TABLE script revisited
editing with text editors, The EDIT Command, Getting Back to SQL*Plus, EDIT
error handling, If Your Statement Has an Error, The WHENEVER Command, WHENEVER
executing, Executing the Statement in the Buffer, Doing It Again
feedback, Turning Feedback Off, Spool the Extract to a File
parsing user input, Parsing Input with SQL, Parsing Input with SQL
syntax rules, Running SQL Queries, Running SQL Queries
validating user input, Validating Input with SQL, Validating Input with SQL
writing SQL with, DDL, Using SQL to Write SQL, Using SQL to Write SQL, Generating a File of Commands, Generating a File of Commands
SQL and SQL*Plus, SQL*Plus’s Relation to SQL, PL/SQL and the Oracle Database
SQL buffer, Running SQL Queries, The SQL Buffer, BUFFER
adding statements to, Getting a statement into the buffer
editing with text editor, The EDIT Command, Getting Back to SQL*Plus, EDIT
executing statements in, Executing the Statement in the Buffer, Doing It Again
line editing, Line Editing, Retyping a line
adding text to lines, APPEND
deleting lines, DEL
inserting lines, INPUT, Retyping a line
search-and-replace, CHANGE, CHANGE
viewing buffer contents, LIST, LIST
saving and retrieving, Saving and Retrieving the Buffer, GET
SQL parameter (SET BUFFER), BUFFER
SQL.PNO user variable, The bottom title, Getting the Current Date into a Header
SQL.RELEASE user variable, The bottom title
SQL.SQLCODE user variable, The bottom title, WHENEVER SQLERROR, WHENEVER OSERROR
SQL statements
blank lines in, allowing, SQLBLANKLINES
closing cursor after execution, SET CLOSECURSOR
SQL.USER user variable, The bottom title
SQL*Loader utility, Reloading the Data, Loading the data
control file, The control file, Building a control file for fixed-width data
datatypes, Building a control file for comma-delimited data
logging, Loading the data, Loading the data
SQL*Plus
command reference, SQLPLUS, WHENEVER
data extraction limitations, Limitations of SQL*Plus
environment variables for (list), Environment Variables That Affect SQL*Plus, PLUS_DFLT
history of, History of SQL*Plus, History of SQL*Plus
PL/SQL and (see PL/SQL)
reasons for mastering, Why Master SQL*Plus?
SQL and, SQL*Plus’s Relation to SQL, PL/SQL and the Oracle Database
starting, Step 2: Start SQL*Plus
executing scripts at startup, Command-Line Options, Starting the SQL*Plus executable, Starting the SQL*Plus executable
system variables, The bottom title
uses for, Uses for SQL*Plus, Uses for SQL*Plus
SQL*Plus scripts (see scripts)
SQL.LLNO user variable, The bottom title
SQL92 syntax conformance checks, SET FLAGGER
SQLBLANKLINES setting, SQLBLANKLINES
SQLCODE parameter (SHOW), The SHOW Command, SHOW
SQLCO[NTINUE] setting, SQLCONTINUE
SQLC[ASE] setting, SQLCASE
SQLERROR parameter (WHENEVER), The WHENEVER Command, PL/SQL errors and WHENEVER, WHENEVER
sqlldr command, Loading the data
SQLLDR80 command, Loading the data
SQLN[UMBER] setting, SQLNUMBER
SQLPATH environment variable, SQLPATH
SQLPLUS command, Starting SQL*Plus, Starting the Command-Line Version, SQLPLUS
command-line options, Command-Line Options, Command-Line Options
sqlplus command, Starting SQL*Plus
command-line options, Command-Line Options, Command-Line Options
SQLPRE[FIX] setting, SQLPREFIX
SQLP[ROMPT] setting, SET SQLPROMPT
SQLT[ERMINATOR] setting, SQLTERMINATOR
STAR hint, Join order hints
STAR_TRANSFORMATION hint, Join order hints
STA[RT] command, Executing a Script, START
START parameter
ARCHIVE LOG command, Starting the archive log process, ARCHIVE LOG
TIMING command, The TIMING Command, TIMING
starting
archive log process, Starting the archive log process
databases, Starting and Stopping a Database, Starting a Database, Starting a Database, STARTUP
starting SQL*Plus, Step 2: Start SQL*Plus, Starting SQL*Plus, Command-Line Options
command-line options, Command-Line Options, Command-Line Options
command-line version, Starting the Command-Line Version, Starting the Command-Line Version
executing scripts at startup, Command-Line Options, Starting the SQL*Plus executable, Starting the SQL*Plus executable
GUI version, Starting the GUI Version, Missing the Product User Profile
starting timers, Starting and stopping a timer
STARTUP command, Starting and Stopping a Database, Starting a Database, Starting a Database, STARTUP
startup scripts, SQL*Plus Settings You Can Control, The User Profile
statements (see SQL)
states (operational) of databases, The States of a Database
statistics of query execution, Showing statistics and the plan
STATUS column
ALL_CONSTRAINTS view, The ALL_CONSTRAINTS view
ALL_INDEXES view, The ALL_INDEXES view
ALL_TRIGGERS view, The ALL_TRIGGERS view
STAT[ISTICS] parameter (SET AUTOTRACE), SET AUTOTRACE
STD parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
STOP parameter
ARCHIVE LOG command, ARCHIVE LOG
TIMING command, The TIMING Command, TIMING
stopping
archive log process, Stopping the archive log process
databases, Starting and Stopping a Database, Stopping a Database, SHUTDOWN ABORT, SHUTDOWN
timers, Starting and stopping a timer, Stopping all timers
STORE command, STORE
stored packages, viewing information on, Describing Packages and Object Types
stored procedures/functions, viewing information about, Describing Stored Functions and Procedures
strings
column separators, Fixed-width, SET COLSEP
date formats, Formatting the date
formatting, Formatting Character Strings
null text setting, SET NULL
SUBMIT procedure (DBMS_JOBS), Calling PL/SQL procedures and functions from SQL*Plus
substitution (user) variables
bind variables with, Using Bind Variables and Substitution Variables Together, From bind to substitution
changing prefix character, Changing the Substitution Variable Prefix Character
defining, The DEFINE and UNDEFINE Commands, Deleting a variable, DEFINE
session-duration, Using Double-Ampersand Variables, A final caveat
disabling, Enabling and Disabling Substitution
examining/listing, Examining a variable
extract scripts, Make Your Extract Script User-Friendly
reports, Master/Detail Formatting, Modify the page heading to print the employee name and ID
scripts, Using Substitution Variables, A final caveat
settings for, Substitution Variable Settings, SET SCAN
troubleshooting, Controlling Variable Substitution, Changing the substitution variable prefix character
verification, Turning Verification Off
within comments, Substitution Within Comments
subtotals in reports, Totals and Subtotals, Print Grand Totals
labels for, Printing Subtotals
SUCCESS parameter
EXIT command, EXIT
QUIT command, QUIT
SUF[FIX] setting, SUFFIX
SUM parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
summary reports, Summary Reports, Summary Reports
suppressing
concatenation feature, Turning off the concatenation feature
duplicate column values, Suppressing Duplicate Column Values
escape feature, Turning on the escape feature
output to display, Spooling to a file, Formatting the date, Turning Off All Terminal Output, SET TERMOUT
command echoing, Turning Command Echoing Off, SET ECHO
feedback, Turning Feedback Off, Spool the Extract to a File
prompting for values and, When TERMOUT is off, When TERMOUT is off, Prompting for Values
verification, Turning Verification Off, SET VERIFY
query output when tracing, Suppressing the query output
trailing spaces in output, Spool the Extract to a File, SET TRIMOUT, SET TRIMSPOOL
variable substitution, Enabling and Disabling Substitution
switching buffers, BUFFER
synonyms, Synonyms, Running the LIST_SYN.SQL script
ALL_SYNONYMS view, The ALL_SYNONYMS view, Looking at Synonyms
public vs. private, Looking at Synonyms
viewing definitions, The SHOW_SYN.SQL script, Running the LIST_SYN.SQL script
SYNONYM_NAME column (ALL_SYNONYMS), The ALL_SYNONYMS view
SYSDATE function, Getting the date from Oracle
SYSDBA keyword (CONNECT), CONNECT, CONNECT
SYSDBA role, Privileges You Will Need
connecting as, CONNECT, Connecting as SYSOPER or SYSDBA, CONNECT
SYSOPER keyword (CONNECT), CONNECT, CONNECT
SYSOPER role, Privileges You Will Need
connecting as, CONNECT, Connecting as SYSOPER or SYSDBA, CONNECT
System Global Area (SGA), Looking at Your Database, Looking at the SGA
System R, History of SQL*Plus
system variables, The bottom title

T

TAB clause
BTITLE command, The bottom title, BTITLE
REPHEADER, REPFOOTER commands, REPHEADER and REPFOOTER command syntax, REPFOOTER, REPHEADER
TTITLE command, The top title, TTITLE
TAB setting, History of SQL*Plus, SET TAB
tab-delimited files, Delimited Files, Comma-delimited
SQL*Loader control file for, Building a control file for comma-delimited data
TABLE ACCESS operation (EXPLAIN PLAN), Making sense of the results
table constraints, Table Constraints
ALL_CONSTRAINS view, The ALL_CONSTRAINTS view, Table Constraints
listing, Listing the Constraints for a Table, Running the LIST_CONSTRAINTS script
type of, Different Constraint Types Need Different Queries, FOREIGN KEY constraints
tables, Tables, Running LIST_COLUMNS
ALL_TABLES view, The ALL_TABLES view, The ALL_TABLES view, Tables
ALL_TAB_COLUMNS, Tables
column definitions, listing, DESCRIBE, Listing Column Definitions for a Table, Running LIST_COLUMNS
data dictionary views, Oracle’s Data Dictionary Views, The ALL_COL_PRIVS view
indexes (see indexes)
listing for particular owner, Listing Tables You Own
plan table, Using EXPLAIN PLAN, Creating the Plan Table
interpreting, Interpreting the Results, Making sense of the results
prompting users for names, Using ACCEPT to get the table name
security (privileges), Table Security, Running the SHOW_SECURITY script
ALL_TAB_PRIVS view, Table Security
synonyms, Synonyms, Running the LIST_SYN.SQL script
viewing definitions, The SHOW_SYN.SQL script, Running the LIST_SYN.SQL script
triggers (see triggers)
USER_TABLES view, Listing Tables You Own
viewing definitions of, Describing a Table
tables of sample database, The Tables
TABLESPACE parameter (RECOVER), Tablespace and datafile recovery
tablespace recovery, Tablespace and datafile recovery
TABLESPACE_NAME column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
TABLE_LOCK column (ALL_TABLES), The ALL_TABLES view
TABLE_NAME column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_CONSTRAINTS view, The ALL_CONSTRAINTS view
ALL_CONS_COLUMNS view, The ALL_CONS_COLUMNS view
ALL_INDEXES view, The ALL_INDEXES view
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view
ALL_SYNONYMS view, The ALL_SYNONYMS view
ALL_TABLES view, The ALL_TABLES view
ALL_TAB_COLUMNS view, The ALL_TAB_COLUMNS view
ALL_TAB_VIEWS view, The ALL_TAB_PRIVS view
ALL_TRIGGERS view, The ALL_TRIGGERS view
ALL_TRIGGER_COLS view, The ALL_TRIGGER_COLS view
TABLE_OWNER column
ALL_INDEXES view, The ALL_INDEXES view
ALL_IND_COLUMNS view, The ALL_IND_COLUMNS view
ALL_SYNONYMS view, The ALL_SYNONYMS view
ALL_TRIGGERS view, The ALL_TRIGGERS view
ALL_TRIGGER_COLS view, The ALL_TRIGGER_COLS view
TABLE_SCHEMA column
ALL_COL_PRIVS view, The ALL_COL_PRIVS view
ALL_TAB_VIEWS view, The ALL_TAB_PRIVS view
TABLE_TYPE column (ALL_INDEXES), The ALL_INDEXES view
TEMPORARY column
ALL_INDEXES view, The ALL_INDEXES view
ALL_TABLES view, The ALL_TABLES view
terminal output (see display)
TERMINATED BY clause (SQL*Loader), Building a control file for comma-delimited data
terminating SQL statements, Running SQL Queries
termination character for substitution variables, SET CONCAT
TERM[OUT] setting, SET TERMOUT
TERM[OUT] setting, Spooling to a file, Formatting the date, Turning Off All Terminal Output
prompting for values and, When TERMOUT is off, When TERMOUT is off, Prompting for Values
text editors, The EDIT Command, Getting Back to SQL*Plus, EDIT
text files (see files)
time in command prompt, SET TIME
TI[ME] setting, SET TIME
timers, Tuning and Timing, Stopping all timers
displaying value without stopping, Displaying the value of a timer
nesting, Nesting timers
resolution of, Using SQL*Plus Timers
SET TIMING command, The SET TIMING Command
settings for, Tuning and Timing Settings, SET TIMING
starting and stopping, Starting and stopping a timer, Stopping all timers
TIMI[NG] command, The TIMING Command, Stopping all timers, TIMING
TIMI[NG] command, The TIMING Command, Stopping all timers, TIMING
TIMI[NG] setting, The SET TIMING Command, SET TIMING
TIMI[NG] parameter (CLEAR), Stopping all timers, CLEAR
titles, report, Report Headers and Footers, An example
TO parameter (COPY), COPY
toggling (see suppressing)
Total System Global Area value, Looking at the SGA
totals/subtotals in reports, Totals and Subtotals, Print Grand Totals
TO_CHAR function, Formatting Dates, Formatting Dates
converting numbers to strings, Comma-delimited
formatting dates, Formatting the date
TO_DATE function, ACCEPTing date values, ACCEPTing date values
TRACE[ONLY] parameter (SET AUTOTRACE), Suppressing the query output, SET AUTOTRACE
trailing spaces, eliminating, Spool the Extract to a File, SET TRIMOUT, SET TRIMSPOOL
transactional database shutdown, SHUTDOWN TRANSACTIONAL, SHUTDOWN
TRANSACTIONAL parameter (SHUTDOWN), SHUTDOWN TRANSACTIONAL, SHUTDOWN
TRIGGERING_EVENT column (ALL_TRIGGERS), The ALL_TRIGGERS view
triggers, Triggers, Running the LIST_TRIGGERS script
ALL_TRIGGERS view, The ALL_TRIGGERS view, Triggers
ALL_TRIGGER_COLS view, The ALL_TRIGGER_COLS view, Triggers
listing definitions (example), The SHOW_TRIGGER.SQL script, Running the LIST_TRIGGERS script
TRIGGER_BODY column
ALL_TRIGGERS view, The ALL_TRIGGERS view, Looking at Trigger Definitions
TRIGGER_NAME column
ALL_TRIGGERS view, The ALL_TRIGGERS view
ALL_TRIGGER_COLS view, The ALL_TRIGGER_COLS view
TRIGGER_OWNER column (ALL_TRIGGER_COLS), The ALL_TRIGGER_COLS view
TRIGGER_TYPE column (ALL_TRIGGERS), The ALL_TRIGGERS view
TRIMS[POOL] setting, History of SQL*Plus, Spool the Extract to a File, SET TRIMSPOOL
TRIM[OUT] setting, History of SQL*Plus, SET TRIMOUT
troubleshooting
application queries, with bind variables, Testing application queries
database backup and recovery, Database Backup and Recovery, Other Things You Need to Know
error handling, Error Handling, WHENEVER OSERROR
errors in SQL statements, If Your Statement Has an Error, The WHENEVER Command, WHENEVER
logon (GUI version), Making a mistake on the logon dialog
querying product user profile, How the Product User Profile Works
variable substitution, Controlling Variable Substitution, Changing the substitution variable prefix character
TRU[NCATE] setting, SET TRUNCATE
TRU[NCATED] parameter
COLUMN command, The COLUMN command, Fixed-width, COLUMN
SET SERVEROUTPUT command, SET SERVEROUTPUT
TTI[TLE] command, The top title, The top title, TTITLE
REPHEADER command vs., An example
user variables, Modify the page heading to print the employee name and ID
TTI[TLE] parameter (SHOW), The SHOW Command, SHOW
turning off (see suppressing)
two-line column heading, SET HEADSEP

U

UFI (User Friendly Interface), History of SQL*Plus
UNDEF[INE] command, The DEFINE and UNDEFINE Commands, The UNDEFINE Command, UNDEFINE
UND[ERLINE] setting, SET UNDERLINE
UNION [ALL] operator, The UNION query, The UNION query
UNION operation (EXPLAIN PLAN), Making sense of the results
unions, Taking Advantage of Unions, The final report
unique constraints, PRIMARY KEY and UNIQUE constraints
columns specified in, The ALL_CONS_COLUMNS view, Table Constraints
UNIQUENESS column (ALL_INDEXES), The ALL_INDEXES view
Unix commands for scripts, Creating a Unix Command
Unix environment variables, Unix
UNTIL CANCEL phrase (RECOVER), RECOVER
UNTIL CHANGE phrase (RECOVER), RECOVER
UNTIL TIME phrase (RECOVER), RECOVER
UPDATE privileges, Looking at Table Security
ALL_COL_PRIVS, The ALL_COL_PRIVS view, Table Security
product user profile, Issues related to PL/SQL
UPPER parameter
SET SQLCASE command, SQLCASE
user (substitution) variables
bind variables with, Using Bind Variables and Substitution Variables Together, From bind to substitution
changing prefix character, Changing the Substitution Variable Prefix Character
defining, The DEFINE and UNDEFINE Commands, Deleting a variable, DEFINE
session-duration, Using Double-Ampersand Variables, A final caveat
disabling, Enabling and Disabling Substitution
examining/listing, Examining a variable
extract scripts, Make Your Extract Script User-Friendly
reports, Master/Detail Formatting, Modify the page heading to print the employee name and ID
scripts, Using Substitution Variables, A final caveat
settings for, Substitution Variable Settings, SET SCAN
troubleshooting, Controlling Variable Substitution, Changing the substitution variable prefix character
verification, Turning Verification Off
within comments, Substitution Within Comments
user input
parsing with SQL, Parsing Input with SQL, Parsing Input with SQL
validating, Validating and Parsing User Input
ACCEPT statement, Validating Input with ACCEPT, ACCEPTing date values
SQL for, Validating Input with SQL, Validating Input with SQL
USER parameter (SHOW), The SHOW Command, SHOW
user profile script, SQL*Plus Settings You Can Control, The User Profile
USER views, The View Types: ALL, DBA, and USER, The View Types: ALL, DBA, and USER
USER_TABLES view, Listing Tables You Own
users
connecting as other, CONNECT, CONNECT, CONNECT
logging in as administrator, Connecting for Administrative Purposes, Connecting as INTERNAL
product user profile, Missing the Product User Profile, What Is the Product User Profile?, Listing restrictions for a particular user
creating profile table, Creating the Profile Table, Creating the Profile Table
disabling commands access, Limiting Access to Commands, Re-enabling a command
disabling roles access, Limiting Access to Roles, Re-enabling a role
limitations, Product User Profile Limitations, Issues related to roles
reporting on, Reporting on the Product User Profile, Listing restrictions for a particular user
prompting for values, Using Single-Ampersand Variables, Using PROMPT to explain the output
display text for, The PROMPT Command, Using PROMPT to explain the output
extract scripts, Make Your Extract Script User-Friendly
session-duration definitions, Using Double-Ampersand Variables, A final caveat
TERMOUT setting and, When TERMOUT is off, Prompting for Values
tables owned by, listing, Listing Tables You Own
USE_CONCAT hint, Access method hints
USE_HASH hint, Join operation hints
USE_MERGE hint, Join operation hints
USE_NL hint, Join operation hints
USING BACKUP CONTROLFILE clause (RECOVER), RECOVER
UTLXPLAN.SQL script, Creating the Plan Table

V

V$..., V_$... pseudoviews (see dynamic performance views)
V$DATAFILE view, Cold backups
V$LOGFILE view, Cold backups
V7, V8 parameters (SET COMPATIBILITY), SET COMPATIBILITY
VALIDATED column (ALL_CONSTRAINTS), The ALL_CONSTRAINTS view
validating user input, Validating and Parsing User Input
ACCEPT statement, Validating Input with ACCEPT, ACCEPTing date values
SQL for, Validating Input with SQL, Validating Input with SQL
values, prompting users for, Using Single-Ampersand Variables, Using PROMPT to explain the output
session-duration definitions, Using Double-Ampersand Variables, A final caveat
TERMOUT setting and, When TERMOUT is off, Prompting for Values
VARCHAR2 datatype, Notes about the LIST_COLUMNS script, Declaring Bind Variables, VARIABLE
VAR[IABLE] command, Declaring Bind Variables, VARIABLE
Variable Size value (SGA), Looking at the SGA
variables
bind variables, Bind Variables, Testing application queries
declaring, Declaring Bind Variables, VARIABLE
displaying contents of, Displaying the Contents of a Bind Variable, SELECTing a bind variable
how to use, When and How to Use Bind Variables, Testing application queries
printing contents automatically, SET AUTOPRINT
substitution variables with, Using Bind Variables and Substitution Variables Together, From bind to substitution
prompting users for values, Using Single-Ampersand Variables, Using PROMPT to explain the output
display text for, The PROMPT Command, Using PROMPT to explain the output
extract scripts, Make Your Extract Script User-Friendly
session-duration definitions, Using Double-Ampersand Variables, A final caveat
TERMOUT setting and, When TERMOUT is off, Prompting for Values
resetting definitions, A final caveat, The UNDEFINE Command
SQL*Plus system variables, The bottom title
substitution (user) variables
bind variables with, Using Bind Variables and Substitution Variables Together, From bind to substitution
changing prefix character, Changing the Substitution Variable Prefix Character
defining, Using Double-Ampersand Variables, A final caveat, The DEFINE and UNDEFINE Commands, Deleting a variable, DEFINE
disabling, Enabling and Disabling Substitution
examining/listing, Examining a variable
extract scripts, Make Your Extract Script User-Friendly
reports, Master/Detail Formatting, Modify the page heading to print the employee name and ID
scripts, Using Substitution Variables, A final caveat
settings for, Substitution Variable Settings, SET SCAN
troubleshooting, Controlling Variable Substitution, Changing the substitution variable prefix character
verification, Turning Verification Off
within comments, Substitution Within Comments
VAR[IANCE] parameter (COMPUTE command), Syntax of the COMPUTE command, Syntax of the COMPUTE command
verification, turning off, Turning Verification Off, SET VERIFY
VER[IFY] setting, SET VERIFY
version of Oracle, specifying, SET COMPATIBILITY
versions of SQL*Plus, Which Platform and Version?
command-line vs. GUI, Command-Line Versus GUI Versions
displayed at startup, Logging into a database, Command-Line Options
VER[IFY] setting, Turning Verification Off
VIEW operation (EXPLAIN PLAN), Making sense of the results
views
data dictionary, Oracle’s Data Dictionary Views, The ALL_COL_PRIVS view
definitions of, viewing, Describing a Table
dynamic performance views, Granting Access to the Performance Views
VIS[IBLE] parameter (SET SHIFTINOUT), SET SHIFTINOUT

W

WARNING parameter
EXIT command, EXIT
QUIT command, QUIT
WHENEVER command, The WHENEVER Command, WHENEVER OSERROR, WHENEVER
WHENEVER OSERROR, The WHENEVER Command, WHENEVER OSERROR, WHENEVER OSERROR, WHENEVER
WHENEVER SQLERROR, The WHENEVER Command, PL/SQL errors and WHENEVER, WHENEVER
WHEN_CLAUSE column (ALL_TRIGGERS), The ALL_TRIGGERS view
WHERE clause, simulating branching with, Simulating Branching by Adjusting the WHERE Clause, Simulating Branching by Adjusting the WHERE Clause
width (see size)
Windows environment variables, setting, Windows 95/98/NT, Windows 3.1
Windows shortcuts for scripts, Creating a Windows Shortcut, Creating the shortcut
word wrap, Where’s the output?, SET WRAP, Formatting Character Strings
WOR[D_WRAPPED] parameter
COLUMN command, The COLUMN command, COLUMN, Formatting Character Strings
SET SERVEROUTPUT command, SET SERVEROUTPUT
work file names, SET EDITFILE
working directory, The Working Directory, The Working Directory
WRA[P] setting, SET WRAP
WRA[PPED] parameter
COLUMN command, The COLUMN command, COLUMN
SET RECSEP command, SET RECSEP
WRA[PPED] parameter
SET SERVEROUTPUT command, SET SERVEROUTPUT
wrapping output lines, Where’s the output?, SET WRAP, Formatting Character Strings
writing SQL with SQL, DDL, Using SQL to Write SQL, Using SQL to Write SQL, Generating a File of Commands, Generating a File of Commands
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset