1. Index

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 8.4

Numerics

A

  • ABORT LOGICAL STANDBY clause
    • of ALTER DATABASE 10.8
  • ABS function 7.9
  • ACCESSED GLOBALLY clause
    • of CREATE CONTEXT 13.6
  • ACCOUNT LOCK clause
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10
  • ACCOUNT UNLOCK clause
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10
  • ACOS function 7.10
  • ACTIVATE STANDBY DATABASE clause
    • of ALTER DATABASE 10.8
  • AD and A.D. datetime format elements 2.4.2.2
  • ADD_MONTHS function 7.11
  • ADD clause
    • of ALTER DIMENSION 10.11
    • of ALTER INDEXTYPE 10.17
    • of ALTER TABLE 12.3
    • of ALTER VIEW 12.9
  • ADD DATAFILE clause
    • of ALTER TABLESPACE 12.4
  • adding a constraint to a table 12.3
  • ADD LOGFILE clause
    • of ALTER DATABASE 10.8
  • ADD LOGFILE GROUP clause
    • of ALTER DATABASE 10.8
  • ADD LOGFILE INSTANCE clause
    • of ALTER DATABASE 10.8
  • ADD LOGFILE MEMBER clause
    • of ALTER DATABASE 10.8
  • ADD LOGFILE THREAD clause
    • of ALTER DATABASE 10.8
  • ADD MEASURES keywords 19.9
  • ADD OVERFLOW clause
    • of ALTER TABLE 12.3
  • ADD PARTITION clause
    • of ALTER TABLE 12.3
  • ADD PRIMARY KEY clause
    • of ALTER MATERIALIZED VIEW LOG 11.4
  • ADD ROWID clause
    • of ALTER MATERIALIZED VIEW 11.4
  • ADD SUPPLEMENTAL LOG DATA clause
    • of ALTER DATABASE 10.8
  • ADD SUPPLEMENTAL LOG GROUP clause
    • of ALTER TABLE 12.3
  • ADD TEMPFILE clause
    • of ALTER TABLESPACE 12.4
  • ADD VALUES clause
    • of ALTER TABLE ... MODIFY PARTITION 12.3
  • ADMINISTER ANY SQL TUNING SET system privilege 18.12
  • ADMINISTER KEY MANAGEMENT statement 10.3
  • ADMINISTER KEY MANAGEMENT system privilege 18.12
  • ADMINISTER SQL MANAGEMENT OBJECT system privilege 18.12
  • ADMINISTER SQL TUNING SET system privilege 18.12
  • ADMIN USER clause
    • of CREATE PLUGGABLE DATABASE 14.11
  • advanced index compression
  • Advanced Row Compression 15.4
  • ADVISE clause
  • aggregate functions 7.3
  • alias
    • for a column 9.2
    • for an expressions in a view query 15.11
    • specifying in queries and subqueries 19.9
  • ALL_COL_COMMENTS data dictionary view 12.15
  • ALL_INDEXTYPE_COMMENTS data dictionary view 12.15
  • ALL_MVIEW_COMMENTS data dictionary view 12.15
  • ALL_OPERATOR_COMMENTS data dictionary view 12.15
  • ALL_ROWS hint 2.6.4.1
  • ALL_TAB_COMMENTS data dictionary view 12.15
  • ALL clause
  • all-column wildcard 19.9
  • ALLOCATE EXTENT clause
    • of ALTER CLUSTER 10.7
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER TABLE 12.3
  • ALL operator 6.2
  • ALLOW CORRUPTION clause
    • of ALTER DATABASE ... RECOVER 10.8
  • ALL PRIVILEGES clause
  • ALL PRIVILEGES shortcut
  • ALL shortcut
  • alter_external_table clause
    • of ALTER TABLE 12.3
  • ALTER ANALYTIC VIEW statement 10.4
  • ALTER ANY SQL PROFILE system privilege 18.12
  • ALTER ATTRIBUTE DIMENSION statement 10.5
  • ALTER AUDIT POLICY statement 10.6
  • ALTER CLUSTER statement 10.7
  • ALTER DATABASE LINK system privilege 18.12
  • ALTER DATABASE statement 10.8
  • ALTER DIMENSION statement 10.11
  • ALTER DISKGROUP statement 10.12
  • ALTER FLASHBACK ARCHIVE statement 10.13
  • ALTER FUNCTION statement 10.14
  • ALTER HIERARCHY statement 10.15
  • ALTER INDEX statement 10.16
  • ALTER INDEXTYPE statement 10.17
  • altering storage
  • ALTER INMEMORY JOIN GROUP statement 10.18
  • ALTER JAVA CLASS statement 10.19
  • ALTER JAVA SOURCE statement 10.19
  • ALTER LIBRARY statement 11.1
  • ALTER LOCKDOWN PROFILE statement 11.2
  • ALTER MATERIALIZED VIEW LOG statement 11.4
  • ALTER MATERIALIZED VIEW statement 11.3
  • ALTER MATERIALIZED ZONEMAP statement 11.5
  • ALTER object privilege
    • on a SQL translation profile 18.12
  • ALTER OPERATOR statement 11.6
  • ALTER OUTLINE statement 11.7
  • ALTER PACKAGE statement 11.8
  • ALTER PLUGGABLE DATABASE statement 11.9
  • ALTER PROCEDURE statement 11.10
  • ALTER PROFILE statement 11.11
  • ALTER PUBLIC DATABASE LINK system privilege 18.12
  • ALTER RESOURCE COST statement 11.12
  • ALTER ROLE statement 11.13
  • ALTER ROLLBACK SEGMENT statement 11.14
  • ALTER SEQUENCE statement 11.15
  • ALTER SESSION statement 11.16
  • ALTER SNAPSHOT
    • See: ALTER MATERIALIZED VIEW
  • ALTER SNAPSHOT LOG
    • See: ALTER MATERIALIZED VIEW LOG
  • ALTER SYSTEM statement 12.2
  • ALTER TABLESPACE SET statement 12.5
  • ALTER TABLESPACE statement 12.4
  • ALTER TABLE statement 12.3
  • ALTER TRIGGER statement 12.6
  • ALTER TYPE statement 12.7
  • ALTER USER statement 12.8
  • ALTER VIEW statement 12.9
  • AM and A.M. datetime format elements 2.4.2.2
  • American National Standards Institute (ANSI)
    • data types 2.1.3
      • conversion to Oracle data types 2.1.3
    • standards 1.2, C.1
    • supported data types 2.1
  • analytic functions 7.4
  • analytic views
    • adding measures in a query of 19.9
    • altering 10.4
    • creating 13.2
    • dropping 15.14
    • filtering facts in a query of 19.9
    • granting system privileges for 18.12
    • inline 19.9
    • measure expressions 5.3
    • retrieving data from 19.9
    • transitory 19.9
  • ANALYZE CLUSTER statement 12.10
  • ANALYZE INDEX statement 12.10
  • ANALYZE TABLE statement 12.10
  • ANCILLARY TO clause
    • of CREATE OPERATOR 14.6
  • AND condition 6.4
  • AND DATAFILES clause
    • of DROP TABLESPACE 18.2
  • ANSI
    • See: American National Standards Institute (ANSI)
  • antijoins 9.6.8
  • ANY_VALUE function 7.12
  • ANY operator 6.2
  • APPEND_VALUES hint 2.6.4.3
  • APPEND hint 2.6.4.2
  • applications
    • allowing connection as user 12.8
    • securing 13.6
    • validating 13.6
  • application servers
    • allowing connection as user 12.8
  • APPROX_COUNT_DISTINCT_AGG function 7.15
  • APPROX_COUNT_DISTINCT_DETAIL function 7.16
  • APPROX_COUNT_DISTINCT function 7.14
  • APPROX_MEDIAN function 7.17
  • APPROX_PERCENTILE_AGG function 7.19
  • APPROX_PERCENTILE_DETAIL function 7.20
  • APPROX_PERCENTILE function 7.18
  • archived redo logs
  • ARCHIVELOG clause
    • of ALTER DATABASE 10.8
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
  • ARCHIVE LOG clause
    • of ALTER SYSTEM 12.2
  • archive mode
  • arguments
    • of operators 4
  • arithmetic
  • arithmetic operators 4.2
  • ASC clause
  • ASCII function 7.23
  • ASCIISTR function 7.24
  • AS CLONE clause
    • of CREATE PLUGGABLE DATABASE 14.11
  • ASIN function 7.25
  • ASSOCIATE STATISTICS statement 12.11
  • AS source_char clause
  • AS subquery clause
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE TABLE 15.4
    • of CREATE VIEW 15.11
  • asterisk
    • all-column wildcard in queries 19.9
  • asynchronous commit 13.1
  • ATAN2 function 7.27
  • ATAN function 7.26
  • ATTRIBUTE clause
    • of ALTER DIMENSION 10.11
    • of CREATE DIMENSION 13.10
  • attribute clustering 15.4
  • attribute dimensions
  • attributes
    • adding to a dimension 10.11
    • dropping from a dimension 10.11
    • maximum number of in object type 15.4
    • of dimensions, defining 13.10
    • of disk groups 10.12, 13.12
  • auditing
  • audit policies
  • AUDIT statement 12.12
  • AUTHENTICATED BY clause
    • of CREATE DATABASE LINK 13.9
  • AUTHENTICATED clause
    • of ALTER USER 12.8
  • AUTHENTICATION REQUIRED clause
    • of ALTER USER 12.8
  • AUTHID CURRENT_USER clause
  • AUTHID DEFINER clause
  • AUTOALLOCATE clause
    • of CREATE TABLESPACE 15.5
  • AUTOEXTEND clause
    • of ALTER DATABASE 10.8
    • of CREATE DATABASE 13.8
  • automatic segment-space management 15.5
  • automatic undo mode 11.14, 13.8
  • AVG function 7.28

B

  • BACKUP CONTROLFILE clause
    • of ALTER DATABASE 10.8
  • backups 10.8
  • band joins 9.6.3
  • basic table compression 15.4
  • BC and B.C. datetime format elements 2.4.2.2
  • BECOME USER system privilege 18.12
  • BEGIN BACKUP clause
    • of ALTER DATABASE 10.8
    • of ALTER TABLESPACE 12.4
  • BEQUEATH clause
  • BETWEEN condition 6.12
  • BFILE
  • BFILENAME function 7.29
  • BIN_TO_NUM function 7.30
  • binary large objects
    • See: BLOB
  • binary operators 4.1.1
  • binary XML format 15.4
  • binary XML storage 15.4
  • bindings
    • adding to an operator 11.6
    • dropping from an operator 11.6
  • BITAND function 7.31
  • BITMAP clause
  • bitmap indexes 13.17
    • creating join indexes 13.17
  • bit vectors
    • converting to numbers 7.30
  • blank padding
    • specifying in format models 2.4.3
    • suppressing 2.4.3
  • BLOB data type 2.1.1.6.2
  • BLOCKSIZE clause
    • of CREATE TABLESPACE 15.5
  • bottom-N reporting 7.76, 7.178, 7.194
  • BUFFER_POOL parameter
    • of STORAGE clause 8.9
  • buffer cache
  • BUILD DEFERRED clause
    • of CREATE MATERIALIZED VIEW 14.3
  • BUILD IMMEDIATE clause
    • of CREATE MATERIALIZED VIEW 14.3
  • BY ACCESS clause
  • BY SESSION clause
  • BYTE character semantics 2.1.1.1.1, 2.1.1.1.5
  • BYTE length semantics 12.3

