Index

Symbols Numerics 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 MEASURES keywords 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 views
- adding measures in a query of 1
- altering 1
- creating 1
- dropping 1
- filtering facts in a query of 1
- granting system privileges for 1
- inline 1
- measure expressions 1
- retrieving data from 1
- transitory 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
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 expressions 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, 2
- 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
- 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
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 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
- 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
FETCH
- row_limiting_clause 1
files
- specifying as a redo log file group 1
- specifying as data files 1
- specifying as temp files 1
FILTER FACT keywords 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
- retrieving data from 1
HIERARCHY clause
- of CREATE DIMENSION 1
hierarchy expressions
- analytic view 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 analytic views 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
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
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
measure expressions
- analytic view 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
OFFSET
- row_limiting_clause 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
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
ordinal numbers
- specifying 1
- spelling out 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
siblings
- ordering in a hierarchical query 1
SIGN function 1
simple comparison conditions 1
simple expressions 1
SIN function 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
- 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
- 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
- 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
- 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
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