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