C

  • CACHE clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 15.4
    • of CREATE CLUSTER 13.5
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • cached cursors
    • execution plan for 18.9
  • CACHE hint 2.6.4.4
  • CACHE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • CACHE READS clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • calculated measure expressions 5.3, 5.3.1
  • calls
    • limiting CPU time for 14.13
    • limiting data blocks read 14.13
  • call spec
    • See: call specifications
  • call specifications
  • CALL statement 12.14
  • CARDINALITY function 7.37
  • Cartesian products 9.6.5
  • CASCADE clause
  • CASCADE CONSTRAINTS clause
  • CASE expressions 5.5
  • CAST function 7.38
  • CATSEARCH condition 6.1
  • CATSEARCH operator 4.1
  • CDBs
  • CEIL function 7.39
  • chained rows
  • CHANGE_DUPKEY_ERROR_INDEX hint 2.6.4.5
  • CHANGE CATEGORY clause
    • of ALTER OUTLINE 11.7
  • CHANGE NOTIFICATION system privilege 18.12
  • changing state
  • character functions
    • returning character values 7.2.2
    • returning number values 7.2.3
  • character large objects
    • See: CLOB
  • character length semantics 12.3
  • character literal
    • See: text
  • character set
  • character set functions 7.2.4
  • CHARACTER SET parameter
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
  • character sets
    • database, specifying 13.8
    • multibyte characters 2.8.1
    • specifying for database 13.8
  • character strings
  • CHAR character semantics 2.1.1.1.1, 2.1.1.1.5
  • CHAR data type 2.1.1.1.1
    • converting to VARCHAR2 2.4.1
  • CHAR length semantics 12.3
  • CHARTOROWID function 7.40
  • CHECK clause
    • of constraints 8.2
    • of CREATE TABLE 15.4
  • check constraints 8.2
  • CHECK DATAFILES clause
    • of ALTER SYSTEM 12.2
  • CHECKPOINT clause
    • of ALTER SYSTEM 12.2
  • checkpoints
  • CHR function 7.41
  • CHUNK clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • CLEAR LOGFILE clause
    • of ALTER DATABASE 10.8
  • CLOB data type 2.1.1.6.3
  • clone databases
  • CLOSE DATABASE LINK clause
  • CLUSTER_DETAILS function 7.42
  • CLUSTER_DISTANCE function 7.43
  • CLUSTER_ID function 7.44
  • CLUSTER_PROBABILITY function 7.45
  • CLUSTER_SET function 7.46
  • CLUSTER clause
  • CLUSTER hint 2.6.4.6
  • CLUSTERING hint 2.6.4.7
  • clusters
    • assigning tables to 15.4
    • caching retrieved blocks 13.5
    • cluster indexes 13.17
    • collecting statistics on 12.10
    • creating 13.5
    • deallocating unused extents 10.7
    • degree of parallelism
    • dropping tables 15.17
    • extents, allocating 10.7
    • granting system privileges for 18.12
    • hash 13.5
    • indexed 13.5
    • key values
      • allocating space for 13.5
      • modifying space for 10.7
    • migrated and chained rows in 12.10
    • modifying 10.7
    • physical attributes
    • releasing unused space 10.7
    • removing from the database 15.17
    • SQL examples 15.17
    • storage attributes
    • storage characteristics
    • tablespace in which created 13.5
    • validating structure 12.10
  • COALESCE clause
    • for partitions 12.3
    • of ALTER INDEX 10.16
    • of ALTER TABLE 12.3
    • of ALTER TABLESPACE 12.4
  • COALESCE function 7.47
    • as a variety of CASE expression 7.47
  • COALESCE SUBPARTITION clause
    • of ALTER TABLE 12.3
  • COLLATE operator 4.3
  • COLLATION function 7.48
  • collation functions 7.2.5
  • COLLECT function 7.49
  • collection functions 7.2.10
  • collections
  • collection-typed values
    • converting to data types 7.38
  • collection types
  • COLUMN_VALUE pseudocolumn 3.4
  • column expressions 5.6
  • column REF constraints 8.2
    • of CREATE TABLE 15.4
  • columns
    • adding 12.3
    • aliases for 9.2
    • altering storage 12.3
    • associating statistics types with 12.11
    • basing an index on 13.17
    • comments on 12.15
    • creating comments about 12.15
    • defining 15.4
    • disassociating statistics types from 15.13
    • dropping from a table 12.3
    • LOB
      • storage attributes 12.3
    • maximum number of 15.4
    • modifying existing 12.3
    • parent-child relationships between 13.10
    • properties, altering 12.3
    • qualifying names of 9.2
    • REF
      • describing 8.2
    • renaming 12.3
    • restricting values for 8.2
    • specifying
      • as primary key 8.2
      • constraints on 15.4
      • default values 15.4
    • storage properties 15.4
    • substitutable, identifying type 7.228
    • virtual
  • COLUMNS clause
    • of ASSOCIATE STATISTICS 12.11
    • of DISASSOCIATE STATISTICS 15.13
  • column values
    • unpivoting into rows 19.9
  • COMMENT clause
  • comments 2.6
  • COMMENT statement 12.15
  • commit
  • COMMIT IN PROCEDURE clause
  • COMMIT statement 13.1
  • COMMIT TO SWITCHOVER clause
    • of ALTER DATABASE 10.8
  • comparison conditions 6.2
  • comparison functions 7.2.7
  • comparison semantics
    • of character strings 2.2.4
  • COMPILE clause
    • of ALTER DIMENSION 10.11
    • of ALTER JAVA SOURCE 10.19
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER VIEW 12.9
    • of CREATE JAVA 13.20
  • COMPOSE function 7.50
  • COMPOSITE_LIMIT parameter
  • composite foreign keys 8.2
  • composite partitioning
  • composite primary keys 8.2
  • composite range partitions 15.4
  • compound conditions 6.11
  • compound expressions 5.4
  • COMPRESS clause
    • of ALTER INDEX ... REBUILD 13.17
    • of CREATE TABLE 15.4
  • compression
  • CON_DBID_TO_ID function 7.51
  • CON_GUID_TO_ID function 7.52
  • CON_ID_TO_CON_NAME function 7.53
  • CON_ID_TO_DBID function 7.54
  • CON_NAME_TO_ID function 7.55
  • CON_UID_TO_ID function 7.56
  • concatenation operator 4.4
  • CONCAT function 7.57
  • conditions
  • CONNECT_BY_ISCYCLE pseudocolumn 3.1.1
  • CONNECT_BY_ISLEAF pseudocolumn 3.1.2
  • CONNECT_BY_ROOT operator 4.5.2
  • CONNECT_TIME parameter
    • of ALTER PROFILE 11.11
    • of ALTER RESOURCE COST 11.12
  • CONNECT BY clause
  • CONNECT clause
    • of SELECT and subqueries 19.9
  • connection qualifier 2.9.3.1.1
  • CONNECT TO clause
    • of CREATE DATABASE LINK 13.9
  • CONSIDER FRESH clause
    • of ALTER MATERIALIZED VIEW 11.3
  • constant values
    • See: literals
  • CONSTRAINT(S) session parameter 11.16.2
  • constraints
    • adding to a table 12.3
    • altering 12.3
    • check 8.2
    • checking
      • at end of transaction 8.2
      • at start of transaction 8.2
      • at the end of each DML statement 8.2
    • column REF 8.2
    • deferrable 8.2, 19.10
    • defining 8.2, 15.4
    • disabling 15.4
      • after table creation 12.3
      • cascading 15.4
      • during table creation 15.4
    • dropping 12.3, 18.2
    • enabling 15.4
      • after table creation 12.3
      • during table creation 15.4
    • foreign key 8.2
    • modifying existing 12.3
    • on views
    • partitioning referential 12.3, 15.4
    • primary key 8.2
      • attributes of index 8.2
      • enabling 15.4
    • referential integrity 8.2
    • renaming 12.3
    • restrictions 8.2
    • setting state for a transaction 19.10
    • storing rows in violation 12.3
    • table REF 8.2
    • unique
      • attributes of index 8.2
      • enabling 15.4
  • CONTAINER hint 2.6.4.8
  • CONTAINS condition 6.1
  • CONTAINS operator 4.1
  • context namespaces
    • accessible to instance 13.6
    • associating with package 13.6
    • initializing using OCI 13.6
    • initializing using the LDAP directory 13.6
    • removing from the database 16.1
  • contexts
    • creating namespaces for 13.6
    • granting system privileges for 18.12
  • control file clauses
    • of ALTER DATABASE 10.8
  • CONTROLFILE REUSE clause
    • of CREATE DATABASE 13.8
  • control files
  • conversion
  • CONVERT function 7.58
  • COPY clause
    • of CREATE PLUGGABLE DATABASE 14.11
  • CORR_K function 7.60.2
  • CORR_S function 7.60.1
  • correlated subqueries 9.7
  • correlation functions
    • Kendall’s tau-b 7.60
    • Pearson’s 7.59
    • Spearman’s rho 7.60
  • correlation names
  • CORR function 7.59
  • COS function 7.61
  • COSH function 7.62
  • COUNT function 7.63
  • COVAR_POP function 7.64
  • COVAR_SAMP function 7.65
  • CPU_PER_CALL parameter
  • CPU_PER_SESSION parameter
    • of ALTER PROFILE 11.11
    • of ALTER RESOURCE COST 11.12
    • of CREATE PROFILE 14.13
  • CREATE ANALYTIC VIEW statement 13.2
  • CREATE ANY SQL PROFILE system privilege 18.12
  • CREATE ATTRIBUTE DIMENSION statement 13.3
  • CREATE AUDIT POLICY statement 13.4
  • CREATE CLUSTER statement 13.5
  • CREATE CONTEXT statement 13.6
  • CREATE CONTROLFILE statement 13.7
  • CREATE DATABASE LINK statement 13.9
  • CREATE DATABASE statement 13.8
  • CREATE DATAFILE clause
    • of ALTER DATABASE 10.8
  • CREATE DIMENSION statement 13.10
  • CREATE DIRECTORY statement 13.11
  • CREATE DISKGROUP statement 13.12
  • CREATE FLASHBACK ARCHIVE statement 13.14
  • CREATE FUNCTION statement 13.15
  • CREATE HIERARCHY statement 13.16
  • CREATE INDEX statement 13.17
  • CREATE INDEXTYPE statement 13.18
  • CREATE INMEMORY JOIN GROUP statement 13.19
  • CREATE JAVA statement 13.20
  • CREATE LIBRARY statement 14.1
  • CREATE LOCKDOWN PROFILE statement 14.2
  • CREATE MATERIALIZED VIEW LOG statement 14.4
  • CREATE MATERIALIZED VIEW statement 14.3
  • CREATE MATERIALIZED ZONEMAP statement 14.5
  • CREATE OPERATOR statement 14.6
  • CREATE OUTLINE statement 14.7
  • CREATE PACKAGE BODY statement 14.9
  • CREATE PACKAGE statement 14.8
  • CREATE PFILE statement 14.10
  • CREATE PLUGGABLE DATABASE statement 14.11
  • CREATE PLUGGABLE DATABASE system privilege 18.12
  • CREATE PROCEDURE statement 14.12
  • CREATE PROFILE statement 14.13
  • CREATE RESTORE POINT statement 14.14
  • CREATE ROLE statement 14.15
  • CREATE ROLLBACK SEGMENT statement 14.16
  • CREATE SCHEMA statement 14.17
  • CREATE SEQUENCE statement 15.1
  • CREATE SPFILE statement 15.2
  • CREATE STANDBY CONTROLFILE clause
    • of ALTER DATABASE 10.8
  • CREATE SYNONYM statement 15.3
  • CREATE TABLESPACE SET statement 15.6
  • CREATE TABLESPACE statement 15.5
  • CREATE TABLE statement 15.4
  • CREATE TRIGGER statement 15.7
  • CREATE TYPE BODY statement 15.9
  • CREATE TYPE statement 15.8
  • CREATE USER statement 15.10
  • CREATE VIEW statement 15.11
  • cross joins 19.9
  • CUBE_TABLE function 7.66
  • CUBE clause
    • of SELECT statements 19.9
  • cubes
    • extracting data 7.66
  • CUME_DIST function 7.67
  • cumulative distributions 7.67
  • currency
  • currency symbol
  • CURRENT_DATE function 7.68
  • CURRENT_SCHEMA session parameter 11.16.2
  • CURRENT_TIMESTAMP function 7.69
  • CURRENT_USER clause
    • of CREATE DATABASE LINK 13.9
  • CURRVAL pseudocolumn 3.2, 15.1
  • CURSOR_SHARING_EXACT hint 2.6.4.9
  • CURSOR expressions 5.7
  • cursors
  • CV function 7.70
  • CYCLE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1

