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)
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
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.