Go to main content
595/595
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
Z
Symbols
+ (plus sign) in Oracle Automatic Storage Management filenames
1
Numerics
20th century
1
21st century
1
3GL functions and procedures, calling
1
A
ABORT LOGICAL STANDBY clause
of ALTER DATABASE
1
ABS function
1
ACCESSED GLOBALLY clause
of CREATE CONTEXT
1
ACCOUNT LOCK clause
of ALTER USER. See CREATE USER
1
of CREATE USER
1
ACCOUNT UNLOCK clause
of ALTER USER. See CREATE USER
1
of CREATE USER
1
ACOS function
1
ACTIVATE STANDBY DATABASE clause
of ALTER DATABASE
1
AD and A.D. datetime format elements
1
ADD_MONTHS function
1
ADD clause
of ALTER DIMENSION
1
of ALTER INDEXTYPE
1
of ALTER TABLE
1
of ALTER VIEW
1
ADD DATAFILE clause
of ALTER TABLESPACE
1
adding a constraint to a table
1
ADD LOGFILE clause
of ALTER DATABASE
1
ADD LOGFILE GROUP clause
of ALTER DATABASE
1
ADD LOGFILE INSTANCE clause
of ALTER DATABASE
1
ADD LOGFILE MEMBER clause
of ALTER DATABASE
1
ADD LOGFILE THREAD clause
of ALTER DATABASE
1
ADD OVERFLOW clause
of ALTER TABLE
1
ADD PARTITION clause
of ALTER TABLE
1
ADD PRIMARY KEY clause
of ALTER MATERIALIZED VIEW LOG
1
ADD ROWID clause
of ALTER MATERIALIZED VIEW
1
ADD SUPPLEMENTAL LOG DATA clause
of ALTER DATABASE
1
ADD SUPPLEMENTAL LOG GROUP clause
of ALTER TABLE
1
ADD TEMPFILE clause
of ALTER TABLESPACE
1
ADD VALUES clause
of ALTER TABLE ... MODIFY PARTITION
1
ADMINISTER ANY SQL TUNING SET system privilege
1
ADMINISTER KEY MANAGEMENT statement
1
ADMINISTER KEY MANAGEMENT system privilege
1
ADMINISTER SQL MANAGEMENT OBJECT system privilege
1
ADMINISTER SQL TUNING SET system privilege
1
ADMIN USER clause
of CREATE PLUGGABLE DATABASE
1
advanced index compression
definition
1
disabling
1
enabling
1
of index rebuild
1
Advanced Row Compression
1
ADVISE clause
of ALTER SESSION
1
aggregate functions
1
alias
for a column
1
for an expressions in a view query
1
specifying in queries and subqueries
1
ALL_COL_COMMENTS data dictionary view
1
ALL_INDEXTYPE_COMMENTS data dictionary view
1
ALL_MVIEW_COMMENTS data dictionary view
1
ALL_OPERATOR_COMMENTS data dictionary view
1
ALL_ROWS hint
1
ALL_TAB_COMMENTS data dictionary view
1
ALL clause
of SELECT
1
of SET CONSTRAINTS
1
of SET ROLE
1
all-column wildcard
1
ALLOCATE EXTENT clause
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW
1
of ALTER TABLE
1
ALL operator
1
ALLOW CORRUPTION clause
of ALTER DATABASE ... RECOVER
1
ALL PRIVILEGES clause
of GRANT
1
of REVOKE
1
ALL PRIVILEGES shortcut
of AUDIT
1
ALL shortcut
of AUDIT
1
alter_external_table clause
of ALTER TABLE
1
ALTER ANALYTIC VIEW statement
1
ALTER ANY SQL PROFILE system privilege
1
ALTER ATTRIBUTE DIMENSION statement
1
ALTER AUDIT POLICY statement
1
ALTER CLUSTER statement
1
ALTER DATABASE LINK system privilege
1
ALTER DATABASE statement
1
ALTER DIMENSION statement
1
ALTER DISKGROUP statement
1
ALTER FLASHBACK ARCHIVE statement
1
ALTER FUNCTION statement
1
ALTER HIERARCHY statement
1
ALTER INDEX statement
1
ALTER INDEXTYPE statement
1
altering storage
of PDBs
1
ALTER INMEMORY JOIN GROUP statement
1
ALTER JAVA CLASS statement
1
ALTER JAVA SOURCE statement
1
ALTER LIBRARY statement
1
ALTER LOCKDOWN PROFILE statement
1
ALTER MATERIALIZED VIEW LOG statement
1
ALTER MATERIALIZED VIEW statement
1
ALTER MATERIALIZED ZONEMAP statement
1
ALTER object privilege
on a SQL translation profile
1
ALTER OPERATOR statement
1
ALTER OUTLINE statement
1
ALTER PACKAGE statement
1
ALTER PLUGGABLE DATABASE statement
1
ALTER PROCEDURE statement
1
ALTER PROFILE statement
1
ALTER PUBLIC DATABASE LINK system privilege
1
ALTER RESOURCE COST statement
1
ALTER ROLE statement
1
ALTER ROLLBACK SEGMENT statement
1
ALTER SEQUENCE statement
1
ALTER SESSION statement
1
ALTER SNAPSHOT
See:
ALTER MATERIALIZED VIEW
ALTER SNAPSHOT LOG
See:
ALTER MATERIALIZED VIEW LOG
ALTER SYSTEM statement
1
ALTER TABLESPACE SET statement
1
ALTER TABLESPACE statement
1
ALTER TABLE statement
1
ALTER TRIGGER statement
1
ALTER TYPE statement
1
ALTER USER statement
1
ALTER VIEW statement
1
AM and A.M. datetime format elements
1
American National Standards Institute (ANSI)
data types
1
conversion to Oracle data types
1
standards
1
,
2
supported data types
1
analytic functions
1
analytic view measure expression
1
analytic views
altering
1
creating
1
dropping
1
granting system privileges for
1
analytic view simple expression
1
ANALYZE CLUSTER statement
1
ANALYZE INDEX statement
1
ANALYZE TABLE statement
1
ANCILLARY TO clause
of CREATE OPERATOR
1
AND condition
1
AND DATAFILES clause
of DROP TABLESPACE
1
ANSI
See:
American National Standards Institute (ANSI)
antijoins
1
ANY operator
1
APPEND_VALUES hint
1
APPENDCHILDXML function
1
APPEND hint
1
applications
allowing connection as user
1
securing
1
validating
1
application servers
allowing connection as user
1
APPROX_COUNT_DISTINCT_AGG function
1
APPROX_COUNT_DISTINCT_DETAIL function
1
APPROX_COUNT_DISTINCT function
1
APPROX_MEDIAN function
1
APPROX_PERCENTILE_AGG function
1
APPROX_PERCENTILE_DETAIL function
1
APPROX_PERCENTILE function
1
archived redo logs
location
1
ARCHIVELOG clause
of ALTER DATABASE
1
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
ARCHIVE LOG clause
of ALTER SYSTEM
1
archive mode
specifying
1
arguments
of operators
1
arithmetic
with DATE values
1
arithmetic operators
1
ASC clause
of CREATE INDEX
1
ASCII function
1
ASCIISTR function
1
AS CLONE clause
of CREATE PLUGGABLE DATABASE
1
ASIN function
1
ASSOCIATE STATISTICS statement
1
AS source_char clause
of CREATE JAVA
1
AS subquery clause
of CREATE MATERIALIZED VIEW
1
of CREATE TABLE
1
of CREATE VIEW
1
asterisk
all-column wildcard in queries
1
asynchronous commit
1
ATAN2 function
1
ATAN function
1
ATTRIBUTE clause
of ALTER DIMENSION
1
of CREATE DIMENSION
1
attribute clustering
1
attribute dimensions
altering
1
creating
1
dropping
1
granting system privileges for
1
attributes
adding to a dimension
1
dropping from a dimension
1
maximum number of in object type
1
of dimensions, defining
1
of disk groups
1
,
2
auditing
options
for SQL statements
1
policies
value-based
1
SQL statements
1
by a proxy
1
by a user
1
on a directory
1
on a schema
1
stopping
1
system privileges
1
audit policies
comments on
1
creating
1
dropping
1
modifying
1
AUDIT statement
1
for unified auditing
1
locks
1
AUTHENTICATED BY clause
of CREATE DATABASE LINK
1
AUTHENTICATED clause
of ALTER USER
1
AUTHENTICATION REQUIRED clause
of ALTER USER
1
AUTHID CURRENT_USER clause
of ALTER JAVA
1
of CREATE JAVA
1
AUTHID DEFINER clause
of ALTER JAVA
1
of CREATE JAVA
1
AUTOALLOCATE clause
of CREATE TABLESPACE
1
AUTOEXTEND clause
of ALTER DATABASE
1
of CREATE DATABASE
1
automatic segment-space management
1
automatic undo mode
1
,
2
AVG function
1
B
BACKUP CONTROLFILE clause
of ALTER DATABASE
1
backups
1
band joins
1
basic table compression
1
BC and B.C. datetime format elements
1
BECOME USER system privilege
1
BEGIN BACKUP clause
of ALTER DATABASE
1
of ALTER TABLESPACE
1
BEQUEATH clause
of CREATE VIEW
1
BETWEEN condition
1
BFILE
data type
1
locators
1
BFILENAME function
1
BIN_TO_NUM function
1
binary large objects
See:
BLOB
binary operators
1
binary XML format
1
binary XML storage
1
bindings
adding to an operator
1
dropping from an operator
1
BITAND function
1
BITMAP clause
of CREATE INDEX
1
bitmap indexes
1
creating join indexes
1
bit vectors
converting to numbers
1
blank padding
specifying in format models
1
suppressing
1
BLOB data type
1
BLOCKSIZE clause
of CREATE TABLESPACE
1
bottom-N reporting
1
,
2
,
3
BUFFER_POOL parameter
of STORAGE clause
1
buffer cache
flushing
1
BUILD DEFERRED clause
of CREATE MATERIALIZED VIEW
1
BUILD IMMEDIATE clause
of CREATE MATERIALIZED VIEW
1
BY ACCESS clause
of AUDIT
1
BY SESSION clause
of AUDIT
1
BYTE character semantics
1
,
2
BYTE length semantics
1
C
CACHE clause
of ALTER MATERIALIZED VIEW
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of CREATE CLUSTER
1
of CREATE MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW LOG
1
cached cursors
execution plan for
1
CACHE hint
1
CACHE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
CACHE READS clause
of ALTER TABLE
1
of CREATE TABLE
1
calculated measure expression
1
,
2
calls
limiting CPU time for
1
limiting data blocks read
1
call spec
See:
call specifications
call specifications
in procedures
1
CALL statement
1
CARDINALITY function
1
Cartesian products
1
CASCADE clause
of CREATE TABLE
1
of DROP PROFILE
1
of DROP USER
1
CASCADE CONSTRAINTS clause
of DROP CLUSTER
1
of DROP TABLE
1
of DROP TABLESPACE
1
of DROP VIEW
1
of REVOKE
1
CASE expressions
1
searched
1
simple
1
CAST function
1
CATSEARCH condition
1
CATSEARCH operator
1
CDBs
creating
1
modifying
1
CEIL function
1
chained rows
listing
1
of clusters
1
CHANGE_DUPKEY_ERROR_INDEX hint
1
CHANGE CATEGORY clause
of ALTER OUTLINE
1
CHANGE NOTIFICATION system privilege
1
changing state
of a PDB
1
of multiple PDBs
1
character functions
returning character values
1
returning number values
1
character large objects
See:
CLOB
character length semantics
1
character literal
See:
text
character set
changing
1
character set functions
1
CHARACTER SET parameter
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
character sets
database, specifying
1
multibyte characters
1
specifying for database
1
character strings
comparison rules
1
exact matching
1
fixed-length
1
national character set
1
variable-length
1
,
2
CHAR character semantics
1
,
2
CHAR data type
1
converting to VARCHAR2
1
CHAR length semantics
1
CHARTOROWID function
1
CHECK clause
of constraints
1
of CREATE TABLE
1
check constraints
1
CHECK DATAFILES clause
of ALTER SYSTEM
1
CHECKPOINT clause
of ALTER SYSTEM
1
checkpoints
forcing
1
CHR function
1
CHUNK clause
of ALTER TABLE
1
of CREATE TABLE
1
CLEAR LOGFILE clause
of ALTER DATABASE
1
CLOB data type
1
clone databases
mounting
1
CLOSE DATABASE LINK clause
of ALTER SESSION
1
CLUSTER_DETAILS function
1
CLUSTER_DISTANCE function
1
CLUSTER_ID function
1
CLUSTER_PROBABILITY function
1
CLUSTER_SET function
1
CLUSTER clause
of ANALYZE
1
of CREATE INDEX
1
of CREATE TABLE
1
of TRUNCATE
1
CLUSTER hint
1
CLUSTERING hint
1
clusters
assigning tables to
1
caching retrieved blocks
1
cluster indexes
1
collecting statistics on
1
creating
1
deallocating unused extents
1
degree of parallelism
changing
1
when creating
1
dropping tables
1
extents, allocating
1
granting system privileges for
1
hash
1
single-table
1
sorted
1
,
2
indexed
1
key values
allocating space for
1
modifying space for
1
migrated and chained rows in
1
modifying
1
physical attributes
changing
1
specifying
1
releasing unused space
1
removing from the database
1
SQL examples
1
storage attributes
changing
1
storage characteristics
changing
1
tablespace in which created
1
validating structure
1
COALESCE clause
for partitions
1
of ALTER INDEX
1
of ALTER TABLE
1
of ALTER TABLESPACE
1
COALESCE function
1
as a variety of CASE expression
1
COALESCE SUBPARTITION clause
of ALTER TABLE
1
COLLATE operator
1
COLLATION function
1
collation functions
1
COLLECT function
1
collection functions
1
collections
inserting rows into
1
modifying
1
modifying retrieval method
1
nested tables
1
testing for empty
1
treating as a table
1
,
2
,
3
unnesting
1
examples
1
varrays
1
collection-typed values
converting to data types
1
collection types
multilevel
1
COLUMN_VALUE pseudocolumn
1
column expressions
1
column REF constraints
1
of CREATE TABLE
1
columns
adding
1
aliases for
1
altering storage
1
associating statistics types with
1
basing an index on
1
comments on
1
creating comments about
1
defining
1
disassociating statistics types from
1
dropping from a table
1
LOB
storage attributes
1
maximum number of
1
modifying existing
1
parent-child relationships between
1
properties, altering
1
qualifying names of
1
REF
describing
1
renaming
1
restricting values for
1
specifying
as primary key
1
constraints on
1
default values
1
storage properties
1
substitutable, identifying type
1
virtual
adding to a table
1
creating
1
modifying
1
COLUMNS clause
of ASSOCIATE STATISTICS
1
of DISASSOCIATE STATISTICS
1
column values
unpivoting into rows
1
COMMENT clause
of COMMIT
1
comments
1
adding to objects
1
associating with a transaction
1
dropping from objects
1
in SQL statements
1
on editions
1
on indextypes
1
on mining models
1
on operators
1
on schema objects
1
on table columns
1
on tables
1
on unified audit policies
1
removing from the data dictionary
1
specifying
1
viewing
1
COMMENT statement
1
commit
asynchronous
1
automatic
1
COMMIT IN PROCEDURE clause
of ALTER SESSION
1
COMMIT statement
1
COMMIT TO SWITCHOVER clause
of ALTER DATABASE
1
comparison conditions
1
comparison functions
1
comparison semantics
of character strings
1
COMPILE clause
of ALTER DIMENSION
1
of ALTER JAVA SOURCE
1
of ALTER MATERIALIZED VIEW
1
of ALTER VIEW
1
of CREATE JAVA
1
COMPOSE function
1
COMPOSITE_LIMIT parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
composite foreign keys
1
composite partitioning
range-list
1
,
2
when creating a table
1
composite primary keys
1
composite range partitions
1
compound conditions
1
compound expressions
1
COMPRESS clause
of ALTER INDEX ... REBUILD
1
of CREATE TABLE
1
compression
of index keys
1
of tables
1
of tablespaces
1
CON_DBID_TO_ID function
1
CON_GUID_TO_ID function
1
CON_NAME_TO_ID function
1
CON_UID_TO_ID function
1
concatenation operator
1
CONCAT function
1
conditions
BETWEEN
1
comparison
1
compound
1
EXISTS
1
,
2
floating-point
1
group comparison
1
IN
1
in SQL syntax
1
interval
1
IS [NOT] EMPTY
1
IS ANY
1
IS JSON
1
IS OF type
1
IS PRESENT
1
JSON_EXISTS
1
JSON_TEXTCONTAINS
1
LIKE
1
logical
1
MEMBER
1
membership
1
,
2
model
1
multiset
1
null
1
pattern matching
1
range
1
REGEXP_LIKE
1
SET
1
simple comparison
1
SQL/JSON
1
SUBMULTISET
1
UNDER_PATH
1
XML
1
CONNECT_BY_ISCYCLE pseudocolumn
1
CONNECT_BY_ISLEAF pseudocolumn
1
CONNECT_BY_ROOT operator
1
CONNECT_TIME parameter
of ALTER PROFILE
1
of ALTER RESOURCE COST
1
CONNECT BY clause
of queries and subqueries
1
of SELECT
1
,
2
CONNECT clause
of SELECT and subqueries
1
connection qualifier
1
CONNECT TO clause
of CREATE DATABASE LINK
1
CONSIDER FRESH clause
of ALTER MATERIALIZED VIEW
1
constant values
See:
literals
CONSTRAINT(S) session parameter
1
constraints
adding to a table
1
altering
1
check
1
checking
at end of transaction
1
at start of transaction
1
at the end of each DML statement
1
column REF
1
deferrable
1
,
2
enforcing
1
defining
1
,
2
for a table
1
on a column
1
disabling
1
after table creation
1
cascading
1
during table creation
1
dropping
1
,
3
enabling
1
after table creation
1
during table creation
1
foreign key
1
modifying existing
1
on views
dropping
1
,
2
partitioning referential
1
,
2
primary key
1
attributes of index
1
enabling
1
referential integrity
1
renaming
1
restrictions
1
setting state for a transaction
1
storing rows in violation
1
table REF
1
unique
attributes of index
1
enabling
1
CONTAINER hint
1
CONTAINS condition
1
CONTAINS operator
1
context namespaces
accessible to instance
1
associating with package
1
initializing using OCI
1
initializing using the LDAP directory
1
removing from the database
1
contexts
creating namespaces for
1
granting system privileges for
1
control file clauses
of ALTER DATABASE
1
CONTROLFILE REUSE clause
of CREATE DATABASE
1
control files
allowing reuse
1
,
2
backing up
1
force logging mode
1
re-creating
1
standby, creating
1
conversion
functions
1
rules, string to date
1
CONVERT function
1
COPY clause
of CREATE PLUGGABLE DATABASE
1
CORR_K function
1
CORR_S function
1
correlated subqueries
1
correlation functions
Kendall’s tau-b
1
Pearson’s
1
Spearman’s rho
1
correlation names
in DELETE
1
in SELECT
1
CORR function
1
COS function
1
COSH function
1
COUNT function
1
COVAR_POP function
1
COVAR_SAMP function
1
CPU_PER_CALL parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
CPU_PER_SESSION parameter
of ALTER PROFILE
1
of ALTER RESOURCE COST
1
of CREATE PROFILE
1
CREATE ANALYTIC VIEW statement
1
CREATE ANY SQL PROFILE system privilege
1
CREATE ATTRIBUTE DIMENSION statement
1
CREATE AUDIT POLICY statement
1
CREATE CLUSTER statement
1
CREATE CONTEXT statement
1
CREATE CONTROLFILE statement
1
CREATE DATABASE LINK statement
1
CREATE DATABASE statement
1
CREATE DATAFILE clause
of ALTER DATABASE
1
CREATE DIMENSION statement
1
CREATE DIRECTORY statement
1
CREATE DISKGROUP statement
1
CREATE FLASHBACK ARCHIVE statement
1
CREATE FUNCTION statement
1
CREATE HIERARCHY statement
1
CREATE INDEX statement
1
CREATE INDEXTYPE statement
1
CREATE INMEMORY JOIN GROUP statement
1
CREATE JAVA statement
1
CREATE LIBRARY statement
1
CREATE LOCKDOWN PROFILE statement
1
CREATE MATERIALIZED VIEW LOG statement
1
CREATE MATERIALIZED VIEW statement
1
CREATE MATERIALIZED ZONEMAP statement
1
CREATE OPERATOR statement
1
CREATE OUTLINE statement
1
CREATE PACKAGE BODY statement
1
CREATE PACKAGE statement
1
locks
1
CREATE PFILE statement
1
CREATE PLUGGABLE DATABASE statement
1
CREATE PLUGGABLE DATABASE system privilege
1
CREATE PROCEDURE statement
1
locks
1
CREATE PROFILE statement
1
CREATE RESTORE POINT statement
1
CREATE ROLE statement
1
CREATE ROLLBACK SEGMENT statement
1
CREATE SCHEMA statement
1
CREATE SEQUENCE statement
1
CREATE SPFILE statement
1
CREATE STANDBY CONTROLFILE clause
of ALTER DATABASE
1
CREATE SYNONYM statement
1
CREATE TABLESPACE SET statement
1
CREATE TABLESPACE statement
1
CREATE TABLE statement
1
CREATE TRIGGER statement
1
CREATE TYPE BODY statement
1
CREATE TYPE statement
1
CREATE USER statement
1
CREATE VIEW statement
1
cross joins
1
CUBE_TABLE function
1
CUBE clause
of SELECT statements
1
cubes
extracting data
1
CUME_DIST function
1
cumulative distributions
1
currency
group separators
1
currency symbol
ISO
1
local
1
union
1
CURRENT_DATE function
1
CURRENT_SCHEMA session parameter
1
CURRENT_TIMESTAMP function
1
CURRENT_USER clause
of CREATE DATABASE LINK
1
CURRVAL pseudocolumn
1
,
2
CURSOR_SHARING_EXACT hint
1
CURSOR expressions
1
cursors
cached
1
CV function
1
CYCLE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
D
data
aggregation
composite columns of GROUP BY
1
concatenated grouping sets of GROUP BY
1
grouping sets
1
analyzing a subset
1
caching frequently used
1
independence
1
integrity checking on input
1
locks on
1
pivoting
1
retrieving
1
specifying as temporary
1
undo
preserving
1
,
2
unpivoting
1
database links
1
altering
1
closing
1
creating
1
,
2
creating synonyms with
1
current user
1
granting system privileges for
1
naming
1
public
1
dropping
1
referring to
1
removing from the database
1
shared
1
syntax
1
updating passwords
1
username and password
1
database objects
dropping
1
nonschema
1
schema
1
databases
accounts
creating
1
allowing changes to
1
allowing generation of redo logs
1
allowing reuse of control files
1
allowing unlimited resources to users
1
archive mode, specifying
1
beginning backup of
1
blocks
specifying size
1
cancel-based recovery
terminating
1
changing characteristics
1
changing global name
1
changing name
1
character set, specifying
1
committing to standby status
1
connect strings
1
controlling use
1
create script for
1
creating
1
data files
modifying
1
specifying
1
default edition, setting
1
designing media recovery
1
dropping
1
ending backup of
1
erasing all data from
1
flashing back
1
granting system privileges for
1
in FLASHBACK mode
1
in FORCE LOGGING mode
1
,
2
,
3
instances of
1
limiting resources for users
1
log files
modifying
1
specifying
1
managed recovery
1
modifying
1
mounting
1
,
3
moving a subset to a different database
1
namespaces
1
naming
1
national character set, specifying
1
no-data-loss mode
1
online
adding log files
1
opening
1
,
2
prepare to re-create
1
preventing changes to
1
protection mode of
1
quiesced state
1
read/write
1
read-only
1
reconstructing damaged
1
recovering
1
recovery
allowing corrupt blocks
1
testing
1
using a storage snapshot
1
with backup control file
1
re-creating control file for
1
remote
accessing
1
authenticating users to
1
connecting to
1
inserting into
1
service name of
1
table locks on
1
restoring earlier version of
1
,
2
,
3
restricting users to read-only transactions
1
resuming activity
1
returning to a past time
1
standby
adding log files
1
suspending activity
1
system user passwords
1
temp files
modifying
1
time zone
determining
1
setting, valid values for
1
,
2
Database Smart Flash Cache
1
database triggers
See:
triggers
data cartridge functions
1
data conversion
1
between character data types
1
implicit
disadvantages
1
implicit versus explicit
1
when performed implicitly
1
,
2
when specified explicitly
1
data definition language
locks
1
data definition language (DDL)
statements
1
and implicit commit
1
causing recompilation
1
PL/SQL support
1
statements requiring exclusive access
1
data dictionary
adding comments to
1
locks
1
DATAFILE clause
of CREATE DATABASE
1
DATAFILE clauses
of ALTER DATABASE
1
DATAFILE OFFLINE clause
of ALTER DATABASE
1
DATAFILE ONLINE clause
of ALTER DATABASE
1
DATAFILE RESIZE clause
of ALTER DATABASE
1
data files
bringing online
1
changing size of
1
creating new
1
defining for a tablespace
1
defining for the database
1
designing media recovery
1
dropping
1
,
2
enabling autoextend
1
end online backup of
1
,
2
extending automatically
1
online, updating information on
1
online backup of
1
putting online
1
recover damaged
1
recovering
1
re-creating lost or damaged
1
renaming
1
resizing
1
reusing
1
size of
1
specifying
1
for a tablespace
1
for database
1
system generated
1
taking offline
1
temporary
shrinking
1
data manipulation language (DML)
allowing during indexing
1
operations
during index creation
1
during index rebuild
1
restricting
1
parallelizing
1
retrieving rows affected by
1
,
2
,
3
statements
1
PL/SQL support
1
data mining functions
1
DATAOBJ_TO_MAT_PARTITION function
1
DATAOBJ_TO_PARTITION function
1
data redaction
granting system privileges for
1
data types
1
"Any" types
1
ANSI-supported
1
BFILE
1
BLOB
1
built-in
1
CHAR
1
character
1
CLOB
1
comparison rules
1
converting to collection-typed values
1
converting to other data types
1
DATE
1
datetime
1
interval
1
INTERVAL DAY TO SECOND
1
INTERVAL YEAR TO MONTH
1
length semantics
1
,
2
LONG
1
LONG RAW
1
media types
1
NCHAR
1
NCLOB
1
NUMBER
1
numeric
1
NVARCHAR2
1
Oracle-supplied types
1
RAW
1
ROWID
1
SDO_TOPO_GEOMETRY
1
spatial types
1
TIMESTAMP
1
TIMESTAMP WITH LOCAL TIME ZONE
1
TIMESTAMP WITH TIME ZONE
1
UROWID
1
user-defined
1
VARCHAR
1
VARCHAR2
1
XML types
1
DATE columns
converting to datetime columns
1
DATE data type
1
julian
1
date format models
1
,
2
long
1
punctuation in
1
short
1
text in
1
date functions
1
dates
arithmetic
1
comparison rules
1
datetime arithmetic
1
boundary cases
1
calculating daylight saving time
1
datetime columns
creating from DATE columns
1
datetime data types
1
daylight saving time
1
datetime expressions
1
datetime field
extracting from a datetime or interval value
1
datetime format elements
1
and Globalization Support
1
capitalization
1
ISO standard
1
RR
1
suffixes
1
datetime functions
1
datetime literals
1
DAY datetime format element
1
daylight saving time
1
boundary cases
1
going into or coming out of effect
1
DB2 data types
1
restrictions on
1
DBA_2PC_PENDING data dictionary view
1
DBA_COL_COMMENTS data dictionary view
1
DBA_INDEXTYPE_COMMENTS data dictionary view
1
DBA_MVIEW_COMMENTS data dictionary view
1
DBA_OPERATOR_COMMENTS data dictionary view
1
DBA_ROLLBACK_SEGS data dictionary view
1
DBA_TAB_COMMENTS data dictionary view
1
DBMS_ROWID package
and extended rowids
1
DBTIMEZONE function
1
DDL
See:
data definition language (DDL)
DEALLOCATE UNUSED clause
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER TABLE
1
debugging
granting system privileges for
1
decimal characters
specifying
1
DECODE function
1
decoding functions
1
DECOMPOSE function
1
DEFAULT clause
of ALTER TABLE
1
of CREATE TABLE
1
DEFAULT COST clause
of ASSOCIATE STATISTICS
1
default index, suppressing
1
DEFAULT profile
assigning to users
1
DEFAULT ROLE clause
of ALTER USER
1
DEFAULT SELECTIVITY clause
of ASSOCIATE STATISTICS
1
default tablespace
1
DEFAULT TABLESPACE clause
of ALTER DATABASE
1
of ALTER PLUGGABLE DATABASE
1
of ALTER USER
1
of ALTER USER. See CREATE USER
1
of CREATE USER
1
default tablespaces
specifying for a user
1
DEFAULT TEMPORARY TABLESPACE clause
of ALTER DATABASE
1
of ALTER PLUGGABLE DATABASE
1
of CREATE DATABASE
1
DEFERRABLE clause
of constraints
1
deferrable constraints
1
DEFERRED clause
of SET CONSTRAINTS
1
definer’s rights views
1
DELETE statement
1
error logging
1
DELETE STATISTICS clause
of ANALYZE
1
DELETEXML function
1
DENSE_RANK function
1
DEPTH function
1
DEREF function
1
DESC clause
of CREATE INDEX
1
dictionaries
granting system privileges for
1
dimensional objects
extracting data
1
dimensions
attributes
adding
1
changing
1
defining
1
dropping
1
compiling invalidated
1
creating
1
defining levels
1
examples
1
extracting data
1
granting system privileges for
1
hierarchies
adding
1
changing
1
defining
1
dropping
1
levels
adding
1
defining
1
dropping
1
parent-child hierarchy
1
removing from the database
1
directories
See:
directory objects
directory objects
as aliases for operating system directories
1
auditing
1
creating
1
granting system privileges for
1
redefining
1
removing from the database
1
direct-path INSERT
1
,
2
,
3
DISABLE_PARALLEL_DML hint
1
DISABLE ALL TRIGGERS clause
of ALTER TABLE
1
DISABLE clause
of ALTER INDEX
1
of CREATE TABLE
1
DISABLE DISTRIBUTED RECOVERY clause
of ALTER SYSTEM
1
DISABLE PARALLEL DML clause
of ALTER SESSION
1
DISABLE QUERY REWRITE clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
DISABLE RESTRICTED SESSION clause
of ALTER SYSTEM
1
DISABLE RESUMABLE clause
of ALTER SESSION
1
DISABLE ROW MOVEMENT clause
of ALTER TABLE
1
of CREATE TABLE
1
DISABLE STORAGE IN ROW clause
of ALTER TABLE
1
of CREATE TABLE
1
DISABLE TABLE LOCK clause
of ALTER TABLE
1
DISASSOCIATE STATISTICS statement
1
DISCONNECT SESSION clause
of ALTER SYSTEM
1
disk group files
changing permission settings
1
Intelligent Data Placement
1
setting owner or user group
1
disk groups
altering
1
creating
1
a tablespace in
1
failure groups
1
,
2
files in
1
dropping
1
managing Oracle ADVM volumes
1
rebalancing
1
setting attributes
1
,
2
specifying files in
1
specifying files in control files
1
disks
bringing online
1
QUORUM
1
regions
1
REGULAR
1
replacing
1
taking offline
1
dispatcher processes
creating additional
1
terminating
1
DISTINCT clause
of SELECT
1
distinct queries
1
distributed queries
1
restrictions on
1
distribution
hints for
1
DML
See:
data manipulation language (DML)
domain_index_clause
of CREATE INDEX
1
domain indexes
1
,
3
and LONG columns
1
associating statistics types with
1
creating, prerequisites
1
determining user-defined CPU and I/O costs
1
disassociating statistics types from
1
,
2
example
1
invoking drop routines for
1
local partitioned
1
modifying
1
parallelizing creation of
1
rebuilding
1
removing from the database
1
system managed
1
DOWNGRADE clause
of ALTER DATABASE
1
DROP ANALYTIC VIEW statement
1
DROP ANY SQL PROFILE system privilege
1
DROP ATTRIBUTE DIMENSION statement
1
DROP AUDIT POLICY statement
1
DROP clause
of ALTER DIMENSION
1
of ALTER INDEXTYPE
1
DROP CLUSTER statement
1
DROP COLUMN clause
of ALTER TABLE
1
DROP constraint clause
of ALTER VIEW
1
DROP CONSTRAINT clause
of ALTER TABLE
1
DROP CONTEXT statement
1
DROP DATABASE LINK statement
1
DROP DATABASE statement
1
DROP DIMENSION statement
1
DROP DIRECTORY statement
1
DROP DISKGROUP statement
1
DROP FLASHBACK ARCHIVE statement
1
DROP FUNCTION statement
1
DROP HIERARCHY statement
1
DROP INDEX statement
1
DROP INDEXTYPE statement
1
DROP INMEMORY JOIN GROUP statement
1
DROP JAVA statement
1
DROP LIBRARY statement
1
DROP LOCKDOWN PROFILE statement
1
DROP LOGFILE clause
of ALTER DATABASE
1
DROP LOGFILE MEMBER clause
of ALTER DATABASE
1
DROP MATERIALIZED VIEW LOG statement
1
DROP MATERIALIZED VIEW statement
1
DROP MATERIALIZED ZONEMAP statement
1
DROP OPERATOR statement
1
DROP OUTLINE statement
1
DROP PACKAGE BODY statement
1
DROP PACKAGE statement
1
DROP PARTITION clause
of ALTER INDEX
1
of ALTER TABLE
1
DROP PLUGGABLE DATABASE statement
1
DROP PRIMARY constraint clause
of ALTER TABLE
1
DROP PROCEDURE statement
1
DROP PROFILE statement
1
DROP RESTORE POINT statement
1
DROP ROLE statement
1
DROP ROLLBACK SEGMENT statement
1
DROP SEQUENCE statement
1
DROP SUPPLEMENTAL LOG DATA clause
of ALTER DATABASE
1
DROP SUPPLEMENTAL LOG GROUP clause
of ALTER TABLE
1
DROP SYNONYM statement
1
DROP TABLESPACE SET statement
1
DROP TABLESPACE statement
1
DROP TABLE statement
1
DROP TRIGGER statement
1
DROP TYPE BODY statement
1
DROP TYPE statement
1
DROP UNIQUE constraint clause
of ALTER TABLE
1
DROP USER statement
1
DROP VALUES clause
of ALTER TABLE ... MODIFY PARTITION
1
DROP VIEW statement
1
DUAL dummy table
1
,
2
DUMP function
1
DY datetime format element
1
DYNAMIC_SAMPLING hint
1
E
editioning views
1
editions
comments on
1
creating
1
dropping
1
granting system privileges for
1
setting default for a PDB
1
setting default for database
1
setting for a session
1
embedded SQL
1
precompiler support
1
EMPTY_BLOB function
1
EMPTY_CLOB function
1
ENABLE_PARALLEL_DML hint
1
ENABLE ALL TRIGGERS clause
of ALTER TABLE
1
ENABLE clause
of ALTER INDEX
1
of ALTER TRIGGER
1
of CREATE TABLE
1
ENABLE DISTRIBUTED RECOVERY clause
of ALTER SYSTEM
1
ENABLE NOVALIDATE constraint state
1
ENABLE PARALLEL DML clause
of ALTER SESSION
1
ENABLE QUERY REWRITE clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
ENABLE RESTRICTED SESSION clause
of ALTER SYSTEM
1
ENABLE RESUMABLE clause
of ALTER SESSION
1
ENABLE ROW MOVEMENT clause
of ALTER TABLE
1
of CREATE TABLE
1
ENABLE STORAGE IN ROW clause
of ALTER TABLE
1
of CREATE TABLE
1
ENABLE TABLE LOCK clause
of ALTER TABLE
1
ENABLE VALIDATE constraint state
1
encoding functions
1
encryption
1
of tablespaces
1
encryption keys
generating
1
managing
1
END BACKUP clause
of ALTER DATABASE
1
of ALTER DATABASE ... DATAFILE
1
of ALTER TABLESPACE
1
enterprise users
allowing connection as database users
1
environment functions
1
equality test
1
equijoins
1
defining for a dimension
1
equivalency tests
1
ERROR_ON_OVERLAP_TIME session parameter
1
error logging
of DELETE operations
1
of INSERT operations
1
of MERGE operations
1
EXCEPTIONS INTO clause
of ALTER TABLE
1
EXCHANGE PARTITION clause
of ALTER TABLE
1
EXCHANGE SUBPARTITION clause
of ALTER TABLE
1
exchanging partitions
restrictions on
1
EXCLUDING NEW VALUES clause
of ALTER MATERIALIZED VIEW LOG
1
of CREATE MATERIALIZED VIEW LOG
1
EXCLUSIVE lock mode
1
exclusive locks
row locks (TX)
1
table locks (TM)
1
EXECUTE object privilege
on a directory
1
execution plans
determining
1
dropping outlines for
1
saving
1
EXISTS condition
1
,
2
EXISTSNODE function
1
EXP function
1
EXPLAIN PLAN statement
1
explicit data conversion
1
,
2
expressions
analytic view measure
1
analytic view simple
1
calculated measure
1
,
2
CASE
1
changing declared type of
1
column
1
comparing
1
compound
1
computing with the DUAL table
1
CURSOR
1
datetime
1
in SQL syntax
1
interval
1
lists of
1
model
1
object access
1
placeholder
1
scalar subqueries as
1
simple
1
single row function
1
type constructor
1
extended rowids
base 64
1
not directly available
1
extensible indexing
example
1
EXTENT MANAGEMENT clause
of CREATE DATABASE
1
of CREATE TABLESPACE
1
EXTENT MANAGEMENT DICTIONARY clause
of CREATE TABLESPACE
1
EXTENT MANAGEMENT LOCAL clause
of CREATE DATABASE
1
extents
allocating for partitions
1
allocating for subpartitions
1
allocating for tables
1
restricting access by instances
1
specifying maximum number for an object
1
specifying number allocated upon object creation
1
specifying the first for an object
1
specifying the percentage of size increase
1
specifying the second for an object
1
external functions
1
,
2
external LOBs
1
external procedures
1
external tables
1
access drivers
1
altering
1
creating
1
ORACLE_DATAPUMP access driver
1
ORACLE_HDFS access driver
1
ORACLE_HIVE access driver
1
ORACLE_LOADER access driver
1
restrictions on
1
external users
1
,
2
EXTRACT (datetime) function
1
EXTRACT (XML) function
1
EXTRACTVALUE function
1
F
FACT hint
1
FAILED_LOGIN_ATTEMPTS parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
failure groups
creating for a disk group
1
,
2
fast refresh
1
FEATURE_DETAILS function
1
FEATURE_ID function
1
FEATURE_SET function
1
FEATURE_VALUE function
1
files
specifying as a redo log file group
1
specifying as data files
1
specifying as temp files
1
FIPS
compliance
1
flagging
1
FIRST_ROWS(n) hint
1
FIRST_VALUE function
1
FIRST function
1
FLAGGER session parameter
1
FLASH_CACHE parameter
of STORAGE clause
1
FLASHBACK ARCHIVE object privilege
1
flashback data archives
creating
1
dropping
1
modifying
1
privileges for
1
specifying for a table
1
,
2
FLASHBACK DATABASE statement
1
flashback queries
1
pseudocolumns for
1
using with inserts
1
,
2
FLASHBACK TABLE statement
1
flash cache
1
floating-point conditions
1
floating-point numbers
1
converting to
1
,
2
handling NaN
1
FLOOR function
1
FLUSH BUFFER_CACHE clause
of ALTER SYSTEM
1
FLUSH GLOBAL CONTEXT clause
of ALTER SYSTEM
1
FLUSH REDO clause
of ALTER SYSTEM
1
FLUSH SHARED_POOL clause
of ALTER SYSTEM
1
FM format model modifier
1
FORCE clause
of COMMIT
1
of CREATE VIEW
1
of DISASSOCIATE STATISTICS
1
of DROP INDEX
1
of DROP INDEXTYPE
1
of DROP OPERATOR
1
of DROP TYPE
1
of REVOKE
1
of ROLLBACK
1
,
2
force full database caching
1
FORCE LOGGING clause
of ALTER DATABASE
1
of ALTER TABLESPACE
1
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
of CREATE TABLESPACE
1
FORCE PARALLEL DML clause
of ALTER SESSION
1
FOR clause
of CREATE INDEXTYPE
1
of EXPLAIN PLAN
1
,
2
foreign key constraints
1
foreign tables
rowids of
1
format models
1
changing the return format
1
date
1
changing
1
default format
1
format elements
1
maximum length
1
modifiers
1
number
1
number, elements of
1
specifying
1
XML
1
formats
for dates and numbers. See format models
1
of return values from the database
1
of values stored in the database
1
FOR UPDATE clause
of SELECT
1
FREELIST GROUPS parameter
of STORAGE clause
1
free lists
specifying for a table, partition, cluster, or index
1
specifying for LOBs
1
FREELISTS parameter
of STORAGE clause
1
FREEPOOLS parameter
of LOB storage
1
FRESH_MV hint
1
FROM_TZ function
1
FROM clause
of CREATE PLUGGABLE DATABASE
1
of queries
1
FROM COLUMNS clause
of DISASSOCIATE STATISTICS
1
FROM FUNCTIONS clause
of DISASSOCIATE STATISTICS
1
FROM INDEXES clause
of DISASSOCIATE STATISTICS
1
FROM INDEXTYPES clause
of DISASSOCIATE STATISTICS
1
FROM PACKAGES clause
of DISASSOCIATE STATISTICS
1
FROM TYPES clause
of DISASSOCIATE STATISTICS
1
FULL hint
1
full indexes
1
full outer joins
1
function-based indexes
1
creating
1
disabling
1
enabling
1
refreshing
1
function expressions
built-in
1
user-defined
1
functions
1
See also:
SQL functions
3GL,calling
1
associating statistics types with
1
avoiding run-time compilation
1
built_in
as expressions
1
calling
1
changing the declaration of
1
changing the definition of
1
defining an index on
1
disassociating statistics types from
1
executing
1
external
1
,
2
inverse distribution
1
,
2
issuing COMMIT or ROLLBACK statements
1
linear regression
1
naming rules
1
OLAP
1
recompiling invalid
1
re-creating
1
,
2
removing from the database
1
statistics, assigning default cost
1
statistics, defining default selectivity
1
stored
1
storing return value of
1
synonyms for
1
user-defined
1
as expressions
1
XML
1
FUNCTIONS clause
of ASSOCIATE STATISTICS
1
of DISASSOCIATE STATISTICS
1
FX format model modifier
1
G
GATHER_OPTIMIZER_STATISTICS hint
1
general comparison functions
1
general recovery clause
of ALTER DATABASE
1
geoimaging
1
GLOBAL_TOPIC_ENABLED system parameter
1
global indexes
See:
indexes, globally partitioned
globally partitioned indexes
1
GLOBAL parameter
of CREATE SEQUENCE
1
GLOBAL PARTITION BY HASH clause
of CREATE INDEX
1
GLOBAL PARTITION BY RANGE clause
of CREATE INDEX
1
global sequences
1
GLOBAL TEMPORARY clause
of CREATE TABLE
1
global users
1
,
2
GRANT CONNECT THROUGH clause
of ALTER USER
1
GRANT statement
locks
1
GRAPHIC data type
DB2
1
SQL/DS
1
greater than or equal to tests
1
greater than tests
1
GREATEST function
1
GROUP_ID function
1
GROUP BY clause
CUBE extension
1
identifying duplicate groupings
1
of SELECT and subqueries
1
ROLLUP extension of
1
group comparison conditions
1
GROUPING
1
GROUPING_ID function
1
GROUPING function
1
GROUPING Hint
1
groupings
filtering out duplicate
1
grouping sets
1
GROUPING SETS clause
of SELECT and subqueries
1
group separator
specifying
1
GUARD ALL clause
of ALTER DATABASE
1
GUARD clause
of ALTER DATABASE
1
overriding
1
GUARD NONE clause
of ALTER DATABASE
1
GUARD STANDBY clause
of ALTER DATABASE
1
H
hash clusters
creating
1
range-partitioned
1
single-table, creating
1
specifying hash function for
1
HASH hint
1
HASH IS clause
of CREATE CLUSTER
1
HASHKEYS clause
of CREATE CLUSTER
1
hash partitioning clause
of CREATE TABLE
1
hash partitions
adding
1
coalescing
1
HAVING condition
of GROUP BY clause
1
heap-organized tables
creating
1
hexadecimal value
returning
1
HEXTORAW function
1
hierarchical functions
1
hierarchical queries
1
,
2
child rows
1
,
2
illustrated
1
leaf rows
1
operators in
1
CONNECT_BY_ROOT
1
PRIOR
1
ordering
1
parent rows
1
,
2
pseudocolumns in
1
CONNECT_BY_ISCYCLE
1
CONNECT_BY_ISLEAF
1
LEVEL
1
retrieving root and node values
1
hierarchical query clause
of SELECT and subqueries
1
hierarchies
adding to a dimension
1
altering
1
creating
1
dropping
1
dropping from a dimension
1
granting system privileges for
1
of dimensions, defining
1
HIERARCHY clause
of CREATE DIMENSION
1
high water mark
of clusters
1
of indexes
1
of tables
1
,
2
hints
1
ALL_ROWS
1
APPEND
1
APPEND_VALUES
1
CACHE
1
CLUSTER
1
CLUSTERING
1
CONTAINER
1
CURSOR_SHARING_EXACT
1
DISABLE_PARALLEL_DML
1
DYNAMIC_SAMPLING
1
ENABLE_PARALLEL_DML
1
FACT
1
FIRST_ROWS(n)
1
FRESH_MV
1
FULL
1
GATHER_OPTIMIZER_STATISTICS
1
HASH
1
INDEX
1
INDEX_ASC
1
INDEX_COMBINE
1
INDEX_DESC
1
INDEX_FFS
1
INDEX_JOIN
1
INDEX_SS
1
INDEX_SS_ASC
1
INDEX_SS_DESC
1
INMEMORY
1
INMEMORY_PRUNING
1
in SQL statements
1
LEADING
1
location syntax
1
MERGE
1
MODEL_MIN_ANALYSIS
1
MONITOR
1
NO_CLUSTERING
1
NO_EXPAND
1
NO_FACT
1
NO_GATHER_OPTIMIZER_STATISTICS
1
NO_INDEX
1
NO_INDEX_FFS
1
NO_INDEX_SS
1
NO_INMEMORY
1
NO_INMEMORY_PRUNING
1
NO_MERGE
1
NO_MONITOR
1
NO_PARALLEL
1
NO_PARALLEL_INDEX
1
NO_PQ_CONCURRENT_UNION
1
NO_PQ_SKEW
1
NO_PUSH_PRED
1
NO_PUSH_SUBQ
1
NO_PX_JOIN_FILTER
1
NO_QUERY_TRANSFORMATION
1
NO_RESULT_CACHE
1
NO_REWRITE
1
NO_STAR_TRANSFORMATION
1
NO_STATEMENT_QUEUING
1
NO_UNNEST
1
NO_USE_BAND
1
NO_USE_CUBE
1
NO_USE_HASH
1
NO_USE_MERGE
1
NO_USE_NL
1
NO_XML_QUERY_REWRITE
1
NO_XMLINDEX_REWRITE
1
NO_ZONEMAP
1
NOCACHE
1
NOPARALLEL
1
NOPARALLEL_INDEX
1
NOREWRITE
1
OPT_PARAM
1
ORDERED
1
PARALLEL
1
PARALLEL_INDEX
1
passing to the optimizer
1
PQ_CONCURRENT_UNION
1
PQ_DISTRIBUTE
1
PQ_FILTER
1
PQ_SKEW
1
PUSH_PRED
1
PUSH_SUBQ
1
PX_JOIN_FILTER
1
QB_NAME
1
REWRITE
1
specifying a query block
1
STAR_TRANSFORMATION
1
STATEMENT_QUEUING
1
syntax
1
UNNEST
1
USE_BAND
1
USE_CONCAT
1
USE_CUBE
1
USE_HASH
1
USE_MERGE
1
USE_NL
1
USE_NL_WITH_INDEX
1
histograms
creating equiwidth
1
Hybrid Columnar Compression
1
I
IDENTIFIED BY clause
of ALTER ROLE. See CREATE ROLE
1
of CREATE DATABASE LINK
1
IDENTIFIED EXTERNALLY clause
of ALTER ROLE. See CREATE ROLE
1
,
2
of ALTER USER. See CREATE USER
1
of CREATE ROLE
1
of CREATE USER
1
IDENTIFIED GLOBALLY clause
of ALTER ROLE. See CREATE ROLE
1
of CREATE ROLE
1
of CREATE USER
1
identifier functions
1
identity column
1
IDLE_TIME parameter
of ALTER PROFILE
1
IEEE754
floating-point arithmetic
1
Oracle conformance with
1
IGNORE_ROW_ON_DUPKEY_INDEX hint
1
IMMEDIATE clause
of SET CONSTRAINTS
1
implicit data conversion
1
,
2
,
3
INCLUDING CONTENTS clause
of DROP TABLESPACE
1
INCLUDING DATAFILES clause
of ALTER DATABASE TEMPFILE DROP clause
1
INCLUDING NEW VALUES clause
of ALTER MATERIALIZED VIEW LOG
1
of CREATE MATERIALIZED VIEW LOG
1
INCLUDING TABLES clause
of DROP CLUSTER
1
incomplete object types
1
creating
1
IN conditions
1
incremental
and block change tracking
1
INCREMENT BY clause
of ALTER SEQUENCE. See CREATE SEQUENCE
1
INCREMENT BY parameter
of CREATE SEQUENCE
1
INDEX_ASC hint
1
INDEX_COMBINE hint
1
INDEX_DESC hint
1
INDEX_FFS hint
1
INDEX_JOIN hint
1
INDEX_SS_ASC hint
1
INDEX_SS_DESC hint
1
INDEX_SS hint
1
INDEX clause
of ANALYZE
1
of CREATE CLUSTER
1
indexed clusters
creating
1
indexes
1
advanced index compression, enabling
1
advanced index compression of
1
allocating new extents for
1
application-specific
1
ascending
1
based on indextypes
1
bitmap
1
bitmap join
1
B-tree
1
changing attributes
1
changing parallelism of
1
collecting statistics on
1
creating
1
creating as usable or unusable
1
creating on a cluster
1
creating on a table
1
deallocating unused space from
1
descending
1
and query rewrite
1
as function-based indexes
1
direct-path inserts, logging
1
domain
1
,
3
domain, example
1
dropping index partitions
1
examples
1
full
1
full fast scans
1
function-based
1
creating
1
globally partitioned
1
updating
1
global partitioned, creating
1
granting system privileges for
1
invisible to the optimizer
1
,
2
join, bitmap
1
local domain
1
locally partitioned
1
logging rebuild operations
1
marking as USABLE or UNUSABLE
1
merging block contents
1
merging contents of index blocks
1
merging contents of index partition blocks
1
modifying attributes
1
moving
1
on clusters
1
on composite-partitioned tables
1
on composite-partitioned tables, creating
1
on hash-partitioned tables
1
creating
1
on index-organized tables
1
online
1
on list-partitioned tables
creating
1
on nested table storage tables
1
on partitioned tables
1
on range-partitioned tables
1
on range-partitioned tables, creating
1
on scalar typed object attributes
1
on table columns
1
on XMLType tables
1
parallelizing creation of
1
partial
1
partitioned
1
,
2
user-defined
1
partitioning
1
partitions
1
adding hash
1
adding new
1
changing default attributes
1
changing physical attributes
1
changing storage characteristics
1
coalescing hash partitions
1
deallocating unused space from
1
dropping
1
marking UNUSABLE
1
,
2
modifying the real characteristics
1
preventing use of
1
rebuilding
1
rebuilding unusable
1
re-creating
1
removing
1
renaming
1
specifying tablespace for
1
splitting
1
prefix compression, enabling
1
prefix compression of
1
preventing use of
1
purging from the recycle bin
1
rebuilding
1
re-creating
1
removing from the database
1
renaming
1
reverse
1
,
4
specifying tablespace for
1
statistics on usage
1
subpartitions
allocating extents for
1
changing default attributes
1
changing physical attributes
1
changing storage characteristics
1
deallocating unused space from
1
marking UNUSABLE
1
modifying
1
moving
1
preventing use of
1
rebuilding
1
re-creating
1
renaming
1
specifying tablespace for
1
tablespace containing
1
unique
1
unsorted
1
used to enforce constraints
1
,
2
validating structure
1
INDEXES clause
of ASSOCIATE STATISTICS
1
of DISASSOCIATE STATISTICS
1
INDEX hint
1
indexing property
1
index keys
compression
1
index-organized tables
bitmap indexes on, creating
1
creating
1
mapping tables
1
creating
1
moving
1
merging contents of index blocks
1
modifying
1
moving
1
overflow segments
specifying storage
1
,
2
partitioned, updating secondary indexes
1
PCT_ACCESS_DIRECT statistics
1
primary key indexes
coalescing
1
rebuilding
1
rowids of
1
secondary indexes, updating
1
index partitions
creating subpartitions
1
index subpartitions
1
INDEXTYPE clause
of CREATE INDEX
1
indextypes
adding operators
1
altering
1
associating statistics types with
1
changing implementation type
1
comments on
1
creating
1
disassociating statistics types from
1
,
2
drop routines, invoking
1
granting system privileges for
1
indexes based on
1
instances
1
removing from the database
1
INDEXTYPES clause
of ASSOCIATE STATISTICS
1
of DISASSOCIATE STATISTICS
1
in-doubt transactions
forcing
1
forcing commit of
1
forcing rollback
1
,
2
rolling back
1
inequality test
1
INHERIT PRIVILEGES object privilege
on a user
1
INITCAP function
1
initialization parameters
changing session settings
1
setting using ALTER SESSION
1
INITIALIZED EXTERNALLY clause
of CREATE CONTEXT
1
INITIALIZED GLOBALLY clause
of CREATE CONTEXT
1
INITIALLY DEFERRED clause
of constraints
1
INITIALLY IMMEDIATE clause
of constraints
1
INITIAL parameter
of STORAGE clause
1
INITRANS parameter
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of CREATE INDEX. See CREATE TABLE
1
of CREATE MATERIALIZED VIEW. See CREATE TABLE
1
of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE
1
of CREATE TABLE
1
inline constraints
of ALTER TABLE
1
of CREATE TABLE
1
inline views
1
lateral
1
INMEMORY_PRUNING hint
1
INMEMORY hint
1
inner joins
1
,
2
inner-N reporting
1
INSERT
direct-path versus conventional
1
INSERTCHILDXMLAFTER function
1
INSERTCHILDXMLBEFORE function
1
INSERTCHILDXML function
1
INSERT clause
of MERGE
1
inserts
and simultaneous update
1
conditional
1
conventional
1
direct-path
1
multitable
1
examples
1
single-table
1
using MERGE
1
INSERT statement
1
append
1
,
2
error logging
1
INSERTXMLAFTER function
1
INSERTXMLBEFORE function
1
instance recovery
continue after interruption
1
instances
making index extents available to
1
setting parameters for
1
INSTANCE session parameter
1
INSTR2 function
1
INSTR4 function
1
INSTRB function
1
INSTRC function
1
INSTR function
1
integers
generating unique
1
in SQL syntax
1
precision of
1
syntax of
1
integrity constraints
See:
constraints
internal LOBs
1
International Organization for Standardization (ISO)
standards
1
,
2
INTERSECT set operator
1
interval
arithmetic
1
data types
1
literals
1
interval conditions
1
INTERVAL DAY TO SECOND data type
1
INTERVAL expressions
1
interval partitioning
1
,
2
changing the interval
1
INTERVAL YEAR TO MONTH data type
1
INTO clause
of EXPLAIN PLAN
1
of INSERT
1
INVALIDATE GLOBAL INDEXES clause
of ALTER TABLE
1
inverse distribution functions
1
,
2
invoker rights
altering for a Java class
1
defining for a Java class
1
invoker’s rights views
1
IS [NOT] EMPTY conditions
1
IS ANY condition
1
IS JSON condition
1
ISO
See:
International Organization for Standardization (ISO)
IS OF type condition
1
IS PRESENT condition
1
ITERATION_NUMBER function
1
J
Java
class
creating
1
dropping
1
resolving
1
,
2
Java source schema object
creating
1
resource
creating
1
dropping
1
schema object
name resolution of
1
source
compiling
1
,
2
creating
1
dropping
1
job scheduler object privileges
1
JOIN clause
of CREATE DIMENSION
1
join groups
altering
1
creating
1
dropping
1
JOIN KEY clause
of ALTER DIMENSION
1
of CREATE DIMENSION
1
joins
1
antijoins
1
band
1
conditions
defining
1
cross
1
equijoins
1
full outer
1
inner
1
,
2
left outer
1
natural
1
outer
1
and data densification
1
on grouped tables
1
restrictions
1
parallel
1
right outer
1
self
1
semijoins
1
without join conditions
1
join views
example
1
making updatable
1
modifying
1
,
2
,
3
JSON_ARRAYAGG function
1
JSON_ARRAY function
1
JSON_DATAGUIDE function
1
JSON_EXISTS condition
1
JSON_OBJECTAGG function
1
JSON_OBJECT function
1
JSON_QUERY function
1
JSON_TABLE function
1
JSON_TEXTCONTAINS condition
1
JSON_VALUE function
1
Julian dates
1
K
KEEP DATAFILES clause
of DROP PLUGGABLE DATABASE
1
KEEP keyword
of FIRST function
1
of LAST function
1
with aggregate functions
1
KEEP parameter
of CREATE SEQUENCE
1
KEEP SEQUENCE object privilege
on a sequence
1
key compression
See:
prefix compression
key management framework
granting system privileges for
1
managing
1
key-preserved tables
1
keys, eliminating repetition
1
keywords
1
in object names
1
optional
1
required
1
KILL SESSION clause
of ALTER SYSTEM
1
L
LAG function
1
large object functions
1
large objects
See:
LOB data types
LAST_DAY function
1
LAST_VALUE function
1
LAST function
1
lateral inline views
1
LEAD function
1
LEADING hint
1
LEAST function
1
left outer joins
1
LENGTH2 function
1
LENGTH4 function
1
LENGTHB function
1
LENGTHC function
1
LENGTH function
1
less than tests
1
LEVEL clause
of ALTER DIMENSION
1
of CREATE DIMENSION
1
level columns
specifying default values
1
LEVEL pseudocolumn
1
,
2
levels
adding to a dimension
1
dropping from a dimension
1
of dimensions, defining
1
libraries
creating
1
granting system privileges for
1
re-creating
1
removing from the database
1
library units
See:
Java schema objects
LIKE conditions
1
linear regression functions
1
LISTAGG function
1
LIST CHAINED ROWS clause
of ANALYZE
1
listeners
registering
1
list partitioning
adding default partition
1
adding partitions
1
adding values
1
creating a default partition
1
creating partitions
1
dropping values
1
merging default with nondefault partitions
1
splitting default partition
1
list subpartitions
adding
1
literals
1
datetime
1
interval
1
LN function
1
LNNVL function
1
LOB columns
adding
1
compressing
1
creating from LONG columns
1
,
2
deduplication
1
defining properties
for materialized views
1
encrypting
1
modifying
1
modifying storage
1
restricted in joins
1
restrictions on
1
storage characteristics of materialized views
1
LOB data types
1
LOBs
attributes, initializing
1
columns
difference from LONG and LONG RAW
1
populating
1
external
1
internal
1
locators
1
logging attribute
1
modifying physical attributes
1
number of bytes manipulated in
1
saving old versions
1
saving values in a cache
1
,
2
specifying directories for
1
storage
attributes
1
characteristics
1
in-line
1
tablespace for
defining
1
LOB storage clause
for partitions
1
of ALTER MATERIALIZED VIEW
1
of ALTER TABLE
1
of CREATE MATERIALIZED VIEW
1
of CREATE TABLE
1
LOCAL clause
of CREATE INDEX
1
locale independent
1
locally managed tablespaces
altering
1
storage attributes
1
locally partitioned indexes
1
LOCALTIMESTAMP function
1
local users
1
,
2
location transparency
1
locking, overriding automatic
1
locks
See:
table locks
data
1
dictionary
1
row (TX)
1
table (TM)
1
LOCK TABLE statement
1
log data
collection during update operations
1
LOGFILE clause
OF CREATE DATABASE
1
log file clauses
of ALTER DATABASE
1
LOGFILE GROUP clause
of CREATE CONTROLFILE
1
log files
adding
1
dropping
1
modifying
1
registering
1
renaming
1
specifying for the database
1
LOG function
1
logging
and redo log size
1
specifying minimal
1
supplemental
dropping
1
supplemental, adding log groups
1
supplemental, dropping log groups
1
LOGGING clause
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of ALTER TABLESPACE
1
of CREATE MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW LOG
1
of CREATE TABLE
1
of CREATE TABLESPACE
1
log groups
adding
1
dropping
1
LOGICAL_READS_PER_CALL parameter
of ALTER PROFILE
1
LOGICAL_READS_PER_SESSION parameter
of ALTER PROFILE
1
of ALTER RESOURCE COST
1
logical conditions
1
logical standby database
aborting
1
activating
1
stopping
1
LogMiner
granting system privileges for
1
supplemental logging
1
,
2
LONG columns
and domain indexes
1
converting to LOB
1
,
2
restrictions on
1
to store text strings
1
to store view definitions
1
where referenced from
1
LONG data type
1
in triggers
1
LONG RAW data type
1
converting from CHAR data
1
LONG VARGRAPHIC data type
DB2
1
SQL/DS
1
LOWER function
1
LPAD function
1
LTRIM function
1
M
MAKE_REF function
1
managed recovery
of database
1
managed standby recovery
as background process
1
create a logical standby from the physical standby
1
overriding delays
1
returning control during
1
terminating existing
1
MANAGED STANDBY RECOVERY clause
of ALTER DATABASE
1
MAPPING TABLE clause
of ALTER TABLE
1
mapping tables
of index-organized tables
1
,
2
modifying
1
master databases
1
master tables
1
MATCHES condition
1
MATCHES operator
1
materialized join views
1
materialized view logs
1
creating
1
excluding new values from
1
logging changes to
1
object ID based
1
parallelizing creation
1
partition attributes, changing
1
partitioned
1
physical attributes
changing
1
specifying
1
purging
1
,
2
refreshing
1
,
2
removing from the database
1
required for fast refresh
1
required for synchronous refresh
1
rowid based
1
saving new values in
1
saving old values in
1
staging logs
1
storage attributes
specifying
1
materialized views
1
changing from rowid-based to primary-key-based
1
changing to primary-key-based
1
complete refresh
1
,
2
compression of
1
,
2
constraints on
1
creating
1
creating comments about
1
degree of parallelism
1
,
2
during creation
1
enabling and disabling query rewrite
1
examples
1
,
2
fast refresh
1
,
2
forced refresh
1
for data warehousing
1
for replication
1
granting system privileges for
1
index characteristics
changing
1
indexes that maintain
1
join
1
LOB storage attributes
1
logging changes to
1
master table, dropping
1
object type, creating
1
partitions
1
compression of
1
,
2
physical attributes
1
changing
1
,
2
primary key
1
recording values in master table
1
query rewrite
eligibility for
1
enabling and disabling
1
re-creating during refresh
1
refresh
1
after DML on master table
1
,
2
mode, changing
1
on next COMMIT
1
,
2
using trusted constraints
1
refresh, time, changing
1
refreshing
1
removing from the database
1
restricting scope of
1
retrieving data from
1
revalidating
1
rowid
1
rowid values
recording in master table
1
saving blocks in a cache
1
storage attributes
1
changing
1
,
2
subquery
1
suppressing creation of default index
1
synonyms for
1
when to populate
1
MAXDATAFILES parameter
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
MAXEXTENTS parameter
of STORAGE clause
1
MAX function
1
MAXINSTANCES parameter
of CREATE CONTROLFILE
1
OF CREATE DATABASE
1
MAXLOGFILES parameter
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
MAXLOGHISTORY parameter
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
MAXLOGMEMBERS parameter
of CREATE CONTROLFILE
1
of CREATE DATABASE
1
MAXSIZE clause
of ALTER DATABASE
1
MAXTRANS parameter
of physical_attributes_clause
1
MAXVALUE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
MEDIAN function
1
median values
1
media recovery
avoid on startup
1
designing
1
disabling
1
from specified redo logs
1
of database
1
of data files
1
of standby database
1
of tablespaces
1
performing ongoing
1
preparing for
1
restrictions
1
sustained standby recovery
1
MEMBER conditions
1
membership conditions
1
,
2
merge_insert_clause
of MERGE
1
MERGE ANY VIEW system privilege
1
MERGE hint
1
MERGE PARTITIONS clause
of ALTER TABLE
1
MERGE statement
1
deletes during
1
error logging
1
inserts during
1
updates during
1
MERGE VIEW object privilege on a view
1
migrated rows
listing
1
of clusters
1
MINEXTENTS parameter
of STORAGE clause
1
MIN function
1
MINIMIZE RECORDS PER BLOCK clause
of ALTER TABLE
1
MINIMUM EXTENT clause
of ALTER TABLESPACE
1
of CREATE TABLESPACE
1
mining models
auditing
1
comments on
1
MINUS set operator
1
MINVALUE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
MODE clause
of LOCK TABLE
1
MODEL_MIN_ANALYSIS hint
1
MODEL clause
of SELECT
1
model conditions
1
IS ANY
1
IS PRESENT
1
model expression
1
model functions
1
MOD function
1
MODIFY clause
of ALTER TABLE
1
MODIFY CONSTRAINT clause
of ALTER TABLE
1
of ALTER VIEW
1
MODIFY DEFAULT ATTRIBUTES clause
of ALTER INDEX
1
of ALTER TABLE
1
MODIFY LOB storage clause
of ALTER MATERIALIZED VIEW
1
of ALTER TABLE
1
MODIFY NESTED TABLE clause
of ALTER TABLE
1
MODIFY PARTITION clause
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW
1
of ALTER TABLE
1
MODIFY scoped_table_ref_constraint clause
of ALTER MATERIALIZED VIEW
1
MODIFY SUBPARTITION clause
of ALTER INDEX
1
MODIFY VARRAY clause
of ALTER TABLE
1
MON datetime format element
1
MONITOR hint
1
MONITORING USAGE clause
of ALTER INDEX
1
MONTH datetime format element
1
MONTHS_BETWEEN function
1
MOUNT clause
of ALTER DATABASE
1
MOVE clause
of ALTER TABLE
1
of CREATE PLUGGABLE DATABASE
1
MOVE ONLINE clause
of ALTER TABLE
1
MOVE SUBPARTITION clause
of ALTER TABLE
1
MTS
See:
shared server
multilevel collections
1
multiset conditions
1
MULTISET EXCEPT operator
1
MULTISET INTERSECT operator
1
MULTISET keyword
of CAST function
1
multiset operators
1
MULTISET EXCEPT
1
MULTISET INTERSECT
1
MULTISET UNION
1
MULTISET UNION operator
1
multitable inserts
1
conditional
1
examples
1
unconditional
1
multitenant container databases
See:
CDBs
multi-threaded server
See:
shared server
N
NAME clause
of SET TRANSACTION
1
NAMED clause
of CREATE JAVA
1
namespaces
and object naming rules
1
database
1
for nonschema objects
1
for schema objects
1
NANVL function
1
national character set
changing
1
multibyte character data
1
variable-length strings
1
NATIONAL CHARACTER SET parameter
of CREATE DATABASE
1
natural joins
1
NCHAR data type
1
NCHR function
1
NCLOB data type
1
nested subqueries
1
NESTED TABLE clause
of ALTER TABLE
1
of CREATE TABLE
1
nested tables
1
,
2
,
3
,
4
changing returned value
1
combining
1
compared with varrays
1
comparison rules
1
creating
1
creating from existing columns
1
defining as index-organized tables
1
determining hierarchy
1
dropping the body of
1
dropping the specification of
1
indexing columns of
1
in materialized views
1
modifying
1
modifying column properties
1
multilevel
1
partitioned nested table columns
1
storage characteristics of
1
,
2
NEW_TIME function
1
NEXT_DAY function
1
NEXT clause
of ALTER MATERIALIZED VIEW ... REFRESH
1
NEXT parameter
of STORAGE clause
1
NEXTVAL pseudocolumn
1
,
2
NLS_CHARSET_DECL_LEN function
1
NLS_CHARSET_ID function
1
NLS_CHARSET_NAME function
1
NLS_COLLATION_ID function
1
NLS_COLLATION_NAME function
1
NLS_DATE_LANGUAGE initialization parameter
1
NLS_INITCAP function
1
NLS_LANGUAGE initialization parameter
1
,
2
NLS_LOWER function
1
NLS_SORT initialization parameter
1
NLS_TERRITORY initialization parameter
1
NLS_UPPER function
1
NLSSORT function
1
NO_CLUSTERING hint
1
NO_EXPAND hint
1
NO_FACT hint
1
NO_GATHER_OPTIMIZER_STATISTICS hint
1
NO_INDEX_FFS hint
1
NO_INDEX_SS hint
1
NO_INDEX hint
1
NO_INMEMORY_PRUNING hint
1
NO_INMEMORY hint
1
NO_MERGE hint
1
NO_MONITOR hint
1
NO_PARALLEL_INDEX
1
NO_PARALLEL hint
1
NO_PQ_CONCURRENT_UNION hint
1
NO_PQ_SKEW hint
1
NO_PUSH_PRED hint
1
NO_PUSH_SUBQ hint
1
NO_PX_JOIN_FILTER hint
1
NO_QUERY_TRANSFORMATION hint
1
NO_RESULT_CACHE hint
1
NO_REWRITE hint
1
NO_STAR_TRANSFORMATION hint
1
NO_STATEMENT_QUEUING hint
1
NO_UNNEST hint
1
NO_USE_BAND hint
1
NO_USE_CUBE hint
1
NO_USE_HASH hint
1
NO_USE_MERGE hint
1
NO_USE_NL hint
1
NO_XML_QUERY_REWRITE hint
1
NO_XMLINDEX_REWRITE hint
1
NO_ZONEMAP hint
1
NOARCHIVELOG clause
of ALTER DATABASE
1
of CREATE CONTROLFILE
1
OF CREATE DATABASE
1
,
2
NOAUDIT statement
1
for unified auditing
1
locks
1
NOCACHE clause
of ALTER MATERIALIZED VIEW
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of ALTER TABLE
1
of CREATE CLUSTER
1
of CREATE MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW LOG
1
of CREATE SEQUENCE
1
NOCACHE hint
1
NOCOMPRESS clause
of ALTER INDEX ... REBUILD
1
of CREATE TABLE
1
NOCOPY clause
of CREATE PLUGGABLE DATABASE
1
NOCYCLE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
NOFORCE clause
of CREATE JAVA
1
of CREATE VIEW
1
NO FORCE LOGGING clause
of ALTER DATABASE
1
of ALTER TABLESPACE
1
NOKEEP parameter
of CREATE SEQUENCE
1
NOLOGGING mode
and force logging mode
1
for nonpartitioned objects
1
for partitioned objects
1
NOMAXVALUE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
NOMINIMIZE RECORDS PER BLOCK clause
of ALTER TABLE
1
NOMINVALUE parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
NOMONITORING USAGE clause
of ALTER INDEX
1
NONE clause
of SET ROLE
1
nonempty subsets of
1
nonequivalency tests
1
nonschema objects
list of
1
namespaces
1
NOORDER parameter
of ALTER SEQUENCE. See CREATE SEQUENCE
1
of CREATE SEQUENCE
1
NOPARALLEL_INDEX hint
1
NOPARALLEL clause
of CREATE INDEX
1
,
2
NOPARALLEL hint
1
NORELY clause
of constraints
1
NORESETLOGS clause
of CREATE CONTROLFILE
1
NOREVERSE parameter
of ALTER INDEX ... REBUILD
1
NOREWRITE hint
1
NOROWDEPENDENCIES clause
of CREATE CLUSTER
1
of CREATE TABLE
1
NOSORT clause
of ALTER INDEX
1
NOT condition
1
NOT DEFERRABLE clause
of constraints
1
NOT IDENTIFIED clause
of ALTER ROLE. See CREATE ROLE
1
of CREATE ROLE
1
NOT IN subqueries
converting to NOT EXISTS subqueries
1
NOT NULL clause
of CREATE TABLE
1
NOWAIT clause
of LOCK TABLE
1
NTH_VALUE function
1
NTILE function
1
null
1
difference from zero
1
in conditions
1
table of
1
in functions
1
with comparison conditions
1
null conditions
1
NULLIF function
1
as a form of CASE expression
1
NULL-related functions
1
NUMBER data type
1
converting to VARCHAR2
1
precision
1
scale
1
number format models
1
number functions
1
numbers
comparison rules
1
floating-point
1
,
2
in SQL syntax
1
precision of
1
spelling out
1
syntax of
1
numeric data type
1
numeric functions
1
numeric precedence
1
NUMTODSINTERVAL function
1
NUMTOYMINTERVAL function
1
NVARCHAR2 data type
1
NVL2 function
1
NVL function
1
O
OBJECT_ID pseudocolumn
1
,
2
,
4
OBJECT_VALUE pseudocolumn
1
object access expressions
1
OBJECT IDENTIFIER clause
of CREATE TABLE
1
object identifiers
contained in REFs
1
primary key
1
specifying
1
specifying an index on
1
system-generated
1
object instances
types of
1
object privileges
granting
1
multiple
1
on specific columns
1
on a database object
revoking
1
revoking
1
from a role
1
from a user
1
from PUBLIC
1
object reference functions
1
objects
See:
object types or database objects
object tables
adding rows to
1
as part of hierarchy
1
creating
1
querying
1
system-generated column name
1
,
3
updating to latest version
1
upgrading
1
object type columns
defining properties
for materialized views
1
in a type hierarchy
1
membership in hierarchy
1
modifying properties
for tables
1
substitutability
1
object type materialized views
creating
1
object types
1
associating statistics types with
1
attributes
1
in a type hierarchy
1
membership in hierarchy
1
substitutability
1
bodies
creating
1
re-creating
1
comparison rules
1
MAP function
1
ORDER function
1
components of
1
creating
1
defining member methods of
1
disassociating statistics types from
1
,
2
dropping the body of
1
dropping the specification of
1
granting system privileges for
1
identifiers
1
incomplete
1
methods
1
privileges on subtypes
1
references to. See REFs
1
statistics types
1
values of
1
object views
1
base tables
adding rows
1
creating
1
defining
1
querying
1
ODCIIndexInsert method
indextype support of
1
,
2
OF clause
of CREATE VIEW
1
of CREATE OPERATOR
1
OFFLINE clause
of ALTER TABLESPACE
1
of CREATE TABLESPACE
1
OIDINDEX clause
of CREATE TABLE
1
OIDs
See:
object identifiers
OLAP functions
1
ON clause
of CREATE OUTLINE
1
ON COMMIT clause
of CREATE TABLE
1
ON DEFAULT clause
of AUDIT
1
of NOAUDIT
1
ON DELETE CASCADE clause
of constraints
1
ON DELETE SET NULL clause
of constraints
1
ON DIRECTORY clause
of AUDIT
1
of NOAUDIT
1
online backup
of tablespaces, ending
1
ONLINE clause
of ALTER TABLESPACE
1
of CREATE INDEX
1
of CREATE TABLESPACE
1
online indexes
1
rebuilding
1
online redo logs
reinitializing
1
ON MINING MODEL clause
of AUDIT
1
ON object clause
of NOAUDIT
1
of REVOKE
1
ON PREBUILT TABLE clause
of CREATE MATERIALIZED VIEW
1
OPEN clause
of ALTER DATABASE
1
OPEN READ ONLY clause
of ALTER DATABASE
1
OPEN READ WRITE clause
of ALTER DATABASE
1
operands
1
operating system files
dropping
1
removing
1
operators
1
adding to indextypes
1
altering
1
arithmetic
1
binary
1
COLLATE
1
comments on
1
concatenation
1
CONNECT_BY_ROOT
1
dropping from indextypes
1
granting system privileges for
1
MULTISET EXCEPT
1
MULTISET INTERSECT
1
MULTISET UNION
1
precedence
1
PRIOR
1
set
1
specifying implementation of
1
unary
1
user-defined
1
binding to a function
1
,
2
compiling
1
creating
1
dropping
1
how bindings are implemented
1
implementation type
1
OPT_PARAM hint
1
OPTIMAL parameter
of STORAGE clause
1
ORA_DST_AFFECTED function
1
ORA_DST_CONVERT function
1
ORA_DST_ERROR function
1
ORA_HASH function
1
ORA_INVOKING_USER function
1
ORA_INVOKING_USERID function
1
ORA_ROWSCN pseudocolumn
1
Oracle ADVM volumes
1
Oracle Automatic Storage Management
migrating nodes in a cluster
1
Oracle Call Interface
1
Oracle reserved words
1
Oracle Text
built-in conditions
1
CATSEARCH
1
CONTAINS
1
creating domain indexes
1
MATCHES
1
operators
1
CATSEARCH
1
CONTAINS
1
MATCHES
1
SCORE
1
Oracle Tools
support of SQL
1
OR condition
1
ORDAudio data type
1
ORDDicom data type
1
ORDDoc data type
1
ORDER BY clause
of queries
1
of SELECT
1
,
2
with ROWNUM
1
ORDER clause
of ALTER SEQUENCE. See CREATE SEQUENCE
1
ORDERED hint
1
ORDER parameter
of CREATE SEQUENCE
1
ORDER SIBLINGS BY clause
of SELECT
1
ORDImage data type
1
ordinal numbers
specifying
1
spelling out
1
ORDVideo data type
1
ORGANIZATION EXTERNAL clause
of CREATE TABLE
1
ORGANIZATION HEAP clause
of CREATE TABLE
1
ORGANIZATION INDEX clause
of CREATE TABLE
1
OR REPLACE clause
of CREATE CONTEXT
1
of CREATE DIRECTORY
1
of CREATE FUNCTION
1
,
2
of CREATE LIBRARY
1
of CREATE OUTLINE
1
of CREATE PACKAGE
1
of CREATE PACKAGE BODY
1
of CREATE PROCEDURE
1
of CREATE TRIGGER
1
of CREATE TYPE
1
of CREATE TYPE BODY
1
of CREATE VIEW
1
outer joins
1
restrictions
1
outlines
assigning to a different category
1
,
2
assign to a different category
1
copying
1
creating
1
creating on statements
1
dropping from the database
1
enabling and disabling dynamically
1
for use by current session
1
for use by PUBLIC
1
granting system privileges for
1
private, use by the optimizer
1
rebuilding
1
,
2
recompiling
1
renaming
1
,
3
replacing
1
storing groups of
1
use by the optimizer
1
used to generate execution plans
1
use to generate execution plans
1
out-of-line constraints
of CREATE TABLE
1
OVER clause
of analytic functions
1
OVERFLOW clause
of ALTER INDEX
1
of ALTER TABLE
1
of CREATE TABLE
1
P
P.M. datetime format element
1
package bodies
creating
1
re-creating
1
removing from the database
1
packaged procedures
dropping
1
packages
associating statistics types with
1
creating
1
disassociating statistics types from
1
,
2
redefining
1
removing from the database
1
synonyms for
1
PACKAGES clause
of ASSOCIATE STATISTICS
1
of DISASSOCIATE STATISTICS
1
PARALLEL_INDEX hint
1
PARALLEL clause
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of CREATE CLUSTER
1
of CREATE INDEX
1
of CREATE MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW LOG
1
of CREATE TABLE
1
parallel execution
1
hints
1
of DDL statements
1
of DML statements
1
PARALLEL hint
1
parameter files
creating
1
from memory
1
parameters
in syntax
optional
1
required
1
PARAMETERS clause
of CREATE INDEX
1
partial indexes
1
PARTITION ... LOB storage clause
of ALTER TABLE
1
PARTITION BY HASH clause
of CREATE TABLE
1
PARTITION BY LIST clause
of CREATE TABLE
1
PARTITION BY RANGE clause
of CREATE TABLE
1
PARTITION BY REFERENCE clause
of CREATE TABLE
1
PARTITION clause
of ANALYZE
1
of CREATE INDEX
1
of CREATE TABLE
1
of DELETE
1
of INSERT
1
of LOCK TABLE
1
of UPDATE
1
partitioned indexes
1
,
2
local, creating
1
user-defined
1
partitioned index-organized tables
secondary indexes, updating
1
partitioned tables
1
partition-extended table names
in DML statements
1
restrictions on
1
syntax
1
partitioning
by hash
1
by list
1
by range
1
by reference
1
clauses
of ALTER INDEX
1
of ALTER TABLE
1
interval
1
of materialized view logs
1
,
2
of materialized views
1
,
2
range with interval partitions
1
referential constraint
1
,
2
system
1
partitions
adding
1
adding rows to
1
allocating extents for
1
based on literal values
1
composite
specifying
1
converting into nonpartitioned tables
1
deallocating unused space from
1
dropping
1
exchanging with tables
1
extents
allocating for an index
1
hash
adding
1
coalescing
1
specifying
1
index
1
inserting rows into
1
list, adding
1
LOB storage characteristics of
1
locking
1
logging attribute
1
logging insert operations
1
merging
1
modifying
1
physical attributes
changing
1
range
adding
1
specifying
1
removing rows from
1
,
2
renaming
1
revising values in
1
splitting
1
storage characteristics
1
tablespace for
defining
1
PASSWORD_GRACE_TIME parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
PASSWORD_LIFE_TIME parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
PASSWORD_LOCK_TIME parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
PASSWORD_REUSE_MAX parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
PASSWORD_REUSE_TIME parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
PASSWORD_VERIFY_FUNCTION parameter
of ALTER PROFILE
1
of CREATE PROFILE
1
PASSWORD EXPIRE clause
of ALTER USER. See CREATE USER
1
of CREATE USER
1
passwords
expiration of
1
grace period
1
guaranteeing complexity
1
limiting use and reuse
1
locking
1
making unavailable
1
parameters
of CREATE PROFILE
1
special characters in
1
PATH_VIEW
1
,
2
PATH function
1
pattern-matching conditions
1
PCT_ACCESS_DIRECT statistics
for index-organized tables
1
PCTFREE parameter
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of CREATE MATERIALIZED VIEW. See CREATE TABLE.
1
of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE.
1
of CREATE TABLE
1
PCTINCREASE parameter
of STORAGE clause
1
PCTTHRESHOLD parameter
of CREATE TABLE
1
PCTUSED parameter
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of CREATE INDEX. See CREATE TABLE
1
of CREATE MATERIALIZED VIEW. See CREATE TABLE.
1
of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE.
1
of CREATE TABLE
1
PCTVERSION parameter
of LOB storage
1
of LOB storage clause
1
PDBs
administrative user
1
backup
1
changing
global name
1
state
1
storage limits
1
cloning
1
creating
by cloning a source PDB
1
using the seed database
1
default edition, setting
1
examples
creating
1
dropping
1
modifying
1
generating file names
1
granting system privileges for
1
modifying data files
1
modifying temporary files
1
plugging into a CDB
1
recovery
1
setting the time zone of
1
storage limits
1
unplugging
1
XML file for plugging in
1
PERCENT_RANK function
1
PERCENTILE_CONT function
1
PERCENTILE_DISC function
1
PERMANENT clause
of ALTER TABLESPACE
1
physical attributes clause
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
of CREATE CLUSTER
1
of CREATE MATERIALIZED VIEW
1
of CREATE TABLE
1
physical standby database
activating
1
converting to snapshot standby database
1
pivot operations
1
examples
1
syntax
1
placeholder expressions
1
PLAN_TABLE sample table
1
plan management
granting system privileges for
1
plan stability
1
pluggable databases
See:
PDBs
PM datetime format element
1
POSIX regular expression standard
1
POWER function
1
POWERMULTISET_BY_CARDINALITY function
1
POWERMULTISET function
1
PQ_CONCURRENT_UNION hint
1
PQ_DISTRIBUTE hint
1
PQ_FILTER hint
1
PQ_SKEW hint
1
precedence
of conditions
1
of numbers
1
of operators
1
precision
number of digits of
1
of NUMBER data type
1
precompilers
1
predefined roles
1
PREDICTION_BOUNDS function
1
PREDICTION_COST function
1
PREDICTION_DETAILS function
1
PREDICTION_PROBABILITY function
1
PREDICTION_SET function
1
PREDICTION function
1
prefix compression
1
definition
1
disabling
1
enabling
1
of index-organized tables
1
of index rebuild
1
PREPARE TO SWITCHOVER clause
of ALTER DATABASE
1
PRESENTNNV function
1
PRESENTV function
1
pretty-printing of XML output
1
PREVIOUS function
1
primary database
converting to physical standby database
1
PRIMARY KEY clause
of constraints
1
of CREATE TABLE
1
primary key constraints
1
enabling
1
index on
1
primary keys
generating values for
1
PRIOR clause
of hierarchical queries
1
PRIOR operator
1
PRIVATE_SGA parameter
of ALTER PROFILE
1
of ALTER RESOURCE COST
1
PRIVATE clause
of CREATE OUTLINE
1
private outlines
use by the optimizer
1
privileges
1
See also:
system privileges or object privileges
on subtypes of object types
1
revoking from a grantee
1
procedures
3GL,calling
1
calling
1
creating
1
executing
1
external
1
granting system privileges for
1
invalidating local objects dependent on
1
issuing COMMIT or ROLLBACK statements
1
naming rules
1
recompiling
1
re-creating
1
removing from the database
1
synonyms for
1
PROFILE clause
of ALTER USER. See CREATE USER
1
of CREATE USER
1
profiles
adding resource limits
1
assigning to a user
1
changing resource limits
1
creating
1
examples
1
deassigning from users
1
dropping resource limits
1
granting system privileges for
1
modifying, examples
1
removing from the database
1
proxy clause
of ALTER USER
1
pseudocolumns
1
COLUMN_VALUE
1
CONNECT_BY_ISCYCLE
1
CONNECT_BY_ISLEAF
1
CURRVAL
1
flashback queries
1
in hierarchical queries
1
LEVEL
1
NEXTVAL
1
OBJECT_ID
1
,
2
,
4
OBJECT_VALUE
1
ORA_ROWSCN
1
ROWID
1
ROWNUM
1
version queries
1
XMLDATA
1
PUBLIC clause
of CREATE OUTLINE
1
of CREATE SYNONYM
1
of DROP DATABASE LINK
1
public database links
dropping
1
public synonyms
1
dropping
1
PURGE statement
1
PUSH_PRED hint
1
PUSH_SUBQ hint
1
PX_JOIN_FILTER hint
1
Q
QB_NAME hint
1
queries
1
,
2
comments in
1
compound
1
correlated
left correlation
1
default locking of
1
defined
1
distributed
1
grouping returned rows on a value
1
hierarchical, ordering
1
hierarchical. See hierarchical queries
1
hints in
1
join
1
,
2
locking rows during
1
multiple versions of rows
1
of past data
1
ordering returned rows
1
outer joins in
1
referencing multiple tables
1
selecting all columns
1
selecting from a random sample of rows
1
select lists of
1
sorting results
1
syntax
1
top-level
1
top-N
1
,
2
query rewrite
and dimensions
1
defined
1
QUIESCE RESTRICTED clause
of ALTER SYSTEM
1
QUOTA clause
of ALTER USER. See CREATE USER
1
of CREATE USER
1
R
range conditions
1
range partitioning
converting to interval partitioning
1
range partitions
adding
1
creating
1
values of
1
RANK function
1
RATIO_TO_REPORT function
1
RAW data type
1
converting from CHAR data
1
RAWTOHEX function
1
RAWTONHEX function
1
READ ANY TABLE system privilege
1
READ object privilege
on a materialized view
1
on a table
1
on a view
1
READ ONLY clause
of ALTER TABLESPACE
1
of ALTER VIEW
1
READ WRITE clause
of ALTER TABLESPACE
1
of ALTER VIEW
1
REBUILD clause
of ALTER INDEX
1
of ALTER OUTLINE
1
REBUILD PARTITION clause
of ALTER INDEX
1
REBUILD SUBPARTITION clause
of ALTER INDEX
1
REBUILD UNUSABLE LOCAL INDEXES clause
of ALTER TABLE
1
RECOVERABLE
1
,
3
See also:
LOGGING clause
RECOVER AUTOMATIC clause
of ALTER DATABASE
1
RECOVER CANCEL clause
of ALTER DATABASE
1
RECOVER clause
of ALTER DATABASE
1
RECOVER CONTINUE clause
of ALTER DATABASE
1
RECOVER DATABASE clause
of ALTER DATABASE
1
RECOVER DATAFILE clause
of ALTER DATABASE
1
RECOVER LOGFILE clause
of ALTER DATABASE
1
RECOVER MANAGED STANDBY DATABASE clause
of ALTER DATABASE
1
RECOVER TABLESPACE clause
of ALTER DATABASE
1
recovery
discarding data
1
distributed, enabling
1
instance, continue after interruption
1
media, designing
1
media, performing ongoing
1
of database
1
recovery clauses
of ALTER DATABASE
1
recursive subquery factoring
1
recycle bin
purging objects from
1
redo log files
specifying
1
specifying for a control file
1
redo logs
1
adding
1
applying to logical standby database
1
archive location
1
automatic archiving
1
automatic name generation
1
clearing
1
dropping
1
enabling and disabling thread
1
manual archiving
1
all
1
by group number
1
by SCN
1
current
1
next
1
with sequence numbers
1
members
adding to existing groups
1
dropping
1
renaming
1
remove changes from
1
reusing
1
size of
1
specifying
1
,
2
for media recovery
1
specifying archive mode
1
switching groups
1
REF columns
rescoping
1
specifying
1
specifying from table or column
1
REF constraints
defining scope, for materialized views
1
of ALTER TABLE
1
reference-partitioned tables
1
maintenance operations
1
reference partitioning
1
REFERENCES clause
of CREATE TABLE
1
referential integrity constraints
1
REF function
1
REFRESH clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
REFRESH COMPLETE clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
REFRESH FAST clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
REFRESH FORCE clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
REFRESH ON COMMIT clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
REFRESH ON DEMAND clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
REFs
1
,
2
as containers for object identifiers
1
dangling
1
updating
1
validating
1
REFTOHEX function
1
REGEXP_COUNT function
1
REGEXP_INSTR function
1
REGEXP_LIKE condition
1
REGEXP_REPLACE function
1
REGEXP_SUBSTR function
1
REGISTER clause
of ALTER SYSTEM
1
REGISTER LOGFILE clause
of ALTER DATABASE
1
REGR_AVGX function
1
REGR_AVGY function
1
REGR_COUNT function
1
REGR_INTERCEPT function
1
REGR_R2 function
1
REGR_SLOPE function
1
REGR_SXX function
1
REGR_SXY function
1
REGR_SYY function
1
regular expressions
multilingual syntax
1
operators, multilingual enhancements
1
Oracle support of
1
Perl-influenced operators
1
subexpressions
1
,
2
relational tables
creating
1
RELY clause
of constraints
1
REMAINDER function
1
RENAME clause
of ALTER INDEX
1
of ALTER OUTLINE
1
of ALTER TABLE
1
of ALTER TABLESPACE
1
of ALTER TRIGGER
1
RENAME CONSTRAINT clause
of ALTER TABLE
1
RENAME DATAFILE clause
of ALTER TABLESPACE
1
RENAME FILE clause
of ALTER DATABASE
1
RENAME GLOBAL_NAME clause
of ALTER DATABASE
1
of ALTER PLUGGABLE DATABASE
1
RENAME PARTITION clause
of ALTER INDEX
1
of ALTER TABLE
1
RENAME statement
1
RENAME SUBPARTITION clause
of ALTER INDEX
1
of ALTER TABLE
1
REPLACE function
1
replication
row-level dependency tracking
1
,
2
reserved words
1
,
2
RESETLOGS parameter
of CREATE CONTROLFILE
1
reset sequence of
1
RESOLVE clause
of ALTER JAVA CLASS
1
of CREATE JAVA
1
RESOLVER clause
of CREATE JAVA
1
RESOURCE_VIEW
1
,
2
Resource Manager
1
resource parameters
of CREATE PROFILE
1
response time
optimizing
1
restore points
guaranteed
1
preserved
1
using
to flash back a table
1
to flashback the database
1
RESULT_CACHE hint
1
result cache
1
resumable space allocation
1
RESUME clause
of ALTER SYSTEM
1
RETENTION parameter
of LOB storage
1
RETRY_ON_ROW_CHANGE hint
1
RETURNING clause
of DELETE
1
of INSERT
1
of UPDATE
1
REUSE clause
of CREATE CONTROLFILE
1
of file specifications
1
REVERSE clause
of CREATE INDEX
1
reverse indexes
1
REVERSE parameter
of ALTER INDEX ... REBUILD
1
REVOKE CONNECT THROUGH clause
of ALTER USER
1
REVOKE statement
1
locks
1
REWRITE hint
1
right outer joins
1
roles
1
authorization
by an external service
1
by a password
1
by the database
1
by the enterprise directory service
1
changing
1
creating
1
disabling
for the current session
1
enabling
for the current session
1
granting
1
system privileges for
1
to another role
1
to a user
1
to PUBLIC
1
identifying by password
1
identifying externally
1
identifying through enterprise directory service
1
identifying using a package
1
removing from the database
1
revoking
1
from another role
1
,
2
from PUBLIC
1
from users
1
,
2
ROLES clause
of CREATE PLUGGABLE DATABASE
1
rollback segments
removing from the database
1
specifying optimal size of
1
rollback segments granting
system privileges for
1
ROLLBACK statement
1
rollback undo
1
,
2
ROLLUP clause
of SELECT statements
1
ROUND (date) function
1
format models
1
ROUND (number) function
1
routines
calling
1
executing
1
ROW_NUMBER function
1
row constructor
1
ROWDEPENDENCIES clause
of CREATE CLUSTER
1
of CREATE TABLE
1
ROW EXCLUSIVE lock mode
1
ROWID data type
1
,
2
ROWID pseudocolumn
1
,
2
,
3
rowids
1
description of
1
extended
base 64
1
not directly available
1
nonphysical
1
of foreign tables
1
of index-organized tables
1
uses for
1
ROWIDTOCHAR function
1
ROWIDTONCHAR function
1
row-level dependency tracking
1
,
2
row-level locking
1
row limiting
1
row locking
1
ROWNUM pseudocolumn
1
rows
adding to a table
1
allowing movement of between partitions
1
inserting
into partitions
1
into remote databases
1
into subpartitions
1
locking
1
locks on
1
movement between partitions
1
removing
from a cluster
1
,
2
from a table
1
,
2
from partitions and subpartitions
1
from tables and views
1
selecting in hierarchical order
1
specifying constraints on
1
storing if in violation of constraints
1
ROW SHARE lock mode
1
row value constructor
1
row values
pivoting into columns
1
RPAD function
1
RR datetime format element
1
RTRIM function
1
run-time compilation
avoiding
1
,
2
S
SAMPLE clause
of SELECT
1
of SELECT and subqueries
1
savepoints
erasing
1
rolling back to
1
specifying
1
SAVEPOINT statement
1
scalar subqueries
1
scale
greater than precision
1
of NUMBER data type
1
SCHEMA clause
of CREATE JAVA
1
schema objects
1
defining default buffer pool for
1
dropping
1
in other schemas
1
list of
1
name resolution
1
namespaces
1
naming
examples
1
guidelines
1
rules
1
object types
1
on remote databases
1
partitioned indexes
1
partitioned tables
1
parts of
1
protecting location
1
protecting owner
1
providing alternate names for
1
reauthorizing
1
recompiling
1
referring to
1
,
2
remote, accessing
1
validating structure
1
schemas
changing for a session
1
creating
1
definition of
1
scientific notation
1
SCN_TO_TIMESTAMP function
1
SCOPE FOR clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW
1
SCORE operator
1
SDO_GEOMETRY data type
1
SDO_GEORASTER data type
1
SDO_TOPO_GEOMETRY data type
1
security
enforcing
1
security clauses
of ALTER SYSTEM
1
segment attributes clause
of CREATE TABLE
1
SEGMENT MANAGEMENT clause
of CREATE TABLESPACE
1
segments
space management
automatic
1
manual
1
using bitmaps
1
using free lists
1
table
compacting
1
,
2
,
3
,
4
select lists
1
ordering
1
SELECT object privilege
granting on a view
1
SELECT statement
1
,
2
self joins
1
semijoins
1
sequences
1
,
2
accessing values of
1
changing
the increment value
1
creating
1
creating without limit
1
global
1
granting system privileges for
1
guarantee consecutive values
1
how to use
1
incrementing
1
increment value, setting
1
initial value, setting
1
keeping values during transaction replay
1
maximum value
eliminating
1
setting
1
setting or changing
1
minimum value
eliminating
1
setting
1
setting or changing
1
number of cached values, changing
1
ordering values
1
preallocating values
1
recycling values
1
removing from the database
1
renaming
1
restarting
1
at a different number
1
at a predefined limit
1
values
1
reusing
1
session
1
stopping at a predefined limit
1
synonyms for
1
where to use
1
server parameter files
creating
1
from memory
1
server wallet
keys
1
service name
of remote database
1
SESSION_ROLES view
1
session control statements
1
PL/SQL support of
1
session locks
releasing
1
SESSION parameter
of CREATE SEQUENCE
1
session parameters
changing settings
1
INSTANCE
1
sessions
calculating resource cost limits
1
changing resource cost limits
1
disconnecting
1
granting system privileges for
1
limiting CPU time
1
limiting data block reads
1
limiting inactive periods
1
limiting private SGA space
1
limiting resource costs
1
limiting total elapsed time
1
limiting total resources
1
modifying characteristics of
1
restricting
1
restricting to privileged users
1
switching to a different instance
1
terminating
1
terminating across instances
1
time zone setting
1
SESSIONS_PER_USER parameter
of ALTER PROFILE
1
session sequences
1
SESSIONTIMEZONE function
1
SET clause
of ALTER SESSION
1
of ALTER SYSTEM
1
SET conditions
1
SET CONSTRAINT(S) statement
1
SET CONTAINER system privilege
1
SET DANGLING TO NULL clause
of ANALYZE
1
SET DATABASE clause
of CREATE CONTROLFILE
1
SET ENCRYPTION KEY clause
of ALTER SYSTEM
1
SET ENCRYPTION WALLET clause
of ALTER SYSTEM
1
SET function
1
set operators
1
INTERSECT
1
MINUS
1
UNION
1
UNION ALL
1
SET ROLE statement
1
SET STANDBY DATABASE clause
of ALTER DATABASE
1
SET STATEMENT_ID clause
of EXPLAIN PLAN
1
SET TIME_ZONE clause
of ALTER DATABASE
1
of ALTER PLUGGABLE DATABASE
1
of ALTER SESSION
1
of CREATE DATABASE
1
SET TRANSACTION statement
1
SET UNUSED clause
of ALTER TABLE
1
SGA
See:
system global area (SGA)
SHARED clause
of CREATE DATABASE LINK
1
shared pool
flushing
1
shared server
processes
creating additional
1
terminating
1
system parameters
1
SHARE ROW EXCLUSIVE lock mode
1
SHARE UPDATE lock mode
1
short-circuit evaluation
DECODE function
1
SHRINK SPACE clause
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW
1
of ALTER MATERIALIZED VIEW LOG
1
of ALTER TABLE
1
SHUTDOWN clause
of ALTER SYSTEM
1
SI_AverageColor data type
1
SI_Color data type
1
SI_ColorHistogram data type
1
SI_FeatureList data type
1
SI_PositionalColorHistogram data type
1
SI_StillImage data type
1
SI_Texture data type
1
siblings
ordering in a hierarchical query
1
SIGN function
1
simple comparison conditions
1
simple expressions
1
SIN function
1
single row function expression
1
single-row functions
1
SINGLE TABLE clause
of CREATE CLUSTER
1
single-table insert
1
SINH function
1
SIZE clause
of ALTER CLUSTER
1
of CREATE CLUSTER
1
of file specifications
1
SOME operator
1
SOUNDEX function
1
SOURCE_FILE_NAME_CONVERT clause
of CREATE PLUGGABLE DATABASE
1
SP datetime format element suffix
1
special characters
in passwords
1
spelled numbers
specifying
1
SPLIT PARTITION clause
of ALTER INDEX
1
of ALTER TABLE
1
SPTH datetime format element suffix
1
SQL
See:
Structured Query Language (SQL)
SQL/DS data types
1
restrictions on
1
SQL/JSON
conditions
1
SQL*Loader inserts, logging
1
SQL Developer
1
SQL Function
Data Mining
1
FEATURE_COMPARE
1
SQL functions
1
ABS
1
ACOS
1
ADD_MONTHS
1
aggregate functions
1
analytic functions
1
APPENDCHILDXML
1
applied to LOB columns
1
APPROX_COUNT_DISTINCT
1
APPROX_COUNT_DISTINCT_AGG
1
APPROX_COUNT_DISTINCT_DETAIL
1
APPROX_MEDIAN
1
APPROX_PERCENTILE
1
APPROX_PERCENTILE_AGG
1
APPROX_PERCENTILE_DETAIL
1
ASCII
1
ASCIISTR
1
ASIN
1
ATAN
1
ATAN2
1
AVG
1
BFILENAME
1
BIN_TO_NUM
1
BITAND
1
CARDINALITY
1
CAST
1
CEIL
1
character functions
returning character values
1
returning number values
1
character set functions
1
CHARTOROWID
1
CHR
1
CLUSTER_DETAILS
1
CLUSTER_DISTANCE
1
CLUSTER_ID
1
CLUSTER_PROBABILITY
1
CLUSTER_SET
1
COALESCE
1
COLLATION
1
collation functions
1
COLLECT
1
collection functions
1
COMPOSE
1
CON_DBID_TO_ID
1
CON_GUID_TO_ID
1
CON_NAME_TO_ID
1
CON_UID_TO_ID
1
CONCAT
1
conversion functions
1
CONVERT
1
CORR
1
CORR_K
1
CORR_S
1
COS
1
COSH
1
COUNT
1
COVAR_POP
1
COVAR_SAMP
1
CUBE_TABLE
1
CUME_DIST
1
CURRRENT_DATE
1
CURRRENT_TIMESTAMP
1
CV
1
data cartridge functions
1
data mining functions
1
DATAOBJ_TO_MAT_PARTITION
1
DATAOBJ_TO_PARTITION
1
datetime functions
1
DBTIMEZONE
1
DECODE
1
DECOMPOSE
1
DELETEXML
1
DENSE_RANK
1
DEPTH
1
DEREF
1
DUMP
1
EMPTY_BLOB
1
EMPTY_CLOB
1
encoding and decoding functions
1
environment and identifier functions
1
EXISTSNODE
1
EXP
1
EXTRACT (datetime)
1
EXTRACT (XML)
1
EXTRACTVALUE
1
FEATURE_DETAILS
1
FEATURE_ID
1
FEATURE_SET
1
FEATURE_VALUE
1
FIRST
1
FIRST_VALUE
1
FLOOR
1
FROM_TZ
1
general comparison functions
1
GREATEST
1
GROUP_ID
1
GROUPING
1
GROUPING_ID
1
HEXTORAW
1
hierarchical functions
1
INITCAP
1
INSERTCHILDXML
1
INSERTCHILDXMLAFTER
1
INSERTCHILDXMLBEFORE
1
INSERTXMLAFTER
1
INSERTXMLBEFORE
1
INSTR
1
INSTR2
1
INSTR4
1
INSTRB
1
INSTRC
1
ITERATION_NUMBER
1
JSON_ARRAY
1
JSON_ARRAYAGG
1
JSON_DATAGUIDE
1
JSON_OBJECT
1
JSON_OBJECTAGG
1
JSON_QUERY
1
JSON_TABLE
1
JSON_VALUE
1
LAG
1
large object functions
1
LAST
1
LAST_DAY
1
LAST_VALUE
1
LEAD
1
LEAST
1
LENGTH
1
LENGTH2
1
LENGTH4
1
LENGTHB
1
LENGTHC
1
linear regression
1
LISTAGG
1
LN
1
LNNVL
1
LOCALTIMESTAMP
1
LOG
1
LOWER
1
LPAD
1
LTRIM
1
MAKE_REF
1
MAX
1
MEDIAN
1
MIN
1
MOD
1
model functions
1
MONTHS_BETWEEN
1
NANVL
1
NCHR
1
NEW_TIME
1
NEXT_DAY
1
NLS_CHARSET_DECL_LEN
1
NLS_CHARSET_ID
1
NLS_CHARSET_NAME
1
NLS_COLLATION_ID
1
NLS_COLLATION_NAME
1
NLS_INITCAP
1
NLS_LOWER
1
NLS_UPPER
1
NLSSORT
1
NTH_VALUE
1
NTILE
1
NULLIF
1
NULL-related functions
1
numeric functions
1
NUMTODSINTERVAL
1
NUMTOYMINTERVAL
1
NVL
1
NVL2
1
object reference functiions
1
OLAP functions
1
ORA_DM_PARTITION_NAME
1
ORA_DST_AFFECTED
1
ORA_DST_CONVERT
1
ORA_DST_ERROR
1
ORA_HASH
1
ORA_INVOKING_USER
1
ORA_INVOKING_USERID
1
PATH
1
PERCENT_RANK
1
PERCENTILE_CONT
1
PERCENTILE_DISC
1
POWER
1
POWERMULTISET
1
POWERMULTISET_BY_CARDINALITY
1
PREDICTION
1
PREDICTION_BOUNDS
1
PREDICTION_COST
1
PREDICTION_DETAILS
1
PREDICTION_PROBABILITY
1
PREDICTION_SET
1
PRESENTNNV
1
PRESENTV
1
PREVIOUS
1
RANK
1
RATIO_TO_REPORT
1
RAWTOHEX
1
RAWTONHEX
1
REF
1
REFTOHEX
1
REGEXP_COUNT
1
REGEXP_INSTR
1
REGEXP_REPLACE
1
REGEXP_SUBSTR
1
REGR_AVGX
1
REGR_AVGY
1
REGR_COUNT
1
REGR_INTERCEPT
1
REGR_R2
1
REGR_SLOPE
1
REGR_SXX
1
REGR_SXY
1
REGR_SYY
1
REMAINDER
1
REPLACE
1
ROUND (date)
1
ROUND (number)
1
ROW_NUMBER
1
ROWIDTOCHAR
1
ROWIDTONCHAR
1
RPAD
1
RTRIM
1
SCN_TO_TIMESTAMP
1
SESSIONTIMEZONE
1
SET
1
SIGN
1
SIN
1
single-row functions
1
SINH
1
SOUNDEX
1
SQRT
1
STANDARD_HASH
1
STATS_BINOMIAL_TEST
1
STATS_CROSSTAB
1
STATS_F_TEST
1
STATS_KS_TEST
1
STATS_MODE
1
STATS_MW_TEST
1
STATS_ONE_WAY_ANOVA
1
STATS_T_TEST_INDEP
1
,
2
STATS_T_TEST_INDEPU
1
,
2
STATS_T_TEST_ONE
1
,
2
STATS_T_TEST_PAIRED
1
,
2
STATS_WSR_TEST
1
STDDEV
1
STDDEV_POP
1
STDDEV_SAMP
1
SUBSTR
1
SUBSTR2
1
SUBSTR4
1
SUBSTRB
1
SUBSTRC
1
SUM
1
SYS_CONNECT_BY_PATH
1
SYS_CONTEXT
1
SYS_DBURIGEN
1
SYS_EXTRACT_UTC
1
SYS_GUID
1
SYS_OP_ZONE_ID
1
SYS_TYPEID
1
SYS_XMLAGG
1
SYS_XMLGEN
1
SYSDATE
1
SYSTIMESTAMP
1
TAN
1
TANH
1
TIMESTAMP_TO_SCN
1
TO_APPROX_COUNT_DISTINCT
1
TO_APPROX_PERCENTILE
1
TO_BINARY_DOUBLE
1
TO_BINARY_FLOAT
1
TO_BLOB (bfile)
1
TO_BLOB (raw)
1
TO_CHAR (bfile|blob)
1
TO_CHAR (character)
1
TO_CHAR (datetime)
1
TO_CHAR (number)
1
TO_CLOB (bfile|blob)
1
TO_CLOB (character)
1
TO_DATE
1
TO_DSINTERVAL
1
TO_LOB
1
TO_MULTI_BYTE
1
TO_NCHAR (character)
1
TO_NCHAR (datetime)
1
TO_NCHAR (number)
1
TO_NCLOB
1
TO_NUMBER
1
TO_SINGLE_BYTE
1
TO_TIMESTAMP
1
TO_TIMESTAMP_TZ
1
TO_YMINTERVAL
1
TRANSLATE
1
TRANSLATE ... USING
1
TREAT
1
TRIM
1
TRUNC (date)
1
TRUNC (number)
1
t-test
1
TZ_OFFSET
1
UID
1
UNISTR
1
UPDATEXML
1
UPPER
1
USER
1
USERENV
1
VALIDATE_CONVERSION
1
VALUE
1
VAR_POP
1
VAR_SAMP
1
VARIANCE
1
VSIZE
1
WIDTH_BUCKET
1
XMLAGG
1
XMLCAST
1
XMLCDATA
1
XMLCOLATTVAL
1
XMLCOMMENT
1
XMLCONCAT
1
XMLDIFF
1
XMLELEMENT
1
XMLEXISTS
1
XMLFOREST
1
XML functions
1
XMLISVALID
1
XMLPARSE
1
XMLPATCH
1
XMLPI
1
XMLQUERY
1
XMLROOT
1
XMLSEQUENCE
1
XMLSERIALIZE
1
XMLTABLE
1
XMLTRANSFORM
1
SQL statements
ALTER FLASHBACK ARCHIVE
1
auditing
by access
1
by session
1
stopping
1
successful
1
CREATE FLASHBACK ARCHIVE
1
DDL
1
determining the execution plan for
1
DML
1
DROP FLASHBACK ARCHIVE
1
organization of
1
rolling back
1
session control
1
space allocation, resumable
1
storage in the result cache
1
suspending and completing
1
system control
1
tracking the occurrence in a session
1
transaction control
1
type of
1
undoing
1
SQL translation profiles
auditing
1
granting object privileges for
1
granting system privileges for
1
SQRT function
1
staging log
1
standalone procedures
dropping
1
STANDARD_HASH function
1
standard SQL
1
Oracle extensions to
1
standby database
synchronizing with primary database
1
standby databases
activating
1
and Data Guard
1
committing to primary status
1
controlling use
1
converting to physical standby
1
designing media recovery
1
mounting
1
recovering
1
STAR_TRANSFORMATION hint
1
START LOGICAL STANDBY APPLY clause
of ALTER DATABASE
1
startup_clauses
of ALTER DATABASE
1
START WITH clause
of ALTER MATERIALIZED VIEW ... REFRESH
1
of queries and subqueries
1
of SELECT and subqueries
1
START WITH parameter
of CREATE SEQUENCE
1
STATEMENT_QUEUING hint
1
statistics
collection during index rebuild
1
deleting from the data dictionary
1
forcing disassociation
1
gathering for bulk loads
1
,
2
on index usage
1
on scalar object attributes
collecting
1
on schema objects
collecting
1
deleting
1
user-defined
dropping
1
,
2
,
3
,
4
,
5
statistics types
associating
with columns
1
with domain indexes
1
with functions
1
with indextypes
1
with object types
1
with packages
1
disassociating
from columns
1
from domain indexes
1
from functions
1
from indextypes
1
from object types
1
from packages
1
STATS_BINOMIAL_TEST function
1
STATS_CROSSTAB function
1
STATS_F_TEST function
1
STATS_KS_TEST function
1
STATS_MODE function
1
STATS_MW_TEST function
1
STATS_ONE_WAY_ANOVA function
1
STATS_T_TEST_INDEP function
1
,
2
STATS_T_TEST_INDEPU function
1
,
2
STATS_T_TEST_ONE function
1
,
2
STATS_T_TEST_PAIRED function
1
,
2
STATS_WSR_TEST function
1
STDDEV_POP function
1
STDDEV_SAMP function
1
STDDEV function
1
STOP LOGICAL STANDBY clause
of ALTER DATABASE
1
STORAGE clause
of ALTER CLUSTER
1
of ALTER INDEX
1
of ALTER MATERIALIZED VIEW LOG
1
of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE
1
of CREATE TABLE
1
storage parameters
resetting
1
,
2
Storage Snapshot Optimization
1
stored functions
1
STORE IN clause
of ALTER TABLE
1
,
2
string literals
See:
text literals.
strings
See:
text literals.
converting to ASCII values
1
converting to unicode
1
Structured Query Language (SQL)
description
1
functions
1
keywords
1
Oracle Tools support of
1
parameters
1
standards
1
,
2
statements
determining the cost of
1
syntax
1
,
2
structures
locking
1
subexpressions
of regular expressions
1
,
2
SUBMULTISET condition
1
SUBPARTITION BY HASH clause
of CREATE TABLE
1
SUBPARTITION BY LIST clause
of CREATE TABLE
1
SUBPARTITION clause
of ANALYZE
1
of DELETE
1
of INSERT
1
of LOCK TABLE
1
of UPDATE
1
subpartition-extended table names
in DML statements
1
restrictions on
1
syntax
1
subpartitions
adding
1
adding rows to
1
allocating extents for
1
coalescing
1
converting into nonpartitioned tables
1
creating
1
creating a template for
1
,
2
deallocating unused space from
1
exchanging with tables
1
hash
1
inserting rows into
1
list
1
list, adding
1
locking
1
logging insert operations
1
moving to a different segment
1
physical attributes
changing
1
removing rows from
1
,
2
renaming
1
revising values in
1
specifying
1
template, creating
1
template, dropping
1
template, replacing
1
subpartition template
creating
1
replacing
1
subqueries
1
,
2
,
3
containing subqueries
1
correlated
1
defined
1
extended subquery unnesting
1
inline views
1
nested
1
of past data
1
scalar
1
to insert table data
1
unnesting
1
using in place of expressions
1
SUBSTR2 function
1
SUBSTR4 function
1
SUBSTRB function
1
SUBSTRC function
1
SUBSTR function
1
subtotal values
deriving
1
subtypes
dropping safely
1
SUM function
1
supplemental logging
identification key (full)
1
minimal
1
SUSPEND clause
of ALTER SYSTEM
1
sustained standby recovery mode
1
SWITCH LOGFILE clause
of ALTER SYSTEM
1
synchronous refresh
1
SYNC WITH PRIMARY
clause of ALTER SESSION
1
synonyms
changing the definition of
1
creating
1
granting system privileges for
1
local
1
private, dropping
1
public
1
dropping
1
remote
1
removing from the database
1
renaming
1
synonyms for
1
syntax diagrams
1
loops
1
multipart diagrams
1
SYS_CONNECT_BY_PATH function
1
SYS_CONTEXT function
1
SYS_DBURIGEN function
1
SYS_EXTRACT_UTC function
1
SYS_GUID function
1
SYS_NC_ROWINFO$ column
1
,
2
SYS_OP_ZONE_ID function
1
SYS_SESSION_ROLES namespace
1
SYS_TYPEID function
1
SYS_XMLAGG function
1
SYS_XMLGEN function
1
SYSAUX clause
of CREATE DATABASE
1
SYSAUX tablespace
creating
1
SYSDATE function
1
system change numbers
obtaining
1
system control statements
1
PL/SQL support of
1
system global area
flushing
1
updating
1
system parameters
GLOBAL_TOPIC_ENABLED
1
system partitioning
1
system privileges
ADMINISTER ANY SQL TUNING SET
1
ADMINISTER KEY MANAGEMENT
1
ADMINISTER SQL MANAGEMENT OBJECT
1
ADMINISTER SQL TUNING SET
1
ALTER ANY SQL PROFILE
1
ALTER DATABASE LINK
1
ALTER PUBLIC DATABASE LINK
1
BECOME USER
1
CHANGE NOTIFICATION
1
CREATE ANY SQL PROFILE
1
CREATE PLUGGABLE DATABASE
1
DROP ANY SQL PROFILE
1
for job scheduler tasks
1
for the Advisor framework
1
granting
1
,
2
to a role
1
to a user
1
to PUBLIC
1
list of
1
,
2
MERGE ANY VIEW
1
READ ANY TABLE
1
revoking
1
from a role
1
from a user
1
from PUBLIC
1
SET CONTAINER
1
SYSTEM tablespace
locally managed
1
SYSTEM user
assigning password for
1
SYSTIMESTAMP function
1
SYS user
assigning password for
1
T
TABLE clause
of ANALYZE
1
of INSERT
1
of SELECT
1
of TRUNCATE
1
of UPDATE
1
TABLE collection expression
1
table compression
1
,
2
,
3
,
4
Advanced Row Compression
1
basic
1
during bulk load operations
1
for archiving data
1
Hybrid Columnar
1
table locks
and queries
1
disabling
1
duration of
1
enabling
1
EXCLUSIVE
1
modes of
1
on partitions
1
on remote database
1
on subpartitions
1
ROW EXCLUSIVE
1
ROW SHARE
1
SHARE
1
SHARE ROW EXCLUSIVE
1
SHARE UPDATE
1
table partitions
compression of
1
,
2
table REF constraints
1
of CREATE TABLE
1
tables
adding a constraint to
1
adding rows to
1
aliases
1
in DELETE
1
allocating extents for
1
assigning to a cluster
1
changing degree of parallelism on
1
changing existing values in
1
collecting statistics on
1
comments on
1
compression of
1
,
2
creating
1
multiple
1
creating comments about
1
data stored outside database
1
deallocating unused space from
1
default physical attributes
changing
1
degree of parallelism
specifying
1
disassociating statistics types from
1
dropping
along with cluster
1
along with owner
1
indexes of
1
partitions of
1
enabling tracking
1
external
1
creating
1
restrictions on
1
externally organized
1
flashing back to an earlier version
1
granting system privileges for
1
heap organized
1
index-organized
1
overflow segment for
1
space in index block
1
inserting rows with a subquery
1
inserting using the direct-path method
1
joining in a query
1
LOB storage of
1
locking
1
logging
insert operations
1
table creation
1
migrated and chained rows in
1
moving
1
moving, index-organized
1
moving to a new segment
1
nested
storage characteristics
1
object
creating
1
querying
1
of XMLType, creating
1
organization, defining
1
parallel creation of
1
parallelism
setting default degree
1
partition attributes of
1
partitioning
1
,
2
allowing rows to move between partitions
1
default attributes of
1
physical attributes
changing
1
purging from the recycle bin
1
read/write mode
1
read-only mode
1
reference-partitioned
1
,
3
relational
creating
1
remote, accessing
1
removing from the database
1
removing rows from
1
renaming
1
,
2
restricting
records in a block
1
retrieving data from
1
saving blocks in a cache
1
SQL examples
1
storage attributes
defining
1
storage characteristics
defining
1
storage properties of
1
subpartition attributes of
1
synonyms for
1
tablespace for
defining
1
temporary
duration of data
1
session-specific
1
transaction specific
1
unclustering
1
updating through views
1
validating structure
1
XMLType, querying
1
TABLESPACE clause
of ALTER INDEX ... REBUILD
1
of CREATE CLUSTER
1
of CREATE INDEX
1
of CREATE MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW LOG
1
of CREATE TABLE
1
tablespaces
allocating space for users
1
allowing write operations on
1
automatic segment-space management
1
backing up data files
1
bigfile
1
database default
1
default temporary
1
resizing
1
undo
1
bringing online
1
,
2
coalescing free extents
1
converting
from permanent to temporary
1
from temporary to permanent
1
creating
1
data files
adding
1
renaming
1
default
1
specifying for a user
1
default permanent
1
default temporary
1
learning name of
1
designing media recovery
1
dropping contents
1
encrypting
1
ending online backup
1
extent size
1
granting system privileges for
1
in FLASHBACK mode
1
,
2
in FORCE LOGGING mode
1
,
2
locally managed
1
altering
1
logging attribute
1
,
2
managing extents of
1
read only
1
reconstructing lost or damaged
1
recovering
1
removing from the database
1
renaming
1
size of free extents in
1
smallfile
1
database default
1
default temporary
1
undo
1
specifying
data files for
1
for a table
1
for a user
1
for index rebuild
1
taking offline
1
,
2
temp files
adding
1
temporary
creating
1
defining for the database
1
shrinking
1
specifying for a user
1
,
2
undo
altering
1
creating
1
,
2
dropping
1
TAN function
1
TANH function
1
TDE
See:
Transparent Data Encryption
TEMPFILE clause
of ALTER DATABASE
1
temp files
bringing online
1
defining for a tablespace
1
defining for the database
1
disabling autoextend
1
dropping
1
,
2
enabling autoextend
1
,
2
extending automatically
1
renaming
1
resizing
1
reusing
1
shrinking
1
size of
1
specifying
1
taking offline
1
TEMPORARY clause
of ALTER TABLESPACE
1
of CREATE TABLESPACE
1
temporary tables
creating
1
session-specific
1
transaction-specific
1
TEMPORARY TABLESPACE clause
of ALTER USER
1
of ALTER USER. See CREATE USER
1
of CREATE USER
1
temporary tablespace groups
reassigning for a user
1
specifying for a user
1
temporary tablespaces
creating
1
default
1
specifying extent management during database creation
1
specifying for a user
1
,
2
TEST clause
of ALTER DATABASE ... RECOVER
1
testing for a set
1
text
date and number formats
1
literals
in SQL syntax
1
properties of CHAR and VARCHAR2 data types
1
syntax of
1
text literals
conversion to database character set
1
TH datetime format element suffix
1
throughput
optimizing
1
THSP datetime format element suffix
1
TIME_ZONE session parameter
1
TIME data type
DB2
1
SQL/DS
1
time format models
short
1
,
2
timestamp
converting to local time zone
1
TIMESTAMP_TO_SCN function
1
TIMESTAMP data type
1
DB2
1
SQL/DS
1
TIMESTAMP WITH LOCAL TIME ZONE data type
1
TIMESTAMP WITH TIME ZONE data type
1
time zone
changing time zone data file
1
converting data to particular
1
determining for session
1
formatting
1
setting for the database
1
TO_APPROX_COUNT_DISTINCT function
1
TO_APPROX_PERCENTILE function
1
TO_BINARY_DOUBLE function
1
TO_BINARY_FLOAT function
1
TO_BLOB (bfile) function
1
TO_BLOB (raw) function
1
TO_CHAR (bfile|blob) function
1
TO_CHAR (character) function
1
TO_CHAR (datetime) function
1
format models
1
,
2
TO_CHAR (number) function
1
format models
1
,
2
TO_CLOB (bfile|blob) function
1
TO_CLOB (character) function
1
TO_DATE function
1
format models
1
,
2
,
3
TO_DSINTERVAL function
1
TO_LOB function
1
TO_MULTI_BYTE function
1
TO_NCHAR (character) function
1
TO_NCHAR (datetime) function
1
TO_NCHAR (number) function
1
TO_NCLOB function
1
TO_NUMBER function
1
format models
1
TO_SINGLE_BYTE function
1
TO_TIMESTAMP_TZ function
1
TO_TIMESTAMP function
1
TO_YMINTERVAL function
1
top-level SQL statements
1
top-N reporting
1
,
2
,
3
,
4
,
5
TO SAVEPOINT clause
of ROLLBACK
1
tracking
enabling for a table
1
,
2
transaction control statements
1
PL/SQL support of
1
transactions
allowing to complete
1
assigning
rollback segment to
1
automatically committing
1
changes, making permanent
1
commenting on
1
distributed, forcing
1
ending
1
implicit commit of
1
,
2
,
3
,
4
in-doubt
committing
1
forcing
1
resolving
1
isolation level
1
locks, releasing
1
naming
1
read/write
1
read-only
1
rolling back
1
,
2
to a savepoint
1
savepoints for
1
TRANSLATE ... USING function
1
TRANSLATE function
1
TRANSLATE SQL object privilege
on a user
1
Transparent Data Encryption
1
key management
1
master key
1
TREAT function
1
triggers
compiling
1
creating
1
database
altering
1
dropping
1
,
2
disabling
1
,
2
enabling
1
,
2
,
4
granting system privileges for
1
INSTEAD OF
dropping
1
re-creating
1
removing from the database
1
renaming
1
TRIM function
1
TRUNC (date) function
1
format models
1
TRUNC (number) function
1
TRUNCATE_CLUSTER statement
1
TRUNCATE_TABLE statement
1
TRUNCATE PARTITION clause
of ALTER TABLE
1
TRUNCATE SUBPARTITION clause
of ALTER TABLE
1
type constructor expressions
1
types
See:
object types or data types
TYPES clause
of ASSOCIATE STATISTICS
1
of DISASSOCIATE STATISTICS
1
TZ_OFFSET function
1
U
UID function
1
unary operators
1
UNDER_PATH condition
1
UNDER object privilege
on a view
1
undo
rollback
1
,
2
system managed
1
,
2
UNDO_RETENTION initialization parameter
setting with ALTER SYSTEM
1
UNDO tablespace clause
of CREATE DATABASE
1
of CREATE TABLESPACE
1
undo tablespaces
creating
1
,
2
dropping
1
modifying
1
preserving unexpired data
1
,
2
unified auditing
ALTER AUDIT POLICY statement
1
AUDIT statement
1
CREATE AUDIT POLICY statement
1
DROP AUDIT POLICY statement
1
NOAUDIT statement
1
unified audit policies
comments on
1
creating
1
dropping
1
modifying
1
UNIFORM clause
of CREATE TABLESPACE
1
UNION ALL set operator
1
UNION set operator
1
UNIQUE clause
of CREATE INDEX
1
of CREATE TABLE
1
of SELECT
1
unique constraints
conditional
1
enabling
1
index on
1
unique elements of
1
unique indexes
1
unique queries
1
UNISTR function
1
universal rowids
See:
urowids
UNNEST hint
1
unnesting collections
1
examples
1
unnesting subqueries
1
unpivot operations
1
examples
1
syntax
1
UNQUIESCE clause
of ALTER SYSTEM
1
UNRECOVERABLE
1
,
3
See also:
NOLOGGING clause
unsorted indexes
1
UNUSABLE clause
of ALTER INDEX
1
UNUSABLE LOCAL INDEXES clause
of ALTER MATERIALIZED VIEW
1
of ALTER TABLE
1
UPDATE BLOCK REFERENCES clause
of ALTER INDEX
1
UPDATE GLOBAL INDEXES clause
of ALTER TABLE
1
update operations
collecting supplemental log data for
1
updates
and simultaneous insert
1
using MERGE
1
UPDATE SET clause
of MERGE
1
UPDATE statement
1
UPDATEXML function
1
UPGRADE clause
of ALTER DATABASE
1
of ALTER TABLE
1
UPPER function
1
URLs
generating
1
UROWID data type
1
urowids
and foreign tables
1
and index-organized tables
1
description of
1
USABLE clause
of ALTER INDEX
1
USE_BAND hint
1
USE_CONCAT hint
1
USE_CUBE hint
1
USE_HASH hint
1
USE_MERGE hint
1
USE_NL_WITH_INDEX hint
1
USE_NL hint
1
USE_PRIVATE_OUTLINES session parameter
1
USE_STORED_OUTLINES session parameter
1
,
2
USE object privilege
on a SQL translation profile
1
USER_COL_COMMENTS data dictionary view
1
USER_INDEXTYPE_COMMENTS data dictionary view
1
USER_MVIEW_COMMENTS data dictionary view
1
USER_OPERATOR_COMMENTS data dictionary view
1
USER_TAB_COMMENTS data dictionary view
1
user-defined functions
1
name precedence of
1
naming conventions
1
user-defined operators
1
user-defined statistics
dropping
1
,
2
,
3
,
4
,
5
user-defined types
1
USERENV function
1
USERENV namespace
1
USER function
1
user groups
adding or dropping a member
1
adding to a disk group
1
dropping from a disk group
1
users
allocating space for
1
and database links
1
assigning
default roles
1
profiles
1
authenticating
1
authenticating to a remote server
1
changing authentication
1
creating
1
default tablespaces for
1
,
2
denying access to tables and views
1
external
1
,
2
global
1
,
2
granting system privileges for
1
local
1
,
2
locking accounts
1
operating system
adding to a disk group
1
dropping from a disk group
1
password expiration of
1
removing from the database
1
SQL examples
1
temporary tablespaces for
1
,
2
USER SYS clause
of CREATE DATABASE
1
USER SYSTEM clause
of CREATE DATABASE
1
USING BFILE clause
of CREATE JAVA
1
USING BLOB clause
of CREATE JAVA
1
USING clause
of ALTER INDEXTYPE
1
of ASSOCIATE STATISTICS
1
of CREATE DATABASE LINK
1
of CREATE INDEXTYPE
1
of CREATE PLUGGABLE DATABASE
1
USING CLOB clause
of CREATE JAVA
1
USING INDEX clause
of ALTER MATERIALIZED VIEW
1
of ALTER TABLE
1
of constraints
1
of CREATE MATERIALIZED VIEW
1
of CREATE TABLE
1
USING NO INDEX clause
of CREATE MATERIALIZED VIEW
1
USING ROLLBACK SEGMENT clause
of ALTER MATERIALIZED VIEW ... REFRESH
1
of CREATE MATERIALIZED VIEW
1
UTC
extracting from a datetime value
1
UTC offset
replacing with time zone region name
1
UTLCHN.SQL script
1
UTLEXPT1.SQL script
1
UTLXPLAN.SQL script
1
V
VALIDATE_CONVERSION function
1
VALIDATE clause
of DROP TYPE
1
VALIDATE REF UPDATE clause
of ANALYZE
1
VALIDATE STRUCTURE clause
of ANALYZE
1
validation
of clusters
1
of database objects
offline
1
of database objects, online
1
of indexes
1
of tables
1
VALUE function
1
VALUES clause
of CREATE INDEX
1
of INSERT
1
VALUES LESS THAN clause
of CREATE TABLE
1
VAR_POP function
1
VAR_SAMP function
1
VARCHAR2 data type
1
converting to NUMBER
1
VARCHAR data type
1
VARGRAPHIC data type
DB2
1
SQL/DS
1
VARIANCE function
1
VARRAY clause
of ALTER TABLE
1
VARRAY column properties
of ALTER TABLE
1
of CREATE MATERIALIZED VIEW
1
of CREATE TABLE
1
varrays
1
changing returned value
1
compared with nested tables
1
comparison rules
1
creating
1
dropping the body of
1
dropping the specification of
1
modifying column properties
1
storage characteristics
1
,
3
storing out of line
1
varying arrays
See:
varrays
version queries
pseudocolumns for
1
view constraints
1
,
2
and materialized views
1
dropping
1
modifying
1
views
base tables
adding rows
1
changing
definition
1
values in base tables
1
creating
before base tables
1
comments about
1
multiple
1
definer’s rights
1
defining
1
dropping constraints on
1
editioning
1
granting system privileges for
1
invoker’s rights
1
modifying constraints on
1
object, creating
1
recompiling
1
re-creating
1
remote, accessing
1
removing
from the database
1
rows from the base table of
1
renaming
1
retrieving data from
1
subquery of
1
restricting
1
synonyms for
1
updatable
1
with joins
and key-preserved tables
1
making updatable
1
XMLType
1
XMLType, creating
1
XMLType, querying
1
virtual columns
adding to a table
1
creating
1
modifying
1
VSIZE function
1
W
WHENEVER SUCCESSFUL clause
of AUDIT sql_statements
1
WHERE clause
of DELETE
1
of queries and subqueries
1
of SELECT
1
of UPDATE
1
WIDTH_BUCKET function
1
WITH ... AS clause
of SELECT
1
WITH ADMIN OPTION clause
of GRANT
1
WITH CHECK OPTION clause
of CREATE VIEW
1
of DELETE
1
of INSERT
1
of SELECT
1
of UPDATE
1
WITH clause
of SELECT
1
WITH GRANT OPTION clause
of GRANT
1
WITH HIERARCHY OPTION
of GRANT
1
WITH INDEX CONTEXT clause
of CREATE OPERATOR
1
WITH OBJECT ID clause
of CREATE MATERIALIZED VIEW LOG
1
WITH PRIMARY KEY clause
of ALTER MATERIALIZED VIEW
1
of CREATE MATERIALIZED VIEW ... REFRESH
1
of CREATE MATERIALIZED VIEW LOG
1
WITH READ ONLY clause
of CREATE VIEW
1
of DELETE
1
of INSERT
1
of SELECT
1
of UPDATE
1
WITH ROWID clause
of column ref constraints
1
of CREATE MATERIALIZED VIEW ... REFRESH
1
of CREATE MATERIALIZED VIEW LOG
1
WITH SEQUENCE clause
of CREATE MATERIALIZED VIEW LOG
1
WRITE clause
of COMMIT
1
X
XML
conditions
1
data
storage of
1
database repository
SQL access to
1
,
2
documents
producing from XML fragments
1
retrieving from the database
1
examples
1
format models
1
fragments
1
functions
1
XMLAGG function
1
XMLCAST function
1
XMLCDATA function
1
XMLCOLATTVAL function
1
XMLCOMMENT function
1
XMLCONCAT function
1
XMLDATA pseudocolumn
1
XMLDIFF function
1
XMLELEMENT function
1
XMLEXISTS function
1
XMLFOREST function
1
XMLGenFormatType object
1
XMLIndex
creating
1
modifying
1
XMLISVALID function
1
XMLPARSE function
1
XMLPATCH function
1
XMLPI function
1
XMLQUERY function
1
XMLROOT function
1
XMLSchemas
adding to a table
1
single and multiple
1
XMLSEQUENCE function
1
XMLSERIALIZE function
1
XMLTABLE function
1
XMLTRANSFORM function
1
XMLType columns
properties of
1
,
2
storage of
1
storing in binary XML format
1
XMLType storage clause
of CREATE TABLE
1
XMLType tables
creating
1
creating index on
1
XMLType views
1
querying
1
Z
zone maps
creating
1
modifying
1
removing from the database
1
Scripting on this page enhances content navigation, but does not change the content in any way.