D

  • data
    • aggregation
      • composite columns of GROUP BY 19.9
      • concatenated grouping sets of GROUP BY 19.9
      • grouping sets 19.9
    • analyzing a subset 7.159
    • caching frequently used 15.4
    • independence 15.3
    • integrity checking on input 2.1.1.2.1
    • locks on B.1
    • pivoting 19.9
    • retrieving 9.1
    • specifying as temporary 15.4
    • undo
    • unpivoting 19.9
  • database links 9.10
  • database objects
  • databases
    • accounts
    • allowing changes to 11.16
    • allowing generation of redo logs 10.8
    • allowing reuse of control files 13.8
    • allowing unlimited resources to users 14.13
    • archive mode, specifying 13.8
    • beginning backup of 10.8
    • blocks
      • specifying size 15.5
    • cancel-based recovery
    • changing characteristics 13.7
    • changing global name 10.8
    • changing name 13.7
    • character set, specifying 13.8
    • committing to standby status 10.8
    • connect strings 2.9.3.1.3
    • controlling use 10.8
    • create script for 10.8
    • creating 13.8
    • data files
    • default edition, setting 10.8
    • designing media recovery 10.8
    • dropping 16.2
    • ending backup of 10.8
    • erasing all data from 13.8
    • flashing back 18.10
    • granting system privileges for 18.12
    • in FLASHBACK mode 10.8
    • in FORCE LOGGING mode 10.8, 13.7, 13.8
    • instances of 13.8
    • limiting resources for users 14.13
    • log files
    • managed recovery 10.8
    • modifying 10.8
    • mounting 10.8, 13.8
    • moving a subset to a different database 12.3
    • namespaces 2.8.1
    • naming 10.8, 11.9
    • national character set, specifying 13.8
    • no-data-loss mode 10.8
    • online
      • adding log files 10.8
    • opening 10.8, 13.8
    • prepare to re-create 10.8
    • preventing changes to 10.8
    • protection mode of 10.8
    • quiesced state 12.2
    • read/write 10.8
    • read-only 10.8
    • reconstructing damaged 10.8
    • recovering 10.8
    • recovery
      • allowing corrupt blocks 10.8
      • testing 10.8
      • using a storage snapshot 10.8
      • with backup control file 10.8
    • re-creating control file for 13.7
    • remote
    • restoring earlier version of 10.8, 12.4, 15.5
    • restricting users to read-only transactions 10.8
    • resuming activity 12.2
    • returning to a past time 18.10
    • standby
      • adding log files 10.8
    • suspending activity 12.2
    • system user passwords 13.8
    • temp files
    • time zone
  • Database Smart Flash Cache 8.9
  • database triggers
    • See: triggers
  • data cartridge functions 7.8
  • data conversion 2.2.8
  • data definition language
  • data definition language (DDL)
  • data dictionary
  • DATAFILE clause
    • of CREATE DATABASE 13.8
  • DATAFILE clauses
    • of ALTER DATABASE 10.8
  • DATAFILE OFFLINE clause
    • of ALTER DATABASE 10.8
  • DATAFILE ONLINE clause
    • of ALTER DATABASE 10.8
  • DATAFILE RESIZE clause
    • of ALTER DATABASE 10.8
  • data files
    • bringing online 10.8
    • changing size of 10.8
    • creating new 10.8
    • defining for a tablespace 15.5
    • defining for the database 13.8
    • designing media recovery 10.8
    • dropping 12.4, 18.2
    • enabling autoextend 8.4
    • end online backup of 10.8, 12.4
    • extending automatically 8.4
    • online, updating information on 12.2
    • online backup of 12.4
    • putting online 10.8
    • recover damaged 10.8
    • recovering 10.8
    • re-creating lost or damaged 10.8
    • renaming 10.8
    • resizing 10.8
    • reusing 8.4
    • size of 8.4
    • specifying 8.4
      • for a tablespace 15.5
      • for database 13.8
    • system generated 10.8
    • taking offline 10.8
    • temporary
  • data manipulation language (DML)
  • data mining functions 7.2.12
  • DATAOBJ_TO_MAT_PARTITION function 7.71
  • DATAOBJ_TO_PARTITION function 7.72
  • data redaction
    • granting system privileges for 18.12
  • data types 2.1
  • DATE columns
    • converting to datetime columns 12.3
  • DATE data type 2.1.1.4.1
  • date format models 2.4.2, 2.4.2.1.2
  • date functions 7.2.6
  • dates
  • datetime arithmetic 2.1.1.4.7
  • datetime columns
    • creating from DATE columns 12.3
  • datetime data types 2.1.1.4
  • datetime expressions 5.8
  • datetime field
    • extracting from a datetime or interval value 7.83
  • datetime format elements 2.4.2.1
  • datetime functions 7.2.6
  • datetime literals 2.3.3
  • DAY datetime format element 2.4.2.2
  • daylight saving time 2.1.1.4.8
  • DB2 data types 2.1.3
  • DBA_2PC_PENDING data dictionary view 11.16
  • DBA_COL_COMMENTS data dictionary view 12.15
  • DBA_INDEXTYPE_COMMENTS data dictionary view 12.15
  • DBA_MVIEW_COMMENTS data dictionary view 12.15
  • DBA_OPERATOR_COMMENTS data dictionary view 12.15
  • DBA_ROLLBACK_SEGS data dictionary view 17.14
  • DBA_TAB_COMMENTS data dictionary view 12.15
  • DBMS_ROWID package
  • DBTIMEZONE function 7.73
  • DDL
    • See: data definition language (DDL)
  • DEALLOCATE UNUSED clause
  • debugging
    • granting system privileges for 18.12
  • decimal characters
  • DECODE function 7.74
  • decoding functions 7.2.15
  • DECOMPOSE function 7.75
  • DEFAULT clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • DEFAULT COST clause
    • of ASSOCIATE STATISTICS 12.11
  • default index, suppressing 14.3
  • DEFAULT profile
    • assigning to users 17.11
  • DEFAULT ROLE clause
    • of ALTER USER 12.8
  • DEFAULT SELECTIVITY clause
    • of ASSOCIATE STATISTICS 12.11
  • default tablespace 13.8
  • DEFAULT TABLESPACE clause
    • of ALTER DATABASE 10.8
    • of ALTER PLUGGABLE DATABASE 11.9
    • of ALTER USER 12.8
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10
  • default tablespaces
    • specifying for a user 12.8
  • DEFAULT TEMPORARY TABLESPACE clause
    • of ALTER DATABASE 10.8
    • of ALTER PLUGGABLE DATABASE 11.9
    • of CREATE DATABASE 13.8
  • DEFERRABLE clause
    • of constraints 8.2
  • deferrable constraints 19.10
  • DEFERRED clause
    • of SET CONSTRAINTS 19.10
  • definer’s rights views 15.11
  • DELETE statement 15.12
  • DELETE STATISTICS clause
  • DENSE_RANK function 7.76
  • DEPTH function 7.77
  • DEREF function 7.78
  • DESC clause
  • dictionaries
    • granting system privileges for 18.12
  • dimensional objects
    • extracting data 7.66
  • dimensions
  • directories
    • See: directory objects
  • directory objects
    • as aliases for operating system directories 13.11
    • auditing 12.12
    • creating 13.11
    • granting system privileges for 18.12
    • redefining 13.11
    • removing from the database 16.5
  • direct-path INSERT 2.6.4.2, 2.6.4.3, 18.13
  • DISABLE_PARALLEL_DML hint 2.6.4.10
  • DISABLE ALL TRIGGERS clause
    • of ALTER TABLE 12.3
  • DISABLE clause
  • DISABLE DISTRIBUTED RECOVERY clause
    • of ALTER SYSTEM 12.2
  • DISABLE PARALLEL DML clause
  • DISABLE QUERY REWRITE clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • DISABLE RESTRICTED SESSION clause
    • of ALTER SYSTEM 12.2
  • DISABLE RESUMABLE clause
  • DISABLE ROW MOVEMENT clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • DISABLE STORAGE IN ROW clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • DISABLE TABLE LOCK clause
    • of ALTER TABLE 12.3
  • DISASSOCIATE STATISTICS statement 15.13
  • DISCONNECT SESSION clause
    • of ALTER SYSTEM 12.2
  • disk group files
    • changing permission settings 10.12
    • Intelligent Data Placement 10.12
    • setting owner or user group 10.12
  • disk groups
  • disks
  • dispatcher processes
    • creating additional 12.2
    • terminating 12.2
  • DISTINCT clause
  • distinct queries 19.9
  • distributed queries 9.10
    • restrictions on 9.10
  • distribution
  • DML
    • See: data manipulation language (DML)
  • domain_index_clause
  • domain indexes 13.17, 13.18
    • and LONG columns 12.3
    • associating statistics types with 12.11
    • creating, prerequisites 13.17
    • determining user-defined CPU and I/O costs 18.9
    • disassociating statistics types from 15.13, 16.11
    • example F.1
    • invoking drop routines for 18.1
    • local partitioned 13.17
    • modifying 10.16
    • parallelizing creation of 13.17
    • rebuilding 10.16
    • removing from the database 16.11
    • system managed 13.18
  • DOWNGRADE clause
    • of ALTER DATABASE 10.8
  • DROP ANALYTIC VIEW statement 15.14
  • DROP ANY SQL PROFILE system privilege 18.12
  • DROP ATTRIBUTE DIMENSION statement 15.15
  • DROP AUDIT POLICY statement 15.16
  • DROP clause
    • of ALTER DIMENSION 10.11
    • of ALTER INDEXTYPE 10.17
  • DROP CLUSTER statement 15.17
  • DROP COLUMN clause
    • of ALTER TABLE 12.3
  • DROP constraint clause
    • of ALTER VIEW 12.9
  • DROP CONSTRAINT clause
    • of ALTER TABLE 12.3
  • DROP CONTEXT statement 16.1
  • DROP DATABASE LINK statement 16.3
  • DROP DATABASE statement 16.2
  • DROP DIMENSION statement 16.4
  • DROP DIRECTORY statement 16.5
  • DROP DISKGROUP statement 16.6
  • DROP FLASHBACK ARCHIVE statement 16.8
  • DROP FUNCTION statement 16.9
  • DROP HIERARCHY statement 16.10
  • DROP INDEX statement 16.11
  • DROP INDEXTYPE statement 16.12
  • DROP INMEMORY JOIN GROUP statement 16.13
  • DROP JAVA statement 16.14
  • DROP LIBRARY statement 17.1
  • DROP LOCKDOWN PROFILE statement 17.2
  • DROP LOGFILE clause
    • of ALTER DATABASE 10.8
  • DROP LOGFILE MEMBER clause
    • of ALTER DATABASE 10.8
  • DROP MATERIALIZED VIEW LOG statement 17.4
  • DROP MATERIALIZED VIEW statement 17.3
  • DROP MATERIALIZED ZONEMAP statement 17.5
  • DROP OPERATOR statement 17.6
  • DROP OUTLINE statement 17.7
  • DROP PACKAGE BODY statement 17.8
  • DROP PACKAGE statement 17.8
  • DROP PARTITION clause
  • DROP PLUGGABLE DATABASE statement 17.9
  • DROP PRIMARY constraint clause
    • of ALTER TABLE 12.3
  • DROP PROCEDURE statement 17.10
  • DROP PROFILE statement 17.11
  • DROP RESTORE POINT statement 17.12
  • DROP ROLE statement 17.13
  • DROP ROLLBACK SEGMENT statement 17.14
  • DROP SEQUENCE statement 17.15
  • DROP SUPPLEMENTAL LOG DATA clause
    • of ALTER DATABASE 10.8
  • DROP SUPPLEMENTAL LOG GROUP clause
    • of ALTER TABLE 12.3
  • DROP SYNONYM statement 17.16
  • DROP TABLESPACE SET statement 18.3
  • DROP TABLESPACE statement 18.2
  • DROP TABLE statement 18.1
  • DROP TRIGGER statement 18.4
  • DROP TYPE BODY statement 18.6
  • DROP TYPE statement 18.5
  • DROP UNIQUE constraint clause
    • of ALTER TABLE 12.3
  • DROP USER statement 18.7
  • DROP VALUES clause
    • of ALTER TABLE ... MODIFY PARTITION 12.3
  • DROP VIEW statement 18.8
  • DUAL dummy table 2.8.1, 9.9
  • DUMP function 7.79
  • DY datetime format element 2.4.2.2
  • DYNAMIC_SAMPLING hint 2.6.4.12

E

  • editioning views 15.11
  • editions
    • comments on 12.15
    • creating 13.13
    • dropping 16.7
    • granting system privileges for 18.12
    • setting default for a PDB 11.9
    • setting default for database 10.8
    • setting for a session 11.16
  • embedded SQL 10.1.6
  • EMPTY_BLOB function 7.80
  • EMPTY_CLOB function 7.80
  • ENABLE_PARALLEL_DML hint 2.6.4.13
  • ENABLE ALL TRIGGERS clause
    • of ALTER TABLE 12.3
  • ENABLE clause
    • of ALTER INDEX 10.16
    • of ALTER TRIGGER 12.6
    • of CREATE TABLE 15.4
  • ENABLE DISTRIBUTED RECOVERY clause
    • of ALTER SYSTEM 12.2
  • ENABLE NOVALIDATE constraint state 8.2
  • ENABLE PARALLEL DML clause
  • ENABLE QUERY REWRITE clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • ENABLE RESTRICTED SESSION clause
    • of ALTER SYSTEM 12.2
  • ENABLE RESUMABLE clause
  • ENABLE ROW MOVEMENT clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • ENABLE STORAGE IN ROW clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • ENABLE TABLE LOCK clause
    • of ALTER TABLE 12.3
  • ENABLE VALIDATE constraint state 8.2
  • encoding functions 7.2.15
  • encryption 15.4
    • of tablespaces 8.9
  • encryption keys
  • END BACKUP clause
    • of ALTER DATABASE 10.8
    • of ALTER DATABASE ... DATAFILE 10.8
    • of ALTER TABLESPACE 12.4
  • enterprise users
    • allowing connection as database users 12.8
  • environment functions 7.2.17
  • equality test 6.2
  • equijoins 9.6.2
    • defining for a dimension 13.10
  • equivalency tests 6.14
  • ERROR_ON_OVERLAP_TIME session parameter 11.16.2
  • error logging
    • of DELETE operations 15.12
    • of INSERT operations 18.13
    • of MERGE operations 19.1
  • EXCEPTIONS INTO clause
    • of ALTER TABLE 12.3
  • EXCHANGE PARTITION clause
    • of ALTER TABLE 12.3
  • EXCHANGE SUBPARTITION clause
    • of ALTER TABLE 12.3
  • exchanging partitions
    • restrictions on 12.3
  • EXCLUDING NEW VALUES clause
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • EXCLUSIVE lock mode 18.14
  • exclusive locks
    • row locks (TX) B.1
    • table locks (TM) B.1
  • EXECUTE object privilege
  • execution plans
  • EXISTS condition 6.9.1, 6.13
  • EXISTSNODE function 7.81
  • EXP function 7.82
  • EXPLAIN PLAN statement 18.9
  • explicit data conversion 2.2.8.1, 2.2.8.4
  • expressions
  • extended rowids
  • extensible indexing
  • EXTENT MANAGEMENT clause
    • of CREATE DATABASE 13.8
    • of CREATE TABLESPACE 15.5
  • EXTENT MANAGEMENT DICTIONARY clause
    • of CREATE TABLESPACE 15.5
  • EXTENT MANAGEMENT LOCAL clause
    • of CREATE DATABASE 13.8
  • extents
    • allocating for partitions 12.3
    • allocating for subpartitions 12.3
    • allocating for tables 12.3
    • restricting access by instances 10.16
    • specifying maximum number for an object 8.9
    • specifying number allocated upon object creation 8.9
    • specifying the first for an object 8.9
    • specifying the percentage of size increase 8.9
    • specifying the second for an object 8.9
  • external functions 13.15, 14.12
  • external LOBs 2.1.1.6
  • external procedures 14.12
  • external tables 15.4
    • access drivers 15.4
    • altering 12.3
    • creating 15.4
    • ORACLE_DATAPUMP access driver 15.4
    • ORACLE_HDFS access driver 15.4
    • ORACLE_HIVE access driver 15.4
    • ORACLE_LOADER access driver 15.4
    • restrictions on 15.4
  • external users 14.15, 15.10
  • EXTRACT (datetime) function 7.83
  • EXTRACT (XML) function 7.84
  • EXTRACTVALUE function 7.85

F

  • FACT hint 2.6.4.14
  • FAILED_LOGIN_ATTEMPTS parameter
  • failure groups
  • fast refresh 14.4
  • FEATURE_DETAILS function 7.87
  • FEATURE_ID function 7.88
  • FEATURE_SET function 7.89
  • FEATURE_VALUE function 7.90
  • FETCH
    • row_limiting_clause 19.9
  • files
    • specifying as a redo log file group 8.4
    • specifying as data files 8.4
    • specifying as temp files 8.4
  • FILTER FACT keywords 19.9
  • FIPS
  • FIRST_ROWS(n) hint 2.6.4.15
  • FIRST_VALUE function 7.92
  • FIRST function 7.91
  • FLAGGER session parameter 11.16.2
  • FLASH_CACHE parameter
    • of STORAGE clause 8.9
  • FLASHBACK ARCHIVE object privilege 18.12
  • flashback data archives
  • FLASHBACK DATABASE statement 18.10
  • flashback queries 19.9
  • FLASHBACK TABLE statement 18.11
  • flash cache 8.9
  • floating-point conditions 6.3
  • floating-point numbers 2.1.1.2.3
  • FLOOR function 7.93
  • FLUSH BUFFER_CACHE clause
    • of ALTER SYSTEM 12.2
  • FLUSH GLOBAL CONTEXT clause
    • of ALTER SYSTEM 12.2
  • FLUSH REDO clause
    • of ALTER SYSTEM 12.2
  • FLUSH SHARED_POOL clause
    • of ALTER SYSTEM 12.2
  • FM format model modifier 2.4.3
  • FORCE clause
  • force full database caching 10.8
  • FORCE LOGGING clause
    • of ALTER DATABASE 10.8
    • of ALTER TABLESPACE 12.4
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
    • of CREATE TABLESPACE 15.5
  • FORCE PARALLEL DML clause
  • FOR clause
  • foreign key constraints 8.2
  • foreign tables
  • format models 2.4
  • formats
    • for dates and numbers. See format models 2.4
    • of return values from the database 2.4
    • of values stored in the database 2.4
  • FOR UPDATE clause
  • FREELIST GROUPS parameter
    • of STORAGE clause 8.9
  • free lists
    • specifying for a table, partition, cluster, or index 8.9
    • specifying for LOBs 15.4
  • FREELISTS parameter
    • of STORAGE clause 8.9
  • FREEPOOLS parameter
    • of LOB storage 15.4
  • FRESH_MV hint 2.6.4.16
  • FROM_TZ function 7.94
  • FROM clause
    • of CREATE PLUGGABLE DATABASE 14.11
    • of queries 9.6.4
  • FROM COLUMNS clause
    • of DISASSOCIATE STATISTICS 15.13
  • FROM FUNCTIONS clause
    • of DISASSOCIATE STATISTICS 15.13
  • FROM INDEXES clause
    • of DISASSOCIATE STATISTICS 15.13
  • FROM INDEXTYPES clause
    • of DISASSOCIATE STATISTICS 15.13
  • FROM PACKAGES clause
    • of DISASSOCIATE STATISTICS 15.13
  • FROM TYPES clause
    • of DISASSOCIATE STATISTICS 15.13
  • FULL hint 2.6.4.17
  • full indexes 13.17
  • full outer joins 19.9
  • function-based indexes 13.17
  • function expressions
    • built-in 5.9
    • user-defined 5.9
  • functions 7.302
    • See also: SQL functions
    • 3GL,calling 14.1
    • associating statistics types with 12.11
    • avoiding run-time compilation 10.14
    • built_in
      • as expressions 5.9
    • calling 12.14
    • changing the declaration of 13.15
    • changing the definition of 13.15
    • defining an index on 13.17
    • disassociating statistics types from 15.13
    • executing 12.14
    • external 13.15, 14.12
    • inverse distribution 7.164, 7.165
    • issuing COMMIT or ROLLBACK statements 11.16
    • linear regression 7.188
    • naming rules 2.8.1
    • OLAP 7.7
    • recompiling invalid 10.14
    • re-creating 13.15, 13.20
    • removing from the database 16.9
    • statistics, assigning default cost 12.11
    • statistics, defining default selectivity 12.11
    • stored 13.15
    • storing return value of 12.14
    • synonyms for 15.3
    • user-defined 7.302
      • as expressions 5.9
    • XML 7.2.13
  • FUNCTIONS clause
    • of ASSOCIATE STATISTICS 12.11
    • of DISASSOCIATE STATISTICS 15.13
  • FX format model modifier 2.4.3

