Oracle7 Server SQL Reference Manual
Library
Product
Contents
Index
Index
@
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
@
!= comparison operator
[
2
]
" double quotation marks, with object names
$ format element
% character, in pattern matching
(+) outer join operator
[
2
]
, format element
. number format element
0 format element
9 format element
<< comparison operator
<<= comparison operator
= comparison operator
> comparison operator
>= comparison operator
[
\
]
^
^= comparison operator
_
_ character, in pattern matching
A.D. format element
A.M. format element
abnormal termination, automatic rollback
ABS numeric function
AD format element
ADD clause, of ALTER TABLE command
ADD DATAFILE clause, of ALTER TABLESPACE command
ADD LOGFILE clause, of ALTER DATABASE command
ADD LOGFILE MEMBER clause, of ALTER DATABASE command
ADD_MONTHS date function
adding, columns to tables
[
2
] [
3
]
comments to objects
datafiles
datafiles to databases
[
2
]
datafiles to tablespaces
integrity constraints to columns
[
2
]
integrity constraints to tables
[
2
] [
3
]
members to redo log file groups
procedures to packages
redo log file groups to threads
redo log files to databases
[
2
]
resource limits to profiles
[
2
]
stored functions to packages
tables to clusters
[
2
]
triggers to tables
ADMIN OPTION, of GRANT command
[
2
]
ADVISE clause, of ALTER SESSION command
AFTER option, of CREATE TRIGGER command
alias, table
ALL comparison operator
[
2
]
ALL option
of ARCHIVE LOG clause
of DEFAULT ROLE clause
of SELECT command
of SET ROLE command
of SQL group functions
ALL PRIVILEGES option
of GRANT command
of REVOKE command
ALL statement auditing short cut
ALL TRIGGERS option
of DISABLE clause
of ENABLE clause
ALL_INDEXES view
ALL_TAB_COLUMNS view
ALL_TABLES view
ALLOCATE command
ALLOCATE EXTENT clause
of ALTER CLUSTER command
of ALTER TABLE command
[
2
]
allocating
cursors
extents for tables
[
2
]
ALTER CLUSTER command
[
2
]
ALTER DATABASE command
[
2
]
examples
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
] [
9
] [
10
] [
11
] [
12
] [
13
] [
14
]
ALTER FUNCTION command
examples
ALTER INDEX command
[
2
]
examples
ALTER object auditing option
ALTER object privilege
on sequences
on tables
ALTER PACKAGE command
examples
[
2
]
ALTER PROCEDURE command
examples
ALTER PROFILE command
examples
[
2
] [
3
] [
4
]
ALTER RESOURCE COST command
examples
ALTER ROLE command
examples
ALTER ROLLBACK SEGMENT command
[
2
]
examples
ALTER SEQUENCE command
examples
[
2
]
ALTER SESSION command
[
2
]
examples
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
] [
9
] [
10
] [
11
]
ALTER SNAPSHOT command
examples
[
2
] [
3
]
ALTER SNAPSHOT LOG command
examples
ALTER SYSTEM command
examples
[
2
] [
3
] [
4
]
ALTER TABLE command
[
2
]
examples
ALTER TABLESPACE command
[
2
]
examples
ALTER TRIGGER command
examples
ALTER USER command
[
2
]
examples
syntax
ALTER VIEW command
examples
altering
costs of resources
databases
profiles
sequences
snapshot logs
snapshots
tables
AM format element
American National Standards Committee (ANSI)
ANALYZE command
examples
[
2
]
AND logical operator
in a condition
truth table
ANSI
American National Standards Institute
datatypes
X3.135-1992
ANY comparison operator
ARCHIVE LOG clause
examples
[
2
]
of ALTER SYSTEM command
ARCHIVELOG option
of ALTER DATABASE command
of CREATE CONTROLFILE command
of CREATE DATABASE command
archiving redo log files
disabling
enabling
arithmetic operator
arithmetic, with DATE values
AS clause
of CREATE SNAPSHOT command
of CREATE TABLE command
of CREATE VIEW command
ASC option
of CREATE INDEX command
of ORDER BY clause
ASCII
and EBCDIC
character function
character set
AT clause
of COMMIT command
of CONNECT command
of DECLARE CURSOR command
of DECLARE STATEMENT command
of EXECUTE command
of EXECUTE IMMEDIATE command
of INSERT command
of ROLLBACK command
of SAVEPOINT command
of SELECT command
of UPDATE command
AUDIT command
[
2
] [
3
]
examples
[
2
]
AUDIT object auditing option
AUDIT_TRAIL
AUTOEXTEND clause
of ALTER DATABASE command
of CREATE DATABASE command
AUTOEXTEND, datafile size in tablespace
[
2
]
AUTOMATIC option, of RECOVER clause
AVG group function
B format element
B.C. format element
BACKUP CONTROLFILE clause, of ALTER DATABASE command
BC format element
BEFORE option, of CREATE TRIGGER command
BEGIN BACKUP option, of ALTER TABLESPACE command
BETWEEN comparison operator
[
2
]
blank-padded comparison semantics
block size, effect on PCTINCREASE
BODY option
of ALTER PACKAGE command
of DROP PACKAGE command
BY ACCESS option, of AUDIT command
[
2
]
BY clause
of AUDIT command
of NOAUDIT command
BY SESSION option, of AUDIT command
[
2
]
C format element
CACHE parameter
of CREATE SEQUENCE command
of CREATE SEQUENCE command
CACHE_INSTANCES parameter, of ALTER SYSTEM command
CANCEL option, of RECOVER clause
capitalizing, date format elements
cartesian product
CASCADE CONSTRAINTS option
of DROP CLUSTER command
of DROP TABLE command
of DROP TABLESPACE command
of REVOKE command
CASCADE option
of ANALYZE command
of DISABLE clause
of DROP clause
of DROP USER command
case sensitivity
in pattern matching
in SQL statements
CATEXP.SQL
CEIL number function
[
2
]
century, storing
change display format, format model
CHANGE parameter, of ARCHIVE LOG clause
changing
goal for the cost-based optimization approach
optimization approach
passwords
CHAR datatype
comparing values of
CHARACTER datatype
in V6
CHARACTER SET parameter, of CREATE DATABASE command
character, character sets
[
2
]
comparison rules
datatypes
literal
operator
SQL functions
CHARTOROWID conversion function
CHECK constraint
CHECK constraints
CHECK DATAFILES clause, of ALTER SYSTEM command
CHECK OPTION, of CREATE VIEW command
CHECKPOINT clause, of ALTER SYSTEM command
[
2
]
CHR character function
CLEAR LOGFILE clause, of ALTER DATABASE command
CLOSE command
examples
CLOSE DATABASE LINK clause, of ALTER SESSION command
CLOSE_OPEN_CACHED_CURSORS clause, of ALTER SESSION command
closing
cursors
database links
database links
CLUSTER clause
of CREATE SNAPSHOT command
of CREATE TABLE command
cluster keys
distinct values of
CLUSTER option
of ANALYZE command
of CREATE INDEX command
of TRUNCATE command
clusters
adding snapshots to
adding tables to
[
2
]
altering
cluster indexes
creating
definition
dropping
indexed clusters
[
2
]
order of columns in
physical storage of tables in
removing tables from
size
specifying tablespaces for
storage characteristics of
storage characteristics of
[
2
] [
3
] [
4
] [
5
] [
6
]
truncating
column constraints
column_constraint, syntax
columns, adding comments to
[
2
]
adding integrity constraints to
[
2
]
adding to tables
[
2
] [
3
]
changing datatypes of
[
2
] [
3
] [
4
]
changing default values of
[
2
]
defining
maximum number in a table
maximum number in indexes
of cluster keys
order in indexes
qualifying names with tables and schemas
redefining
[
2
] [
3
] [
4
]
removing integrity constraints from
removing comments from
removing integrity constraints from
renaming
selecting from tables
specifying datatypes for
vs. pseudocolumns
COMMENT clause, of COMMIT command
[
2
]
COMMENT command
examples
COMMENT object auditing option
comments
adding to objects
examples
removing from objects
within SQL statements
COMMIT command
[
2
] [
3
]
ending a transaction
[
2
] [
3
]
examples
[
2
] [
3
]
summary
COMMIT option, of ADVISE clause
committing, transactions
[
2
]
comparison operators
comparison rules
comparison semantics
blank-padded
non-padded
compatibility mode
COMPILE option, of ALTER FUNCTION command
[
2
] [
3
]
of ALTER PROCEDURE command
of ALTER VIEW command
compiling
packages
procedures
stored functions
COMPLETE option, of REFRESH clause
[
2
]
complex snapshots
COMPOSITE_LIMIT parameter, of CREATE PROFILE command
COMPUTE STATISTICS option, of ANALYZE command
CONCAT character function
[
2
]
condition
example
multiple
syntax
CONNECT BY clause
examples
of SELECT command
[
2
] [
3
]
CONNECT command
examples
CONNECT role
CONNECT statement auditing short cut
CONNECT TO clause, of CREATE DATABASE LINK command
CONNECT_TIME parameter
of ALTER RESOURCE COST command
of CREATE PROFILE command
constant, literal
CONSTRAINT clause
examples
[
2
]
syntax
CONSTRAINT identifier, of CONSTRAINT clause
[
2
]
of WITH CHECK OPTION clause
CONSTRAINT option
of DISABLE clause
of DROP clause
constraints, Integrity constraints
CONTINUE option
of RECOVER clause
of WHENEVER command
control files, reusing
CONTROL_FILES
CONTROLFILE REUSE option, of CREATE DATABASE command
controlfile, standby database
CONVERT conversion function
CONVERT option, of ALTER DATABASE command
converting values
explicitly
[
2
]
implicitly
[
2
]
correlated subqueries
[
2
]
examples
correlated update
COSH number function
cost, of executing SQL statements
COUNT group function
CPU_PER_CALL parameter, of CREATE PROFILE command
CPU_PER_SESSION parameter, of CREATE PROFILE command
CREATE CLUSTER command
[
2
]
examples
CREATE CONTROLFILE command
examples
CREATE DATABASE command
[
2
]
examples
CREATE DATABASE LINK command
[
2
]
CREATE DATAFILE clause, of ALTER DATABASE command
CREATE FUNCTION command
CREATE INDEX command
[
2
]
CREATE PACKAGE BODY command
examples
CREATE PACKAGE command
examples
CREATE PROCEDURE command
CREATE PROFILE command
examples
CREATE ROLE command
examples
CREATE ROLLBACK SEGMENT command
[
2
]
examples
CREATE SCHEMA command
examples
CREATE SEQUENCE command
examples
CREATE SNAPSHOT command
examples
CREATE SNAPSHOT LOG command
examples
CREATE SYNONYM command
examples
CREATE TABLE command
[
2
]
examples
[
2
]
part of CREATE SCHEMA command
CREATE TABLESPACE command
[
2
]
examples
CREATE TRIGGER command
examples
[
2
]
CREATE USER command
examples
CREATE VIEW command
examples
part of CREATE SCHEMA command
creating
clusters
database links
databases
dispatcher processes (DISP)
indexes
packages
[
2
]
procedures
profiles
roles
rollback segments
savepoints
[
2
]
schemas
sequences
shared server processes
snapshot logs
snapshots
stored functions
synonyms
tables
tablespaces
triggers
users
views
CURRENT OF clause
of embedded SQL DELETE command
of embedded SQL UPDATE command
CURRENT option, of ARCHIVE LOG clause
CURRVAL pseudocolumn
examples
[
2
] [
3
]
cursor variable
[
2
]
cursors
allocating
closing
fetching rows from
opening
storing in session cache
CYCLE option, of CREATE SEQUENCE command
D format element
data complexity, hiding with a view
data definition language (DDL)
data independence, via synonyms
data manipulation language (DML)
database links, closing
[
2
] [
3
]
creating
definition
dropping
using in DELETE command
[
2
]
using in INSERT command
[
2
]
using in LOCK TABLE command
using in SELECT command
[
2
]
using in UPDATE command
[
2
]
using with synonyms
database objects, definition of
DATABASE option, of RECOVER clause
DATABASE parameter, of CREATE CONTROLFILE command
database
deleting rollback segments from
disconnecting from, embedded SQL
databases, adding datafiles to
[
2
]
adding redo log files to
[
2
]
altering
archiving redo log files
[
2
] [
3
] [
4
]
creating
maximum number
[
2
]
of instances
of redo log files
[
2
]
mounting and dismounting
opening and closing
renaming
reusing control files
DATAFILE clause
of ALTER DATABASE command
of CREATE CONTROLFILE clause
of CREATE DATABASE command
of CREATE TABLESPACE command
DATAFILE option, of RECOVER clause
DATAFILE parameter, of ALLOCATE EXTENT clause
[
2
] [
3
]
datafiles
adding
adding to databases
[
2
]
adding to tablespaces
[
2
]
backing up
[
2
] [
3
]
maximum number
[
2
]
renaming
[
2
] [
3
]
specifying
datatypes
[
2
]
ANSI
changing for columns
[
2
]
converting between values of different
converting between with SQL functions
DB2
explicit conversion
implicit conversion
of conditions
of expressions
specifying for columns
[
2
]
SQL/DS
summary
user-defined type equivalencing
DATE datatype
comparing values of
julian
DATE format element
date format elements
capitalizing
date format model
default
examples
[
2
] [
3
]
modifiers
suffixes
date
arithmetic
comparison rules
DAY format element
DB2, datatypes
DB_FILES
DBA role
[
2
]
DBA statement auditing short cut
DBA_CLUSTERS view
DBA_INDEXES view
DBA_TAB_COLUMNS view
DBA_TABLES view
DBHIGH parameter, of ALTER DATABASE command
DBHIGH predefined label
DBLOW parameter, of ALTER DATABASE command
DBLOW predefined label
DBMAC parameter, of ALTER DATABASE command
[
2
]
DBMS MAC mode
DBMS_SNAPSHOT.REFRESH() procedure
DBMSSNAP.SQL
[
2
]
DBMSSTDX.SQL
[
2
] [
3
] [
4
] [
5
]
DDL (data definition language)
decimal places, negative
DECLARE CURSOR command
examples
DECLARE DATABASE command
DECLARE STATEMENT command
examples
scope of
DECLARE TABLE command
examples
DECODE expression
DEFAULT option, of ALTER PROFILE command
[
2
] [
3
] [
4
] [
5
] [
6
]
of AUDIT command
of CREATE PROFILE command
of CREATE TABLE command
of RECOVER clause
default privilege domain
DEFAULT profile
[
2
] [
3
] [
4
] [
5
]
DEFAULT ROLE clause, of ALTER USER command
[
2
]
DEFAULT STORAGE clause, of ALTER TABLESPACE clause
[
2
]
of CREATE TABLESPACE command
[
2
]
DEFAULT TABLESPACE clause
of ALTER USER command
of CREATE USER command
default, cluster key
DELETE command
[
2
] [
3
]
embedded SQL examples
summary
DELETE object auditing option
DELETE object privilege
on tables
on views
DELETE option, of CREATE TRIGGER command
[
2
]
DELETE STATISTICS option, of ANALYZE command
deleting
rows from tables
rows from tables and views
delimited names, quoted names
DESC option
of CREATE INDEX command
of ORDER BY clause
DESCRIBE command
example
use with PREPARE command
descriptor, naming
DISABLE clause
examples
of ALTER DATABASE command
of ALTER TABLE command
of CREATE TABLE command
DISABLE COMMIT IN PROCEDURE option, of ALTER SESSION command
DISABLE DISTRIBUTED RECOVERY option, of ALTER SYSTEM command
DISABLE option
of ALTER TRIGGER command
of CONSTRAINT clause
DISABLE RESTRICTED SESSION option, of ALTER SYSTEM command
disabling
distributed recovery
integrity constraints
[
2
] [
3
]
redo log threads
resource limits
[
2
] [
3
]
roles for sessions
SQL trace facility for sessions
[
2
]
table locks
[
2
]
triggers
disconnect from database
ending a transaction
with the RELEASE option of ROLLBACK
dispatcher processes (DISP), creating and terminating
[
2
]
DISTINCT clause, with ORDER BY clause
DISTINCT option
of SELECT command
of SQL group functions
distributed query, examples
distributed query
restrictions on
distributed recovery, disabling
[
2
]
enabling in a single-process environment
[
2
]
enabling in single-process environments
distributed transactions
[
2
]
DML (data manipulation language)
DO option, of WHENEVER command
DROP clause
examples
of ALTER TABLE command
DROP CLUSTER command
examples
DROP DATABASE LINK command
examples
DROP FUNCTION command
examples
DROP INDEX command
examples
DROP LOGFILE clause, of ALTER DATABASE command
DROP LOGFILE MEMBER clause, of ALTER DATABASE command
DROP PACKAGE command
DROP PROCEDURE command
examples
[
2
]
DROP PROFILE command
examples
DROP ROLE command
examples
DROP ROLLBACK SEGMENT command
[
2
]
examples
DROP SEQUENCE command
examples
DROP SNAPSHOT command
examples
DROP SNAPSHOT LOG command
examples
DROP STORAGE option, of TRUNCATE command
DROP SYNONYM command
examples
DROP TABLE command
[
2
]
examples
DROP TABLESPACE command
examples
DROP TRIGGER command
examples
DROP USER command
examples
DROP VIEW command, examples
dropping
clusters
database links
indexes
integrity constraints from tables
[
2
] [
3
]
members from redo log file groups
objects contained in tablespaces
objects owned by users
package bodies
packages
procedures
profiles
redo log file groups
roles
sequences
snapshots
snapshots logs
stored functions
synonyms
tables
tablespaces
[
2
]
triggers from tables
users
views
DUAL data dictionary table
definition
example of selecting from
DUMMY column, of DUAL table
DUMP function
DY format element
dynamic performance tables, V$LOG
[
2
]
V$NLS_PARAMETERS
EBCDIC
and ASCII
character set
EEEE format element
embedded SQL
DECLARE CURSOR command
DECLARE DATABASE command
DECLARE TABLE command
EXECUTE command
embedded SQL
ALLOCATE command
CLOSE command
COMMIT command
CONNECT command
DECLARE STATEMENT command
DELETE command
DESCRIBE command
EXECUTE command
EXECUTE IMMEDIATE command
FETCH command
INSERT command
OPEN command
PREPARE command
ROLLBACK command
SAVEPOINT command
SELECT command
terms
TYPE command
UPDATE command
VAR command
WHENEVER command
embedding, PL/SQL blocks in Oracle7 precompiler programs
ENABLE clause
examples
of ALTER DATABASE command
of ALTER TABLE command
of CREATE TABLE command
ENABLE COMMIT IN PROCEDURE option, of ALTER SESSION command
ENABLE DISTRIBUTED RECOVERY option
of ALTER SYSTEM command
of ALTER SYSTEM command
ENABLE option, of ALTER TRIGGER command
ENABLE RESTRICTED SESSION option, of ALTER SYSTEM command
ENABLE TABLE LOCK clause, of ALTER TABLE command
[
2
]
enabling, distributed recovery
[
2
] [
3
]
integrity constraints
[
2
] [
3
]
redo log threads
resource limits
[
2
] [
3
] [
4
]
roles for sessions
SQL trace facility for sessions
SQL trace facility for sessions
triggers
END BACKUP option, of ALTER TABLESPACE command
END BACKUP, of ALTER DATABASE command
ending, transactions
[
2
]
ENTRYID option, of USERENV function
equijoins
equivalencing
host variable equivalencing
user-defined type equivalencing
error detection, error reporting
error reporting, WHENEVER command
ESCAPE character, of LIKE operator
ESTIMATE STATISTICS option, of ANALYZE command
examples, of comments
EXCEPT clause
of ALTER USER command
of SET ROLE command
EXCEPTIONS option, of ENABLE clause
exclusive lock
EXCLUSIVE option
of ALTER DATABASE command
of CREATE DATABASE command
EXECUTE command
[
2
]
examples
[
2
]
EXECUTE IMMEDIATE command
examples
EXECUTE object auditing option
EXECUTE object privilege, on procedures, functions, and packages
executing, triggers
EXISTS comparison operator
EXP number function
EXPLAIN PLAN command
examples
summary
syntax
explicit commit or rollback
expression
examples
use in condition
extents, allocating for tables
[
2
]
deallocating space
INITIAL size
MAXEXTENTS limit
EXTERNALLY option
of IDENTIFIED clause
of IDENTIFIED clause
[
2
] [
3
]
FALSE option, of SET RESOURCE_LIMIT clause
FALSE, result of a condition
FAST option, of REFRESH clause
[
2
]
Federal Information Processing Standard (FIPS)
FETCH command
examples
used after OPEN command
fetching, rows from cursors
filespec
examples
fill mode, trims trailing blanks
FIPS
FIPS Flagger
FIPS
Federal Information Processing Standard
flagging
PUB 127-2
firing, triggers
FLAGGER clause, of ALTER SESSION command
FLOAT, ANSI datatype
FLOOR number function
FLUSH SHARED_POOL option, of ALTER SYSTEM command
FM date format element prefix, examples
FM format model modifier
FOR clause
of embedded SQL EXECUTE command
of embedded SQL INSERT command
of EXPLAIN PLAN command
FOR EACH ROW option, of CREATE TRIGGER command
FOR UPDATE clause, of SELECT command
[
2
]
FOR UPDATE OF, example
FORCE clause, of COMMIT command
[
2
]
of ROLLBACK command
[
2
]
FORCE option
of CREATE VIEW command
of REFRESH clause
[
2
]
foreign key constraints
format model
date
definition
examples
[
2
] [
3
] [
4
] [
5
]
number
formatting
date values
number values
FREELIST GROUPS parameter, of STORAGE clause
FREELISTS parameter, of STORAGE clause
FROM clause, of REVOKE command
[
2
]
FROM parameter, of RECOVER clause
functions
PL/SQL
SQL
stored functions
user
FX format model modifier
G format element
GLB group function
GLOBAL option
of CHECK DATAFILES clause
of CHECKPOINT clause
GLOBAL_NAMES
GLOBAL_NAMES parameter, of ALTER SYSTEM command
GOTO option, of WHENEVER command
GRANT command
[
2
] [
3
] [
4
]
examples
[
2
]
part of CREATE SCHEMA command
GRANT object auditing option
GRANT OPTION, of GRANT command
granting
object privileges to users and roles
roles
system privileges and roles to users, roles
GRAPHIC datatype
GREATEST function
GREATEST_LB function
GROUP BY clause
group SQL functions and
of SELECT command
[
2
]
GROUP parameter
of ADD LOGFILE MEMBER clause
of DROP LOGFILE clause
group, SQL functions
HASH parameter, of CREATE CLUSTER command
HAVING clause, of SELECT command
[
2
]
HEXTORAW conversion function
hints
in DELETE statements
in SELECT statements
[
2
]
in UPDATE statements
[
2
]
HOLD_CURSOR option, of ORACLE Precompilers
host variables
host variable equivalencing
in EXECUTE command
in OPEN command
I date format element
IDENTIFIED clause
of ALTER USER command
of CREATE ROLE command
of CREATE USER command
identifiers, names
IDLE_TIME parameter, of CREATE PROFILE command
IEC (International Electrotechnical Commission)
IMMEDIATE option, of ALTER TABLESPACE command
IN comparison operator
definition
INCLUDING CONTENTS option, of DROP TABLESPACE command
INCLUDING TABLES option, of DROP CLUSTER command
INCREMENT BY clause, of CREATE SEQUENCE command
incrementing, sequence values
[
2
]
INDEX object auditing option
INDEX object privilege, on tables
INDEX option
of ANALYZE command
of CREATE CLUSTER command
INDEX_STATS view
indexed clusters
[
2
]
indexes
altering
and LIKE operator
cluster indexes
creating
definition
dropping
[
2
]
LONG RAW datatypes prohibit
multiple per table
storage characteristics of
[
2
] [
3
] [
4
]
indexing, specifying tablespaces for
INIT.ORA parameters, initialization parameters
INITCAP character function
INITIAL parameter, of STORAGE clause
[
2
]
initialization parameters, NLS_TERRITORY
initialization parameters
AUDIT_TRAIL
CONTROL_FILES
DB_FILES
GLOBAL_NAMES
INSTANCES
LOG_FILES
MAX_ENABLED_ROLES
MTS_DISPATCHERS
MTS_MAX_DISPATCHERS
MTS_MAX_SERVERS
MTS_SERVERS
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_LANGUAGE
NLS_TERRITORY
[
2
]
OPEN_LINKS
[
2
]
OPTIMIZER_MODE
OS_AUTHENT_PREFIX
OS_ROLES
ROLLBACK_SEGMENTS
SNAPSHOT_REFRESH_INTERVAL
SNAPSHOT_REFRESH_KEEP_CONNECTIONS
SNAPSHOT_REFRESH_PROCESSES
SQL_TRACE
THREAD
INITRANS parameter
of ALTER CLUSTER command
of ALTER INDEX command
of ALTER SNAPSHOT command
of ALTER TABLE command
of CREATE CLUSTER command
of CREATE INDEX command
of CREATE SNAPSHOT command
[
2
]
of CREATE TABLE command
INSERT command
[
2
] [
3
] [
4
]
embedded SQL examples
examples
[
2
] [
3
]
summary
INSERT object auditing option
INSERT object privilege
on tables
on views
INSERT option, of CREATE TRIGGER command
[
2
]
inserting, rows into tables and views
[
2
]
INSTANCE clause, of ALTER SESSION command
INSTANCE parameter, of ALLOCATE EXTENT clause
[
2
] [
3
]
INSTANCES
maximum number
INSTR character function
INSTRB character function
INTEGER datatype
integrity constraints, adding to columns
[
2
]
adding to tables
[
2
] [
3
]
CHECK
[
2
]
column definition
creating as parts of tables
defining
definition
disabling
[
2
] [
3
] [
4
]
dropping from tables
enabling
[
2
] [
3
]
NOT NULL
PRIMARY KEY
[
2
]
referential
[
2
]
removing from columns
[
2
]
table definition
[
2
] [
3
] [
4
]
UNIQUE
[
2
]
International Electrotechnical Commission (IEC)
International Standards Organization (ISO)
INTERSECT set operator
examples
INTO clause
of ANALYZE command
of EXPLAIN PLAN command
of FETCH command
of SELECT command
IS NOT NULL comparison operator
IS NULL comparison operator
[
2
]
ISDBA option, of USERENV function
ISO
International Standards Organization
ISO/IEC 9075:1992
IW date format element
IY date format element
IYY date format element
IYYY date format element
join view
joins
and clusters
examples
[
2
]
simple
julian dates
KILL SESSION clause, of ALTER SYSTEM command
L format element
LABEL option, of USERENV function
LABEL parameter, of ALTER SESSION command
LANGUAGE option, of USERENV function
LAST_DAY date function
LEAST function
LEAST_UB function
LENGTH character function
LENGTHB character function
LEVEL pseudocolumn
in SELECT command
lexical conventions, SQL
LICENSE_MAX_SESSION parameter, of ALTER SYSTEM command
LICENSE_MAX_USERS parameter, of ALTER SYSTEM command
LICENSE_SESSIONS_WARNING parameter, of ALTER SYSTEM command
LIKE comparison operator
[
2
] [
3
]
definition
links, database links
LIST option, of ANALYZE command
literal
character
definition of
numeric
LN number function
LOCAL option
of CHECK DATAFILES clause
of CHECKPOINT clause
location transparency, via synonyms
LOCK object auditing option
LOCK TABLE command
[
2
]
examples
summary
lock
and queries
exclusive
locking, tables and views
lock
multiple
released by ROLLBACK statement
releasing with COMMIT command
table
types of
LOG number function
LOG_FILES
logarithms
LN number function
LOG number function
LOGFILE clause
of CREATE CONTROLFILE command
of CREATE DATABASE command
LOGFILE parameter
of ARCHIVE LOG clause
of RECOVER clause
logical operator
definition
use in condition
logical Unit of Work
LOGICAL_READS_PER_CALL parameter, of CREATE PROFILE command
LOGICAL_READS_PER_SESSION parameter
of CREATE PROFILE command
of ALTER RESOURCE COST command
LONG datatype
maximum length
restrictions on
LONG RAW datatype
indexing prohibited on
similarity to LONG datatype
LONG VARGRAPHIC datatype
LOWER character function
[
2
]
lowercase and uppercase
of object names
significance in pattern matching
lowercase, significance in SQL statements
LPAD character function
LTRIM character function
LUB group function
MAC mode
[
2
]
MAX group function
MAX_ENABLE_ROLES
MAXDATAFILES parameter
of CREATE CONTROLFILE command
of CREATE DATABASE command
MAXEXTENTS parameter, of STORAGE clause
[
2
]
MAXINSTANCES parameter
of CREATE CONTROLFILE command
of CREATE DATABASE command
MAXLOGFILES parameter
of CREATE CONTROLFILE command
of CREATE DATABASE command
MAXLOGHISTORY parameter
of CREATE CONTROLFILE command
of CREATE DATABASE command
MAXLOGMEMBERS parameter
of CREATE DATABASE command
of CREATE CONTROLFILE command
MAXSIZE clause, of ALTER DATABASE command
MAXTRANS parameter
of ALTER CLUSTER command
of ALTER INDEX command
of ALTER SNAPSHOT command
of ALTER TABLE command
of CREATE CLUSTER command
of CREATE INDEX command
of CREATE SNAPSHOT command
[
2
]
of CREATE TABLE command
MAXVALUE parameter, of CREATE SEQUENCE command
MI format element
MIN group function
MINEXTENTS parameter, of STORAGE clause
MINUS set operator
examples
MINVALUE parameter, of CREATE SEQUENCE command
miscellaneous operators
MLS_LABEL_FORMAT parameter, of ALTER SESSION command
MLSLABEL datatype
MOD number function
MODIFY clause, of ALTER TABLE command
modifying, column definitions
[
2
] [
3
]
resource limits
MON format element
MONTH format element
MONTHS_BETWEEN date function
MOUNT option, of ALTER DATABASE command
mounting, databases
MTS_DISPATCHERS
MTS_DISPATCHERS parameter, of ALTER SYSTEM command
[
2
]
MTS_MAX_DISPATCHERS
MTS_MAX_SERVERS
MTS_SERVERS
MTS_SERVERS parameter
of ALTER SYSTEM command
of ALTER SYSTEM command
multi-threaded server, managing processes for
multi-threaded server, managing processes for
[
2
]
names
for objects
lowercase and uppercase
namespaces, for objects
names, quoted
naming objects
National Institute for Standards and Technology (NIST)
National Language Support (NLS), session settings
[
2
]
natural logarithms
navigation, automatic
negative scale
NEW_TIME date function
NEXT clause, of ALTER DATABASE command
NEXT option, of ARCHIVE LOG clause
NEXT parameter, of REFRESH clause
[
2
]
of STORAGE clause
NEXT_DAY date function
[
2
]
NEXTVAL pseudocolumn
examples
[
2
] [
3
] [
4
]
NIST, National Institute for Standards and Technology
NLS_CALENDAR parameter, of ALTER SESSION command
NLS_CURRENCY parameter, of ALTER SESSION command
NLS_DATE_FORMAT parameter, of ALTER SESSION command
NLS_DATE_LANGUAGE parameter, of ALTER SESSION command
NLS_INITCAP character function
NLS_ISO_CURRENCY parameter, of ALTER SESSION command
NLS_LANGUAGE parameter, of ALTER SESSION command
NLS_LOWER character function
NLS_NUMERIC_CHARACTERS parameter, of ALTER SESSION command
NLS_SORT parameter, of ALTER SESSION command
NLS_TERRITORY parameter, of ALTER SESSION command
NLS_UPPER character function
NLSSORT character function
[
2
]
NOARCHIVELOG option
of ALTER DATABASE command
of CREATE CONTROLFILE command
of CREATE DATABASE command
NOAUDIT command
[
2
]
examples
[
2
]
NOCACHE option, of CREATE SEQUENCE command
NOCYCLE option, of CREATE SEQUENCE command
NOFORCE option, of CREATE VIEW command
NOMAXVALUE option, of CREATE SEQUENCE command
NOMINVALUE option, of CREATE SEQUENCE command
non-padded comparison semantics
NONE option
of DEFAULT ROLE clause
of SET ROLE command
NOORDER option, of CREATE SEQUENCE command
NORESETLOGS option
of ALTER DATABASE command
of CREATE CONTROLFILE command
normal exit from Oracle7
NORMAL option, of ALTER TABLESPACE command
NOSORT option, of CREATE INDEX command
[
2
]
NOT FOUND condition, of WHENEVER command
NOT IN comparison operator
examples
NOT LIKE comparison operator
NOT logical operator
truth table
NOT NULL clause, ALTER TABLE command
NOT NULL constraints
NOT option, of WHENEVER clause
[
2
] [
3
] [
4
] [
5
]
NOWAIT option
of FOR UPDATE clause
of LOCK TABLE command
null
NULL value, of OPTIMAL parameter
[
2
]
NULL
constraint, example
in a condition
in an index
NUMBER datatype
comparing values of
number format elements
number format models
examples
number, comparison rules
[
2
]
literal
numeric, literal
NVL function
[
2
]
object auditing options
[
2
]
object auditing short cuts
object name, qualifiers
object naming
object privileges
granting to users and roles
on procedures, functions, and packages
on sequences
on snapshots
on synonyms
on tables
on views
revoking from users and roles
object
naming
naming rules
OF clause, of CREATE TRIGGER command
OFFLINE option, of ALTER ROLLBACK SEGMENT command
[
2
]
of ALTER TABLESPACE command
of CREATE TABLESPACE command
[
2
]
of DATAFILE clause
[
2
]
ON clause, of CREATE TRIGGER command
[
2
]
of GRANT command
of NOAUDIT command
of REVOKE command
ONLINE option
of ALTER ROLLBACK SEGMENT command
of ALTER TABLESPACE command
of CREATE TABLESPACE command
[
2
]
of DATAFILE clause
OPEN command
examples
[
2
]
OPEN option, of ALTER DATABASE command
OPEN_LINKS
opening
cursors
databases
operator
arithmetic
character
definition
logical
[
2
] [
3
]
miscellaneous
NOT IN
set
[
2
]
use in expression
optimal size, of rollback segments
[
2
]
OPTIMIZER_GOAL parameter, of ALTER SESSION command
OPTIMIZER_MODE
optimizer
hints
SQL
OR logical operator, truth table
OR REPLACE option
of CREATE PACKAGE command
of CREATE FUNCTION command
of CREATE PACKAGE BODY command
of CREATE PROCEDURE command
of CREATE TRIGGER command
of CREATE VIEW command
Oracle7 precompilers, embedded SQL
ORDER BY clause
and ROWNUM pseudocolumn
of SELECT command
[
2
]
ORDER option, of CREATE SEQUENCE command
OS MAC mode
OS_AUTHENT_PREFIX, initialization parameter
OS_ROLES
outer join
[
2
] [
3
]
outer joins, examples
overloading, procedures and stored functions
[
2
]
P.M. format element
package bodies, dropping
PACKAGE option, of ALTER PACKAGE command
package specifications
packages
[
2
] [
3
] [
4
]
packages bodies
packages
adding procedures to
adding stored functions to
auditing
creating
[
2
]
creating package bodies for
creating package specifications for
creating synonyms for
dropping
granting object privileges on
[
2
]
recompiling
redefining
[
2
]
removing procedures from
removing stored functions from
revoking object privileges on
PARALLEL clause
of RECOVER clause
PARALLEL option, of ALTER DATABASE command
parallel query clause
of ALTER TABLE command
of CREATE TABLE command
parallel server, setting the instance
PARALLEL_DEFAULT_SCANSIZE parameter
parentheses
around expressions
overriding operator precedence
parsing dynamic statements, PREPARE command
partition views
passwords
changing
establishing for users
[
2
]
pattern matching, definition
PCTFREE parameter
of ALTER CLUSTER command
of ALTER SNAPSHOT command
of ALTER TABLE command
of CREATE CLUSTER command
of CREATE INDEX command
of CREATE SNAPSHOT command
[
2
]
of CREATE TABLE command
PCTINCREASE parameter, of STORAGE clause
PCTUSED parameter
of ALTER CLUSTER command
of ALTER SNAPSHOT command
of ALTER TABLE command
of CREATE CLUSTER command
of CREATE SNAPSHOT command
[
2
]
of CREATE TABLE command
PL/SQL blocks, embedded in Oracle7 precompiler programs
PL/SQL, functions
PM format element
POWER number function
[
2
]
PR format element
precedence, definition
precision, of NUMBER columns
precompilers, embedded SQL
PREPARE command
examples
PRIMARY KEY option
of DISABLE clause
of DROP clause
of ENABLE clause
primary keys
[
2
]
PRIOR operator
PRIVATE_SGA parameter
of ALTER RESOURCE COST command
of CREATE PROFILE command
privilege domain, changing
privileges
[
2
]
procedures
adding to packages
auditing
creating
creating synonyms for
definition
[
2
]
dropping
granting object privileges on
granting privileges on
overloading
[
2
]
recompiling
redefining
removing from packages
revoking object privileges on
PROFILE clause
of ALTER USER command
of CREATE USER command
profiles, adding resource limits to
[
2
]
altering
assigning to users
[
2
] [
3
]
creating
DEFAULT profile
[
2
] [
3
] [
4
]
definition
[
2
]
dropping
modifying resource limits in
PUBLIC_DEFAULT profile
[
2
] [
3
] [
4
] [
5
] [
6
]
removing resource limits from
pseudocolumns
PUBLIC option, of CREATE DATABASE LINK command
[
2
]
of CREATE ROLLBACK SEGMENT command
of CREATE SYNONYM command
of DROP DATABASE LINK command
[
2
]
of DROP SYNONYM command
[
2
]
of ENABLE clause
of FROM clause
[
2
]
of TO clause
[
2
]
public rollback segments
PUBLIC_DEFAULT profile
[
2
] [
3
] [
4
] [
5
]
punctuation, in date format models
queries
examples
[
2
]
SELECT
QUOTA clause
multiple in CREATE USER statement
of ALTER USER command
of CREATE USER command
[
2
] [
3
]
quote marks, using in text literals
quoted names
RAW datatype
RAWTOHEX conversion function
RDBMS (relational database management system)
read consistency, default
READ ONLY option
of CREATE VIEW command
of SET TRANSACTION command
READ WRITE option, of SET TRANSACTION command
read-only mounts
recompiling
packages
procedures
stored functions
RECOVER clause
examples
of ALTER DATABASE command
recoverability, of tables
RECOVERABLE clause, of CREATE TABLE command
RECOVERABLE keyword
recovery
disabling for distributed transactions
disabling for distributed transactions
enabling for distributed transactions
enabling for distributed transactions
[
2
]
redefining
columns
packages
[
2
]
procedures
stored functions
redo log file members, maximum number, for redo log files
redo log file groups
adding members to
adding to threads
assigning to redo log threads
assigning to redo log threads
dropping
dropping members from
maximum number
redo log file members
adding to redo log file groups
dropping from redo log file groups
maximum number
renaming
specifying
redo log files, adding to databases
[
2
]
archiving
[
2
] [
3
] [
4
] [
5
]
maximum number
[
2
]
of members
specifying
switching
[
2
] [
3
]
redo log threads
adding redo log file groups to
assigning redo log file groups to
assigning redo log file groups to
disabling
dropping redo log file groups from
enabling
REFERENCES object privilege, on tables
REFERENCING clause, of CREATE TRIGGER command
referential integrity constraints
[
2
]
REFRESH clause
of ALTER SNAPSHOT command
of CREATE SNAPSHOT command
refresh modes, for snapshots
refresh times, for snapshots
refreshing, snapshots
[
2
] [
3
]
snapshots with snapshot logs
RELEASE_CURSOR option, of ORACLE Precompilers
remote database, declaration of
remote query
remote table, identifying
removing
comments from objects
integrity constraints from columns
[
2
]
procedures from packages
resource limits from profiles
stored functions from packages
RENAME command
examples
RENAME DATAFILE clause, of ALTER TABLESPACE command
RENAME FILE clause, of ALTER DATABASE command
RENAME GLOBAL_NAME clause, of ALTER DATABASE command
RENAME object auditing option
renaming
databases
datafiles
[
2
] [
3
]
objects
redo log file members
REPLACE character function
RESETLOGS option
of ALTER DATABASE command
of CREATE CONTROLFILE command
RESIZE clause, of ALTER DATABASE command
resource limits, adding to profiles
[
2
]
assigning to users
[
2
]
costs of resources
disabling
[
2
] [
3
]
enabling
[
2
] [
3
] [
4
]
exceeding
modifying
removing profiles from
RESOURCE on tablespaces, QUOTA clause
RESOURCE role
RESOURCE statement auditing short cut
RESOURCE_LIMIT option, of ALTER SYSTEM command
[
2
]
retrieving rows from a table, embedded SQL
REUSE option
of BACKUP CONTROLFILE clause
of CREATE CONTROLFILE command
of filespec
REUSE STORAGE option, of TRUNCATE command
REVOKE command
[
2
] [
3
]
examples
[
2
]
revoking
object privileges from users and roles
system privileges and roles from users, roles
RN format element
roles
CONNECT role
creating
DBA role
defined by ORACLE
defined by Oracle7
definition
dropping
enabling or disabling for sessions
establishing default roles for users
[
2
] [
3
]
granting to users and roles
granting object privileges to
granting system privileges and roles to
RESOURCE role
revoking from users and roles
revoking object privileges from
revoking system privileges and roles from
roll back
to a savepoint
to the same savepoint multiple times
ROLLBACK command, ending a transaction
ROLLBACK command
[
2
] [
3
]
ending a transaction
examples
[
2
]
summary
ROLLBACK option, of ADVISE clause
rollback segments
altering
creating
definition
dropping
optimal size of
[
2
]
shrinking size
[
2
] [
3
]
specifying tablespaces for
[
2
]
storage characteristics of
SYSTEM rollback segment
taking online and offline
[
2
] [
3
] [
4
]
ROLLBACK_SEGMENTS
rolling back, transactions
[
2
]
ROUND date function
[
2
]
format models for
ROUND number function
rounding numeric data
by using scale
row address, ROWID
row exclusive locks
row share locks
ROWID
description of
pseudocolumn
ROWIDTOCHAR conversion function
ROWLABEL
ROWLABEL column
ROWLABEL, column
ROWNUM pseudocolumn
and ORDER BY clause
rows
accessing via ROWID
deleting from tables and views
fetching from cursors
identifying with ROWID values
inserting into tables and views
[
2
]
ordering
selecting from tables
updating
[
2
]
RPAD character function
RR date format element
RTRIM character function
RX locks
S format element
SAMPLE parameter, of ANALYZE command
SAVEPOINT command
[
2
]
examples
[
2
]
summary
savepoints, creating
[
2
]
erasing with COMMIT command
scale
negative
of NUMBER columns
SCAN_INSTANCES parameter, of ALTER SYSTEM command
schema objects
definition of
namespaces for
schemas, creating
scope, of DECLARE STATEMENT command
searching, for rows with an index
security, provided by views
SELECT clause
INSERT command
UPDATE command
[
2
]
SELECT command
[
2
] [
3
]
embedded SQL examples
examples
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
] [
9
] [
10
] [
11
]
summary
select list
SELECT object auditing option
SELECT object privilege
on sequences
on tables
on views
self joins
SEQ parameter, of ARCHIVE LOG clause
SEQUEL (Structured English Query Language)
sequences
accessing values of
[
2
] [
3
]
altering
auditing
creating
creating synonyms for
cycling values of
dropping
granting object privileges on
[
2
]
increment between values
[
2
]
incrementing values of
[
2
] [
3
]
limiting values of
losing values of
performance benefits of
renaming
restarting
revoking object privileges on
skipping values of
session control commands
session cursors
SESSION_CACHED_CURSORS
SESSION_CACHED_CURSORS clause, of ALTER SESSION command
SESSIONID option, of USERENV function
SESSIONS_PER_USER parameter, of CREATE PROFILE command
sessions
altering
beginning
closing database links for
[
2
]
enabling and disabling roles for
enabling and disabling SQL trace facility for
[
2
]
National Language Support (NLS) settings for
[
2
]
terminating
[
2
]
SET clause
of UPDATE command
of EXPLAIN PLAN command
SET DATABASE parameter, of CREATE CONTROLFILE command
set operators
SET ROLE command
examples
SET TRANSACTION command
[
2
]
examples
summary
shadow processes, server processes
share locks
share row exclusive locks
share update locks
shared pool, clearing
shared server processes, creating and terminating
[
2
]
shared SQL area, session cursors
SHRINK clause, of ALTER ROLLBACK SEGMENT command
[
2
]
shrinking, rollback segments
[
2
]
SIGN number function
simple join, example
simple snapshots
simultaneous update and query on tables
SIN number function
SINH number function
SIZE parameter
of CREATE CLUSTER command
of ALLOCATE EXTENT clause
[
2
] [
3
]
of ALTER CLUSTER command
of CREATE CLUSTER command
of filespec
snapshot logs
altering
creating
definition
dropping
storage characteristics of
[
2
] [
3
] [
4
]
snapshot refresh processes
SNAPSHOT_REFRESH_INTERVAL
SNAPSHOT_REFRESH_KEEP_CONNECTIONS
SNAPSHOT_REFRESH_PROCESSES
snapshots
adding comments to
adding to clusters
altering
complex
creating
creating synonyms for
definition
[
2
]
dropping
granting object privileges on
[
2
]
refresh modes
refresh times
refreshing
[
2
] [
3
]
refreshing with snapshot logs
removing comments from
revoking object privileges on
simple
storage characteristics of
storage characteristics of
[
2
] [
3
]
types of
SOME comparison operator
SOUNDEX character function
space, deallocating
SQL (Structured Query Language)
SQL functions
character
group
SQL trace facility, enabling and disabling for sessions
[
2
]
SQL-92
SQL.BSQ
SQL/DS, datatypes
SQL2
SQL_CURSOR
SQL_TRACE
SQL
benefits of
compliance with standards
conversion functions
embedded
embedded terms
SQLERROR, WHENEVER command condition
SQL, functions
[
2
]
history of
lexical conventions
optimizer
standards
standards compliance
summary of commands
unified language
SQLWARNING, WHENEVER command condition
SQRT number function
SRX locks
standard deviation
standards, compliance
standby database
ALTER DATABASE command
controlfile
RECOVER clause
START WITH clause
of CREATE SEQUENCE command
of SELECT command
[
2
] [
3
]
START WITH parameter, of REFRESH clause
[
2
]
statement auditing options
statement auditing short cuts
STDDEV group function
STOP option, of WHENEVER command
storage characteristics
of snapshot logs
of clusters
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
]
of indexes
[
2
] [
3
] [
4
] [
5
] [
6
]
of rollback segments
[
2
]
of snapshot logs
[
2
] [
3
]
of snapshots
[
2
] [
3
] [
4
]
of tables
[
2
] [
3
] [
4
] [
5
]
of tablespaces
[
2
] [
3
]
STORAGE clause
[
2
] [
3
] [
4
] [
5
] [
6
]
examples
of ALTER CLUSTER command
of ALTER INDEX command
[
2
]
of ALTER SNAPSHOT command
of ALTER TABLE command
of CREATE CLUSTER command
of CREATE INDEX command
of CREATE ROLLBACK SEGMENT command
of CREATE SNAPSHOT command
[
2
]
of CREATE TABLE command
storage, ALTER TABLESPACE
stored functions
adding to packages
auditing
creating
creating synonyms for
definition
dropping
granting object privileges on
[
2
]
overloading
[
2
]
PL/SQL
recompiling
redefining
removing from packages
revoking object privileges on
stored procedures, procedures
subqueries
correlated
SUBSTR character function
SUM group function
[
2
]
suppressing blank padding, in date format models
SWITCH LOGFILE option, of ALTER SYSTEM command
[
2
]
switching
redo log files
redo log files
[
2
]
SYEAR date format element
synonyms
auditing
creating
creating synonyms for
definition
dropping
granting object privileges on
[
2
]
renaming
revoking object privileges on
scope of
using with database links
SYSDATE date function
system change numbers, specifying for forced transactions
system commit numbers, system change numbers
system control commands
system privileges
granting to users and roles
revoking from users and roles
SYSTEM rollback segment
SYSTEM tablespace
[
2
]
table alias
table constraints
example
table locks, disabling
[
2
]
TABLE option
of ANALYZE command
of TRUNCATE command
tables, adding columns to
[
2
] [
3
]
adding comments to
adding integrity constraints to
[
2
] [
3
]
adding to clusters
adding triggers to
aliases for
allocating extents for
[
2
]
allowing writes
altering
auditing
creating
creating snapshot logs for
creating synonyms for
[
2
]
creating views on
definition
deleting rows from
[
2
] [
3
]
disallowing writes
dropping
dropping integrity constraints from
dropping triggers from
granting object privileges on
[
2
]
inserting rows into
[
2
]
locking
TABLESPACE option
of CREATE CLUSTER command
of CREATE INDEX command
of CREATE ROLLBACK SEGMENT command
of CREATE SNAPSHOT command
[
2
]
of CREATE TABLE command
of RECOVER clause
tablespaces
altering
assigning to users
backing up
backing up
[
2
]
changing future storage allocations
creating
[
2
]
creating clusters in
creating indexes in
creating rollback segments in
[
2
]
datafiles of
[
2
] [
3
] [
4
]
dropping
[
2
]
establishing default tablespaces for users
[
2
] [
3
]
establishing tablespace quotas for users
[
2
] [
3
]
establishing temporary tablespaces for users
[
2
] [
3
]
specifying for tables
storage characteristics of
[
2
]
storage characteristics of
SYSTEM tablespace
[
2
]
taking online and offline
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
]
tables
recoverability
redefining columns of
removing comments from
removing from clusters
renaming
revoking object privileges on
selecting data from
specifying tablespaces for
storage characteristics of
storage characteristics of
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
]
truncating
unrecoverable
updating rows in
[
2
]
TAN number function
TANH number function
TEMPORARY option, of ALTER TABLESPACE command
TEMPORARY TABLESPACE clause
of ALTER USER command
of CREATE USER command
TERMINAL option, of USERENV function
terminating
dispatcher processes (DISP)
sessions
[
2
]
shared shadow processes
text, definition of
THREAD parameter
of ADD LOGFILE clause
of ARCHIVE LOG clause
threads, redo log threads
TO clause, of GRANT command
[
2
]
of ROLLBACK command
[
2
]
TO parameter, of ARCHIVE LOG clause
TO_CHAR conversion function
[
2
] [
3
] [
4
]
examples
[
2
] [
3
] [
4
] [
5
]
TO_DATE conversion function
[
2
]
examples
TO_LABEL conversion function
TO_MULTI_BYTE conversion function
TO_NUMBER conversion function
[
2
]
TO_SINGLE_BYTE conversion function
transaction control commands
transactions
[
2
]
committing
[
2
]
distributed
[
2
]
establishing as read-only
read consistency
read only
rolling back
[
2
] [
3
]
TRANSLATE character function
triggered action
triggers
creating
definition
[
2
]
dropping from tables
enabling and disabling
executing
firing
LONG datatype
TRUE option, of SET RESOURCE_LIMIT clause
TRUE, result of a condition
TRUNC date function
[
2
]
format models for
TRUNC number function
TRUNCATE command
examples
truncating
clusters
tables
truth tables
[
2
] [
3
]
TYPE command
examples
UID function
UNARCHIVED option, of CLEAR LOGFILE clause
undo a transaction
UNION ALL set operator
examples
UNION set operator
examples
unique keys
[
2
]
UNIQUE option
of DISABLE clause
of ENABLE clause
UNLIMITED clause, of ALTER DATABASE command
UNLIMITED option, of ALTER PROFILE command
[
2
]
of CREATE PROFILE command
of QUOTA clause
[
2
]
unrecoverability, of tables
UNRECOVERABLE
UNRECOVERABLE clause, of CREATE TABLE command
UNRECOVERABLE keyword
UNTIL CANCEL option, of RECOVER clause
UNTIL CHANGE parameter, of RECOVER clause
UNTIL TIME parameter, of RECOVER clause
UPDATE command
[
2
] [
3
] [
4
]
embedded SQL examples
examples
subquery
UPDATE object auditing options
UPDATE object privilege
on tables
on views
UPDATE option, of CREATE TRIGGER command
[
2
]
updating
rows in tables and views
rows in tables and views
UPPER character function
uppercase and lowercase, significance in pattern matching
uppercase, significance in SQL statements
USE ROLLBACK SEGMENT option, of SET TRANSACTION command
user function
[
2
]
expression syntax
user functions
user-defined type equivalencing
USER_CLUSTERS view
USER_INDEXES view
USER_TAB_COLUMNS view
USER_TABLES view
USERENV function
users
altering
assigning profiles to
[
2
] [
3
]
assigning resource limits to
[
2
]
assigning tablespaces to
changing passwords
creating
definition
dropping
establishing default roles for
[
2
] [
3
]
establishing default tablespaces for
[
2
] [
3
]
establishing passwords for
[
2
]
establishing tablespace quotas for
establishing tablespace quotas for
[
2
]
establishing temporary tablespaces for
[
2
] [
3
]
granting object privileges to
granting system privileges and roles to
revoking object privileges from
revoking system privileges and roles from
USING BACKUP CONTROLFILE parameter, of RECOVER clause
USING clause
of CREATE DATABASE LINK command
of FETCH command
of OPEN command
[
2
]
using dbstring, SQL*Net database id specification
USING INDEX option
of ALTER SNAPSHOT command
of CONSTRAINT clause
of CREATE SNAPSHOT command
of ENABLE clause
UTLEXCPT.SQL
UTLSAMPL.SQL
UTLXPLAN.SQL
V format element
V$LOG table
[
2
]
V$NLS_PARAMETERS table
VALIDATE INDEX command
VALIDATE STRUCTURE option, of ANALYZE command
VALUES clause, of embedded SQL INSERT command
[
2
]
of INSERT command
[
2
] [
3
]
value, use in expression
VAR command
examples
VARCHAR datatype
in V6
VARCHAR2
VARCHAR2 datatype
comparing values of
similarity to RAW datatype
VARGRAPHIC datatype
variable length, date format models
views
adding comments to
and DML commands
auditing
creating
creating synonym for
definition
deleting rows from
dropping
granting object privileges on
[
2
]
inserting rows into
[
2
]
join views
updatable
locking
partition
redefining
removing comments from
renaming
revoking object privileges on
updating rows in
[
2
]
uses of
VSIZE function
WHEN clause, of CREATE TRIGGER command
WHENEVER clause, of AUDIT command
[
2
]
of NOAUDIT command
[
2
]
WHENEVER command
examples
WHERE clause
of DELETE command
of SELECT command
of UPDATE command
[
2
] [
3
]
wildcard characters
in pattern matching
pattern matching
WITH ADMIN OPTION
WITH CHECK OPTION
WITH GRANT OPTION
WITH READ ONLY, CREATE VIEW
WORK option
of ROLLBACK command
of COMMIT command
[
2
]
of ROLLBACK command
WW date format element
YEAR date format element
year, storing