G

  • GATHER_OPTIMIZER_STATISTICS hint 2.6.4.18
  • general comparison functions 7.2.7
  • general recovery clause
    • of ALTER DATABASE 10.8
  • geoimaging 2.1.8
  • GLOBAL_TOPIC_ENABLED system parameter 12.2
  • global indexes
    • See: indexes, globally partitioned
  • globally partitioned indexes 13.17
  • GLOBAL parameter
    • of CREATE SEQUENCE 15.1
  • GLOBAL PARTITION BY HASH clause
  • GLOBAL PARTITION BY RANGE clause
  • global sequences 15.1
  • GLOBAL TEMPORARY clause
    • of CREATE TABLE 15.4
  • global users 14.15, 15.10
  • GRANT CONNECT THROUGH clause
    • of ALTER USER 12.8
  • GRANT statement
  • GRAPHIC data type
  • greater than or equal to tests 6.2
  • greater than tests 6.2
  • GREATEST function 7.95
  • GROUP_ID function 7.96
  • GROUP BY clause
    • CUBE extension 19.9
    • identifying duplicate groupings 7.96
    • of SELECT and subqueries 19.9
    • ROLLUP extension of 19.9
  • group comparison conditions 6.2.2
  • GROUPING 2.6.4.19
  • GROUPING_ID function 7.98
  • GROUPING function 7.97
  • GROUPING Hint 2.6.4.19
  • groupings
    • filtering out duplicate 7.96
  • grouping sets 19.9
  • GROUPING SETS clause
    • of SELECT and subqueries 19.9
  • group separator
  • GUARD ALL clause
    • of ALTER DATABASE 10.8
  • GUARD clause
  • GUARD NONE clause
    • of ALTER DATABASE 10.8
  • GUARD STANDBY clause
    • of ALTER DATABASE 10.8

H

I

  • IDENTIFIED BY clause
    • of ALTER ROLE. See CREATE ROLE 11.13
    • of CREATE DATABASE LINK 13.9
  • IDENTIFIED EXTERNALLY clause
  • IDENTIFIED GLOBALLY clause
    • of ALTER ROLE. See CREATE ROLE 11.13
    • of CREATE ROLE 14.15
    • of CREATE USER 15.10
  • identifier functions 7.2.17
  • identity column 15.4
  • IDLE_TIME parameter
  • IEEE754
  • IGNORE_ROW_ON_DUPKEY_INDEX hint 2.6.4.21
  • IMMEDIATE clause
    • of SET CONSTRAINTS 19.10
  • implicit data conversion 2.2.8.1, 2.2.8.2, 2.2.8.3
  • INCLUDING CONTENTS clause
    • of DROP TABLESPACE 18.2
  • INCLUDING DATAFILES clause
    • of ALTER DATABASE TEMPFILE DROP clause 10.8
  • INCLUDING NEW VALUES clause
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • INCLUDING TABLES clause
  • incomplete object types 15.8
  • IN conditions 6.14
  • incremental
    • and block change tracking 10.8
  • INCREMENT BY clause
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
  • INCREMENT BY parameter
    • of CREATE SEQUENCE 15.1
  • INDEX_ASC hint 2.6.4.23
  • INDEX_COMBINE hint 2.6.4.24
  • INDEX_DESC hint 2.6.4.25
  • INDEX_FFS hint 2.6.4.26
  • INDEX_JOIN hint 2.6.4.27
  • INDEX_SS_ASC hint 2.6.4.29
  • INDEX_SS_DESC hint 2.6.4.30
  • INDEX_SS hint 2.6.4.28
  • INDEX clause
  • indexed clusters
  • indexes 10.16
    • advanced index compression, enabling 10.16
    • advanced index compression of 13.17
    • allocating new extents for 10.16
    • application-specific 13.18
    • ascending 13.17
    • based on indextypes 13.17
    • bitmap 13.17
    • bitmap join 13.17
    • B-tree 13.17
    • changing attributes 10.16
    • changing parallelism of 10.16
    • collecting statistics on 12.10
    • creating 13.17
    • creating as usable or unusable 13.17
    • creating on a cluster 13.17
    • creating on a table 13.17
    • deallocating unused space from 10.16
    • descending 13.17
      • and query rewrite 13.17
      • as function-based indexes 13.17
    • direct-path inserts, logging 10.16
    • domain 13.17, 13.18
    • domain, example F.1
    • dropping index partitions 16.11
    • examples 13.17
    • full 13.17
    • full fast scans 2.6.4.26
    • function-based 13.17
    • globally partitioned 13.17
    • global partitioned, creating 13.17
    • granting system privileges for 18.12
    • invisible to the optimizer 10.16, 13.17
    • join, bitmap 13.17
    • local domain 13.17
    • locally partitioned 13.17
    • logging rebuild operations 10.16
    • marking as USABLE or UNUSABLE 10.16
    • merging block contents 10.16
    • merging contents of index blocks 10.16
    • merging contents of index partition blocks 10.16
    • modifying attributes 10.16
    • moving 10.16
    • on clusters 13.17
    • on composite-partitioned tables 13.17
    • on composite-partitioned tables, creating 13.17
    • on hash-partitioned tables 13.17
    • on index-organized tables 13.17
    • online 13.17
    • on list-partitioned tables
    • on nested table storage tables 13.17
    • on partitioned tables 13.17
    • on range-partitioned tables 13.17
    • on range-partitioned tables, creating 13.17
    • on scalar typed object attributes 13.17
    • on table columns 13.17
    • on XMLType tables 13.17
    • parallelizing creation of 13.17
    • partial 13.17
    • partitioned 2.9.4, 13.17
    • partitioning 13.17
    • partitions 13.17
    • prefix compression, enabling 10.16
    • prefix compression of 13.17
    • preventing use of 10.16
    • purging from the recycle bin 19.4
    • rebuilding 10.16
    • re-creating 10.16
    • removing from the database 16.11
    • renaming 10.16
    • reverse 10.16, 13.17
    • specifying tablespace for 10.16
    • statistics on usage 10.16
    • subpartitions
      • allocating extents for 10.16
      • changing default attributes 10.16
      • changing physical attributes 10.16
      • changing storage characteristics 10.16
      • deallocating unused space from 10.16
      • marking UNUSABLE 10.16
      • modifying 10.16
      • moving 10.16
      • preventing use of 10.16
      • rebuilding 10.16
      • re-creating 10.16
      • renaming 10.16
      • specifying tablespace for 10.16
    • tablespace containing 13.17
    • unique 13.17
    • unsorted 13.17
    • used to enforce constraints 12.3, 15.4
    • validating structure 12.10
  • INDEXES clause
    • of ASSOCIATE STATISTICS 12.11
    • of DISASSOCIATE STATISTICS 15.13
  • INDEX hint 2.6.4.22
  • indexing property 15.4
  • index keys
  • index-organized tables
    • bitmap indexes on, creating 15.4
    • creating 15.4
    • mapping tables 12.3
    • merging contents of index blocks 12.3
    • modifying 12.3
    • moving 12.3
    • overflow segments
    • partitioned, updating secondary indexes 10.16
    • PCT_ACCESS_DIRECT statistics 12.10
    • primary key indexes
    • rebuilding 12.3
    • rowids of 2.1.2.2
    • secondary indexes, updating 10.16
  • index partitions
    • creating subpartitions 13.17
  • index subpartitions 13.17
  • INDEXTYPE clause
  • indextypes
    • adding operators 10.17
    • altering 10.17
    • associating statistics types with 12.11
    • changing implementation type 10.17
    • comments on 12.15
    • creating 13.18
    • disassociating statistics types from 15.13, 16.12
    • drop routines, invoking 16.11
    • granting system privileges for 18.12
    • indexes based on 13.17
    • instances 13.17
    • removing from the database 16.12
  • INDEXTYPES clause
    • of ASSOCIATE STATISTICS 12.11
    • of DISASSOCIATE STATISTICS 15.13
  • in-doubt transactions
  • inequality test 6.2
  • INHERIT PRIVILEGES object privilege
  • INITCAP function 7.100
  • initialization parameters
    • changing session settings 11.16
    • setting using ALTER SESSION 11.16.1
  • INITIALIZED EXTERNALLY clause
    • of CREATE CONTEXT 13.6
  • INITIALIZED GLOBALLY clause
    • of CREATE CONTEXT 13.6
  • INITIALLY DEFERRED clause
    • of constraints 8.2
  • INITIALLY IMMEDIATE clause
    • of constraints 8.2
  • INITIAL parameter
    • of STORAGE clause 8.9
  • INITRANS parameter
    • of ALTER CLUSTER 10.7
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 12.3
    • of CREATE INDEX. See CREATE TABLE 13.17
    • of CREATE MATERIALIZED VIEW. See CREATE TABLE 14.3
    • of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE 14.4
    • of CREATE TABLE 8.7
  • inline analytic views 19.9
  • inline constraints
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • inline views 9.7
  • INMEMORY_PRUNING hint 2.6.4.32
  • INMEMORY hint 2.6.4.31
  • inner joins 9.6.6, 19.9
  • inner-N reporting 7.194
  • INSERT
    • direct-path versus conventional 18.13
  • INSERT clause
  • inserts
  • INSERT statement 18.13
  • instance recovery
    • continue after interruption 10.8
  • instances
    • making index extents available to 10.16
    • setting parameters for 12.2
  • INSTANCE session parameter 11.16.2
  • INSTR2 function 7.101
  • INSTR4 function 7.101
  • INSTRB function 7.101
  • INSTRC function 7.101
  • INSTR function 7.101
  • integers
  • integrity constraints
    • See: constraints
  • internal LOBs 2.1.1.6
  • International Organization for Standardization (ISO)
  • INTERSECT set operator 4.6
  • interval
  • interval conditions 6.12
  • INTERVAL DAY TO SECOND data type 2.1.1.4.6
  • INTERVAL expressions 5.10
  • interval partitioning 12.3, 15.4
    • changing the interval 12.3
  • INTERVAL YEAR TO MONTH data type 2.1.1.4.5
  • INTO clause
  • INVALIDATE GLOBAL INDEXES clause
    • of ALTER TABLE 12.3
  • inverse distribution functions 7.164, 7.165
  • invoker rights
    • altering for a Java class 10.19
    • defining for a Java class 13.20
  • invoker’s rights views 15.11
  • IS [NOT] EMPTY conditions 6.6.2
  • IS ANY condition 6.5.1
  • IS JSON condition 6.10.1
  • ISO
    • See: International Organization for Standardization (ISO)
  • IS OF type condition 6.15
  • IS PRESENT condition 6.5.2
  • ITERATION_NUMBER function 7.102

J

K

  • KEEP DATAFILES clause
    • of DROP PLUGGABLE DATABASE 17.9
  • KEEP keyword
    • of FIRST function 7.91
    • of LAST function 7.91
    • with aggregate functions 7.3
  • KEEP parameter
    • of CREATE SEQUENCE 15.1
  • KEEP SEQUENCE object privilege
  • key compression
    • See: prefix compression
  • key management framework
    • granting system privileges for 18.12
    • managing 10.3
  • key-preserved tables 15.11
  • keys, eliminating repetition 10.16
  • keywords 2.8.1
  • KILL SESSION clause
    • of ALTER SYSTEM 12.2

L

  • LAG function 7.114
  • large object functions 7.2.9
  • large objects
    • See: LOB data types
  • LAST_DAY function 7.116
  • LAST_VALUE function 7.117
  • LAST function 7.115
  • lateral inline views 19.9
  • LEAD function 7.118
  • LEADING hint 2.6.4.33
  • LEAST function 7.119
  • left outer joins 19.9
  • LENGTH2 function 7.120
  • LENGTH4 function 7.120
  • LENGTHB function 7.120
  • LENGTHC function 7.120
  • LENGTH function 7.120
  • less than tests 6.2
  • LEVEL clause
    • of ALTER DIMENSION 10.11
    • of CREATE DIMENSION 13.10
  • level columns
    • specifying default values 15.4
  • LEVEL pseudocolumn 3.1.3, 19.9
  • levels
    • adding to a dimension 10.11
    • dropping from a dimension 10.11
    • of dimensions, defining 13.10
  • libraries
    • creating 14.1
    • granting system privileges for 18.12
    • re-creating 14.1
    • removing from the database 17.1
  • library units
    • See: Java schema objects
  • LIKE conditions 6.7.1
  • linear regression functions 7.188
  • LISTAGG function 7.121
  • LIST CHAINED ROWS clause
  • listeners
  • list partitioning
    • adding default partition 12.3
    • adding partitions 12.3
    • adding values 12.3
    • creating a default partition 15.4
    • creating partitions 15.4
    • dropping values 12.3
    • merging default with nondefault partitions 12.3
    • splitting default partition 12.3
  • list subpartitions
  • literals 2.3
  • LN function 7.122
  • LNNVL function 7.123
  • LOB columns
    • adding 12.3
    • compressing 15.4
    • creating from LONG columns 2.1.1.3, 12.3
    • deduplication 15.4
    • defining properties
      • for materialized views 14.3
    • encrypting 15.4
    • modifying 12.3
    • modifying storage 12.3
    • restricted in joins 9.6.1
    • restrictions on 2.1.1.6
    • storage characteristics of materialized views 11.3
  • LOB data types 2.1.1.6
  • LOBs
  • LOB storage clause
    • for partitions 12.3
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER TABLE 12.3
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE TABLE 15.4
  • LOCAL clause
  • locale independent 2.4.2.1.2
  • locally managed tablespaces
    • altering 12.4
    • storage attributes 8.9
  • locally partitioned indexes 13.17
  • LOCALTIMESTAMP function 7.124
  • local users 14.15, 15.10
  • location transparency 15.3
  • locking, overriding automatic 18.14
  • locks
    • See: table locks
  • LOCK TABLE statement 18.14
  • log data
    • collection during update operations 10.8
  • LOGFILE clause
    • OF CREATE DATABASE 13.8
  • log file clauses
    • of ALTER DATABASE 10.8
  • LOGFILE GROUP clause
    • of CREATE CONTROLFILE 13.7
  • log files
  • LOG function 7.125
  • logging
    • and redo log size 8.5
    • specifying minimal 8.5
    • supplemental
    • supplemental, adding log groups 12.3
    • supplemental, dropping log groups 12.3
  • LOGGING clause
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 12.3
    • of ALTER TABLESPACE 12.4
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
    • of CREATE TABLE 15.4
    • of CREATE TABLESPACE 15.5
  • log groups
  • LOGICAL_READS_PER_CALL parameter
  • LOGICAL_READS_PER_SESSION parameter
    • of ALTER PROFILE 11.11
    • of ALTER RESOURCE COST 11.12
  • logical conditions 6.4
  • logical standby database
  • LogMiner
    • granting system privileges for 18.12
    • supplemental logging 12.3, 15.4
  • LONG columns
  • LONG data type 2.1.1.3
  • LONG RAW data type 2.1.1.5
    • converting from CHAR data 2.1.1.5
  • LONG VARGRAPHIC data type
  • LOWER function 7.126
  • LPAD function 7.127
  • LTRIM function 7.128

M

  • MAKE_REF function 7.129
  • managed recovery
  • managed standby recovery
    • as background process 10.8
    • create a logical standby from the physical standby 10.8
    • overriding delays 10.8
    • returning control during 10.8
    • terminating existing 10.8
  • MANAGED STANDBY RECOVERY clause
    • of ALTER DATABASE 10.8
  • MAPPING TABLE clause
    • of ALTER TABLE 12.3
  • mapping tables
  • master databases 14.3
  • master tables 14.3
  • MATCHES condition 6.1
  • MATCHES operator 4.1
  • materialized join views 14.4
  • materialized view logs 14.4
    • creating 14.4
    • excluding new values from 11.4
    • logging changes to 11.4
    • object ID based 11.4
    • parallelizing creation 14.4
    • partition attributes, changing 11.4
    • partitioned 14.4
    • physical attributes
    • purging 11.4, 14.4
    • refreshing 11.4, 14.4
    • removing from the database 17.4
    • required for fast refresh 14.4
    • required for synchronous refresh 14.4
    • rowid based 11.4
    • saving new values in 11.4
    • saving old values in 14.4
    • staging logs 14.4
    • storage attributes
  • materialized views 14.3
    • changing from rowid-based to primary-key-based 11.3
    • changing to primary-key-based 11.4
    • complete refresh 11.3, 14.3
    • compression of 11.3, 14.3
    • constraints on 8.2
    • creating 14.3
    • creating comments about 12.15
    • degree of parallelism 11.3, 11.4
      • during creation 14.3
    • enabling and disabling query rewrite 14.3
    • examples 14.3, 14.4
    • fast refresh 11.3, 14.3
    • forced refresh 11.3
    • for data warehousing 14.3
    • for replication 14.3
    • granting system privileges for 18.12
    • index characteristics
    • indexes that maintain 14.3
    • join 14.4
    • LOB storage attributes 11.3
    • logging changes to 11.3
    • master table, dropping 17.3
    • object type, creating 14.3
    • partitions 11.3
    • physical attributes 14.3
    • primary key 14.3
      • recording values in master table 11.4
    • query rewrite
      • eligibility for 8.2
      • enabling and disabling 11.3
    • re-creating during refresh 11.3
    • refresh 10.8
    • refresh, time, changing 11.3
    • refreshing 10.8
    • removing from the database 17.3
    • restricting scope of 14.3
    • retrieving data from 19.9
    • revalidating 11.3
    • rowid 14.3
    • rowid values
      • recording in master table 11.4
    • saving blocks in a cache 11.3
    • storage attributes 14.3
    • subquery 14.3
    • suppressing creation of default index 14.3
    • synonyms for 15.3
    • when to populate 14.3
  • MAXDATAFILES parameter
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
  • MAXEXTENTS parameter
    • of STORAGE clause 8.9
  • MAX function 7.130
  • MAXINSTANCES parameter
    • of CREATE CONTROLFILE 13.7
    • OF CREATE DATABASE 13.8
  • MAXLOGFILES parameter
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
  • MAXLOGHISTORY parameter
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
  • MAXLOGMEMBERS parameter
    • of CREATE CONTROLFILE 13.7
    • of CREATE DATABASE 13.8
  • MAXSIZE clause
    • of ALTER DATABASE 10.8
  • MAXTRANS parameter
    • of physical_attributes_clause 8.7
  • MAXVALUE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • measure expressions
    • analytic view 5.3
  • MEDIAN function 7.131
  • median values 7.165
  • media recovery
    • avoid on startup 10.8
    • designing 10.8
    • disabling 10.8
    • from specified redo logs 10.8
    • of database 10.8
    • of data files 10.8
    • of standby database 10.8
    • of tablespaces 10.8
    • performing ongoing 10.8
    • preparing for 10.8
    • restrictions 10.8
    • sustained standby recovery 10.8
  • MEMBER conditions 6.6.3
  • membership conditions 6.6.3, 6.14
  • merge_insert_clause
  • MERGE ANY VIEW system privilege 18.12
  • MERGE hint 2.6.4.34
  • MERGE PARTITIONS clause
    • of ALTER TABLE 12.3
  • MERGE statement 19.1
    • deletes during 19.1
    • error logging 19.1
    • inserts during 19.1
    • updates during 19.1
  • MERGE VIEW object privilege on a view 18.12
  • migrated rows
  • MINEXTENTS parameter
    • of STORAGE clause 8.9
  • MIN function 7.132
  • MINIMIZE RECORDS PER BLOCK clause
    • of ALTER TABLE 12.3
  • MINIMUM EXTENT clause
    • of ALTER TABLESPACE 12.4
    • of CREATE TABLESPACE 15.5
  • mining models
  • MINUS set operator 4.6
  • MINVALUE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • MODE clause
  • MODEL_MIN_ANALYSIS hint 2.6.4.35
  • MODEL clause
  • model conditions 6.5
  • model expression 5.12
  • model functions 7.6
  • MOD function 7.133
  • MODIFY clause
    • of ALTER TABLE 12.3
  • MODIFY CONSTRAINT clause
    • of ALTER TABLE 12.3
    • of ALTER VIEW 12.9
  • MODIFY DEFAULT ATTRIBUTES clause
  • MODIFY LOB storage clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER TABLE 12.3
  • MODIFY NESTED TABLE clause
    • of ALTER TABLE 12.3
  • MODIFY PARTITION clause
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER TABLE 12.3
  • MODIFY scoped_table_ref_constraint clause
    • of ALTER MATERIALIZED VIEW 11.3
  • MODIFY SUBPARTITION clause
  • MODIFY VARRAY clause
    • of ALTER TABLE 12.3
  • MON datetime format element 2.4.2.2
  • MONITOR hint 2.6.4.36
  • MONITORING USAGE clause
  • MONTH datetime format element 2.4.2.2
  • MONTHS_BETWEEN function 7.134
  • MOUNT clause
    • of ALTER DATABASE 10.8
  • MOVE clause
    • of ALTER TABLE 12.3
    • of CREATE PLUGGABLE DATABASE 14.11
  • MOVE ONLINE clause
    • of ALTER TABLE 12.3
  • MOVE SUBPARTITION clause
    • of ALTER TABLE 12.3
  • MTS
    • See: shared server
  • multilevel collections 15.4
  • multiset conditions 6.6
  • MULTISET EXCEPT operator 4.7.1
  • MULTISET INTERSECT operator 4.7.2
  • MULTISET keyword
    • of CAST function 7.38
  • multiset operators 4.7
  • MULTISET UNION operator 4.7.3
  • multitable inserts 18.13
  • multitenant container databases
    • See: CDBs
  • multi-threaded server
    • See: shared server

N

  • NAME clause
    • of SET TRANSACTION 19.12
  • NAMED clause
  • namespaces
  • NANVL function 7.135
  • national character set
  • NATIONAL CHARACTER SET parameter
    • of CREATE DATABASE 13.8
  • natural joins 19.9
  • NCHAR data type 2.1.1.1.2
  • NCHR function 7.136
  • NCLOB data type 2.1.1.6.4
  • nested subqueries 9.7
  • NESTED TABLE clause
    • of ALTER TABLE 12.3
    • of CREATE TABLE 15.4
  • nested tables 2.1.4.4, 6.6.1, 7.167, 7.201
    • changing returned value 12.3
    • combining 4.7
    • compared with varrays 2.2.6
    • comparison rules 2.2.6
    • creating 15.8
    • creating from existing columns 7.49
    • defining as index-organized tables 12.3
    • determining hierarchy 6.6.4
    • dropping the body of 18.6
    • dropping the specification of 18.5
    • indexing columns of 13.17
    • in materialized views 14.3
    • modifying 12.3
    • modifying column properties 12.3
    • multilevel 15.4
    • partitioned nested table columns 12.3
    • storage characteristics of 12.3, 15.4
  • NEW_TIME function 7.137
  • NEXT_DAY function 7.138
  • NEXT clause
    • of ALTER MATERIALIZED VIEW ... REFRESH 11.3
  • NEXT parameter
    • of STORAGE clause 8.9
  • NEXTVAL pseudocolumn 3.2, 15.1
  • NLS_CHARSET_DECL_LEN function 7.139
  • NLS_CHARSET_ID function 7.140
  • NLS_CHARSET_NAME function 7.141
  • NLS_COLLATION_ID function 7.142
  • NLS_COLLATION_NAME function 7.143
  • NLS_DATE_LANGUAGE initialization parameter 2.4.2.2
  • NLS_INITCAP function 7.144
  • NLS_LANGUAGE initialization parameter 2.4.2.2
  • NLS_LOWER function 7.145
  • NLS_TERRITORY initialization parameter 2.4.2.2
  • NLS_UPPER function 7.146
  • NLSSORT function 7.147
  • NO_CLUSTERING hint 2.6.4.40
  • NO_EXPAND hint 2.6.4.41
  • NO_FACT hint 2.6.4.42
  • NO_GATHER_OPTIMIZER_STATISTICS hint 2.6.4.43
  • NO_INDEX_FFS hint 2.6.4.45
  • NO_INDEX_SS hint 2.6.4.46
  • NO_INDEX hint 2.6.4.44
  • NO_INMEMORY_PRUNING hint 2.6.4.48
  • NO_INMEMORY hint 2.6.4.47
  • NO_MERGE hint 2.6.4.49
  • NO_MONITOR hint 2.6.4.50
  • NO_PARALLEL_INDEX 2.6.4.54
  • NO_PARALLEL hint 2.6.4.52
  • NO_PQ_CONCURRENT_UNION hint 2.6.4.56
  • NO_PQ_SKEW hint 2.6.4.57
  • NO_PUSH_PRED hint 2.6.4.58
  • NO_PUSH_SUBQ hint 2.6.4.59
  • NO_PX_JOIN_FILTER hint 2.6.4.60
  • NO_QUERY_TRANSFORMATION hint 2.6.4.61
  • NO_RESULT_CACHE hint 2.6.4.62
  • NO_REWRITE hint 2.6.4.63
  • NO_STAR_TRANSFORMATION hint 2.6.4.65
  • NO_STATEMENT_QUEUING hint 2.6.4.66
  • NO_UNNEST hint 2.6.4.67
  • NO_USE_BAND hint 2.6.4.68
  • NO_USE_CUBE hint 2.6.4.69
  • NO_USE_HASH hint 2.6.4.70
  • NO_USE_MERGE hint 2.6.4.71
  • NO_USE_NL hint 2.6.4.72
  • NO_XML_QUERY_REWRITE hint 2.6.4.73
  • NO_XMLINDEX_REWRITE hint 2.6.4.74
  • NO_ZONEMAP hint 2.6.4.75
  • NOARCHIVELOG clause
    • of ALTER DATABASE 10.8
    • of CREATE CONTROLFILE 13.7
    • OF CREATE DATABASE 10.8, 13.8
  • NOAUDIT statement 19.2
  • NOCACHE clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of ALTER TABLE 15.4
    • of CREATE CLUSTER 13.5
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
    • of CREATE SEQUENCE 15.1
  • NOCACHE hint 2.6.4.39
  • NOCOMPRESS clause
    • of ALTER INDEX ... REBUILD 13.17
    • of CREATE TABLE 15.4
  • NOCOPY clause
    • of CREATE PLUGGABLE DATABASE 14.11
  • NOCYCLE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • NOFORCE clause
  • NO FORCE LOGGING clause
    • of ALTER DATABASE 10.8
    • of ALTER TABLESPACE 12.4
  • NOKEEP parameter
    • of CREATE SEQUENCE 15.1
  • NOLOGGING mode
    • and force logging mode 8.5
    • for nonpartitioned objects 8.5
    • for partitioned objects 8.5
  • NOMAXVALUE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • NOMINIMIZE RECORDS PER BLOCK clause
    • of ALTER TABLE 12.3
  • NOMINVALUE parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • NOMONITORING USAGE clause
  • NONE clause
  • nonempty subsets of 7.167
  • nonequivalency tests 6.14
  • nonschema objects
  • NOORDER parameter
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
    • of CREATE SEQUENCE 15.1
  • NOPARALLEL_INDEX hint 2.6.4.54
  • NOPARALLEL clause
  • NOPARALLEL hint 2.6.4.52
  • NORELY clause
    • of constraints 8.2
  • NORESETLOGS clause
    • of CREATE CONTROLFILE 13.7
  • NOREVERSE parameter
    • of ALTER INDEX ... REBUILD 10.16
  • NOREWRITE hint 2.6.4.63
  • NOROWDEPENDENCIES clause
    • of CREATE CLUSTER 13.5
    • of CREATE TABLE 15.4
  • NOSORT clause
  • NOT condition 6.4
  • NOT DEFERRABLE clause
    • of constraints 8.2
  • NOT IDENTIFIED clause
    • of ALTER ROLE. See CREATE ROLE 11.13
    • of CREATE ROLE 14.15
  • NOT IN subqueries
    • converting to NOT EXISTS subqueries 7.123
  • NOT NULL clause
    • of CREATE TABLE 15.4
  • NOWAIT clause
  • NTH_VALUE function 7.148
  • NTILE function 7.149
  • null 2.5
    • difference from zero 2.5
    • in conditions 2.5.3
    • in functions 7.1
    • with comparison conditions 2.5.2
  • null conditions 6.8
  • NULLIF function 7.150
    • as a form of CASE expression 7.150
  • NULL-related functions 7.2.16
  • NUMBER data type 2.1.1.2.1
  • number format models 2.4.1
  • number functions 7.2.1
  • numbers
  • numeric data type 2.1.1.2
  • numeric functions 7.2.1
  • numeric precedence 2.1.1.2.4
  • NUMTODSINTERVAL function 7.151
  • NUMTOYMINTERVAL function 7.152
  • NVARCHAR2 data type 2.1.1.1.5
  • NVL2 function 7.154
  • NVL function 7.153

O

  • OBJECT_ID pseudocolumn 3.5, 15.4, 15.11
  • OBJECT_VALUE pseudocolumn 3.6
  • object access expressions 5.13
  • OBJECT IDENTIFIER clause
    • of CREATE TABLE 15.4
  • object identifiers
  • object instances
  • object privileges
  • object reference functions 7.5
  • objects
    • See: object types or database objects
  • object tables
  • object type columns
    • defining properties
      • for materialized views 14.3
    • in a type hierarchy 15.4
    • membership in hierarchy 12.3
    • modifying properties
    • substitutability 12.3
  • object type materialized views
  • object types 2.1.4.1
    • associating statistics types with 12.11
    • attributes 2.9.5
      • in a type hierarchy 15.4
      • membership in hierarchy 12.3
      • substitutability 12.3
    • bodies
    • comparison rules 2.2.5
    • components of 2.1.4.1
    • creating 15.8
    • defining member methods of 15.9
    • disassociating statistics types from 15.13, 18.5
    • dropping the body of 18.6
    • dropping the specification of 18.5
    • granting system privileges for 18.12
    • identifiers 3.5
    • incomplete 15.8
    • methods 2.9.5
    • privileges on subtypes 18.12
    • references to. See REFs 2.1.4.2
    • statistics types 12.11
    • values of 3.6
  • object views 15.11
  • ODCIIndexInsert method
  • OF clause
  • of CREATE OPERATOR 14.6
  • OFFLINE clause
    • of ALTER TABLESPACE 12.4
    • of CREATE TABLESPACE 15.5
  • OFFSET
    • row_limiting_clause 19.9
  • OIDINDEX clause
    • of CREATE TABLE 15.4
  • OIDs
    • See: object identifiers
  • OLAP functions 7.7
  • ON clause
    • of CREATE OUTLINE 14.7
  • ON COMMIT clause
    • of CREATE TABLE 15.4
  • ON DEFAULT clause
  • ON DELETE CASCADE clause
    • of constraints 8.2
  • ON DELETE SET NULL clause
    • of constraints 8.2
  • ON DIRECTORY clause
  • online backup
    • of tablespaces, ending 12.4
  • ONLINE clause
    • of ALTER TABLESPACE 12.4
    • of CREATE INDEX 13.17
    • of CREATE TABLESPACE 15.5
  • online indexes 13.17
  • online redo logs
    • reinitializing 10.8
  • ON MINING MODEL clause
  • ON object clause
  • ON PREBUILT TABLE clause
    • of CREATE MATERIALIZED VIEW 14.3
  • OPEN clause
    • of ALTER DATABASE 10.8
  • OPEN READ ONLY clause
    • of ALTER DATABASE 10.8
  • OPEN READ WRITE clause
    • of ALTER DATABASE 10.8
  • operands 4
  • operating system files
  • operators 4
  • OPT_PARAM hint 2.6.4.77
  • OPTIMAL parameter
    • of STORAGE clause 8.9
  • ORA_DST_AFFECTED function 7.156
  • ORA_DST_CONVERT function 7.157
  • ORA_DST_ERROR function 7.158
  • ORA_HASH function 7.159
  • ORA_INVOKING_USER function 7.160
  • ORA_INVOKING_USERID function 7.161
  • ORA_ROWSCN pseudocolumn 3.7
  • Oracle ADVM volumes 10.12
  • Oracle Automatic Storage Management
    • migrating nodes in a cluster 12.2
  • Oracle Call Interface 1.5
  • Oracle reserved words E.1
  • Oracle Text
  • Oracle Tools
    • support of SQL 1.5
  • OR condition 6.4
  • ORDER BY clause
  • ORDER clause
    • of ALTER SEQUENCE. See CREATE SEQUENCE 11.15
  • ORDERED hint 2.6.4.78
  • ORDER parameter
    • of CREATE SEQUENCE 15.1
  • ORDER SIBLINGS BY clause
  • ordinal numbers
  • ORGANIZATION EXTERNAL clause
    • of CREATE TABLE 15.4
  • ORGANIZATION HEAP clause
    • of CREATE TABLE 15.4
  • ORGANIZATION INDEX clause
    • of CREATE TABLE 15.4
  • OR REPLACE clause
    • of CREATE CONTEXT 13.6
    • of CREATE DIRECTORY 13.11
    • of CREATE FUNCTION 13.15, 13.20
    • of CREATE LIBRARY 14.1
    • of CREATE OUTLINE 14.7
    • of CREATE PACKAGE 14.8
    • of CREATE PACKAGE BODY 14.9
    • of CREATE PROCEDURE 14.12
    • of CREATE TRIGGER 15.7
    • of CREATE TYPE 15.8
    • of CREATE TYPE BODY 15.9
    • of CREATE VIEW 15.11
  • outer joins 9.6.7
  • outlines
    • assigning to a different category 11.7, 11.8
    • assign to a different category 11.7
    • copying 14.7
    • creating 14.7
    • creating on statements 14.7
    • dropping from the database 17.7
    • enabling and disabling dynamically 14.7
    • for use by current session 14.7
    • for use by PUBLIC 14.7
    • granting system privileges for 18.12
    • private, use by the optimizer 11.16.2
    • rebuilding 11.7, 11.8
    • recompiling 11.7
    • renaming 11.7, 11.8
    • replacing 14.7
    • storing groups of 14.7
    • use by the optimizer 12.2
    • used to generate execution plans 14.7
    • use to generate execution plans 11.16.2
  • out-of-line constraints
    • of CREATE TABLE 15.4
  • OVER clause
    • of analytic functions 7.4
  • OVERFLOW clause

P

  • P.M. datetime format element 2.4.2.2
  • package bodies
    • creating 14.9
    • re-creating 14.9
    • removing from the database 17.8
  • packaged procedures
  • packages
    • associating statistics types with 12.11
    • creating 14.8
    • disassociating statistics types from 15.13, 17.8
    • redefining 14.8
    • removing from the database 17.8
    • synonyms for 15.3
  • PACKAGES clause
    • of ASSOCIATE STATISTICS 12.11
    • of DISASSOCIATE STATISTICS 15.13
  • PARALLEL_INDEX hint 2.6.4.80
  • PARALLEL clause
    • of ALTER CLUSTER 10.7
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 12.3
    • of CREATE CLUSTER 13.5
    • of CREATE INDEX 13.17
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
    • of CREATE TABLE 15.4
  • parallel execution 8.6
  • PARALLEL hint 2.6.4.79
  • parameter files
  • parameters
  • PARAMETERS clause
  • partial indexes 13.17
  • PARTITION ... LOB storage clause
    • of ALTER TABLE 12.3
  • PARTITION BY HASH clause
    • of CREATE TABLE 15.4
  • PARTITION BY LIST clause
    • of CREATE TABLE 15.4
  • PARTITION BY RANGE clause
    • of CREATE TABLE 15.4
  • PARTITION BY REFERENCE clause
    • of CREATE TABLE 15.4
  • PARTITION clause
  • partitioned indexes 2.9.4, 13.17
  • partitioned index-organized tables
    • secondary indexes, updating 10.16
  • partitioned tables 2.9.4
  • partition-extended table names
  • partitioning
  • partitions
    • adding 12.3
    • adding rows to 18.13
    • allocating extents for 12.3
    • based on literal values 15.4
    • composite
    • converting into nonpartitioned tables 12.3
    • deallocating unused space from 12.3
    • dropping 12.3
    • exchanging with tables 12.3
    • extents
      • allocating for an index 10.16
    • hash
    • index 13.17
    • inserting rows into 18.13
    • list, adding 12.3
    • LOB storage characteristics of 12.3
    • locking 18.14
    • logging attribute 15.4
    • logging insert operations 12.3
    • merging 12.3
    • modifying 12.3
    • physical attributes
    • range
    • removing rows from 12.3, 15.12
    • renaming 12.3
    • revising values in 19.15
    • splitting 12.3
    • storage characteristics 8.7
    • tablespace for
  • PASSWORD_GRACE_TIME parameter
  • PASSWORD_LIFE_TIME parameter
  • PASSWORD_LOCK_TIME parameter
  • PASSWORD_REUSE_MAX parameter
  • PASSWORD_REUSE_TIME parameter
  • PASSWORD_VERIFY_FUNCTION parameter
  • PASSWORD EXPIRE clause
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10
  • passwords
    • expiration of 15.10
    • grace period 14.13
    • guaranteeing complexity 14.13
    • limiting use and reuse 14.13
    • locking 14.13
    • making unavailable 14.13
    • parameters
      • of CREATE PROFILE 14.13
    • special characters in 15.10
  • PATH_VIEW 6.9.1, 6.9.2
  • PATH function 7.162
  • pattern-matching conditions 6.7
  • PCT_ACCESS_DIRECT statistics
    • for index-organized tables 12.10
  • PCTFREE parameter
    • of ALTER CLUSTER 10.7
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 12.3
    • of CREATE MATERIALIZED VIEW. See CREATE TABLE. 14.3
    • of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE. 14.4
    • of CREATE TABLE 8.7
  • PCTINCREASE parameter
    • of STORAGE clause 8.9
  • PCTTHRESHOLD parameter
    • of CREATE TABLE 15.4
  • PCTUSED parameter
    • of ALTER CLUSTER 10.7
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 12.3
    • of CREATE INDEX. See CREATE TABLE 13.17
    • of CREATE MATERIALIZED VIEW. See CREATE TABLE. 14.3
    • of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE. 14.4
    • of CREATE TABLE 8.7
  • PCTVERSION parameter
    • of LOB storage 15.4
    • of LOB storage clause 12.3
  • PDBs
    • administrative user 14.11
    • backup 11.9
    • changing
    • cloning 14.11
    • creating
      • by cloning a source PDB 14.11
      • using the seed database 14.11
    • default edition, setting 11.9
    • examples
    • generating file names 14.11
    • granting system privileges for 18.12
    • modifying data files 11.9
    • modifying temporary files 11.9
    • plugging into a CDB 14.11
    • recovery 11.9
    • setting the time zone of 11.9
    • storage limits 14.11
    • unplugging 11.9
    • XML file for plugging in 14.11
  • PERCENT_RANK function 7.163
  • PERCENTILE_CONT function 7.164
  • PERCENTILE_DISC function 7.165
  • PERMANENT clause
    • of ALTER TABLESPACE 12.4
  • physical attributes clause
    • of ALTER CLUSTER 10.7
    • of ALTER INDEX 10.16
    • of ALTER MATERIALIZED VIEW LOG 11.4
    • of ALTER TABLE 12.3
    • of CREATE CLUSTER 13.5
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE TABLE 15.4
  • physical standby database
    • activating 10.8
    • converting to snapshot standby database 10.8
  • pivot operations 19.9
  • placeholder expressions 5.14
  • PLAN_TABLE sample table 18.9
  • plan management
    • granting system privileges for 18.12
  • plan stability 14.7
  • pluggable databases
    • See: PDBs
  • PM datetime format element 2.4.2.2
  • POSIX regular expression standard D
  • POWER function 7.166
  • POWERMULTISET_BY_CARDINALITY function 7.168
  • POWERMULTISET function 7.167
  • PQ_CONCURRENT_UNION hint 2.6.4.81
  • PQ_DISTRIBUTE hint 2.6.4.82
  • PQ_FILTER hint 2.6.4.83
  • PQ_SKEW hint 2.6.4.84
  • precedence
  • precision
  • precompilers 1.5
  • predefined roles 18.12
  • PREDICTION_BOUNDS function 7.170
  • PREDICTION_COST function 7.171
  • PREDICTION_DETAILS function 7.172
  • PREDICTION_PROBABILITY function 7.173
  • PREDICTION_SET function 7.174
  • PREDICTION function 7.169
  • prefix compression 15.4
  • PREPARE TO SWITCHOVER clause
    • of ALTER DATABASE 10.8
  • PRESENTNNV function 7.175
  • PRESENTV function 7.176
  • pretty-printing of XML output 7.298
  • PREVIOUS function 7.177
  • primary database
    • converting to physical standby database 10.8
  • PRIMARY KEY clause
    • of constraints 8.2
    • of CREATE TABLE 15.4
  • primary key constraints 8.2
  • primary keys
    • generating values for 15.1
  • PRIOR clause
    • of hierarchical queries 9.3
  • PRIOR operator 4.5.1
  • PRIVATE_SGA parameter
    • of ALTER PROFILE 11.11
    • of ALTER RESOURCE COST 11.12
  • PRIVATE clause
    • of CREATE OUTLINE 14.7
  • private outlines
  • privileges 14.15
    • See also: system privileges or object privileges
    • on subtypes of object types 18.12
    • revoking from a grantee 19.6
  • procedures
  • PROFILE clause
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10
  • profiles
    • adding resource limits 11.11
    • assigning to a user 15.10
    • changing resource limits 11.11
    • creating 14.13
    • deassigning from users 17.11
    • dropping resource limits 11.11
    • granting system privileges for 18.12
    • modifying, examples 11.11
    • removing from the database 17.11
  • proxy clause
    • of ALTER USER 12.8
  • pseudocolumns 3
  • PUBLIC clause
    • of CREATE OUTLINE 14.7
    • of CREATE SYNONYM 15.3
    • of DROP DATABASE LINK 16.3
  • public database links
  • public synonyms 15.3
  • PURGE statement 19.4
  • PUSH_PRED hint 2.6.4.85
  • PUSH_SUBQ hint 2.6.4.86
  • PX_JOIN_FILTER hint 2.6.4.87

Q

  • QB_NAME hint 2.6.4.88
  • queries 9.1, 19.9
    • comments in 9.2
    • compound 9.5
    • correlated
      • left correlation 19.9
    • default locking of B.1
    • defined 9.1
    • distributed 9.10
    • grouping returned rows on a value 19.9
    • hierarchical, ordering 19.9
    • hierarchical. See hierarchical queries 9.3
    • hints in 9.2
    • join 9.6, 19.9
    • locking rows during 19.9
    • multiple versions of rows 19.9
    • of past data 19.9
    • ordering returned rows 19.9
    • outer joins in 19.9
    • referencing multiple tables 9.6
    • selecting all columns 19.9
    • selecting from a random sample of rows 19.9
    • select lists of 9.2
    • sorting results 9.5
    • syntax 9.1
    • top-level 9.1
    • top-N 3.9, 19.9
  • query rewrite
  • QUIESCE RESTRICTED clause
    • of ALTER SYSTEM 12.2
  • QUOTA clause
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10

R

  • range conditions 6.12
  • range partitioning
    • converting to interval partitioning 12.3
  • range partitions
  • RANK function 7.178
  • RATIO_TO_REPORT function 7.179
  • RAW data type 2.1.1.5
    • converting from CHAR data 2.1.1.5
  • RAWTOHEX function 7.180
  • RAWTONHEX function 7.181
  • READ ANY TABLE system privilege 18.12
  • READ object privilege
  • READ ONLY clause
    • of ALTER TABLESPACE 12.4
    • of ALTER VIEW 12.9
  • READ WRITE clause
    • of ALTER TABLESPACE 12.4
    • of ALTER VIEW 12.9
  • REBUILD clause
  • REBUILD PARTITION clause
  • REBUILD SUBPARTITION clause
  • REBUILD UNUSABLE LOCAL INDEXES clause
    • of ALTER TABLE 12.3
  • RECOVERABLE 10.16, 15.4
    • See also: LOGGING clause
  • RECOVER AUTOMATIC clause
    • of ALTER DATABASE 10.8
  • RECOVER CANCEL clause
    • of ALTER DATABASE 10.8
  • RECOVER clause
    • of ALTER DATABASE 10.8
  • RECOVER CONTINUE clause
    • of ALTER DATABASE 10.8
  • RECOVER DATABASE clause
    • of ALTER DATABASE 10.8
  • RECOVER DATAFILE clause
    • of ALTER DATABASE 10.8
  • RECOVER LOGFILE clause
    • of ALTER DATABASE 10.8
  • RECOVER MANAGED STANDBY DATABASE clause
    • of ALTER DATABASE 10.8
  • RECOVER TABLESPACE clause
    • of ALTER DATABASE 10.8
  • recovery
    • discarding data 10.8
    • distributed, enabling 12.2
    • instance, continue after interruption 10.8
    • media, designing 10.8
    • media, performing ongoing 10.8
    • of database 10.8
  • recovery clauses
    • of ALTER DATABASE 10.8
  • recursive subquery factoring 19.9
  • recycle bin
    • purging objects from 19.4
  • redo log files
    • specifying 8.4
    • specifying for a control file 13.7
  • redo logs 10.8
    • adding 10.8
    • applying to logical standby database 10.8
    • archive location 12.2
    • automatic archiving 12.2
    • automatic name generation 10.8
    • clearing 10.8
    • dropping 10.8
    • enabling and disabling thread 10.8
    • manual archiving 12.2
    • members
      • adding to existing groups 10.8
      • dropping 10.8
      • renaming 10.8
    • remove changes from 10.8
    • reusing 8.4
    • size of 8.4
    • specifying 8.4, 13.8
      • for media recovery 10.8
    • specifying archive mode 13.8
    • switching groups 12.2
  • REF columns
    • rescoping 11.3
    • specifying 15.4
    • specifying from table or column 15.4
  • REF constraints
    • defining scope, for materialized views 11.3
    • of ALTER TABLE 12.3
  • reference-partitioned tables 12.3
    • maintenance operations 12.3
  • reference partitioning 15.4
  • REFERENCES clause
    • of CREATE TABLE 15.4
  • referential integrity constraints 8.2
  • REF function 7.182
  • REFRESH clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • REFRESH COMPLETE clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • REFRESH FAST clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • REFRESH FORCE clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • REFRESH ON COMMIT clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • REFRESH ON DEMAND clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • REFs 2.1.4.2, 8.2
  • REFTOHEX function 7.183
  • REGEXP_COUNT function 7.184
  • REGEXP_INSTR function 7.185
  • REGEXP_LIKE condition 6.7.2
  • REGEXP_REPLACE function 7.186
  • REGEXP_SUBSTR function 7.187
  • REGISTER clause
    • of ALTER SYSTEM 12.2
  • REGISTER LOGFILE clause
    • of ALTER DATABASE 10.8
  • REGR_AVGX function 7.188
  • REGR_AVGY function 7.188
  • REGR_COUNT function 7.188
  • REGR_INTERCEPT function 7.188
  • REGR_R2 function 7.188
  • REGR_SLOPE function 7.188
  • REGR_SXX function 7.188
  • REGR_SXY function 7.188
  • REGR_SYY function 7.188
  • regular expressions
    • multilingual syntax D.1
    • operators, multilingual enhancements D.2
    • Oracle support of D
    • Perl-influenced operators D.3
    • subexpressions 7.185, 7.187
  • relational tables
  • RELY clause
    • of constraints 8.2
  • REMAINDER function 7.189
  • RENAME clause
    • of ALTER INDEX 10.16
    • of ALTER OUTLINE 11.7
    • of ALTER TABLE 12.3
    • of ALTER TABLESPACE 12.4
    • of ALTER TRIGGER 12.6
  • RENAME CONSTRAINT clause
    • of ALTER TABLE 12.3
  • RENAME DATAFILE clause
    • of ALTER TABLESPACE 12.4
  • RENAME FILE clause
    • of ALTER DATABASE 10.8
  • RENAME GLOBAL_NAME clause
    • of ALTER DATABASE 10.8
    • of ALTER PLUGGABLE DATABASE 11.9
  • RENAME PARTITION clause
  • RENAME statement 19.5
  • RENAME SUBPARTITION clause
  • REPLACE function 7.190
  • replication
    • row-level dependency tracking 13.5, 15.4
  • reserved words 2.8.1, E.1
  • RESETLOGS parameter
    • of CREATE CONTROLFILE 13.7
  • reset sequence of 10.8
  • RESOLVE clause
  • RESOLVER clause
  • RESOURCE_VIEW 6.9.1, 6.9.2
  • Resource Manager 12.2
  • resource parameters
    • of CREATE PROFILE 14.13
  • response time
  • restore points
    • guaranteed 14.14
    • preserved 14.14
    • using
      • to flash back a table 18.11
      • to flashback the database 18.10
  • RESULT_CACHE hint 2.6.4.89
  • result cache 15.4
  • resumable space allocation 11.16
  • RESUME clause
    • of ALTER SYSTEM 12.2
  • RETENTION parameter
    • of LOB storage 15.4
  • RETRY_ON_ROW_CHANGE hint 2.6.4.90
  • RETURNING clause
  • REUSE clause
    • of CREATE CONTROLFILE 13.7
    • of file specifications 8.4
  • REVERSE clause
  • reverse indexes 13.17
  • REVERSE parameter
    • of ALTER INDEX ... REBUILD 10.16
  • REVOKE CONNECT THROUGH clause
    • of ALTER USER 12.8
  • REVOKE statement 19.6
  • REWRITE hint 2.6.4.91
  • right outer joins 19.9
  • roles 18.12
    • authorization
      • by an external service 14.15
      • by a password 14.15
      • by the database 14.15
      • by the enterprise directory service 14.15
      • changing 11.13
    • creating 14.15
    • disabling
      • for the current session 19.11
    • enabling
      • for the current session 19.11
    • granting 18.12
    • identifying by password 14.15
    • identifying externally 14.15
    • identifying through enterprise directory service 14.15
    • identifying using a package 14.15
    • removing from the database 17.13
    • revoking 19.6
  • ROLES clause
    • of CREATE PLUGGABLE DATABASE 14.11
  • rollback segments
    • removing from the database 17.14
    • specifying optimal size of 8.9
  • rollback segments granting
    • system privileges for 18.12
  • ROLLBACK statement 19.7
  • rollback undo 11.14, 13.8
  • ROLLUP clause
    • of SELECT statements 19.9
  • ROUND (date) function 7.191
  • ROUND (number) function 7.192
  • routines
  • ROW_NUMBER function 7.194
  • row constructor 5.17
  • ROWDEPENDENCIES clause
    • of CREATE CLUSTER 13.5
    • of CREATE TABLE 15.4
  • ROW EXCLUSIVE lock mode 18.14
  • ROWID data type 2.1.2, 2.1.2.1
  • ROWID pseudocolumn 2.1.2, 2.1.2.2, 3.8
  • rowids 2.1.2
  • ROWIDTOCHAR function 7.195
  • ROWIDTONCHAR function 7.196
  • row-level dependency tracking 13.5, 15.4
  • row-level locking B.1
  • row limiting 19.9
  • row locking B.1
  • ROWNUM pseudocolumn 3.9
  • rows
    • adding to a table 18.13
    • allowing movement of between partitions 15.4
    • inserting
      • into partitions 18.13
      • into remote databases 18.13
      • into subpartitions 18.13
    • locking B.1
    • locks on B.1
    • movement between partitions 15.4
    • removing
    • selecting in hierarchical order 9.3
    • specifying constraints on 8.2
    • storing if in violation of constraints 12.3
  • ROW SHARE lock mode 18.14
  • row value constructor 5.17
  • row values
    • pivoting into columns 19.9
  • RPAD function 7.197
  • RR datetime format element 2.4.2.4
  • RTRIM function 7.198
  • run-time compilation

S

T

  • TABLE clause
  • TABLE collection expression 19.9
  • table compression 11.3, 12.3, 14.3, 15.4
    • Advanced Row Compression 15.4
    • basic 15.4
    • during bulk load operations 15.4
    • for archiving data 15.4
    • Hybrid Columnar 15.4
  • table locks
  • table partitions
  • table REF constraints 8.2
    • of CREATE TABLE 15.4
  • tables
    • adding a constraint to 12.3
    • adding rows to 18.13
    • aliases 2.9.5
    • allocating extents for 12.3
    • assigning to a cluster 15.4
    • changing degree of parallelism on 12.3
    • changing existing values in 19.15
    • collecting statistics on 12.10
    • comments on 12.15
    • compression of 12.3, 15.4
    • creating 15.4
    • creating comments about 12.15
    • data stored outside database 15.4
    • deallocating unused space from 12.3
    • default physical attributes
    • degree of parallelism
    • disassociating statistics types from 18.1
    • dropping
    • enabling tracking 15.4
    • external 15.4
    • externally organized 15.4
    • flashing back to an earlier version 18.11
    • granting system privileges for 18.12
    • heap organized 15.4
    • index-organized 15.4
      • overflow segment for 15.4
      • space in index block 15.4
    • inserting rows with a subquery 15.4
    • inserting using the direct-path method 18.13
    • joining in a query 19.9
    • LOB storage of 8.7
    • locking 18.14
    • logging
      • insert operations 12.3
      • table creation 15.4
    • migrated and chained rows in 12.10
    • moving 12.3
    • moving, index-organized 12.3
    • moving to a new segment 12.3
    • nested
      • storage characteristics 15.4
    • object
    • of XMLType, creating 15.4
    • organization, defining 15.4
    • parallel creation of 15.4
    • parallelism
      • setting default degree 15.4
    • partition attributes of 12.3
    • partitioning 2.9.4, 15.4
      • allowing rows to move between partitions 12.3
      • default attributes of 12.3
    • physical attributes
    • purging from the recycle bin 19.4
    • read/write mode 12.3
    • read-only mode 12.3
    • reference-partitioned 12.3, 15.4
    • relational
    • remote, accessing 13.9
    • removing from the database 18.1
    • removing rows from 15.12
    • renaming 12.3, 19.5
    • restricting
      • records in a block 12.3
    • retrieving data from 19.9
    • saving blocks in a cache 15.4
    • SQL examples 15.4
    • storage attributes
    • storage characteristics
    • storage properties of 15.4
    • subpartition attributes of 12.3
    • synonyms for 15.3
    • tablespace for
    • temporary
      • duration of data 15.4
      • session-specific 15.4
      • transaction specific 15.4
    • unclustering 15.17
    • updating through views 15.11
    • validating structure 12.10
    • XMLType, querying 15.4
  • TABLESPACE clause
    • of ALTER INDEX ... REBUILD 10.16
    • of CREATE CLUSTER 13.5
    • of CREATE INDEX 13.17
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
    • of CREATE TABLE 15.4
  • tablespaces
    • allocating space for users 15.10
    • allowing write operations on 12.4
    • automatic segment-space management 15.5
    • backing up data files 12.4
    • bigfile 15.5
    • bringing online 12.4, 15.5
    • coalescing free extents 12.4
    • converting
      • from permanent to temporary 12.4
      • from temporary to permanent 12.4
    • creating 15.5
    • data files
    • default 10.8
      • specifying for a user 12.8
    • default permanent 13.8
    • default temporary 10.8
      • learning name of 10.8
    • designing media recovery 10.8
    • dropping contents 18.2
    • encrypting 8.9
    • ending online backup 12.4
    • extent size 15.5
    • granting system privileges for 18.12
    • in FLASHBACK mode 12.4, 15.5
    • in FORCE LOGGING mode 12.4, 15.5
    • locally managed 8.9
    • logging attribute 12.4, 15.5
    • managing extents of 15.5
    • read only 12.4
    • reconstructing lost or damaged 10.8
    • recovering 10.8
    • removing from the database 18.2
    • renaming 12.4
    • size of free extents in 12.4
    • smallfile 15.5
    • specifying
    • taking offline 12.4, 15.5
    • temp files
    • temporary
    • undo
  • TAN function 7.233
  • TANH function 7.234
  • TDE
    • See: Transparent Data Encryption
  • TEMPFILE clause
    • of ALTER DATABASE 10.8
  • temp files
  • TEMPORARY clause
    • of ALTER TABLESPACE 12.4
    • of CREATE TABLESPACE 15.5
  • temporary tables
    • creating 15.4
    • session-specific 15.4
    • transaction-specific 15.4
  • TEMPORARY TABLESPACE clause
    • of ALTER USER 12.8
    • of ALTER USER. See CREATE USER 12.8
    • of CREATE USER 15.10
  • temporary tablespace groups
    • reassigning for a user 12.8
    • specifying for a user 15.10
  • temporary tablespaces
    • creating 15.5
    • default 10.8
    • specifying extent management during database creation 13.8
    • specifying for a user 12.8, 15.10
  • TEST clause
    • of ALTER DATABASE ... RECOVER 10.8
  • testing for a set 6.6.1
  • text
    • date and number formats 2.4
    • literals
    • properties of CHAR and VARCHAR2 data types 2.3.1
    • syntax of 2.3.1
  • text literals
    • conversion to database character set 2.3.1
  • TH datetime format element suffix 2.4.2.5
  • throughput
  • THSP datetime format element suffix 2.4.2.5
  • TIME_ZONE session parameter 11.16.2
  • TIME data type
  • time format models
  • timestamp
    • converting to local time zone 5.8
  • TIMESTAMP_TO_SCN function 7.235
  • TIMESTAMP data type 2.1.1.4.2
  • TIMESTAMP WITH LOCAL TIME ZONE data type 2.1.1.4.4
  • TIMESTAMP WITH TIME ZONE data type 2.1.1.4.3
  • time zone
    • changing time zone data file 7.156
    • converting data to particular 5.8
    • determining for session 7.200
    • formatting 2.4.2.1.2
    • setting for the database 13.8
  • TO_APPROX_COUNT_DISTINCT function 7.236
  • TO_APPROX_PERCENTILE function 7.237
  • TO_BINARY_DOUBLE function 7.238
  • TO_BINARY_FLOAT function 7.239
  • TO_BLOB (bfile) function 7.240
  • TO_BLOB (raw) function 7.241
  • TO_CHAR (bfile|blob) function 7.242
  • TO_CHAR (character) function 7.243
  • TO_CHAR (datetime) function 7.244
  • TO_CHAR (number) function 7.245
  • TO_CLOB (bfile|blob) function 7.246
  • TO_CLOB (character) function 7.247
  • TO_DATE function 7.248
  • TO_DSINTERVAL function 7.249
  • TO_LOB function 7.250
  • TO_MULTI_BYTE function 7.251
  • TO_NCHAR (character) function 7.252
  • TO_NCHAR (datetime) function 7.253
  • TO_NCHAR (number) function 7.254
  • TO_NCLOB function 7.255
  • TO_NUMBER function 7.256
  • TO_SINGLE_BYTE function 7.257
  • TO_TIMESTAMP_TZ function 7.259
  • TO_TIMESTAMP function 7.258
  • TO_YMINTERVAL function 7.261
  • top-level SQL statements 12.12
  • top-N reporting 3.9, 7.76, 7.178, 7.194, 19.9
  • TO SAVEPOINT clause
  • tracking
  • transaction control statements 10.1.3
  • transactions
  • TRANSLATE ... USING function 7.263
  • TRANSLATE function 7.262
  • TRANSLATE SQL object privilege
  • Transparent Data Encryption 15.4
  • TREAT function 7.264
  • triggers
  • TRIM function 7.265
  • TRUNC (date) function 7.266
  • TRUNC (number) function 7.267
  • TRUNCATE_CLUSTER statement 19.13
  • TRUNCATE_TABLE statement 19.14
  • TRUNCATE PARTITION clause
    • of ALTER TABLE 12.3
  • TRUNCATE SUBPARTITION clause
    • of ALTER TABLE 12.3
  • type constructor expressions 5.16
  • types
    • See: object types or data types
  • TYPES clause
    • of ASSOCIATE STATISTICS 12.11
    • of DISASSOCIATE STATISTICS 15.13
  • TZ_OFFSET function 7.268

U

  • UID function 7.269
  • unary operators 4.1.1
  • UNDER_PATH condition 6.9.2
  • UNDER object privilege
  • undo
  • UNDO_RETENTION initialization parameter
    • setting with ALTER SYSTEM 18.11
  • UNDO tablespace clause
    • of CREATE DATABASE 13.8
    • of CREATE TABLESPACE 15.5
  • undo tablespaces
  • unified auditing
    • ALTER AUDIT POLICY statement 10.6
    • AUDIT statement 12.13
    • CREATE AUDIT POLICY statement 13.4
    • DROP AUDIT POLICY statement 15.16
    • NOAUDIT statement 19.3
  • unified audit policies
  • UNIFORM clause
    • of CREATE TABLESPACE 15.5
  • UNION ALL set operator 4.6
  • UNION set operator 4.6
  • UNIQUE clause
  • unique constraints
  • unique elements of 7.201
  • unique indexes 13.17
  • unique queries 19.9
  • UNISTR function 7.270
  • universal rowids
    • See: urowids
  • UNNEST hint 2.6.4.94
  • unnesting collections 19.9
  • unnesting subqueries 9.8
  • unpivot operations 19.9
  • UNQUIESCE clause
    • of ALTER SYSTEM 12.2
  • UNRECOVERABLE 10.16, 15.4
    • See also: NOLOGGING clause
  • unsorted indexes 13.17
  • UNUSABLE clause
  • UNUSABLE LOCAL INDEXES clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER TABLE 12.3
  • UPDATE BLOCK REFERENCES clause
  • UPDATE GLOBAL INDEXES clause
    • of ALTER TABLE 12.3
  • update operations
    • collecting supplemental log data for 10.8
  • updates
    • and simultaneous insert 19.1
    • using MERGE 19.1
  • UPDATE SET clause
  • UPDATE statement 19.15
  • UPGRADE clause
    • of ALTER DATABASE 10.8
    • of ALTER TABLE 12.3
  • UPPER function 7.271
  • URLs
  • UROWID data type 2.1.2.2
  • urowids
  • USABLE clause
  • USE_BAND hint 2.6.4.95
  • USE_CONCAT hint 2.6.4.96
  • USE_CUBE hint 2.6.4.97
  • USE_HASH hint 2.6.4.98
  • USE_MERGE hint 2.6.4.99
  • USE_NL_WITH_INDEX hint 2.6.4.101
  • USE_NL hint 2.6.4.100
  • USE_PRIVATE_OUTLINES session parameter 11.16.2
  • USE_STORED_OUTLINES session parameter 11.16.2, 12.2
  • USE object privilege
    • on a SQL translation profile 18.12
  • USER_COL_COMMENTS data dictionary view 12.15
  • USER_INDEXTYPE_COMMENTS data dictionary view 12.15
  • USER_MVIEW_COMMENTS data dictionary view 12.15
  • USER_OPERATOR_COMMENTS data dictionary view 12.15
  • USER_TAB_COMMENTS data dictionary view 12.15
  • user-defined functions 7.302
  • user-defined operators 4.8
  • user-defined statistics
  • user-defined types 2.1.4
  • USERENV function 7.273
  • USERENV namespace 7.223
  • USER function 7.272
  • user groups
    • adding or dropping a member 10.12
    • adding to a disk group 10.12
    • dropping from a disk group 10.12
  • users
  • USER SYS clause
    • of CREATE DATABASE 13.8
  • USER SYSTEM clause
    • of CREATE DATABASE 13.8
  • USING BFILE clause
  • USING BLOB clause
  • USING clause
    • of ALTER INDEXTYPE 10.17
    • of ASSOCIATE STATISTICS 12.11
    • of CREATE DATABASE LINK 13.9
    • of CREATE INDEXTYPE 13.18
    • of CREATE PLUGGABLE DATABASE 14.11
  • USING CLOB clause
  • USING INDEX clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of ALTER TABLE 12.3
    • of constraints 8.2
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE TABLE 15.4
  • USING NO INDEX clause
    • of CREATE MATERIALIZED VIEW 14.3
  • USING ROLLBACK SEGMENT clause
    • of ALTER MATERIALIZED VIEW ... REFRESH 11.3
    • of CREATE MATERIALIZED VIEW 14.3
  • UTC
    • extracting from a datetime value 7.225
  • UTC offset
    • replacing with time zone region name 2.3.3
  • UTLCHN.SQL script 12.10
  • UTLEXPT1.SQL script 12.3
  • UTLXPLAN.SQL script 18.9

V

  • VALIDATE_CONVERSION function 7.274
  • VALIDATE clause
  • VALIDATE REF UPDATE clause
  • VALIDATE STRUCTURE clause
  • validation
  • VALUE function 7.275
  • VALUES clause
  • VALUES LESS THAN clause
    • of CREATE TABLE 15.4
  • VAR_POP function 7.276
  • VAR_SAMP function 7.277
  • VARCHAR2 data type 2.1.1.1.3
    • converting to NUMBER 2.4.1
  • VARCHAR data type 2.1.1.1.4
  • VARGRAPHIC data type
  • VARIANCE function 7.278
  • VARRAY clause
    • of ALTER TABLE 12.3
  • VARRAY column properties
    • of ALTER TABLE 12.3
    • of CREATE MATERIALIZED VIEW 14.3
    • of CREATE TABLE 15.4
  • varrays 2.1.4.3
    • changing returned value 12.3
    • compared with nested tables 2.2.6
    • comparison rules 2.2.6
    • creating 15.8
    • dropping the body of 18.6
    • dropping the specification of 18.5
    • modifying column properties 12.3
    • storage characteristics 12.3, 15.4
    • storing out of line 2.1.4.3
  • varying arrays
    • See: varrays
  • version queries
    • pseudocolumns for 3.3
  • view constraints 8.2, 15.11
    • and materialized views 8.2
    • dropping 18.8
    • modifying 12.9
  • views
    • base tables
    • changing
      • definition 18.8
      • values in base tables 19.15
    • creating
    • definer’s rights 15.11
    • defining 15.11
    • dropping constraints on 12.9
    • editioning 15.11
    • granting system privileges for 18.12
    • invoker’s rights 15.11
    • modifying constraints on 12.9
    • object, creating 15.11
    • recompiling 12.9
    • re-creating 15.11
    • remote, accessing 13.9
    • removing
      • from the database 18.8
      • rows from the base table of 15.12
    • renaming 19.5
    • retrieving data from 19.9
    • subquery of 15.11
    • synonyms for 15.3
    • updatable 15.11
    • with joins
      • and key-preserved tables 15.11
      • making updatable 15.11
    • XMLType 15.11
    • XMLType, creating 15.11
    • XMLType, querying 15.11
  • virtual columns
  • VSIZE function 7.279

W

  • WHENEVER SUCCESSFUL clause
    • of AUDIT sql_statements 12.12
  • WHERE clause
  • WIDTH_BUCKET function 7.280
  • WITH ... AS clause
  • WITH ADMIN OPTION clause
  • WITH CHECK OPTION clause
  • WITH clause
  • WITH GRANT OPTION clause
  • WITH HIERARCHY OPTION
  • WITH INDEX CONTEXT clause
    • of CREATE OPERATOR 14.6
  • WITH OBJECT ID clause
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • WITH PRIMARY KEY clause
    • of ALTER MATERIALIZED VIEW 11.3
    • of CREATE MATERIALIZED VIEW ... REFRESH 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • WITH READ ONLY clause
  • WITH ROWID clause
    • of column ref constraints 8.2
    • of CREATE MATERIALIZED VIEW ... REFRESH 14.3
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • WITH SEQUENCE clause
    • of CREATE MATERIALIZED VIEW LOG 14.4
  • WRITE clause

X

  • XML
    • conditions 6.9
    • data
    • database repository
    • documents
      • producing from XML fragments 7.229
      • retrieving from the database 7.224
    • examples F.2
    • format models 2.4.5
    • fragments 7.84
    • functions 7.2.13
  • XMLAGG function 7.281
  • XMLCAST function 7.282
  • XMLCDATA function 7.283
  • XMLCOLATTVAL function 7.284
  • XMLCOMMENT function 7.285
  • XMLCONCAT function 7.286
  • XMLDATA pseudocolumn 3.10
  • XMLDIFF function 7.287
  • XMLELEMENT function 7.288
  • XMLEXISTS function 7.289
  • XMLFOREST function 7.290
  • XMLGenFormatType object 2.4.5
  • XMLIndex
  • XMLISVALID function 7.291
  • XMLPARSE function 7.292
  • XMLPATCH function 7.293
  • XMLPI function 7.294
  • XMLQUERY function 7.295
  • XMLROOT function 7.296
  • XMLSchemas
    • adding to a table 15.4
    • single and multiple 15.4
  • XMLSEQUENCE function 7.297
  • XMLSERIALIZE function 7.298
  • XMLTABLE function 7.299
  • XMLTRANSFORM function 7.300
  • XMLType columns
  • XMLType storage clause
    • of CREATE TABLE 15.4
  • XMLType tables
  • XMLType views 15.11

Z

  • zone maps
    • creating 14.5
    • modifying 11.5
    • removing from the database 17.5