Index
A B C D E F G H I J K L M N O P Q R S T U V W X Z
Symbols
- % (percent) used with LIKE operator, 6.16
- + (plus sign)
-
- in Automatic Storage management filenames, 8
Numerics
- 20th century, 2.4.2.4
- 21st century, 2.4.2.4
A
- ABORT LOGICAL STANDBY clause
-
- of ALTER DATABASE, 10.2
- ABS function, 7.2
- ACCESSED GLOBALLY clause
-
- of CREATE CONTEXT, 14
- ACCOUNT LOCK clause
-
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
- ACCOUNT UNLOCK clause
-
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
- ACOS function, 7.3
- ACTIVATE STANDBY DATABASE clause
-
- of ALTER DATABASE, 10.2
- active session history, 11
- ACTIVE_INSTANCE_COUNT initialization parameter
-
- setting with ALTER SYSTEM, 11
- AD datetime format element, 2.4.2.2, 2.4.2.2
- ADD clause
-
- of ALTER DIMENSION, 10.2
- of ALTER INDEXTYPE, 10.2
- of ALTER TABLE, 12
- of ALTER VIEW, 13
- ADD DATAFILE clause
-
- of ALTER TABLESPACE, 12
- ADD LOGFILE clause
-
- of ALTER DATABASE, 10.2
- ADD LOGFILE GROUP clause
-
- of ALTER DATABASE, 10.2
- ADD LOGFILE MEMBER clause
-
- of ALTER DATABASE, 10.2, 10.2
- ADD LOGFILE THREAD clause
-
- of ALTER DATABASE, 10.2, 10.2
- ADD OVERFLOW clause
-
- of ALTER TABLE, 12
- ADD PARTITION clause
-
- of ALTER TABLE, 12, 12, 12
- ADD PRIMARY KEY clause
-
- of ALTER MATERIALIZED VIEW LOG, 11
- ADD ROWID clause
-
- of ALTER MATERIALIZED VIEW, 11
- of ALTER MATERIALIZED VIEW LOG, 11
- ADD SUPPLEMENTAL LOG DATA clause
-
- of ALTER DATABASE, 10.2
- ADD SUPPLEMENTAL LOG GROUP clause
-
- of ALTER TABLE, 12
- ADD TEMPFILE clause
-
- of ALTER TABLESPACE, 12
- ADD VALUES clause
-
- of ALTER TABLE ... MODIFY PARTITION, 12
- ADD_MONTHS function, 7.4
- adding a constraint, 12
- ADMINISTER ANY SQL TUNING SET system privilege, 18
- ADMINISTER DATABASE TRIGGER system privilege, 18
- ADMINISTER SQL TUNING SET system privilege, 18
- ADVISE clause
-
- of ALTER SESSION, 11
- ADVISOR system privilege, 18
- AFTER clause
-
- of CREATE TRIGGER, 16
- AFTER triggers, 16
- AGENT clause
-
- of CREATE LIBRARY, 15
- aggregate functions, 7.1.2
-
- user-defined, creating, 14
- alias
-
- for a column, 9.2
- for an expressions in a view query, 17
- specifying in queries and subqueries, 19
- ALL clause
-
- of SELECT, 19
- of SET CONSTRAINTS, 19
- of SET ROLE, 19
- ALL EXCEPT clause
-
- of SET ROLE, 19
- ALL operator, 6.2
- ALL PRIVILEGES clause
-
- of GRANT, 18
- of REVOKE, 18
- ALL PRIVILEGES shortcut
-
- of AUDIT, 13
- ALL shortcut
-
- of AUDIT, 13
- ALL_COL_COMMENTS data dictionary view, 13
- ALL_INDEXTYPE_COMMENTS data dictionary view, 13
- ALL_MVIEW_COMMENTS data dictionary view, 13
- ALL_OPERATOR_COMMENTS data dictionary view, 13
- ALL_TAB_COMMENTS data dictionary view, 13
- ALLOCATE EXTENT clause
-
- of ALTER CLUSTER, 10.2, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW, 11
- of ALTER TABLE, 12
- ALLOW CORRUPTION clause
-
- of ALTER DATABASE ... RECOVER, 10.2
- ALTER ANY CLUSTER system privilege, 18
- ALTER ANY DIMENSION system privilege, 18
- ALTER ANY INDEX system privilege, 18
- ALTER ANY INDEXTYPE system privilege, 18
- ALTER ANY MATERIALIZED VIEW system privilege, 18
- ALTER ANY OPERATOR system privilege, 18
- ALTER ANY OUTLINE system privilege, 18
- ALTER ANY PROCEDURE system privilege, 18
- ALTER ANY ROLE system privilege, 18
- ALTER ANY SEQUENCE system privilege, 18
- ALTER ANY SQL PROFILE system privilege, 18
- ALTER ANY TABLE system privilege, 18
- ALTER ANY TRIGGER system privilege, 18
- ALTER ANY TYPE system privilege, 18
- ALTER CLUSTER statement, 10.2
- ALTER DATABASE statement, 10.2
- ALTER DATABASE system privilege, 18
- ALTER DIMENSION statement, 10.2
- ALTER DISKGROUP statement, 10.2
- ALTER FUNCTION statement, 10.2
- ALTER INDEX statement, 10.2
- ALTER INDEXTYPE statement, 10.2
- ALTER JAVA CLASS statement, 10.2
- ALTER JAVA SOURCE statement, 10.2
- ALTER MATERIALIZED VIEW LOG statement, 11
- ALTER MATERIALIZED VIEW statement, 11
- ALTER object privilege, 18
-
- on a sequence, 18
- on a table, 18
- ALTER OPERATOR statement, 11
- ALTER OUTLINE statement, 11
- ALTER PACKAGE statement, 11
- ALTER PROCEDURE statement, 11
- ALTER PROFILE statement, 11
- ALTER PROFILE system privilege, 18
- ALTER RESOURCE COST statement, 11
- ALTER RESOURCE COST system privilege, 18
- ALTER ROLE statement, 11
- ALTER ROLLBACK SEGMENT statement, 11
- ALTER ROLLBACK SEGMENT system privilege, 18
- ALTER SEQUENCE statement, 11
- ALTER SESSION statement, 11
- ALTER SESSION system privilege, 18
- ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG
- ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW
- ALTER statements
-
- triggers on, 16
- ALTER SYSTEM statement, 11
- ALTER SYSTEM system privilege, 18
- ALTER TABLE statement, 12
- ALTER TABLESPACE statement, 12
- ALTER TABLESPACE system privilege, 18
- ALTER TRIGGER statement, 13
- ALTER TYPE statement, 13
- ALTER USER statement, 13
- ALTER USER system privilege, 18
- ALTER VIEW statement, 13
- alter_external_table_clause
-
- of ALTER TABLE, 12
- AM datetime format element, 2.4.2.2, 2.4.2.2
- American National Standards Institute (ANSI), B
-
- datatypes, 2.1.2
-
- conversion to Oracle datatypes, 2.1.2
- standards, 1.2, 1.2, B.1
- supported datatypes, 2.1
- analytic functions, 7.1.3
-
- AVG, 7.10
- CORR, 7.24
- COUNT, 7.28
- COVAR_POP, 7.29
- COVAR_SAMP, 7.30
- CUME_DIST, 7.31
- DENSE_RANK, 7.38
- FIRST, 7.48
- FIRST_VALUE, 7.49
- inverse distribution, 7.100, 7.101
- LAG, 7.60
- LAST, 7.61
- LAST_VALUE, 7.63
- LEAD, 7.64
- linear regression, 7.117
- MAX, 7.75
- MIN, 7.77
- NTILE, 7.91
- OVER clause, 7.1.3
- PERCENT_CONT, 7.100
- PERCENT_DISC, 7.101
- PERCENT_RANK, 7.99
- RANK, 7.108
- RATIO_TO_REPORT, 7.109
- ROW_NUMBER, 7.122
- STDDEV, 7.144
- STDDEV_POP, 7.145
- STDDEV_SAMP, 7.146
- SUM, 7.148
- syntax, 7.1.3
- user-defined, 14
- VAR_POP, 7.195
- VAR_SAMP, 7.196
- VARIANCE, 7.197
- ANALYZE ANY system privilege, 18
- ANALYZE CLUSTER statement, 13
- ANALYZE INDEX statement, 13
- ANALYZE TABLE statement, 13
- ANCILLARY TO clause
-
- of CREATE OPERATOR, 15
- AND condition, 6.4, 6.4
- AND DATAFILES clause
-
- of DROP TABLESPACE, 18
- ANSI. See American National Standards Institute (ANSI)
- antijoins, 9.6.7
- ANY operator, 6.2
- application servers
-
- allowing connection as user, 13
- applications
-
- allowing connection as user, 13
- securing, 14
- validating, 14
- AQ_ADMINISTRATOR_ROLE role, 18
- AQ_TM_PROCESSES initialization parameter
-
- setting with ALTER SYSTEM, 11
- AQ_USER_ROLE role, 18
- ARCHIVE LOG clause
-
- of ALTER SYSTEM, 11
- archive logs
-
- applying to standby database, 10.2
- archive mode
-
- specifying, 14
- ARCHIVE_LAG_TARGET initialization parameter
-
- setting with ALTER SYSTEM, 11
- archived redo logs
-
- location, 10.2
- ARCHIVELOG clause
-
- of ALTER DATABASE, 10.2, 10.2
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- arguments
-
- of operators, 4
- arithmetic
-
- operators, 4.2
- with DATE values, 2.1.1.15
- AS clause
-
- of CREATE JAVA, 14
- AS EXTERNAL clause
-
- of CREATE FUNCTION, 15
- of CREATE TYPE BODY, 17
- AS OBJECT clause
-
- of CREATE TYPE, 17
- AS subquery clause
-
- of CREATE MATERIALIZED VIEW, 15
- of CREATE TABLE, 16
- of CREATE VIEW, 17
- AS TABLE clause
-
- of CREATE TYPE, 17
- AS VARRAY clause
-
- of CREATE TYPE, 17
- ASC clause
-
- of CREATE INDEX, 14
- ASCII
-
- character set, 2.2.4
- ASCII function, 7.5
- ASCIISTR function, 7.6
- ASIN function, 7.7
- ASSOCIATE STATISTICS statement, 13
- ATAN function, 7.8
- ATAN2 function, 7.9
- ATTRIBUTE clause
-
- of ALTER DIMENSION, 10.2
- of CREATE DIMENSION, 14, 14
- attributes
-
- adding to a dimension, 10.2
- dropping from a dimension, 10.2
- maximum number of in object type, 16
- of dimensions, defining, 14
- of user-defined types
-
- mapping to Java fields, 17
- AUDIT ANY system privilege, 18
- AUDIT SYSTEM system privilege, 18
- AUDIT_FILE_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- AUDIT_SYS_OPERATIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- AUDIT_TRAIL initialization parameter
-
- setting with ALTER SYSTEM, 11
- auditing
-
- options
-
- for SQL statements, 13
- policies
-
- value-based, 13
- SQL statements, 13
-
- by a proxy, 13
- by a user, 13
- SQL statements, on a directory, 13
- SQL statements, on a schema, 13
- SQL statements, stopping, 18
- system privileges, 13
- AUTHENTICATED BY clause
-
- of CREATE DATABASE LINK, 14
- AUTHENTICATED clause
-
- of ALTER USER, 13
- AUTHENTICATION REQUIRED clause
-
- of ALTER USER, 13
- AUTHID CURRENT_USER clause
-
- of ALTER JAVA, 10.2
- of CREATE FUNCTION, 14, 14
- of CREATE JAVA, 14, 14
- of CREATE PACKAGE, 15
- of CREATE PROCEDURE, 15
- of CREATE TYPE, 13, 17
- AUTHID DEFINER clause
-
- of ALTER JAVA, 10.2
- of CREATE FUNCTION, 14, 14
- of CREATE JAVA, 14, 14
- of CREATE PACKAGE, 15
- of CREATE PROCEDURE, 15
- of CREATE TYPE, 13, 17
- AUTOALLOCATE clause
-
- of CREATE TABLESPACE, 16
- AUTOEXTEND clause
-
- of ALTER DATABASE, 10.2
- of CREATE DATABASE, 14
- Automatic Database Diagnostic Monitor
-
- collecting statistics for, 11
- automatic segment-space management, 16
- Automatic Undo Management mode, 11, 14
- AVG function, 7.10
B
- BACKGROUND_CORE_DUMP initialization parameter
-
- setting with ALTER SYSTEM, 11
- BACKGROUND_DUMP_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- BACKUP ANY TABLE system privilege, 18
- BACKUP CONTROLFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- BACKUP_TAPE_IO_SLAVES initialization parameter
-
- setting with ALTER SYSTEM, 11
- backups
-
- incremental
-
- and block change tracking, 10.2
- BC datetime format element, 2.4.2.2, 2.4.2.2
- BEFORE clause
-
- of CREATE TRIGGER, 16
- BEFORE triggers, 16
- BEGIN BACKUP clause
-
- of ALTER DATABASE, 10.2
- of ALTER TABLESPACE, 12
- beginning backup of, 10.2
- BFILE
-
- datatype, 2.1.1.19
- locators, 2.1.1.19
- BFILENAME function, 7.11
- BIN_TO_NUM function, 7.12
- binary large objects. See BLOB
- binary operators, 4.1.1
- BINDING clause
-
- of CREATE OPERATOR, 15
- bindings
-
- adding to an operator, 11
- dropping from an operator, 11
- bit vectors
-
- converting to numbers, 7.12
- BITAND function, 7.13
- BITMAP clause
-
- of CREATE INDEX, 14
- bitmap indexes, 14
-
- creating join indexes, 14
- BITMAP_MERGE_AREA_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- blank padding
-
- specifying in format models, 2.4.3
- suppressing, 2.4.3
- BLANK_TRIMMING initialization parameter
-
- setting with ALTER SYSTEM, 11
- blank-padded comparison semantics, 2.2.4
- BLOB datatype, 2.1.1.20
-
- transactional support, 2.1.1.20
- BLOCKSIZE clause
-
- of CREATE TABLESPACE, 16
- bottom-N reporting, 7.38, 7.108, 7.122
- buffer cache
-
- flushing, 11
- BUFFER_POOL parameter
-
- of STORAGE clause, 8
- BUILD DEFERRED clause
-
- of CREATE MATERIALIZED VIEW, 15
- BUILD IMMEDIATE clause
-
- of CREATE MATERIALIZED VIEW, 15
- BY ACCESS clause
-
- of AUDIT, 13
- BY proxy clause
-
- of AUDIT, 13
- BY SESSION clause
-
- of AUDIT, 13
- BY user clause
-
- of AUDIT, 13
- BYTE character semantics, 2.1.1.1, 2.1.1.3
- BYTE length semantics, 12
C
- C clause
-
- of CREATE TYPE, 17
- of CREATE TYPE BODY, 17
- C method
-
- mapping to an object type, 17
- CACHE clause
-
- of ALTER MATERIALIZED VIEW, 11
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 16
- of CREATE CLUSTER, 14
- of CREATE MATERIALIZED VIEW, 15
- of CREATE MATERIALIZED VIEW LOG, 15
- CACHE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE, 11
- of CREATE SEQUENCE, 15
- CACHE READS clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16
- cached cursors
-
- execution plan for, 18
- CALL clause
-
- of CREATE TRIGGER, 16
- CALL procedure statement
-
- of CREATE TRIGGER, 16
- call spec. See call specifications
- call specifications
-
- in procedures, 15
- of CREATE PROCEDURE, 15
- of CREATE TYPE, 17
- of CREATE TYPE BODY, 17
- CALL statement, 13
- calls
-
- limiting CPU time for, 15
- limiting data blocks read, 15
- CARDINALITY function, 7.14
- Cartesian products, 9.6.4
- CASCADE clause
-
- of CREATE TABLE, 16
- of DROP PROFILE, 17
- of DROP USER, 18
- CASCADE CONSTRAINTS clause
-
- of DROP CLUSTER, 17
- of DROP TABLE, 18
- of DROP TABLESPACE, 18
- of DROP VIEW, 18
- of REVOKE, 18, 18
- CASE expressions, 5.4
-
- searched, 5.4
- simple, 5.4
- CAST function, 7.15
-
- MULTISET parameter, 7.15
- CATSEARCH condition, 4.1, 6.1
- CEIL function, 7.16
- chained rows
-
- listing, 13
- of clusters, 13
- CHANGE CATEGORY clause
-
- of ALTER OUTLINE, 11
- CHAR character semantics, 2.1.1.1, 2.1.1.3
- CHAR datatype, 2.1.1.1
-
- converting to VARCHAR2, 2.4.1
- CHAR length semantics, 12
- character functions, 7.1.1.2, 7.1.1.3
- character large objects. See CLOB
- character length semantics, 12
- character literal. See text
- character set
-
- changing, 10.2
- CHARACTER SET parameter
-
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- character sets
-
- common, 2.2.4
- database, specifying, 14
- multibyte characters, 2.8.1
- specifying for database, 14
- character strings
-
- comparison rules, 2.2.3
- exact matching, 2.4.3
- fixed-length, 2.1.1.1
- national character set, 2.1.1.2
- variable length, 2.1.1.4
- variable-length, 2.1.1.8
- zero-length, 2.1.1.1
- characters
-
- single, comparison rules, 2.2.4
- CHARTOROWID function, 7.17
- CHECK clause
-
- of constraints, 8
- of CREATE TABLE, 16
- check constraints, 8
- CHECK DATAFILES clause
-
- of ALTER SYSTEM, 11
- CHECKPOINT clause
-
- of ALTER SYSTEM, 11
- checkpoints
-
- forcing, 11
- CHR function, 7.18
- CHUNK clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16
- CIRCUITS initialization parameter
-
- setting with ALTER SYSTEM, 11
- CLEAR LOGFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- CLOB datatype, 2.1.1.21
-
- transactional support, 2.1.1.21
- clone databases
-
- mounting, 10.2
- CLOSE DATABASE LINK clause
-
- of ALTER SESSION, 11
- CLUSTER clause
-
- of ANALYZE, 13
- of CREATE INDEX, 14
- of CREATE TABLE, 16
- of TRUNCATE, 19
- CLUSTER_DATABASE initialization parameter
-
- setting with ALTER SYSTEM, 11
- CLUSTER_DATABASE_INSTANCES initialization parameter
-
- setting with ALTER SYSTEM, 11
- CLUSTER_INTERCONNECTS initialization parameter
-
- setting with ALTER SYSTEM, 11
- clusters
-
- assigning tables to, 16
- caching retrieved blocks, 14
- cluster indexes, 14
- collecting statistics on, 13
- creating, 14, 14
- deallocating unused extents, 10.2
- degree of parallelism
-
- changing, 10.2, 10.2
- when creating, 14
- dropping tables, 17
- extents, allocating, 10.2, 10.2
- granting system privileges for, 18
- hash, 14
-
- single-table, 14
- sorted, 14, 16
- indexed, 14
- key values
-
- allocating space for, 14
- modifying space for, 10.2
- migrated and chained rows in, 13, 13
- modifying, 10.2
- physical attributes
-
- changing, 10.2
- specifying, 14
- releasing unused space, 10.2
- removing from the database, 17
- SQL examples, 17
- storage attributes
-
- changing, 10.2
- storage characteristics, changing, 10.2
- tablespace in which created, 14
- validating structure, 13
- COALESCE clause
-
- for partitions, 12
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12, 12, 12
- of ALTER TABLESPACE, 12
- COALESCE function, 7.19
-
- as a variety of CASE expression, 7.19
- COALESCE SUBPARTITION clause
-
- of ALTER TABLE, 12
- COLLECT function, 7.20
- collection types
-
- multilevel, 16
- collections
-
- inserting rows into, 18
- modifying, 12
- modifying retrieval method, 12
- nested tables, 2.1.3.4
- testing for empty, 6.13
- treating as a table, 18, 19, 19, 19
- unnesting, 19
-
- examples, 19
- varrays, 2.1.3.3
- collection-typed values
-
- converting to datatypes, 7.15
- column REF constraints, 8
-
- of CREATE TABLE, 16
- columns
-
- adding, 12
- aliases for, 9.2
- altering storage, 12
- associating statistics with, 13
- basing an index on, 14
- collecting statistics on, 13
- comments on, 13
- creating comments about, 13
- defining, 16
- dropping from a table, 12
- LOB
-
- storage attributes, 12
- maximum number of, 16
- modifying existing, 12
- parent-child relationships between, 14
- properties, altering, 12, 12
- qualifying names of, 9.2
- REF
-
- describing, 8
- renaming, 12
- restricting values for, 8
- specifying as primary key, 8
- specifying constraints on, 16
- specifying default values, 16
- storage properties, 16
- substitutable, identifying type, 7.154
- COLUMNS clause
-
- of ASSOCIATE STATISTICS, 13, 13
- COMMENT ANY TABLE system privilege, 18
- COMMENT clause
-
- of COMMIT, 13
- COMMENT statement, 13
- comments, 2.6
-
- adding to objects, 13
- associating with a transaction, 13
- dropping from objects, 13
- in SQL statements, 2.6.1
- on indextypes, 13
- on operators, 13
- on schema objects, 2.6.2
- on table columns, 13
- on tables, 13
- removing from the data dictionary, 13
- specifying, 2.6.1
- viewing, 13
- commit
-
- automatic, 13
- COMMIT IN PROCEDURE clause
-
- of ALTER SESSION, 11
- COMMIT statement, 13
- COMMIT TO SWITCHOVER clause
-
- of ALTER DATABASE, 10.2
- COMMIT_POINT_STRENGTH initialization parameter
-
- setting with ALTER SYSTEM, 11
- comparison conditions, 6.2
- comparison functions
-
- MAP, 17, 17
- ORDER, 17, 17
- comparison semantics
-
- blank-padded, 2.2.4
- nonpadded, 2.2.3
- of character strings, 2.2.3
- COMPATIBLE initialization parameter
-
- setting with ALTER SYSTEM, 11
- COMPILE clause
-
- of ALTER DIMENSION, 10.2
- of ALTER FUNCTION, 10.2
- of ALTER JAVA SOURCE, 10.2
- of ALTER MATERIALIZED VIEW, 11
- of ALTER PROCEDURE, 11
- of ALTER TRIGGER, 13
- of ALTER TYPE, 13
- of ALTER VIEW, 13
- of CREATE JAVA, 14
- compiler switches
-
- dropping and preserving, 10.2, 11, 13, 13
- COMPOSE function, 7.21
- composite foreign keys, 8
- composite partitioning
-
- range-list, 12, 16
- when creating a table, 16, 16
- composite primary keys, 8
- COMPOSITE_LIMIT parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- compound conditions, 6.7
- compound expressions, 5.3
- COMPRESS clause
-
- of ALTER INDEX ... REBUILD, 10.2
- of CREATE TABLE, 16
- compression
-
- of index keys, 10.2
- COMPUTE STATISTICS clause
-
- of ALTER INDEX, 10.2
- of ANALYZE, 13
- of CREATE INDEX, 14
- CONCAT function, 7.22
- concatenation operator, 4.3
- conditions
-
- comparison, 6.2
- compound, 6.7
- EXISTS, 6.8, 6.9
- floating-point, 6.3
- group comparison, 6.2.2
- IN, 6.10
- in SQL syntax, 6
- IS [NOT] EMPTY, 6.13
- IS ANY, 6.12
- IS OF type, 6.14
- IS PRESENT, 6.15
- LIKE, 6.16
- logical, 6.4
- MEMBER, 6.17
- membership, 6.10, 6.17
- null, 6.6
- range, 6.5
- SET, 6.11
- simple comparison, 6.2.1
- SUBMULTISET, 6.19
- UNDER_PATH, 6.20
- CONNECT BY clause
-
- of queries and subqueries, 19
- of SELECT, 9.3, 19
- CONNECT clause
-
- of SELECT and subqueries, 19
- CONNECT role, 18
- CONNECT THROUGH clause
-
- of ALTER USER, 13
- CONNECT TO clause
-
- of CREATE DATABASE LINK, 14
- CONNECT_BY_ISCYCLE pseudocolumns, 3.1.1
- CONNECT_BY_ISLEAF pseudocolumns, 3.1.2
- CONNECT_BY_ROOT operator, 4.4.2
- CONNECT_TIME parameter
-
- of ALTER PROFILE, 11
- of ALTER RESOURCE COST, 11
- CONSIDER FRESH clause
-
- of ALTER MATERIALIZED VIEW, 11
- constant values. See literals
- CONSTRAINT(S) session parameter, 11
- constraints
-
- adding to a table, 12
- altering, 12
- check, 8
- checking
-
- at end of transaction, 8
- at start of transaction, 8
- at the end of each DML statement, 8
- column REF, 8
- deferrable, 8, 19
-
- enforcing, 11
- defining, 8, 16
-
- for a table, 16
- on a column, 16
- disabling, 16
-
- cascading, 16
- disabling after table creation, 12
- disabling during table creation, 16
- dropping, 12, 12, 18
- enabling, 16, 16
- enabling after table creation, 12
- enabling during table creation, 16
- foreign key, 8
- modifying existing, 12
- on views
-
- dropping, 13, 18
- modifying, 13
- primary key, 8
-
- attributes of index, 8
- enabling, 16
- referential integrity, 8
- renaming, 12
- restrictions, 8
- setting state for a transaction, 19
- storing rows in violation, 12
- table REF, 8
- unique
-
- attributes of index, 8
- enabling, 16
- constructor methods
-
- and object types, 17
- constructors
-
- defining for an object type, 17
- user-defined, 17
- CONTAINS condition, 4.1, 6.1
- context namespaces
-
- accessible to instance, 14
- associating with package, 14
- initializing using OCI, 14
- initializing using the LDAP directory, 14
- removing from the database, 17
- contexts
-
- creating namespaces for, 14
- granting system privileges for, 18
- control files
-
- allowing reuse, 14, 14
- backing up, 10.2
- force logging mode, 14
- re-creating, 14
- CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
-
- setting with ALTER SYSTEM, 11
- CONTROL_FILES initialization parameter
-
- setting with ALTER SYSTEM, 11
- controlfile clauses
-
- of ALTER DATABASE, 10.2
- CONTROLFILE REUSE clause
-
- of CREATE DATABASE, 14
- controlfiles
-
- standby, creating, 10.2
- conversion
-
- functions, 7.1.1.5
- rules, string to date, 2.4.4
- CONVERT clause
-
- of ALTER DATABASE, 10.2
- CONVERT function, 7.23
- CORE_DUMP_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- CORR function, 7.24
- CORR_K function, 7.25.2
- CORR_S function, 7.25.1
- correlated subqueries, 9.7
- correlation functions
-
- Kendall's tau-b, 7.25
- Pearson's, 7.24
- Spearman's rho, 7.25
- correlation names
-
- for base tables of indexes, 14
- in DELETE, 17
- in SELECT, 19
- COS function, 7.26
- COSH function, 7.27
- COUNT function, 7.28
- COVAR_POP function, 7.29
- COVAR_SAMP function, 7.30
- CPU_COUNT initialization parameter
-
- setting with ALTER SYSTEM, 11
- CPU_PER_CALL parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- CPU_PER_SESSION parameter
-
- of ALTER PROFILE, 11
- of ALTER RESOURCE COST, 11
- of CREATE PROFILE, 15
- CREATE ANY CLUSTER system privilege, 18
- CREATE ANY CONTEXT system privilege, 18
- CREATE ANY DIMENSION system privilege, 18
- CREATE ANY DIRECTORY system privilege, 18
- CREATE ANY INDEX system privilege, 18
- CREATE ANY INDEXTYPE system privilege, 18
- CREATE ANY JOB system privilege, 18
- CREATE ANY LIBRARY system privilege, 18
- CREATE ANY MATERIALIZED VIEW system privilege, 18
- CREATE ANY OPERATOR system privilege, 18
- CREATE ANY OUTLINE system privilege, 18
- CREATE ANY PROCEDURE system privilege, 18
- CREATE ANY SEQUENCE system privilege, 18
- CREATE ANY SQL PROFILE system privilege, 18, 18
- CREATE ANY SYNONYM system privilege, 18
- CREATE ANY TABLE system privilege, 18
- CREATE ANY TRIGGER system privilege, 18
- CREATE ANY TYPE system privilege, 18
- CREATE ANY VIEW system privilege, 18
- CREATE CLUSTER statement, 14
- CREATE CLUSTER system privilege, 18
- CREATE CONTEXT statement, 14
- CREATE CONTROLFILE statement, 14
- CREATE DATABASE LINK statement, 14
- CREATE DATABASE LINK system privilege, 18
- CREATE DATABASE statement, 14
- CREATE DATAFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- CREATE DIMENSION
-
- system privilege, 18
- CREATE DIMENSION statement, 14
- CREATE DIRECTORY statement, 14
- CREATE DISKGROUP statement, 14
- CREATE FUNCTION statement, 14
- CREATE INDEX
-
- statement, 14
- CREATE INDEXTYPE
-
- statement, 14
- CREATE INDEXTYPE system privilege, 18
- CREATE JAVA statement, 14
- CREATE JOB system privilege, 18
- CREATE LIBRARY statement, 15
- CREATE LIBRARY system privilege, 18
- CREATE MATERIALIZED VIEW LOG statement, 15
- CREATE MATERIALIZED VIEW statement, 15
- CREATE MATERIALIZED VIEW system privilege, 18
- CREATE OPERATOR statement, 15
- CREATE OPERATOR system privilege, 18
- CREATE OUTLINE statement, 15
- CREATE PACKAGE statement, 15
- CREATE PFILE statement, 15
- CREATE PROCEDURE statement, 15
- CREATE PROCEDURE system privilege, 18
- CREATE PROFILE statement, 15
- CREATE PROFILE system privilege, 18
- CREATE PUBLIC DATABASE LINK system privilege, 18
- CREATE PUBLIC SYNONYM system privilege, 18
- CREATE ROLE statement, 15
- CREATE ROLE system privilege, 18
- CREATE ROLLBACK SEGMENT statement, 15
- CREATE ROLLBACK SEGMENT system privilege, 18
- CREATE SCHEMA statement, 15
- CREATE SEQUENCE statement, 15
- CREATE SEQUENCE system privilege, 18
- CREATE SESSION system privilege, 18
- CREATE SPFILE statement, 15
- CREATE STANDBY CONTROLFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- CREATE statements
-
- triggers on, 16
- CREATE SYNONYM statement, 16
- CREATE SYNONYM system privilege, 18
- CREATE TABLE statement, 16
- CREATE TABLE system privilege, 18
- CREATE TABLESPACE statement, 16
- CREATE TABLESPACE system privilege, 18
- CREATE TRIGGER statement, 16
- CREATE TRIGGER system privilege, 18
- CREATE TYPE BODY statement, 17
- CREATE TYPE statement, 17
- CREATE TYPE system privilege, 18
- CREATE USER statement, 17
- CREATE USER system privilege, 18
- CREATE VIEW statement, 17
- CREATE VIEW system privilege, 18
- CREATE_BITMAP_AREA_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- CREATE_STORED_OUTLINES initialization parameter, 11
-
- setting with ALTER SYSTEM, 11
- cross joins, 19
- CUBE clause
-
- of SELECT statements, 19
- CUME_DIST function, 7.31
- cumulative distributions, 7.31
- currency
-
- group separators, 2.4.1.1
- currency symbol
-
- ISO, 2.4.1.1
- local, 2.4.1.1
- union, 2.4.1.1
- CURRENT_DATE function, 7.32
- CURRENT_SCHEMA session parameter, 11
- CURRENT_TIMESTAMP function, 7.33
- CURRENT_USER clause
-
- of CREATE DATABASE LINKI, 14
- CURRVAL pseudocolumn, 3.2, 15
- CURSOR expressions, 5.5
- CURSOR_SHARING initialization parameter
-
- setting with ALTER SYSTEM, 11
- CURSOR_SPACE_FOR_TIME initialization parameter
-
- setting with ALTER SYSTEM, 11
- cursors
-
- cached, 18
- CustomDatum Java storage format, 17
- CV function, 7.34
- CYCLE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE, 11
- of CREATE SEQUENCE, 15
D
- data
-
- aggregation
-
- composite columns of GROUP BY, 19
- concatenated grouping sets of GROUP BY, 19
- grouping sets, 19
- analyzing a subset, 7.97
- caching frequently used, 16
- independence, 16
- integrity checking on input, 2.1.1.6.1
- retrieving, 9.1
- specifying as temporary, 16
- undo
-
- preserving, 12, 16
- data conversion, 2.2.7
-
- between character datatypes, 2.2.7.2
- implicit
-
- disadvantages, 2.2.7.1
- implicit versus explicit, 2.2.7.1
- when performed implicitly, 2.2.7.2, 2.2.7.3
- when specified explicitly, 2.2.7.4
- data definition language (DDL)
-
- events and triggers, 16
- statements, 10.1.1
-
- and implicit commit, 10.1.1
- causing recompilation, 10.1.1
- PL/SQL support, 10.1.1
- statements requiring exclusive access, 10.1.1
- data dictionary
-
- adding comments to, 13
- data manipulation language (DML)
-
- allowing during indexing, 10.2
- operations
-
- and triggers, 16
- during index creation, 14
- during index rebuild, 12
- parallelizing, 16
- restricting operations, 11
- retrieving affected rows, 17, 18, 19
- retrieving rows affected by, 17, 18, 19
- statements, 10.1.2
-
- PL/SQL support, 10.1.2
- data object number
-
- in extended rowids, 2.1.1.24
- database
-
- flashing back, 18
- returning to a past time, 18
- database links, 9.10
-
- closing, 11
- creating, 2.9.3.1, 14
- creating synonyms with, 16
- current user, 14
- granting system privileges for, 18
- naming, 2.9.3.1.1
- public, 14
-
- dropping, 17
- referring to, 2.9.3.2
- removing from the database, 17
- shared, 14
- syntax, 2.9.3.1.1
- username and password, 2.9.3.1.2
- database objects
-
- dropping, 18
- nonschema, 2.7.2, 2.7.2
- schema, 2.7.1
- database triggers. See triggers
- databases, 10.2
-
- accounts
-
- creating, 17
- allowing changes to, 11
- allowing generation of redo logs, 10.2
- allowing reuse of control files, 14
- allowing unlimited resources to users, 15
- archive mode
-
- specifying, 14
- blocks
-
- specifying size, 16
- cancel-based recovery, 10.2
-
- terminating, 10.2
- change-based recovery, 10.2
- changing characteristics, 14
- changing global name, 10.2
- changing name, 14, 14
- character set, specifying, 14
- character sets
-
- specifying, 14
- committing to standby status, 10.2
- connect strings, 2.9.3.1.3
- controlling, 10.2
- controlling use, 10.2
- converting from Oracle7 data dictionary, 10.2
- create script for, 10.2
- creating, 14
- datafiles
-
- modifying, 10.2
- specifying, 14
- designing media recovery, 10.2
- dropping, 17
- ending backup of, 10.2
- erasing all data from, 14
- events
-
- and triggers, 16
- auditing, 16
- transparent logging of, 16
- granting system privileges for, 18
- in FLASHBACK mode, 10.2
- in FORCE LOGGING mode, 10.2, 14, 14
- instances of, 14
- limiting resources for users, 15
- log files
-
- modifying, 10.2
- specifying, 14
- managed recovery, 10.2
- modifying, 10.2
- mounting, 10.2, 10.2, 14
- moving a subset to a different database, 12
- naming, 10.2
- national character set
-
- specifying, 14
- no-data-loss mode, 10.2
- online
-
- adding log files, 10.2
- opening, 10.2, 14
- prepare to re-create, 10.2
- preventing changes to, 10.2
- protection mode of, 10.2
- quiesced state, 11
- read-only, 10.2
- read/write, 10.2
- reconstructing damaged, 10.2
- recovering, 10.2, 10.2
- recovery
-
- allowing corrupt blocks, 10.2
- testing, 10.2
- with backup control file, 10.2
- re-creating control file for, 14
- remote
-
- accessing, 9.10
- authenticating users to, 14
- connecting to, 14
- inserting into, 18
- service name of, 14
- table locks on, 18
- resetting
-
- to an earlier version, 10.2
- restoring earlier version of, 10.2, 12, 16
- restricting users to read-only transactions, 10.2
- resuming activity, 11
- standby
-
- adding log files, 10.2
- suspending activity, 11
- system user passwords, 14
- tempfiles
-
- modifying, 10.2
- time zone
-
- determining, 7.35
- setting, valid values for, 10.2, 14
- time-based recovery, 10.2
- upgrading, 10.2
- DATAFILE clause
-
- of CREATE DATABASE, 14
- DATAFILE clauses
-
- of ALTER DATABASE, 10.2, 10.2
- DATAFILE OFFLINE clause
-
- of ALTER DATABASE, 10.2
- DATAFILE ONLINE clause
-
- of ALTER DATABASE, 10.2
- DATAFILE RESIZE clause
-
- of ALTER DATABASE, 10.2
- datafiles
-
- bringing online, 10.2
- changing size of, 10.2
- creating new, 10.2
- defining for a tablespace, 16, 16, 16
- defining for the database, 14
- designing media recovery, 10.2
- dropping, 18
- enabling autoextend, 8
- end online backup of, 10.2, 12
- extending automatically, 8
- online backup of, 12
- online, updating information on, 11
- putting online, 10.2
- recover damaged, 10.2
- recovering, 10.2
- re-creating lost or damaged, 10.2
- renaming, 10.2, 10.2
- resizing, 10.2, 10.2
- reusing, 8
- size of, 8
- specifying, 8, 8
-
- for a tablespace, 16
- specifying for database, 14
- system generated, 10.2
- taking offline, 10.2, 10.2
- datatypes, 2.1
-
- "Any" types, 2.1.5
- ANSI-supported, 2.1
- associating statistics with, 13, 13
- BFILE, 2.1.1.19
- BLOB, 2.1.1.20
- CHAR, 2.1.1.1
- character, 2.1.1
- CLOB, 2.1.1.21
- comparison rules, 2.2
- converting to collection-typed values, 7.15
- converting to other datatypes, 7.15
- DATE, 2.1.1.9
- datetime, 2.1.1.8
- interval, 2.1.1.8
- INTERVAL DAY TO SECOND, 2.1.1.14
- INTERVAL YEAR TO MONTH, 2.1.1.13
- length semantics, 2.1.1.1, 2.1.1.3
- LONG, 2.1.1.8
- LONG RAW, 2.1.1.18
- media types, 2.1.8
- NCHAR, 2.1.1.2
- NCLOB, 2.1.1.22
- NUMBER, 2.1.1.6
- NVARCHAR2, 2.1.1.3
- Oracle-supplied types, 2.1.4
- RAW, 2.1.1.18
- ROWID, 2.1.1.22
- spatial types, 2.1.7
- TIMESTAMP, 2.1.1.10
- TIMESTAMP WITH LOCAL TIME ZONE, 2.1.1.12
- TIMESTAMP WITH TIME ZONE, 2.1.1.11
- UROWID, 2.1.1.26
- user-defined, 2.1.3
- VARCHAR, 2.1.1.5
- VARCHAR2, 2.1.1.4
- XML types, 2.1.6
- DATE columns
-
- converting to datetime columns, 12
- DATE datatype, 2.1.1.9
-
- julian, 2.1.1.9.1
- date format models, 2.4.2, 2.4.2.1.2
-
- long, 2.4.2.1.2
- punctuation in, 2.4.2.1.2
- short, 2.4.2.1.2
- text in, 2.4.2.1.2
- date functions, 7.1.1.4
- dates
-
- arithmetic, 2.1.1.15
- comparison rules, 2.2.2
- datetime arithmetic, 2.1.1.15
-
- boundary cases, 11
- calculating daylight saving time, 2.1.1.16
- datetime columns
-
- creating from DATE columns, 12
- datetime datatypes, 2.1.1.8
-
- daylight saving time, 2.1.1.16
- datetime expressions, 5.6
- datetime field
-
- extracting from a datetime or interval value, 7.45
- datetime format elements, 2.4.2.1
-
- and Globalization Support, 2.4.2.2
- capitalization, 2.4.2.1.1
- ISO standard, 2.4.2.3
- RR, 2.4.2.4
- suffixes, 2.4.2.5
- datetime functions, 7.1.1.4
- DAY datetime format element, 2.4.2.2
- daylight saving time, 2.1.1.16
-
- boundary cases, 2.1.1.16
- going into or coming out of effect, 2.1.1.16
- DB_BLOCK_CHECKING initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_BLOCK_CHECKSUM initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_BLOCK_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_CACHE_ADVICE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_CACHE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_CREATE_FILE_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_CREATE_ONLINE_LOG_DEST_n initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_DOMAIN initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_FILE_NAME_CONVERT initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_FILES initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_FLASHBACK_RETENTION_TARGET initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_KEEP_CACHE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_NAME initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_nK_CACHE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_RECOVERY_FILE_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_RECOVERY_FILE_DEST_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_RECYCLE_CACHE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_UNIQUE_NAME initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB_WRITER_PROCESSES initialization parameter
-
- setting with ALTER SYSTEM, 11
- DB2 datatypes, 2.1.2
-
- conversion to Oracle datatypes, 2.1.2
- restrictions on, 2.1.2
- DBA role, 18
- DBA_2PC_PENDING data dictionary view, 11
- DBA_COL_COMMENTS data dictionary view, 13
- DBA_INDEXTYPE_COMMENTS data dictionary view, 13
- DBA_MVIEW_COMMENTS data dictionary view, 13
- DBA_OPERATOR_COMMENTS data dictionary view, 13
- DBA_ROLLBACK_SEGS data dictionary view, 17
- DBA_TAB_COMMENTS data dictionary view, 13
- DBMS_OUTPUT package, 13
- DBMS_ROWID package
-
- and extended rowids, 2.1.1.24
- DBMSSTDX.SQL script, 14, 15, 15, 15
-
- and triggers, 16
- DBTIMEZONE function, 7.35
- DBWR_IO_SLAVES initialization parameter
-
- setting with ALTER SYSTEM, 11
- DDL. See data definition language (DDL)
- DDL_WAIT_FOR_LOCKS initialization parameter
-
- setting with ALTER SYSTEM, 11
- DEALLOCATE UNUSED clause
-
- of ALTER CLUSTER, 10.2, 10.2
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- DEBUG ANY PROCEDURE system privilege, 18
- DEBUG clause
-
- of ALTER FUNCTION, 10.2
- of ALTER PROCEDURE, 11
- of ALTER TRIGGER, 13
- of ALTER TYPE, 13
- DEBUG object privilege, 18
-
- on a function, procedure, or package, 18
- on a table, 18
- on a view, 18
- on an object type, 18
- debugging
-
- granting system privileges for, 18
- decimal characters, 2.3.2.2
-
- specifying, 2.4.1.1
- DECODE function, 7.36
- DECOMPOSE function, 7.37
- DEFAULT clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16, 16
- DEFAULT COST clause
-
- of ASSOCIATE STATISTICS, 13, 13, 13
- default index, suppressing, 15
- DEFAULT profile
-
- assigning to users, 17
- DEFAULT ROLE clause
-
- of ALTER USER, 13
- DEFAULT SELECTIVITY clause
-
- of ASSOCIATE STATISTICS, 13, 13, 13
- DEFAULT storage clause
-
- of ALTER TABLESPACE, 12
- of CREATE TABLESPACE, 16
- default tablespace, 14
- DEFAULT TABLESPACE clause
-
- of ALTER DATABASE, 10.2
- of ALTER USER, 13
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
- default tablespaces
-
- specifying for a user, 13
- DEFAULT TEMPORARY TABLESPACE clause
-
- of ALTER DATABASE, 10.2
- of CREATE DATABASE, 14
- DEFERRABLE clause
-
- of constraints, 8
- deferrable constraints, 19
- DEFERRED clause
-
- of SET CONSTRAINTS, 19
- definer-rights functions, 14
- DELETE ANY TABLE system privilege, 18
- DELETE object privilege, 18
-
- on a table, 18
- on a view, 18
- DELETE statement, 17
-
- triggers on, 16
- DELETE STATISTICS clause
-
- of ANALYZE, 13
- DELETE_CATALOG_ROLE role, 18
- deletes during, 18
- DENSE_RANK function, 7.38
- DEREF function, 7.40
- DESC clause
-
- of CREATE INDEX, 14
- DETERMINISTIC clause
-
- of CREATE FUNCTION, 14
- DG_BROKER_CONFIG_FILEn initialization parameter
-
- setting with ALTER SYSTEM, 11
- DG_BROKER_START initialization parameter
-
- setting with ALTER SYSTEM, 11
- dimensions
-
- attributes
-
- adding, 10.2
- changing, 10.2
- defining, 14
- dropping, 10.2
- compiling invalidated, 10.2
- creating, 14
- defining levels, 14
- examples, 14
- granting system privileges for, 18
- hierarchies
-
- adding, 10.2
- changing, 10.2
- defining, 14
- dropping, 10.2
- levels
-
- adding, 10.2
- defining, 14
- dropping, 10.2
- removing from the database, 17
- directories. See directory objects
- directory objects
-
- as aliases for operating system directories, 14
- auditing, 13
- creating, 14
- granting system privileges for, 18
- redefining, 14
- removing from the database, 17
- direct-path INSERT, 18
- DISABLE ALL TRIGGERS clause
-
- of ALTER TABLE, 12
- DISABLE clause
-
- of ALTER INDEX, 10.2
- of CREATE TABLE, 16
- DISABLE DISTRIBUTED RECOVERY clause
-
- of ALTER SYSTEM, 11
- DISABLE NOVALIDATE constraint state, 8
- DISABLE PARALLEL DML clause
-
- of ALTER SESSION, 11
- DISABLE QUERY REWRITE clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- DISABLE RESTRICTED SESSION clause
-
- of ALTER SYSTEM, 11
- DISABLE RESUMABLE clause
-
- of ALTER SESSION, 11
- DISABLE ROW MOVEMENT clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16, 16
- DISABLE STORAGE IN ROW clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16
- DISABLE TABLE LOCK clause
-
- of ALTER TABLE, 12
- DISABLE THREAD clause
-
- of ALTER DATABASE, 10.2
- DISABLE VALIDATE constraint state, 8
- DISASSOCIATE STATISTICS statement, 17
- DISCONNECT SESSION clause
-
- of ALTER SYSTEM, 11
- disk groups
-
- altering, 10.2
- creating, 14
- creating a tablespace in, 16
- creating failure groups, 10.2, 14
- creating files in, 8
- dropping, 17
- specifying files in, 8
- specifying files in control files, 14
- DISK_ASYNCH_IO initialization parameter
-
- setting with ALTER SYSTEM, 11
- dispatcher processes
-
- creating additional, 11
- terminating, 11
- DISPATCHERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- DISTINCT clause
-
- of SELECT, 19
- distinct queries, 19
- distributed queries, 9.10
-
- restrictions on, 9.10
- DISTRIBUTED_LOCK_TIMEOUT initialization parameter
-
- setting with ALTER SYSTEM, 11
- DML. See data manipulation language (DML)
- DML_LOCKS initialization parameter
-
- setting with ALTER SYSTEM, 11
- domain indexes, 14, 14, 14
-
- and LONG columns, 12
- associating statistics with, 13, 13
- creating, prerequisites, 14
- determining user-defined CPU and I/O costs, 18
- example, E.1
- invoking drop routines for, 18
- modifying, 10.2
- parallelizing creation of, 14
- rebuilding, 10.2
- removing from the database, 17
- domain_index_clause
-
- of CREATE INDEX, 14
- DOWNGRADE clause
-
- of ALTER DATABASE, 10.2
- DROP ANY CLUSTER system privilege, 18
- DROP ANY CONTEXT system privilege, 18
- DROP ANY DIMENSION system privilege, 18
- DROP ANY DIRECTORY system privilege, 18
- DROP ANY INDEX system privilege, 18
- DROP ANY INDEXTYPE system privilege, 18
- DROP ANY LIBRARY system privilege, 18
- DROP ANY MATERIALIZED VIEW system privilege, 18
- DROP ANY OPERATOR system privilege, 18
- DROP ANY OUTLINE system privilege, 18
- DROP ANY PROCEDURE system privilege, 18
- DROP ANY ROLE system privilege, 18
- DROP ANY SEQUENCE system privilege, 18
- DROP ANY SYNONYM system privilege, 18
- DROP ANY TABLE system privilege, 18
- DROP ANY TRIGGER system privilege, 18
- DROP ANY TYPE system privilege, 18
- DROP ANY VIEW system privilege, 18
- DROP clause
-
- of ALTER DIMENSION, 10.2
- of ALTER INDEXTYPE, 10.2
- DROP CLUSTER statement, 17
- DROP COLUMN clause
-
- of ALTER TABLE, 12
- DROP CONSTRAINT clause
-
- of ALTER TABLE, 12
- DROP constraint clause
-
- of ALTER VIEW, 13
- DROP CONTEXT statement, 17
- DROP DATABASE LINK statement, 17
- DROP DATABASE statement, 17
- DROP DIMENSION statement, 17
- DROP DIRECTORY statement, 17
- DROP DISKGROUP statement, 17
- DROP FUNCTION statement, 17
- DROP INDEX statement, 17
- DROP INDEXTYPE statement, 17
- DROP JAVA statement, 17
- DROP LIBRARY statement, 17
- DROP LOGFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- DROP LOGFILE MEMBER clause
-
- of ALTER DATABASE, 10.2, 10.2
- DROP MATERIALIZED VIEW LOG statement, 17
- DROP MATERIALIZED VIEW statement, 17
- DROP OPERATOR statement, 17
- DROP OUTLINE statement, 17
- DROP PACKAGE BODY statement, 17
- DROP PACKAGE statement, 17
- DROP PARTITION clause
-
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- DROP PRIMARY constraint clause
-
- of ALTER TABLE, 12
- DROP PROCEDURE statement, 17
- DROP PROFILE statement, 17
- DROP PROFILE system privilege, 18
- DROP PUBLIC DATABASE LINK system privilege, 18
- DROP PUBLIC SYNONYM system privilege, 18
- DROP ROLE statement, 17
- DROP ROLLBACK SEGMENT statement, 17
- DROP ROLLBACK SEGMENT system privilege, 18
- DROP SEQUENCE statement, 18
- DROP statements
-
- triggers on, 16
- DROP SUPPLEMENTAL LOG DATA clause
-
- of ALTER DATABASE, 10.2
- DROP SUPPLEMENTAL LOG GROUP clause
-
- of ALTER TABLE, 12
- DROP SYNONYM statement, 18
- DROP TABLE statement, 18
- DROP TABLESPACE statement, 18
- DROP TABLESPACE system privilege, 18
- DROP TRIGGER statement, 18
- DROP TYPE statement, 18
- DROP UNIQUE constraint clause
-
- of ALTER TABLE, 12
- DROP USER statement, 18
- DROP USER system privilege, 18
- DROP VALUES clause
-
- of ALTER TABLE ... MODIFY PARTITION, 12
- DROP VIEW statement, 18
- DUAL dummy table, 2.8.1, 9.9
- DUMP ACTIVE SESSION HISTORY clause
-
- of ALTER SYSTEM, 11
- DUMP function, 7.41
- DY datetime format element, 2.4.2.2
E
- EBCDIC character set, 2.2.4
- embedded SQL, 10.1.6
-
- precompiler support, 10.1.6
- EMPTY_BLOB function, 7.42
- EMPTY_CLOB function, 7.42
- ENABLE ALL TRIGGERS clause
-
- of ALTER TABLE, 12
- ENABLE clause
-
- of ALTER INDEX, 10.2
- of ALTER TRIGGER, 13
- of CREATE TABLE, 16
- ENABLE DISTRIBUTED RECOVERY clause
-
- of ALTER SYSTEM, 11
- ENABLE NOVALIDATE constraint state, 8
- ENABLE PARALLEL DML clause
-
- of ALTER SESSION, 11
- ENABLE QUERY REWRITE clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- ENABLE RESTRICTED SESSION clause
-
- of ALTER SYSTEM, 11
- ENABLE RESUMABLE clause
-
- of ALTER SESSION, 11
- ENABLE ROW MOVEMENT clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16, 16
- ENABLE STORAGE IN ROW clause
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16
- ENABLE TABLE LOCK clause
-
- of ALTER TABLE, 12
- ENABLE THREAD clause
-
- of ALTER DATABASE, 10.2
- ENABLE VALIDATE constraint state, 8
- END BACKUP clause
-
- of ALTER DATABASE, 10.2
- of ALTER DATABASE ... DATAFILE, 10.2
- of ALTER TABLESPACE, 12
- ENQUEUE_RESOURCES initialization parameter
-
- setting with ALTER SYSTEM, 11
- equality test, 6.2
- equijoins, 9.6.2
-
- defining for a dimension, 14
- equivalency tests, 6.10
- ERROR_ON_OVERLAP_TIME session parameter, 11
- ESTIMATE STATISTICS clause
-
- of ANALYZE, 13
- EVENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- EXCEPTIONS INTO clause
-
- of ALTER TABLE, 12
-
- restrictions, 12
- EXCHANGE PARTITION clause
-
- of ALTER TABLE, 12, 12
- EXCHANGE SUBPARTITION clause
-
- of ALTER TABLE, 12, 12
- exchanging partitions
-
- restrictions on, 12
- EXCLUDING NEW VALUES clause
-
- of ALTER MATERIALIZED VIEW LOG, 11
- of CREATE MATERIALIZED VIEW LOG, 15
- EXCLUSIVE lock mode, 18
- EXECUTE ANY CLASS system privilege, 18
- EXECUTE ANY INDEXTYPE system privilege, 18
- EXECUTE ANY OPERATOR system privilege, 18
- EXECUTE ANY PROCEDURE system privilege, 18
- EXECUTE ANY PROGRAM system privilege, 18
- EXECUTE ANY TYPE system privilege, 18
- EXECUTE object privilege, 18
-
- on a function, procedure, or package, 18
- on a library, 18
- on an indextype, 18
- on an object type, 18
- on an operator, 18
- EXECUTE_CATALOG_ROLE role, 18
- execution plans
-
- determining, 18
- dropping outlines for, 17
- saving, 15
- EXEMPT ACCESS POLICY system privilege, 18
- EXISTS condition, 6.9, 6.9
- EXISTS conditions, 6.8
- EXISTSNODE function, 7.43
- EXP function, 7.44
- EXP_FULL_DATABASE role, 18
- EXPLAIN PLAN statement, 18
- explicit data conversion, 2.2.7.1, 2.2.7.4
- expressions
-
- CASE, 5.4
- changing declared type of, 7.183
- comparing, 7.36
- compound, 5.3
- computing with the DUAL table, 9.9
- CURSOR, 5.5
- datetime, 5.6
- in SQL syntax, 5.1
- interval, 5.8
- lists of, 5.14
- model, 5.11
- object access, 5.9
- scalar subqueries as, 5.10
- simple, 5.2
- type constructor, 5.12
- variable, 5.13
- extended rowids, 2.1.1.24
-
- base 64, 2.1.1.24
- not directly available, 2.1.1.24
- extensible indexing
-
- example, E.1
- EXTENT MANAGEMENT clause
-
- of CREATE DATABASE, 14
- of CREATE TABLESPACE, 16, 16
- EXTENT MANAGEMENT DICTIONARY clause
-
- of CREATE TABLESPACE, 16
- EXTENT MANAGEMENT LOCAL clause
-
- of CREATE DATABASE, 14
- of CREATE TABLESPACE, 16
- extents
-
- allocating for partitions, 12
- allocating for subpartitions, 12
- allocating for tables, 12
- restricting access by instances, 10.2
- specifying maximum number for an object, 8
- specifying number allocated upon object creation, 8
- specifying the first for an object, 8
- specifying the percentage of size increase, 8
- specifying the second for an object, 8
- external functions, 14, 15, 15
- external LOBs, 2.1.1.18
- external procedures, 15, 15
-
- running from remote database, 15
- external tables, 16
-
- access drivers, 16
- altering, 12
- creating, 16
- ORACLE_DATAPUMP access driver, 16
- ORACLE_LOADER access driver, 16
- restrictions on, 16
- external users, 15, 17
- EXTRACT (datetime) function, 7.45
- EXTRACT (XML) function, 7.46
- EXTRACTVALUE function, 7.47
F
- FAILED_LOGIN_ATTEMPTS parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- failure groups
-
- creating for a disk group, 10.2, 14
- FAL_CLIENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- FAL_SERVER initialization parameter
-
- setting with ALTER SYSTEM, 11
- FAST_START_MTTR_TARGET initialization parameter
-
- setting with ALTER SYSTEM, 11
- FAST_START_PARALLEL_ROLLBACK initialization parameter
-
- setting with ALTER SYSTEM, 11
- FILE_MAPPING initialization parameter
-
- setting with ALTER SYSTEM, 11
- FILEIO_NETWORK_ADAPTERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- files
-
- specifying as a redo log file group, 8
- specifying as datafiles, 8
- specifying as tempfiles, 8
- FILESYSTEMIO_OPTIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- FINAL clause
-
- of CREATE TYPE, 17, 17
- FIPS
-
- compliance, B.1.8
- flagging, 11
- FIRST function, 7.48
- FIRST_VALUE function, 7.49
- FIXED_DATE initialization parameter
-
- setting with ALTER SYSTEM, 11
- FLAGGER session parameter, 11
- FLASHBACK ANY TABLE system privilege, 18, 18, 18
- FLASHBACK DATABASE statement, 18
- FLASHBACK object privilege, 18
- flashback queries, 19
-
- pseudocolumns for, 3.3
- using with inserts, 18, 19
- FLASHBACK TABLE statement, 18
- FLOAT datatype, 2.1.1.7.2
- floating-point conditions, 6.3
- floating-point numbers, 2.1.1.7
-
- converting to, 7.162, 7.163
- handling NaN, 7.80
- FLOOR function, 7.50
- FLUSH BUFFER_CACHE clause
-
- of ALTER SYSTEM, 11
- FLUSH SHARED POOL clause
-
- of ALTER SYSTEM, 11
- FM format model modifier, 2.4.3
- FOR clause
-
- of ANALYZE ... COMPUTE STATISTICS, 13
- of ANALYZE ... ESTIMATE STATISTICS, 13
- of CREATE INDEXTYPE, 14
- of EXPLAIN PLAN, 18, 18
- FOR EACH ROW clause
-
- of CREATE TRIGGER, 16
- FOR UPDATE clause
-
- of CREATE MATERIALIZED VIEW, 15
- of SELECT, 19, 19
- FORCE ANY TRANSACTION system privilege, 18
- FORCE clause
-
- of COMMIT, 13
- of CREATE VIEW, 17
- of DISASSOCIATE STATISTICS, 17
- of DROP INDEX, 17
- of DROP INDEXTYPE, 17
- of DROP OPERATOR, 17
- of DROP TYPE, 18
- of REVOKE, 18
- of ROLLBACK, 18, 18
- FORCE LOGGING clause
-
- of ALTER DATABASE, 10.2
- of ALTER TABLESPACE, 12
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- of CREATE TABLESPACE, 16
- FORCE PARALLEL DML clause
-
- of ALTER SESSION, 11
- FORCE TRANSACTION system privilege, 18
- foreign key constraints, 8
- foreign tables
-
- rowids of, 2.1.1.26
- format model modifiers, 2.4.3
- format models, 2.4
-
- changing the return format, 2.4.3.1
- date, 2.4.2
-
- changing, 2.4.2
- default format, 2.4.2
- format elements, 2.4.2.1
- maximum length, 2.4.2
- modifiers, 2.4.3
- number, 2.4.1
- number, elements of, 2.4.1.1
- specifying, 2.4.3.1
- XML, 2.4.5
- formats
-
- for dates and numbers. See format models
- of return values from the database, 2.4
- of values stored in the database, 2.4
- free lists
-
- specifying for a table, partition, cluster, or index, 8
- specifying for LOBs, 16
- FREELIST GROUPS parameter
-
- of STORAGE clause, 8
- FREELISTS parameter
-
- of STORAGE clause, 8
- FREEPOOLS parameter
-
- of LOB storage, 16
- FROM clause
-
- of queries, 9.6.3
- FROM COLUMNS clause
-
- of DISASSOCIATE STATISTICS, 17
- FROM FUNCTIONS clause
-
- of DISASSOCIATE STATISTICS, 17
- FROM INDEXES clause
-
- of DISASSOCIATE STATISTICS, 17
- FROM INDEXTYPES clause
-
- of DISASSOCIATE STATISTICS, 17
- FROM PACKAGES clause
-
- of DISASSOCIATE STATISTICS, 17
- FROM TYPES clause
-
- of DISASSOCIATE STATISTICS, 17
- FROM_TZ function, 7.51
- full outer joins, 19
- function expressions
-
- built-in, 5.7
- user-defined, 5.7
- function-based indexes, 14
-
- creating, 14
- enabling, 10.2, 10.2, 10.2
- enabling and disabling, 10.2
- refreshing, 10.2
- functions
-
- 3GL, calling, 15
- See also SQL functions
- analytic
-
- user-defined, 14
- associating statistics with, 13, 13
- avoiding run-time compilation, 10.2
- built_in
-
- as expressions, 5.7
- calling, 13
- changing the declaration of, 14
- changing the definition of, 14
- datatype of return value, 14
- datetime, 7.1.1.4
- DECODE, 7.36
- defining an index on, 14
- examples, 14
- executing, 13
-
- from parallel query processes, 14
- external, 14, 15, 15
- inverse distribution, 7.100, 7.101
- issuing COMMIT or ROLLBACK statements, 11
- linear regression, 7.117
- naming rules, 2.8.1
- partitioning
-
- among parallel query processes, 14
- privileges executed with, 13, 17
- recompiling explicitly, 10.2
- recompiling invalid, 10.2
- re-creating, 14, 14
- removing from the database, 17
- returning collections, 14
- returning results iteratively, 14
- schema executed in, 13, 17
- specifying schema and user privileges for, 14
- statistics, assigning default cost, 13
- statistics, defining default selectivity, 13
- stored, 14
- storing return value of, 13
- synonyms for, 16
- table, 14
- user_defined
-
- as expressions, 5.7
- user-defined, 7.208
-
- aggregate, 14
- using a saved copy, 14
- FX format model modifier, 2.4.3
G
- GC_FILES_TO_LOCKS initialization parameter
-
- setting with ALTER SYSTEM, 11
- GCS_SERVER_PROCESSES initialization parameter
-
- setting with ALTER SYSTEM, 11
- general recovery clause
-
- of ALTER DATABASE, 10.2, 10.2
- geoimaging, 2.1.7
- global indexes. See indexes, globally partitioned
- GLOBAL PARTITION BY HASH clause
-
- of CREATE INDEX, 14
- GLOBAL PARTITION BY RANGE clause
-
- of CREATE INDEX, 14, 14
- GLOBAL QUERY REWRITE system privilege, 18
- GLOBAL TEMPORARY clause
-
- of CREATE TABLE, 16
- global users, 15, 17
- GLOBAL_NAMES initialization parameter
-
- setting with ALTER SYSTEM, 11
- Globalization Support
-
- change session settings, 11
- globally partitioned indexes, 14, 14
- GRANT ANY OBJECT PRIVILEGE system privilege, 18
- GRANT ANY PRIVILEGE system privilege, 18
- GRANT ANY ROLE system privilege, 18
- GRANT clause
-
- of ALTER USER, 13
- GRANT CONNECT THROUGH clause
-
- of ALTER USER, 13, 13
- GRAPHIC datatype
-
- DB2, 2.1.2
- SQL/DS, 2.1.2
- greater than or equal to tests, 6.2
- greater than tests, 6.2
- GREATEST function, 7.52
- GROUP BY clause
-
- CUBE extension, 19
- identifying duplicate groupings, 7.53
- of SELECT and subqueries, 19, 19
- ROLLUP extension of, 19
- group comparison conditions, 6.2.2
- group separator
-
- specifying, 2.4.1.1
- GROUP_ID function, 7.53
- GROUPING function, 7.54
- grouping sets, 19
- GROUPING SETS clause
-
- of SELECT and subqueries, 19
- GROUPING_ID function, 7.55
- groupings
-
- filtering out duplicate, 7.53
- GUARD ALL clause
-
- of ALTER DATABASE, 10.2
- GUARD clause
-
- of ALTER DATABASE, 10.2
-
- overriding, 11
- GUARD NONE clause
-
- of ALTER DATABASE, 10.2
- GUARD STANDBY clause
-
- of ALTER DATABASE, 10.2
H
- hash clusters
-
- creating, 14
- single-table, creating, 14
- specifying hash function for, 14
- HASH IS clause
-
- of CREATE CLUSTER, 14
- hash partitioning clause
-
- of CREATE TABLE, 16, 16
- hash partitions
-
- adding, 12
- coalescing, 12
- HASH_AREA_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- HASHKEYS clause
-
- of CREATE CLUSTER, 14
- HAVING condition
-
- of GROUP BY clause, 19
- heap-organized tables
-
- creating, 16
- hexadecimal value
-
- returning, 2.4.1.1
- HEXTORAW function, 7.56
- HI_SHARED_MEMORY_ADDRESS initialization parameter
-
- setting with ALTER SYSTEM, 11
- hierarchical queries, 3.1.3, 9.3, 19
-
- child rows, 3.1.3, 9.3
- CONNECT_BY_ISCYCLE pseudocolumn, 3.1.1
- CONNECT_BY_ISLEAF pseudocolumn, 3.1.2
- CONNECT_BY_ROOT operator, 4.4.2
- illustrated, 3.1.3
- leaf rows, 3.1.3
- ordering, 19
- parent rows, 3.1.3, 9.3
- PRIOR operator, 4.4.1
- pseudocolumns in, 3.1
- retrieving root and node values, 7.149
- hierarchical query clause
-
- of SELECT and subqueries, 19
- hierarchies
-
- adding to a dimension, 10.2
- dropping from a dimension, 10.2
- of dimensions, defining, 14
- HIERARCHY clause
-
- of CREATE DIMENSION, 14, 14
- high water mark
-
- of clusters, 10.2
- of indexes, 10.2
- of tables, 12, 13
- hints, 9.2
-
- in SQL statements, 2.6.3
- passing to the optimizer, 19
- syntax, 2.6.3
- histograms
-
- creating equiwidth, 7.199
- HS_ADMIN_ROLE role, 18
- HS_AUTOREGISTER initialization parameter
-
- setting with ALTER SYSTEM, 11
I
- IDENTIFIED BY clause
-
- of ALTER ROLE. See CREATE ROLE
- of CREATE DATABASE LINK, 14
- of SET ROLE, 19
- IDENTIFIED EXTERNALLY clause
-
- of ALTER ROLE. See CREATE ROLE
- of ALTER USER. See CREATE USER
- of CREATE ROLE, 15
- of CREATE USER, 17
- IDENTIFIED GLOBALLY clause
-
- of ALTER ROLE. See CREATE ROLE
- of ALTER USER, 13
- of CREATE ROLE, 15
- of CREATE USER, 17
- IDLE_TIME parameter
-
- of ALTER PROFILE, 11
- IEEE754
-
- floating-point arithmetic, 2.1.1.7.2
- Oracle conformance with, 2.1.1.7.2
- IFILE initialization parameter
-
- setting with ALTER SYSTEM, 11
- IMMEDIATE clause
-
- of SET CONSTRAINTS, 19
- IMP_FULL_DATABASE role, 18
- implicit data conversion, 2.2.7.1, 2.2.7.2, 2.2.7.3
- IN conditions, 6.10
- IN OUT parameter
-
- of CREATE FUNCTION, 14
- of CREATE PROCEDURE, 15
- IN parameter
-
- of CREATE function, 14
- of CREATE PROCEDURE, 15
- INCLUDING CONTENTS clause
-
- of DROP TABLESPACE, 18
- INCLUDING DATAFILES clause
-
- of ALTER DATABASE TEMPFILE DROP clause, 10.2
- INCLUDING NEW VALUES clause
-
- of ALTER MATERIALIZED VIEW LOG, 11
- of CREATE MATERIALIZED VIEW LOG, 15
- INCLUDING TABLES clause
-
- of DROP CLUSTER, 17
- incomplete object types, 17
-
- creating, 17, 17
- INCREMENT BY clause
-
- of ALTER SEQUENCE. See CREATE SEQUENCE
- INCREMENT BY parameter
-
- of CREATE SEQUENCE, 15
- INDEX clause
-
- of ANALYZE, 13
- of CREATE CLUSTER, 14
- index keys
-
- compression, 10.2
- INDEX object privilege, 18
-
- on a table, 18
- index partitions
-
- creating subpartitions, 14
- index subpartitions, 14
- indexed clusters
-
- creating, 14
- indexes, 10.2
-
- allocating new extents for, 10.2
- application-specific, 14
- ascending, 14
- based on indextypes, 14
- bitmap, 14
- bitmap join, 14
- B-tree, 14
- changing attributes, 10.2
- changing parallelism of, 10.2
- collecting statistics on, 13
- computing statistics for, 10.2
- creating, 14
- creating on a cluster, 14
- creating on a table, 14
- deallocating unused space from, 10.2
- descending, 14
-
- and query rewrite, 14
- as function-based indexes, 14
- direct-path inserts, logging, 10.2
- disassociating statistics types from, 17
- domain, 14, 14, 14
- domain, example, E.1
- dropping index partitions, 17
- examples, 14
- function-based, 14
-
- creating, 14
- global partitioned, creating, 14
- globally partitioned, 14, 14
-
- updating, 12
- granting system privileges for, 18
- join, bitmap, 14
- key compression of, 10.2
- key compression, enabling, 10.2
- keys, eliminating repetition, 10.2
- locally partitioned, 14
- logging rebuild operations, 10.2
- marking as UNUSABLE, 10.2
- merging block contents, 10.2
- merging contents of index blocks, 10.2
- merging contents of index partition blocks, 10.2
- modifying attributes, 10.2
- moving, 10.2
- on clusters, 14
- on composite-partitioned tables, creating, 14
- on hash-partitioned tables
-
- creating, 14
- on index-organized tables, 14
- on list-partitioned tables
-
- creating, 14
- on nested table storage tables, 14
- on partitioned tables, 14
- on range-partitioned tables, creating, 14
- on scalar typed object attributes, 14
- on table columns, 14
- on XMLType tables, 14
- online, 14
- parallelizing creation of, 14
- partitioned, 2.9.4, 14
-
- user-defined, 14
- partitioning, 14
- partitions, 14
-
- adding new, 10.2
- changing default attributes, 10.2
- changing physical attributes, 10.2
- changing storage characteristics, 10.2
- coalescing hash partitions, 10.2
- deallocating unused space from, 10.2
- dropping, 10.2
- marking UNUSABLE, 10.2, 12
- modifying the real characteristics, 10.2
- preventing use of, 10.2
- rebuilding, 10.2
- rebuilding unusable, 12
- re-creating, 10.2
- removing, 10.2
- renaming, 10.2
- specifying tablespace, 10.2
- specifying tablespace for, 10.2
- splitting, 10.2, 10.2
- partitions, adding hash, 10.2
- preventing use of, 10.2
- purging from the recycle bin, 18
- rebuilding, 10.2
- rebuilding while online, 10.2
- re-creating, 10.2
- removing from the database, 17
- renaming, 10.2, 10.2
- reverse, 10.2, 10.2, 10.2, 14
- specifying tablespace for, 10.2, 10.2
- statistics on, 14
- statistics on usage, 10.2
- subpartitions
-
- allocating extents for, 10.2
- changing default attributes, 10.2
- changing physical attributes, 10.2
- changing storage characteristics, 10.2
- deallocating unused space from, 10.2, 10.2
- marking UNUSABLE, 10.2
- modifying, 10.2
- moving, 10.2
- preventing use of, 10.2
- rebuilding, 10.2
- re-creating, 10.2
- renaming, 10.2
- specifying tablespace, 10.2
- specifying tablespace for, 10.2
- tablespace containing, 14
- unique, 14
- unsorted, 14
- used to enforce constraints, 12, 16
- validating structure, 13
- on range-partitioned tables, 14, 14, 14
- index-organized tables
-
- bitmap indexes on, creating, 16
- creating, 16
- mapping tables, 12
-
- moving, 12
- mapping tables, creating, 16
- merging contents of index blocks, 12
- modifying, 12, 12
- moving, 12
- overflow segments
-
- specifying storage, 12, 16
- partitioned, updating secondary indexes, 10.2
- PCT_ACCESS_DIRECT statistics, 13
- primary key indexes
-
- coalescing, 12
- rebuilding, 12
- rowids of, 2.1.1.26
- secondary indexes, updating, 10.2
- INDEXTYPE clause
-
- of CREATE INDEX, 14, 14
- indextypes
-
- adding operators, 10.2
- altering, 10.2
- associating statistics with, 13, 13
- changing implementation type, 10.2
- comments on, 13
- creating, 14
- disassociating from statistics types, 17
- drop routines, invoking, 17
- granting system privileges for, 18
- indexes based on, 14
- instances, 14
- removing from the database, 17
- in-doubt transactions
-
- forcing, 13
- forcing commit of, 13
- forcing rollback, 18, 18
- rolling back, 18
- inequality test, 6.2
- INITCAP function, 7.57
- INITIAL parameter
-
- of STORAGE clause, 8
- initialization parameters
-
- changing session settings, 11
- INITIALIZED EXTERNALLY clause
-
- of CREATE CONTEXT, 14
- INITIALIZED GLOBALLY clause
-
- of CREATE CONTEXT, 14
- INITIALLY DEFERRED clause
-
- of constraints, 8
- INITIALLY IMMEDIATE clause
-
- of constraints, 8
- INITRANS parameter
-
- of ALTER CLUSTER, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 12
- of CREATE INDEX. See CREATE TABLE
- of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE
- of CREATE MATERIALIZED VIEW. See CREATE TABLE
- of CREATE TABLE, 8
- inline constraints
-
- of ALTER TABLE, 12
- of CREATE TABLE, 16
- inline views, 9.7
- inner joins, 9.6.5, 19
- inner-N reporting, 7.122
- INSERT ANY TABLE system privilege, 18
- INSERT clause
-
- of MERGE, 18
- INSERT object privilege, 18
-
- on a table, 18
- on a view, 18
- INSERT statement, 18
-
- triggers on, 16
- inserts
-
- and simultaneous update, 18
- conditional, 18
- conventional, 18
- direct-path, 18
- multitable, 18, 18
- multitable, examples, 18
- single-table, 18
- using MERGE, 18
- instance recovery
-
- continue after interruption, 10.2
- INSTANCE session parameter, 11
- INSTANCE_GROUPS initialization parameter
-
- setting with ALTER SYSTEM, 11
- INSTANCE_NAME initialization parameter
-
- setting with ALTER SYSTEM, 11
- INSTANCE_NUMBER initialization parameter
-
- setting with ALTER SYSTEM, 11
- INSTANCE_TYPE initialization parameter
-
- setting with ALTER SYSTEM, 11
- instances
-
- making index extents available to, 10.2
- setting parameters for, 11
- INSTANTIABLE clause
-
- of CREATE TYPE, 17
- INSTEAD OF clause
-
- of CREATE TRIGGER, 16
- INSTEAD OF triggers, 16
- INSTR function, 7.58
- INSTR2 function, 7.58
- INSTR4 function, 7.58
- INSTRB function, 7.58
- INSTRC function, 7.58
- integers
-
- generating unique, 15
- in SQL syntax, 2.3.2.1
- precision of, 2.3.2.1
- syntax of, 2.3.2.1
- integrity constraints. See constraints
- internal LOBs, 2.1.1.18
- International Standards Organization (ISO), B
-
- standards, 1.2, 1.2, B.1
- interrow calculations, 19
-
- CV function, 7.34
- IS ANY condition, 6.12
- IS PRESENT condition, 6.15
- ITERATION_NUMBER function, 7.59
- MODEL clause, 19
- model expression, 5.11
- PRESENTNNV function, 7.105
- PRESENTV function, 7.106
- PREVIOUS function, 7.107
- INTERSECT set operator, 4.5, 19
- interval arithmetic, 2.1.1.15
- interval datatypes, 2.1.1.8
- INTERVAL DAY TO SECOND datatype, 2.1.1.14
- INTERVAL expressions, 5.8
- INTERVAL YEAR TO MONTH datatype, 2.1.1.13
- INTO clause
-
- of EXPLAIN PLAN, 18
- of INSERT, 18
- INVALIDATE GLOBAL INDEXES clause
-
- of ALTER TABLE, 12
- inverse distribution functions, 7.100, 7.101
- invoker rights
-
- altering for a Java class, 10.2
- altering for an object type, 13
- defining for a function, 14
- defining for a Java class, 14, 14
- defining for a package, 15
- defining for a procedure, 15
- defining for an object type, 17
- invoker-rights functions
-
- defining, 14
- IS [NOT] EMPTY conditions, 6.13
- IS ANY condition, 6.12
- IS NOT NULL operator, 6.6
- IS NULL operator, 6.6
- IS OF type condition, 6.14
- IS PRESENT condition, 6.15
- ISO. See International Standards Organization (ISO)
- ISOLATION_LEVEL session parameter, 11
- ITERATION_NUMBER function, 7.59
J
- Java
-
- class
-
- creating, 14, 14
- dropping, 17
- resolving, 10.2, 14
- Java source schema object
-
- creating, 14
- methods
-
- return type of, 17
- resource
-
- creating, 14, 14
- dropping, 17
- schema object
-
- name resolution of, 14
- source
-
- compiling, 10.2, 14
- creating, 14
- dropping, 17
- storage formats
-
- CustomDatum, 17
- SQLData, 17
- JAVA clause
-
- of CREATE TYPE, 17
- of CREATE TYPE BODY, 17
- Java methods
-
- mapping to an object type, 17
- JAVA_MAX_SESSIONSPACE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- JAVA_POOL_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter
-
- setting with ALTER SYSTEM, 11
- job scheduler object privileges, 18
- JOB_QUEUE_PROCESSES initialization parameter
-
- setting with ALTER SYSTEM, 11
- JOIN clause
-
- of CREATE DIMENSION, 14
- JOIN KEY clause
-
- of ALTER DIMENSION, 10.2
- of CREATE DIMENSION, 14
- join views
-
- example, 17
- making updatable, 17
- modifying, 17, 19
- joins, 9.6
-
- antijoins, 9.6.7
- conditions
-
- defining, 9.6.1
- cross, 19
- equijoins, 9.6.2
- full outer, 19
- inner, 9.6.5, 19
- left outer, 19
- natural, 19
- outer, 9.6.6
-
- and data densification, 9.6.6
- on grouped tables, 9.6.6
- restrictions, 9.6.6
- right outer, 19
- self, 9.6.3
- semijoins, 9.6.8
- without join conditions, 9.6.4
- Julian dates, 2.1.1.9.1
K
- key compression, 16
-
- definition, 10.2
- disabling, 10.2, 14
- enabling, 10.2
- of index rebuild, 12
- of indexes
-
- disabling, 10.2
- of index-organized tables, 16
- key-preserved tables, 17
- keywords, 2.8.1
-
- in object names, 2.8.1
- optional, A.1.2
- required, A.1.1
- KILL SESSION clause
-
- of ALTER SYSTEM, 11
L
- LAG function, 7.60
- LANGUAGE clause
-
- of CREATE PROCEDURE, 15
- of CREATE TYPE, 17
- of CREATE TYPE BODY, 17
- large objects. See LOB datatypes
- LARGE_POOL_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- LAST function, 7.61
- LAST_DAY function, 7.62
- LAST_VALUE function, 7.63
- LDAP_DIRECTORY_ACCESS initialization parameter
-
- setting with ALTER SYSTEM, 11
- LEAD function, 7.64
- LEAST function, 7.65
- left outer joins, 19
- LENGTH function, 7.66
- LENGTH2 function, 7.66
- LENGTH4 function, 7.66
- LENGTHB function, 7.66
- LENGTHC function, 7.66
- less than tests, 6.2
- LEVEL clause
-
- of ALTER DIMENSION, 10.2
- of CREATE DIMENSION, 14, 14
- level columns
-
- specifying default values, 16
- LEVEL pseudocolumn, 3.1.3, 19
-
- and hierarchical queries, 3.1.3
- levels
-
- adding to a dimension, 10.2
- dropping from a dimension, 10.2
- of dimensions, defining, 14
- libraries
-
- creating, 15
- granting system privileges for, 18
- re-creating, 15
- removing from the database, 17
- library units. See Java schema objects
- LICENSE_MAX_SESSIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- LICENSE_MAX_USERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- LICENSE_SESSIONS_WARNING initialization parameter
-
- setting with ALTER SYSTEM, 11
- LIKE conditions, 6.16
- linear regression functions, 7.117
- LIST CHAINED ROWS clause
-
- of ANALYZE, 13
- list partitioning
-
- adding default partition, 12
- adding partitions, 12
- adding values, 12
- creating a default partition, 16
- creating partitions, 16
- dropping values, 12
- merging default with nondefault partitions, 12
- splitting default partition, 12
- list subpartitions
-
- adding, 12
- listeners
-
- registering, 11
- literals
-
- in SQL statements and functions, 2.3
- in SQL syntax, 2.3
- LN function, 7.67
- LNNVL function, 7.68
- LOB columns
-
- adding, 12
- creating from LONG columns, 2.1.1.8, 12
- defining properties
-
- for materialized views, 15
- modifying, 12
- modifying storage, 12
- restricted in joins, 9.6.1
- restrictions on, 2.1.1.18
- storage characteristics of materialized views, 11
- LOB datatypes, 2.1.1.18
- LOB storage clause
-
- for partitions, 12
- of ALTER MATERIALIZED VIEW, 11
- of ALTER TABLE, 12, 12
- of CREATE MATERIALIZED VIEW, 15, 15, 15, 15
- of CREATE TABLE, 16, 16
- LOB_storage_clause
-
- of ALTER MATERIALIZED VIEW, 11
- LOBs
-
- attributes, initializing, 2.1.1.18
- columns
-
- difference from LONG and LONG RAW, 2.1.1.18
- populating, 2.1.1.18
- external, 2.1.1.18
- internal, 2.1.1.18
- locators, 2.1.1.18
- logging attribute, 16
- modifying physical attributes, 12
- number of bytes manipulated in, 16
- saving old versions, 16, 16
- saving values in a cache, 12, 16
- specifying directories for, 14
- storage
-
- attributes, 16
- characteristics, 8
- in-line, 16
- tablespace for
-
- defining, 16
- LOCAL clause
-
- of CREATE INDEX, 14, 14
- local users, 15, 17
- LOCAL_LISTENER initialization parameter
-
- setting with ALTER SYSTEM, 11
- locale independent, 2.4.2.1.2
- locally managed tablespaces
-
- altering, 12
- storage attributes, 8
- locally partitioned indexes, 14
- LOCALTIMESTAMP function, 7.69
- location transparency, 16
- LOCK ANY TABLE system privilege, 18
- LOCK TABLE statement, 18
- LOCK_SGA initialization parameter
-
- setting with ALTER SYSTEM, 11
- locking
-
- automatic
-
- overriding, 18
- locks. See table locks
- log data
-
- collection during update operations, 10.2
- log file clauses
-
- of ALTER DATABASE, 10.2
- log files
-
- adding, 10.2
- dropping, 10.2
- modifying, 10.2
- registering, 10.2
- renaming, 10.2
- specifying for the database, 14
- LOG function, 7.70
- log groups
-
- adding, 12
- dropping, 12
- LOG_ARCHIVE_CONFIG initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_DEST_n initialization parameter
-
- overriding DELAY setting, 10.2
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_DEST_STATE_n initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_DUPLEX_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_FORMAT initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_LOCAL_FIRST initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_MAX_PROCESSES initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_ARCHIVE_TRACE initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_BUFFER initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_CHECKPOINT_INTERVAL initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_CHECKPOINT_TIMEOUT initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_CHECKPOINTS_TO_ALERT initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOG_FILE_NAME_CONVERT initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOGFILE clause
-
- OF CREATE DATABASE, 14
- LOGFILE GROUP clause
-
- of CREATE CONTROLFILE, 14
- logging
-
- and redo log size, 8
- specifying minimal, 8
- supplemental
-
- dropping, 10.2
- supplemental, adding log groups, 10.2, 12
- supplemental, dropping log groups, 10.2, 12
- LOGGING clause
-
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW, 11
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 12
- of ALTER TABLESPACE, 12
- of CREATE MATERIALIZED VIEW, 15
- of CREATE MATERIALIZED VIEW LOG, 15
- of CREATE TABLE, 16
- of CREATE TABLESPACE, 16
- logical conditions, 6.4
- logical standby database
-
- aborting, 10.2
- activating, 10.2
- stopping, 10.2
- LOGICAL_READS_PER_CALL parameter
-
- of ALTER PROFILE, 11
- LOGICAL_READS_PER_SESSION parameter
-
- of ALTER PROFILE, 11
- of ALTER RESOURCE COST, 11
- LogMiner
-
- supplemental logging, 10.2, 12, 16
- LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- LOGOFF database event
-
- triggers on, 16
- LOGON database event
-
- triggers on, 16
- LONG columns
-
- and domain indexes, 12
- converting to LOB, 2.1.1.8, 12
- restrictions on, 2.1.1.8
- to store text strings, 2.1.1.8
- to store view definitions, 2.1.1.8
- where referenced from, 2.1.1.8
- LONG datatype, 2.1.1.8
-
- in triggers, 2.1.1.8
- LONG RAW datatype, 2.1.1.18
-
- converting from CHAR data, 2.1.1.18
- LONG VARGRAPHIC datatype
-
- DB2, 2.1.2, 2.1.2
- SQL/DS, 2.1.2
- LOWER function, 7.71
- LPAD function, 7.72
- LTRIM function, 7.73
M
- MAKE_REF function, 7.74
- MANAGE SCHEDULER system privilege, 18
- MANAGE TABLESPACE system privilege, 18
- managed recovery
-
- of database, 10.2
- wait period of, 10.2
- managed standby recovery
-
- as background process, 10.2
- overriding delays, 10.2
- returning control during, 10.2
- terminating automatically, 10.2
- terminating existing, 10.2
- MANAGED STANDBY RECOVERY clause
-
- of ALTER DATABASE, 10.2, 10.2
- MAP MEMBER clause
-
- of ALTER TYPE, 13
- of CREATE TYPE, 17, 17
- MAP methods
-
- defining for a type, 17
- specifying, 13
- MAPPING TABLE clause
-
- of ALTER TABLE, 12, 12
- mapping tables
-
- of index-organized tables, 12, 16
-
- modifying, 12
- master databases, 15
- master tables, 15
- MATCHES condition, 4.1, 6.1
- materialized join views, 15
- materialized view logs, 15
-
- adding columns, 11
- creating, 15
- excluding new values from, 11
- logging changes to, 11
- object ID based, 11
- parallelizing creation, 15
- partition attributes, changing, 11
- partitioned, 15
- physical attributes
-
- specifying, 15
- physical attributes, changing, 11
- removing from the database, 17
- required for fast refresh, 15
- rowid based, 11
- saving new values in, 11
- saving old values in, 15
- storage attributes
-
- specifying, 15
- materialized views, 15
-
- allowing update of, 15
- changing from rowid-based to primary-key-based, 11
- changing to primary-key-based, 11
- complete refresh, 11, 15
- compression of, 11, 15
- constraints on, 8
- creating, 15
- creating comments about, 13
- degree of parallelism, 11, 11
-
- during creation, 15
- enabling and disabling query rewrite, 15
- examples, 15, 15
- fast refresh, 11, 15, 15
- forced refresh, 11
- granting system privileges for, 18
- index characteristics
-
- changing, 11
- indexes that maintain, 15
- join, 15
- LOB storage attributes, 11
- logging changes to, 11
- master table, dropping, 17
- object type, creating, 15
- partitions, 11
-
- compression of, 11, 15
- physical attributes, 15
-
- changing, 11
- primary key, 15
-
- recording values in master table, 11
- query rewrite
-
- eligibility for, 8
- enabling and disabling, 11
- re-creating during refresh, 11
- refresh
-
- using trusted constraints, 15
- refresh mode
-
- changing, 11
- refresh time
-
- changing, 11
- refreshing, 10.2
- refreshing after DML on master table, 11, 15
- refreshing on next COMMIT, 11, 15
- removing from the database, 17
- restricting scope of, 15
- retrieving data from, 19
- revalidating, 11
- rowid, 15
- rowid values
-
- recording in master table, 11
- saving blocks in a cache, 11
- storage attributes, 15
-
- changing, 11
- subquery, 15
- suppressing creation of default index, 15
- synonyms for, 16
- when to populate, 15
- for replication, 15, 15
- MAX function, 7.75
- MAX_COMMIT_PROPAGATION_DELAY initialization parameter
-
- setting with ALTER SYSTEM, 11
- MAX_DISPATCHERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- MAX_DUMP_FILE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- MAX_SHARED_SERVERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- MAXDATAFILES parameter
-
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- MAXEXTENTS parameter
-
- of STORAGE clause, 8
- MAXINSTANCES parameter
-
- of CREATE CONTROLFILE, 14
- OF CREATE DATABASE, 14
- MAXLOGFILES parameter
-
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- MAXLOGHISTORY parameter
-
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- MAXLOGMEMBERS parameter
-
- of CREATE CONTROLFILE, 14
- of CREATE DATABASE, 14
- MAXSIZE clause
-
- of ALTER DATABASE, 10.2
- MAXTRANS parameter
-
- of physical_attributes_clause, 8
- MAXVALUE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE
- of CREATE SEQUENCE, 15
- media recovery
-
- avoid on startup, 10.2
- designing, 10.2
- disabling, 10.2
- from specified redo logs, 10.2
- of database, 10.2
- of datafiles, 10.2
- of standby database, 10.2
- of tablespaces, 10.2
- parallelizing, 10.2
- performing ongoing, 10.2
- preparing for, 10.2, 10.2
- restrictions, 10.2
- sustained standby recovery, 10.2
- MEDIAN function, 7.76
- median values, 7.101
- MEMBER clause
-
- of ALTER TYPE, 13
- of CREATE TYPE, 17
- MEMBER conditions, 6.17
- membership conditions, 6.10, 6.17
- MERGE PARTITIONS clause
-
- of ALTER TABLE, 12
- MERGE statement, 18, 18
-
- inserts during, 18
- updates during, 18
- merge_insert_clause
-
- of MERGE, 18
- methods
-
- overriding a method a supertype, 17
- preventing overriding in subtypes, 17
- static, 17
- without implementation, 17
- migrated rows
-
- listing, 13
- of clusters, 13
- MIN function, 7.77
- MINEXTENTS parameter
-
- of STORAGE clause, 8
- MINIMIZE RECORDS PER BLOCK clause
-
- of ALTER TABLE, 12
- MINIMUM EXTENT clause
-
- of ALTER TABLESPACE, 12
- of CREATE TABLESPACE, 16
- MINUS set operator, 4.5, 19
- MINVALUE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE
- of CREATE SEQUENCE, 15
- MOD function, 7.78
- MODE clause
-
- of LOCK TABLE, 18
- MODEL clause
-
- of SELECT, 19, 19
- model conditions
-
- IS ANY, 6.12
- IS PRESENT, 6.15
- model expression, 5.11
- model functions, 7.1.5
-
- CV, 7.34
- ITERATION_NUMBER, 7.59
- PRESENTNNV, 7.105
- PRESENTV, 7.106
- PREVIOUS, 7.107
- MODIFY clause
-
- of ALTER TABLE, 12
- MODIFY CONSTRAINT clause
-
- of ALTER TABLE, 12, 12
- of ALTER VIEW, 13
- MODIFY DEFAULT ATTRIBUTES clause
-
- of ALTER INDEX, 10.2, 10.2
- of ALTER TABLE, 12
- MODIFY LOB storage clause
-
- of ALTER MATERIALIZED VIEW, 11, 11
- of ALTER TABLE, 12
- MODIFY NESTED TABLE clause
-
- of ALTER TABLE, 12, 12
- MODIFY PARTITION clause
-
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW, 11
- of ALTER TABLE, 12
- MODIFY scoped_table_ref_constraint clause
-
- of ALTER MATERIALIZED VIEW, 11
- MODIFY SUBPARTITION clause
-
- of ALTER INDEX, 10.2, 10.2
- of ALTER TABLE, 12
- MODIFY VARRAY clause
-
- of ALTER TABLE, 12, 12
- MON datetime format element, 2.4.2.2
- MONITORING clause
-
- of CREATE TABLE, 16
- MONITORING USAGE clause
-
- of ALTER INDEX, 10.2
- MONTH datetime format element, 2.4.2.2
- MONTHS_BETWEEN function, 7.79
- MOUNT clause
-
- of ALTER DATABASE, 10.2
- MOVE clause
-
- of ALTER TABLE, 12, 12
- MOVE ONLINE clause
-
- of ALTER TABLE, 12
- MOVE PARTITION clause
-
- of ALTER TABLE, 12
- MOVE SUBPARTITION clause
-
- of ALTER TABLE, 12
- MTS. See shared server
- multilevel collections, 16
- MULTISET EXCEPT operator, 4.6.1
- MULTISET INTERSECT operator, 4.6.2
- multiset operators, 4.6
-
- MULTISET EXCEPT, 4.6.1
- MULTISET INTERSECT, 4.6.2
- MULTISET UNION, 4.6.3
- MULTISET parameter
-
- of CAST function, 7.15
- MULTISET UNION operator, 4.6.3
- multitable inserts, 18
-
- conditional, 18
- examples, 18
- unconditional, 18
- multi-threaded server. See shared server
N
- NAME clause
-
- of SET TRANSACTION, 19
- NAMED clause
-
- of CREATE JAVA, 14
- namespaces
-
- and object naming rules, 2.8.1
- for nonschema objects, 2.8.1
- for schema objects, 2.8.1
- NANVL function, 7.80
- national character set
-
- changing, 10.2
- fixed versus variable width, 2.1.1.3
- multibyte character data, 2.1.1.22
- multibyte character sets, 2.1.1.2, 2.1.1.3
- variable-length strings, 2.1.1.3
- NATIONAL CHARACTER SET parameter
-
- of CREATE DATABASE, 14
- natural joins, 19
- NCHAR datatype, 2.1.1.2
- NCHR function, 7.81
- NCLOB datatype, 2.1.1.22
-
- transactional support of, 2.1.1.22
- negative scale, 2.1.1.6.2
- nested subqueries, 9.7
- NESTED TABLE clause
-
- of ALTER TABLE, 12, 12
- of CREATE TABLE, 16, 16
- of CREATE TRIGGER, 16
- nested tables, 2.1.3.4, 6.11, 7.103, 7.129
-
- changing returned value, 12
- combining, 4.6
- compared with varrays, 2.2.6
- comparison rules, 2.2.6
- creating, 17, 17
- creating from existing columns, 7.20
- defining as index-organized tables, 12
- determining hierarchy, 6.19
- dropping the body of, 18
- dropping the specification of, 18
- in materialized views, 15, 15
- indexing columns of, 14
- modifying, 12, 13
- modifying column properties, 12
- multilevel, 16
- of scalar types, modifying, 13
- storage characteristics of, 12, 16
- update in a view, 16
- NEW_TIME function, 7.82
- NEXT clause
-
- of ALTER MATERIALIZED VIEW...REFRESH, 11
- NEXT parameter
-
- of STORAGE clause, 8
- NEXT_DAY function, 7.83
- NEXTVAL pseudocolumn, 3.2, 15
- NLS_CALENDAR initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_CHARSET_DECL_LEN function, 7.84
- NLS_CHARSET_ID function, 7.85
- NLS_CHARSET_NAME function, 7.86
- NLS_COMP initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_CURRENCY initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_DATE_FORMAT initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_DATE_LANGUAGE initialization parameter, 2.4.2.2
-
- setting with ALTER SYSTEM, 11
- NLS_DUAL_CURRENCY initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_INITCAP function, 7.87
- NLS_ISO_CURRENCY initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_LANGUAGE initialization parameter, 2.4.2.2, 9.5
-
- setting with ALTER SYSTEM, 11
- NLS_LENGTH_SEMANTICS initialization parameter
-
- overriding, 2.1.1.1
- setting with ALTER SYSTEM, 10.2, 11, 11, 13, 13
- NLS_LOWER function, 7.88
- NLS_NCHAR_CONV_EXCP initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_NUMERIC_CHARACTERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_SORT initialization parameter, 9.5
-
- setting with ALTER SYSTEM, 11
- NLS_TERRITORY initialization parameter, 2.4.2.2
-
- setting with ALTER SYSTEM, 11
- NLS_TIMESTAMP_FORMAT initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_TIMESTAMP_TZ_FORMAT initialization parameter
-
- setting with ALTER SYSTEM, 11
- NLS_UPPER function, 7.90
- NLSPG041, 7.89
- NLSSORT function, 7.89
- NO FORCE LOGGING clause
-
- of ALTER DATABASE, 10.2
- of ALTER TABLESPACE, 12
- NOARCHIVELOG clause
-
- of ALTER DATABASE, 10.2, 10.2
- of CREATE CONTROLFILE, 14
- OF CREATE DATABASE, 10.2, 14
- NOAUDIT statement, 18
- NOCACHE clause
-
- of ALTER CLUSTER, 10.2
- of ALTER MATERIALIZED VIEW, 11
- of ALTER MATERIALIZED VIEW LOG, 11, 11
- of ALTER SEQUENCE. See CREATE SEQUENCE
- of ALTER TABLE, 16
- of CREATE CLUSTER, 14
- of CREATE MATERIALIZED VIEW, 15
- of CREATE MATERIALIZED VIEW LOG, 15
- of CREATE SEQUENCE, 15
- NOCOMPRESS clause
-
- of ALTER INDEX ... REBUILD, 10.2
- of CREATE INDEX, 14
- of CREATE TABLE, 16
- NOCOPY clause
-
- of CREATE FUNCTION, 14
- of CREATE PROCEDURE, 15
- NOCYCLE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE, 11
- of CREATE SEQUENCE, 15
- NOFORCE clause
-
- of CREATE JAVA, 14
- of CREATE VIEW, 17
- NOLOGGING mode
-
- and force logging mode, 8
- for nonpartitioned objects, 8
- for partitioned objects, 8
- NOMAXVALUE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE
- of CREATE SEQUENCE, 15
- NOMINIMIZE RECORDS PER BLOCK clause
-
- of ALTER TABLE, 12
- NOMINVALUE parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE, 11
- of CREATE SEQUENCE, 15
- NOMONITORING clause
-
- of CREATE TABLE, 16
- NOMONITORING USAGE clause
-
- of ALTER INDEX, 10.2
- NONE clause
-
- of SET ROLE, 19
- nonempty subsets of, 7.103
- nonequivalency tests, 6.10
- nonpadded comparison semantics, 2.2.3
- nonschema objects
-
- list of, 2.7.2
- namespaces, 2.8.1
- NOORDER parameter
-
- of ALTER SEQUENCE. See CREATE SEQUENCE, 11
- of CREATE SEQUENCE, 15
- NOPARALLEL clause
-
- of CREATE INDEX, 8, 16
- NORELY clause
-
- of constraints, 8
- NORESETLOGS clause
-
- of CREATE CONTROLFILE, 14
- NOREVERSE parameter
-
- of ALTER INDEX ... REBUILD, 10.2, 10.2
- NOROWDEPENDENCIES clause
-
- of CREATE CLUSTER, 14
- of CREATE TABLE, 16
- NOSORT clause
-
- of ALTER INDEX, 14
- NOT condition, 6.4, 6.4
- NOT DEFERRABLE clause
-
- of constraints, 8
- NOT FINAL clause
-
- of CREATE TYPE, 17
- NOT IDENTIFIED clause
-
- of ALTER ROLE. See CREATE ROLE
- of CREATE ROLE, 15
- NOT IN subqueries
-
- converting to NOT EXISTS subqueries, 7.68
- NOT INSTANTIABLE clause
-
- of CREATE TYPE, 17, 17
- NOT NULL clause
-
- of CREATE TABLE, 16
- NOWAIT clause
-
- of LOCK TABLE, 18
- NTILE function, 7.91
- null, 2.5
-
- difference from zero, 2.5
- in conditions, 2.5.3
-
- table of, 2.5.3
- in functions, 2.5.1
- with comparison conditions, 2.5.2
- null conditions, 6.6
- NULLIF function, 7.92
-
- as a form of CASE expression, 7.92
- NUMBER datatype, 2.1.1.6
-
- converting to VARCHAR2, 2.4.1
- precision, 2.1.1.6
- scale, 2.1.1.6
- number format models, 2.4.1
- number functions, 7.1.1.1
- numbers
-
- comparison rules, 2.2.1
- floating-point, 2.1.1.6, 2.1.1.7
- in SQL syntax, 2.3.2
- precision of, 2.3.2.2
- rounding, 2.1.1.6.2
- spelling out, 2.4.2.5
- syntax of, 2.3.2.2
- numeric precedence, 2.1.1.8
- NUMTODSINTERVAL function, 7.93
- NUMTOYMINTERVAL function, 7.94
- NVARCHAR2 datatype, 2.1.1.3
- NVL function, 7.95
- NVL2 function, 7.96
O
- O7_DICTIONARY_ACCESSIBILITY initialization parameter
-
- setting with ALTER SYSTEM, 11
- object access expressions, 5.9
- OBJECT IDENTIFIER clause
-
- of CREATE TABLE, 16
- object identifiers
-
- contained in REFs, 2.1.3.2
- of object views, 17
- primary key, 16
- specifying, 16, 17
- specifying an index on, 16
- system-generated, 16
- object instances
-
- types of, 6.14
- object privileges
-
- DEBUG, 18
- FLASHBACK, 18
- granting, 15
-
- multiple, 15
- on specific columns, 18
- on a database object
-
- revoking, 18
- ON COMMIT REFRESH, 18
- QUERY REWRITE, 18
- revoking, 18
-
- from a role, 18, 18
- from a user, 18, 18
- from PUBLIC, 18
- UNDER, 18
- object reference functions, 7.1.4
- object tables
-
- adding rows to, 18
- as part of hierarchy, 16
- creating, 16, 16
- querying, 16
- system-generated column name, 16, 16, 17, 17
- updating to latest version, 12
- upgrading, 12
- object type columns
-
- defining properties
-
- for materialized views, 15, 15
- in a type hierarchy, 16
- membership in hierarchy, 12
- modifying properties
-
- for tables, 12, 12
- substitutability, 12
- object type materialized views
-
- creating, 15
- object types, 2.1.3.1
-
- adding methods to, 13
- adding new member subprograms, 13
- allowing object instances of, 17
- allowing subtypes, 17
- and subtypes, 13
- and supertypes, 13
- attributes, 2.9.5
-
- in a type hierarchy, 16
- membership in hierarchy, 12
- substitutability, 12
- bodies
-
- creating, 17
- re-creating, 17
- SQL examples, 17
- comparison rules, 2.2.5
-
- MAP function, 2.2.5
- ORDER function, 2.2.5
- compiling the specification and body, 13
- components of, 2.1.3.1
- creating, 17, 17
- defining member methods of, 17
- disassociating statistics types from, 18
- dropping methods from, 13
- dropping the body of, 18
- dropping the specification of, 18
- function subprogram
-
- declaring, 17
- function subprograms, 13, 17
- granting system privileges for, 18
- handling dependent types, 13
- identifiers, 3.4
- incomplete, 17, 17
- inheritance, 17
- invalidating dependent types, 13
- MAP methods, 17
- methods, 2.9.5
- nested table, 17
- ORDER methods, 17
- privileges on subtypes, 18
- procedure subprogram
-
- declaring, 17
- procedure subprograms, 13, 17
- references to. See REFs
- root, specifying, 17
- SQL examples, 17
- static methods of, 17
- statistics types, 13
- subtypes, specifying, 17
- top-level, 17
- user-defined
-
- creating, 17
- values
-
- comparing, 17, 17, 17
- values of, 3.5
- varrays, 17
- object views, 17
-
- base tables
-
- adding rows, 18
- creating, 17
- creating subviews, 17
- defining, 17
- querying, 17
- OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- OBJECT_CACHE_OPTIMAL_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- OBJECT_ID pseudocolumn, 3.4, 16, 16, 17, 17
- OBJECT_VALUE pseudocolumn, 3.5
- objects. See object types or database objects
- ODCIIndexInsert method
-
- indextype support of, 10.2, 14
- OF clause
-
- of CREATE VIEW, 17
- OFFLINE clause
-
- of ALTER TABLESPACE, 12
- of CREATE TABLESPACE, 16
- OIDINDEX clause
-
- of CREATE TABLE, 16
- OIDs. See object identifiers
- OLAP_PAGE_POOL_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- ON clause
-
- of CREATE OUTLINE, 15
- ON COMMIT clause
-
- of CREATE TABLE, 16
- ON COMMIT REFRESH object privilege, 18
-
- on a materialized view, 18
- ON COMMIT REFRESH system privilege, 18
- ON DATABASE clause
-
- of CREATE TRIGGER, 16
- ON DEFAULT clause
-
- of AUDIT, 13
- of NOAUDIT, 18
- ON DELETE CASCADE clause
-
- of constraints, 8
- ON DELETE SET NULL clause
-
- of constraints, 8
- ON DIRECTORY clause
-
- of AUDIT, 13
- of NOAUDIT, 18
- ON NESTED TABLE clause
-
- of CREATE TRIGGER, 16
- ON object clause
-
- of NOAUDIT, 18
- of REVOKE, 18
- ON PREBUILT TABLE clause
-
- of CREATE MATERIALIZED VIEW, 15
- ON SCHEMA clause
-
- of CREATE TRIGGER, 16
- online backup
-
- of tablespaces, ending, 12
- ONLINE clause
-
- of ALTER TABLESPACE, 12
- of CREATE INDEX, 14
- of CREATE TABLESPACE, 16
- online indexes, 14
-
- rebuilding, 12
- ONLINE parameter
-
- of ALTER INDEX ... REBUILD, 10.2
- online redo logs
-
- reinitializing, 10.2
- OPEN clause
-
- of ALTER DATABASE, 10.2
- OPEN READ ONLY clause
-
- of ALTER DATABASE, 10.2
- OPEN READ WRITE clause
-
- of ALTER DATABASE, 10.2
- OPEN_CURSORS initialization parameter
-
- setting with ALTER SYSTEM, 11
- OPEN_LINKS initialization parameter
-
- setting with ALTER SYSTEM, 11
- OPEN_LINKS_PER_INSTANCE initialization parameter
-
- setting with ALTER SYSTEM, 11
- operands, 4
- operating system files
-
- dropping, 18
- removing, 10.2
- operators, 4
-
- adding to indextypes, 10.2
- altering, 11
- arithmetic, 4.2
- binary, 4.1.1
- comments on, 13
- concatenation, 4.3
- CONNECT_BY_ROOT, 4.4.2
- dropping from indextypes, 10.2
- granting
-
- system privileges for, 18
- MULTISET EXCEPT, 4.6.1
- MULTISET INTERSECT, 4.6.2
- MULTISET UNION, 4.6.3
- precedence, 4.1.2
- PRIOR, 4.4.1
- set, 4.5, 19
- specifying implementation of, 15
- unary, 4.1.1
- user-defined, 4.7
-
- binding to a function, 11, 15
- creating, 15
- dropping, 17
- how bindings are implemented, 15
- implementation type, 15
- return type of binding, 15
- user-defined, compiling, 11
- OPTIMAL parameter
-
- of STORAGE clause, 8
- OPTIMIZER_DYNAMIC_SAMPLING initialization parameter
-
- setting with ALTER SYSTEM, 11
- OPTIMIZER_FEATURES_ENABLE initialization parameter
-
- setting with ALTER SYSTEM, 11
- OPTIMIZER_INDEX_CACHING initialization parameter
-
- setting with ALTER SYSTEM, 11
- OPTIMIZER_INDEX_COST_ADJ initialization parameter
-
- setting with ALTER SYSTEM, 11
- OPTIMIZER_MODE initialization parameter
-
- setting with ALTER SYSTEM, 11
- OR condition, 6.4, 6.4
- OR REPLACE clause
-
- of CREATE CONTEXT, 14
- of CREATE DIRECTORY, 14
- of CREATE FUNCTION, 14, 14
- of CREATE LIBRARY, 15
- of CREATE OUTLINE, 15
- of CREATE PACKAGE, 15
- of CREATE PACKAGE BODY, 15
- of CREATE PROCEDURE, 15
- of CREATE TRIGGER, 16
- of CREATE TYPE, 17
- of CREATE TYPE BODY, 17
- of CREATE VIEW, 17
- ORA_HASH function, 7.97
- ORA_ROWSCN pseudocolumns, 3.6
- Oracle Call Interface, 1.7
- Oracle Expression Filter
-
- conditions, 6.1
- operators, 4.1
- Oracle reserved words, D
- Oracle Text
-
- built-in conditions, 4.1, 6.1
- CATSEARCH, 4.1, 6.1
- CONTAINS, 4.1, 6.1
- MATCHES, 4.1, 6.1
- Oracle Tools
-
- support of SQL, 1.7
- Oracle9i Text
-
- creating domain indexes, 14
- ORDER BY clause
-
- of queries, 9.5
- of SELECT, 9.5, 19, 19
-
- with ROWNUM, 3.8
- ORDER clause
-
- of ALTER SEQUENCE. See CREATE SEQUENCE
- ORDER MEMBER clause
-
- of ALTER TYPE, 13
- of CREATE TYPE BODY, 17
- ORDER methods
-
- defining for a type, 17
- specifying, 13
- ORDER parameter
-
- of CREATE SEQUENCE, 15
- ORDER SIBLINGS BY clause
-
- of SELECT, 19
- ordinal numbers
-
- specifying, 2.4.2.5
- spelling out, 2.4.2.5
- ORDSYS.ORDAudio datatype, 2.1.8.1
- ORDSYS.ORDDoc datatype, 2.1.8.5
- ORDSYS.ORDImage datatype, 2.1.8.2
- ORDSYS.ORDImageSignature datatype, 2.1.8.3
- ORDSYS.ORDVideo datatype, 2.1.8.4
- ORDSYS.SI_AverageColor datatype, 2.1.8.8
- ORDSYS.SI_Color datatype, 2.1.8.7
- ORDSYS.SI_ColorHistogram datatype, 2.1.8.9
- ORDSYS.SI_FeatureList datatype, 2.1.8.12
- ORDSYS.SI_PositionalColorHistogram datatype, 2.1.8.10
- ORDSYS.SI_StillImage datatype, 2.1.8.6
- ORDSYS.SI_Texture datatype, 2.1.8.11
- ORGANIZATION EXTERNAL clause
-
- of CREATE TABLE, 16, 16
- ORGANIZATION HEAP clause
-
- of CREATE TABLE, 16
- ORGANIZATION INDEX clause
-
- of CREATE TABLE, 16
- OS_AUTHENT_PREFIX initialization parameter
-
- setting with ALTER SYSTEM, 11
- OS_ROLES initialization parameter
-
- setting with ALTER SYSTEM, 11
- OSM_DISKGROUPS initialization parameter
-
- setting with ALTER SYSTEM, 10.2, 11, 14
- OSM_DISKSTRING initialization parameter
-
- setting with ALTER SYSTEM, 11, 14
- OSM_POWER_LIMIT initialization parameter
-
- setting with ALTER SYSTEM, 11
- OUT parameter
-
- of CREATE FUNCTION, 14
- of CREATE PROCEDURE, 15
- outer joins, 9.6.6
-
- restrictions, 9.6.6
- outlines
-
- assign to a different category, 11
- assigning to a different category, 11, 11
- copying, 15
- creating, 15
- creating on statements, 15
- dropping from the database, 17
- enabling and disabling dynamically, 15
- for use by current session, 15
- for use by PUBLIC, 15
- granting
-
- system privileges for, 18
- private, use by the optimizer, 11
- rebuilding, 11, 11
- recompiling, 11
- renaming, 11, 11, 11
- replacing, 15
- storing during the session, 11
- storing groups of, 15
- use by the optimizer, 11
- use to generate execution plans, 11
- used to generate execution plans, 15
- out-of-line constraints
-
- of CREATE TABLE, 16
- OVER clause
-
- of analytic functions, 7.1.3
- OVERFLOW clause
-
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- of CREATE TABLE, 16
- OVERRIDING clause
-
- of ALTER TYPE, 13
- of CREATE TYPE, 17
P
- package bodies
-
- creating, 15
- re-creating, 15
- removing from the database, 17
- packaged procedures
-
- dropping, 17
- packages
-
- associating statistics with, 13, 13
- creating, 15
- disassociating statistics types from, 17
- invoker rights, 15
- redefining, 15
- removing from the database, 17
- specifying schema and privileges of, 15
- synonyms for, 16
- PARALLEL clause
-
- of ALTER CLUSTER, 10.2, 10.2
- of ALTER DATABASE, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW, 11, 11
- of ALTER MATERIALIZED VIEW LOG, 11, 11
- of ALTER TABLE, 12
- of CREATE CLUSTER, 14
- of CREATE INDEX, 14
- of CREATE MATERIALIZED VIEW, 15, 15
- of CREATE MATERIALIZED VIEW LOG, 15, 15
- of CREATE TABLE, 16, 16
- parallel execution
-
- of DDL statements, 11
- of DML statements, 11
- PARALLEL_ADAPTIVE_MULTI_USER initialization parameter
-
- setting with ALTER SYSTEM, 11
- PARALLEL_ENABLE clause
-
- of CREATE FUNCTION, 14
- PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- PARALLEL_INSTANCE_GROUP initialization parameter
-
- setting with ALTER SYSTEM, 11
- PARALLEL_MAX_SERVERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- PARALLEL_MIN_PERCENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- PARALLEL_MIN_SERVERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- PARALLEL_THREADS_PER_CPU initialization parameter
-
- setting with ALTER SYSTEM, 11
- parameter files
-
- creating, 15
- parameters
-
- in syntax
-
- optional, A.1.2
- required, A.1.1
- PARAMETERS clause
-
- of CREATE INDEX, 14
- PARTITION ... LOB storage clause
-
- of ALTER TABLE, 12
- PARTITION BY HASH clause
-
- of CREATE TABLE, 16
- PARTITION BY LIST clause
-
- of CREATE TABLE, 16
- PARTITION BY RANGE clause
-
- of CREATE TABLE, 16, 16
- PARTITION clause
-
- of ANALYZE, 13
- of CREATE INDEX, 14
- of CREATE TABLE, 16
- of DELETE, 17
- of INSERT, 18
- of LOCK TABLE, 18
- of UPDATE, 19
- partition_storage_clause
-
- of ALTER TABLE, 12
- partitioned indexes, 2.9.4, 14, 14, 14
-
- local, creating, 14
- user-defined, 14
- partitioned index-organized tables
-
- secondary indexes, updating, 10.2
- partitioned tables, 2.9.4
- partition-extended table names
-
- in DML statements, 2.9.4
- restrictions on, 2.9.4
- syntax, 2.9.4
- partitioning
-
- by range, 16
- clauses
-
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- of materialized view logs, 11, 15
- of materialized views, 11, 15, 15
- partitions
-
- adding, 12
- adding rows to, 18
- allocating extents for, 12
- based on literal values, 16
- composite
-
- specifying, 16
- converting into nonpartitioned tables, 12
- deallocating unused space from, 12
- dropping, 12
- exchanging with tables, 12
- extents
-
- allocating for an index, 10.2
- hash
-
- adding, 12
- coalescing, 12
- specifying, 16
- index, 14
- inserting rows into, 18
- list, adding, 12
- LOB storage characteristics of, 12
- locking, 18
- logging attribute, 16
- logging insert operations, 12
- merging, 12
- modifying, 12, 12
- moving to a different segment, 12
- physical attributes
-
- changing, 12
- range
-
- adding, 12
- specifying, 16
- removing rows from, 12, 17
- renaming, 12
- revising values in, 19
- splitting, 12
- storage characteristics, 8
- tablespace for
-
- defining, 16
- PASSWORD EXPIRE clause
-
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
- PASSWORD_GRACE_TIME parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- PASSWORD_LIFE_TIME parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- PASSWORD_LOCK_TIME parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- PASSWORD_REUSE_MAX parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- PASSWORD_REUSE_TIME parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- PASSWORD_VERIFY_FUNCTION parameter
-
- of ALTER PROFILE, 11
- of CREATE PROFILE, 15
- passwords
-
- expiration of, 17
- grace period, 15
- guaranteeing complexity, 15
- limiting use and reuse, 15
- locking, 15
- making unavailable, 15
- parameters
-
- of CREATE PROFILE, 15
- special characters in, 15
- PATH_VIEW, 6.8, 6.20
- PCT_ACCESS_DIRECT statistics
-
- for index-organized tables, 13
- PCTFREE parameter
-
- of ALTER CLUSTER, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 12
- of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE.
- of CREATE MATERIALIZED VIEW. See CREATE TABLE.
- of CREATE TABLE, 8
- PCTINCREASE parameter
-
- of STORAGE clause, 8
- PCTTHRESHOLD parameter
-
- of CREATE TABLE, 16
- PCTUSED parameter
-
- of ALTER CLUSTER, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 12
- of CREATE INDEX. See CREATE TABLE
- of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE.
- of CREATE MATERIALIZED VIEW. See CREATE TABLE.
- of CREATE TABLE, 8
- PCTVERSION parameter
-
- of LOB storage, 16
- of LOB storage clause, 12
- PERCENT_RANK function, 7.99
- PERCENTILE_CONT function, 7.100
- PERCENTILE_DISC function, 7.101
- PERMANENT clause
-
- of ALTER TABLESPACE, 12
- PGA_AGGREGATE_TARGET initialization parameter
-
- setting with ALTER SYSTEM, 11
- physical attributes clause
-
- of ALTER CLUSTER, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 12
- of CREATE CLUSTER, 14
- of CREATE MATERIALIZED VIEW, 15
- of CREATE TABLE, 16, 16
- physical standby database
-
- activating, 10.2
- PIPELINED clause
-
- of CREATE FUNCTION, 14
- plan stability, 15
- PLAN_TABLE sample table, 18
- PL/SQL
-
- program body
-
- of CREATE FUNCTION, 14
- PL/SQL compiler
-
- parameters, 10.2, 11, 13, 13
- PLSQL_CODE_TYPE initialization parameter
-
- setting with ALTER SYSTEM, 11
- PLSQL_DEBUG initialization parameter
-
- setting with ALTER SYSTEM, 11
- PLSQL_DEBUG session parameter, 11
- PLSQL_NATIVE_LIBRARY_DIR initialization parameter
-
- setting with ALTER SYSTEM, 11
- PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter
-
- setting with ALTER SYSTEM, 11
- PLSQL_OPTIMIZE_LEVEL initialization parameter
-
- setting with ALTER SYSTEM, 11
- PLSQL_V2_COMPATIBILITY initialization parameter
-
- setting with ALTER SYSTEM, 11
- PLSQL_WARNINGS initialization parameter
-
- setting with ALTER SYSTEM, 11
- P.M. datetime format element, 2.4.2.2, 2.4.2.2
- POSIX regular expression standard, C
- POWER function, 7.102
- POWERMULTISET function, 7.103
- POWERMULTISET_BY_CARDINALITY function, 7.104
- PRAGMA clause
-
- of ALTER TYPE, 13
- of CREATE TYPE, 17, 17
- PRAGMA RESTRICT_REFERENCES, 13
- PRE_PAGE_SGA initialization parameter
-
- setting with ALTER SYSTEM, 11
- precedence
-
- of conditions, 6.1.1
- of numbers, 2.1.1.8
- of operators, 4.1.2
- precision
-
- number of digits of, 2.3.2.2
- of NUMBER datatype, 2.1.1.6
- precompilers, 1.7
- PREPARE TO SWITCHOVER clause
-
- of ALTER DATABASE, 10.2
- PRESENTNNV function, 7.105
- PRESENTV function, 7.106
- PREVIOUS function, 7.107
- PRIMARY KEY clause
-
- of constraints, 8
- of CREATE TABLE, 16
- primary key constraints, 8
-
- enabling, 16
- index on, 16
- primary keys
-
- generating values for, 15
- PRIOR clause
-
- of hierarchical queries, 9.3
- PRIOR operator, 4.4.1
- PRIVATE clause
-
- of CREATE OUTLINE, 15
- private outlines
-
- use by the optimizer, 11
- PRIVATE_SGA parameter
-
- of ALTER PROFILE, 11
- of ALTER RESOURCE COST, 11
- privileges
-
- on subtypes of object types, 18
- revoking from a grantee, 18
- See also system privileges or object privileges
- procedures
-
- 3GL, calling, 15
- avoid run-time compilation, 11
- calling, 13
- compile explicitly, 11
- creating, 15, 15
- declaring
-
- as a Java method, 15
- as C functions, 15
- executing, 13
- external, 15, 15
-
- running from remote database, 15
- granting
-
- system privileges for, 18
- invalidating local objects dependent on, 17
- issuing COMMIT or ROLLBACK statements, 11
- naming rules, 2.8.1
- privileges executed with, 13, 17
- recompiling, 11
- re-creating, 15
- removing from the database, 17
- schema executed in, 13, 17
- specifying schema and privileges for, 15
- synonyms for, 16
- PROCESSES initialization parameter
-
- setting with ALTER SYSTEM, 11
- PROFILE clause
-
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
- profiles
-
- adding resource limits, 11
- assigning to a user, 17
- changing resource limits, 11
- creating, 15
-
- examples, 15
- deassigning from users, 17
- dropping resource limits, 11
- granting
-
- system privileges for, 18
- modifying, examples, 11
- removing from the database, 17
- proxy clause
-
- of ALTER USER, 13, 13
- pseudocolumns, 3
-
- CONNECT_BY_ISCYCLE, 3.1.1
- CONNECT_BY_ISLEAF, 3.1.2
- CURRVAL, 3.2
- hierarchical queries, 3.1
- LEVEL, 3.1.3
- NEXTVAL, 3.2
- OBJECT_ID, 3.4, 16, 16, 17, 17
- OBJECT_VALUE, 3.5
- ORA_ROWSCN, 3.6
- ROWID, 3.7
- ROWNUM, 3.8
-
- uses for, 3.8
- versions queries, 3.3
- XMLDATA, 3.9
- PUBLIC clause
-
- of CREATE OUTLINE, 15
- of CREATE SYNONYM, 16
- of DROP DATABASE LINK, 17
- public database links
-
- dropping, 17
- public synonyms, 16
-
- dropping, 18
- PURGE statement, 18
Q
- queries, 9.1, 19
-
- comments in, 9.2
- compound, 9.5
- correlated
-
- left correlation, 19
- defined, 9.1
- distributed, 9.10
- grouping returned rows on a value, 19
- hierarchical. See hierarchical queries
- hierarchical, ordering, 19
- hints in, 9.2
- join, 9.6, 19
- locking rows during, 19
- multiple versions of rows, 19
- of past data, 19
- ordering returned rows, 19
- outer joins in, 19
- referencing multiple tables, 9.6
- select lists of, 9.2
- selecting from a random sample of rows, 19
- sorting results, 9.5
- syntax, 9.1
- top-level, 9.1
- top-N, 3.8
- query rewrite
-
- and dimensions, 14
- defined, 19
- QUERY REWRITE object privilege, 18
-
- on a materialized view, 18
- QUERY REWRITE system privilege, 18
- QUERY_REWRITE_ENABLED initialization parameter
-
- setting with ALTER SYSTEM, 11
- QUERY_REWRITE_INTEGRITY initialization parameter
-
- setting with ALTER SYSTEM, 11
- QUIESCE RESTRICTED clause
-
- of ALTER SYSTEM, 11
- QUOTA clause
-
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
R
- range conditions, 6.5
- range partitions
-
- adding, 12
- creating, 16
- values of, 16
- RANK function, 7.108
- RATIO_TO_REPORT function, 7.109
- RAW datatype, 2.1.1.18
-
- converting from CHAR data, 2.1.1.18
- RAWTOHEX function, 7.110
- RAWTONHEX function, 7.111
- RDBMS_SERVER_DN initialization parameter
-
- setting with ALTER SYSTEM, 11
- READ object privilege, 18
-
- on a materialized directory, 18
- READ ONLY clause
-
- of ALTER TABLESPACE, 12
- READ WRITE clause
-
- of ALTER TABLESPACE, 12
- READ_ONLY_OPEN_DELAYED initialization parameter
-
- setting with ALTER SYSTEM, 11
- REBUILD clause
-
- of ALTER INDEX, 10.2
- of ALTER OUTLINE, 11
- REBUILD PARTITION clause
-
- of ALTER INDEX, 10.2
- REBUILD SUBPARTITION clause
-
- of ALTER INDEX, 10.2
- REBUILD UNUSABLE LOCAL INDEXES clause
-
- of ALTER TABLE, 12
- RECOVER AUTOMATIC clause
-
- of ALTER DATABASE, 10.2
- RECOVER CANCEL clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER clause
-
- of ALTER DATABASE, 10.2
- RECOVER CONTINUE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER DATABASE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER DATAFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER LOGFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER MANAGED STANDBY DATABASE clause
-
- of ALTER DATABASE, 10.2
- RECOVER STANDBY DATAFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER STANDBY TABLESPACE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVER TABLESPACE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RECOVERABLE, 10.2, 16
-
- See also LOGGING clause
- recovery
-
- discarding data, 10.2
- distributed, enabling, 11
- instance, continue after interruption, 10.2
- media, designing, 10.2
- media, performing ongoing, 10.2
- of database, 10.2
- parallelizing, 10.2
- recovery clauses
-
- of ALTER DATABASE, 10.2
- RECOVERY_CATALOG_OWNER role, 18
- RECOVERY_PARALLELISM initialization parameter
-
- setting with ALTER SYSTEM, 11
- recycle bin
-
- purging objects from, 18
- redo log files
-
- specifying, 8
- specifying for a controlfile, 14
- redo logs, 10.2
-
- adding, 10.2, 10.2
- applying to logical standby database, 10.2
- archive location, 11
- automatic archiving, 11
-
- starting, 11
- stopping, 11
- automatic name generation, 10.2, 10.2
- clearing, 10.2
- disabling specified threads in a cluster database, 10.2
- dropping, 10.2, 10.2
- enabling and disabling thread, 10.2
- enabling specified threads in a cluster database, 10.2
- manual archiving, 11
-
- all, 11
- by group number, 11
- by SCN, 11
- current, 11
- next, 11
- with sequence numbers, 11
- members
-
- adding to existing groups, 10.2
- dropping, 10.2
- renaming, 10.2
- remove changes from, 10.2
- reusing, 8
- size of, 8
- specifying, 8, 14
-
- for media recovery, 10.2
- specifying archive mode, 14
- switching groups, 11
- threads, 11
- REF columns
-
- rescoping, 11
- specifying, 16
- specifying from table or column, 16
- REF constraints
-
- defining scope, for materialized views, 11
- of ALTER TABLE, 12
- REF function, 7.112
- REFERENCES clause
-
- of CREATE TABLE, 16
- REFERENCES object privilege, 18
-
- on a table, 18
- on a view, 18
- REFERENCING clause
-
- of CREATE TRIGGER, 16, 16
- referential integrity constraints, 8
- REFRESH clause
-
- of ALTER MATERIALIZED VIEW, 11, 11
- of CREATE MATERIALIZED VIEW, 15
- REFRESH COMPLETE clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- REFRESH FAST clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- REFRESH FORCE clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- REFRESH ON COMMIT clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- REFRESH ON DEMAND clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- REFs, 2.1.3.2, 8
-
- as containers for OIDs, 2.1.3.2
- dangling, 13
- updating, 13
- validating, 13
- REFTOHEX function, 7.113
- REGISTER clause
-
- of ALTER SYSTEM, 11
- REGISTER LOGFILE clause
-
- of ALTER DATABASE, 10.2
- REGR_AVGX function, 7.117
- REGR_AVGY function, 7.117
- REGR_COUNT function, 7.117
- REGR_INTERCEPT function, 7.117
- REGR_R2 function, 7.117
- REGR_SLOPE function, 7.117
- REGR_SXX function, 7.117
- REGR_SXY function, 7.117
- REGR_SYY function, 7.117
- regular expressions
-
- multilingual syntax, C.1
- operators, multilingual enhancements, C.2
- Oracle support of, C
- relational tables
-
- creating, 16, 16
- RELY clause
-
- of constraints, 8
- REMAINDER function, 7.118
- REMOTE_ARCHIVE_ENABLE initialization parameter
-
- setting with ALTER SYSTEM, 11
- REMOTE_DEPENDENCIES_MODE initialization parameter
-
- setting with ALTER SYSTEM, 11
- REMOTE_LISTENER initialization parameter
-
- setting with ALTER SYSTEM, 11
- REMOTE_LOGIN_PASSWORDFILE initialization parameter
-
- and control files, 14
- and databases, 14
- setting with ALTER SYSTEM, 11
- REMOTE_OS_AUTHENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- REMOTE_OS_ROLES initialization parameter
-
- setting with ALTER SYSTEM, 11
- RENAME clause
-
- of ALTER INDEX, 10.2
- of ALTER OUTLINE, 11
- of ALTER TABLE, 12
- of ALTER TABLESPACE, 12
- of ALTER TRIGGER, 13
- RENAME CONSTRAINT clause
-
- of ALTER TABLE, 12
- RENAME DATAFILE clause
-
- of ALTER TABLESPACE, 12
- RENAME FILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- RENAME GLOBAL_NAME clause
-
- of ALTER DATABASE, 10.2
- RENAME PARTITION clause
-
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- RENAME statement, 18
- RENAME SUBPARTITION clause
-
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- REPLACE AS OBJECT clause
-
- of ALTER TYPE, 13
- REPLACE function, 7.119
- replication
-
- row-level dependency tracking, 14, 16
- REPLICATION_DEPENDENCY_TRACKING initialization parameter
-
- setting with ALTER SYSTEM, 11
- reserved words, 2.8.1, D
- RESET COMPATIBILITY clause
-
- of ALTER DATABASE, 10.2
- reset sequence of, 10.2
- RESETLOGS parameter
-
- of CREATE CONTROLFILE, 14
- RESOLVE clause
-
- of ALTER JAVA CLASS, 10.2
- of CREATE JAVA, 14
- RESOLVER clause
-
- of ALTER JAVA CLASS, 10.2
- of ALTER JAVA SOURCE, 10.2
- of CREATE JAVA, 14
- Resource Manager, 11
- resource parameters
-
- of CREATE PROFILE, 15
- RESOURCE role, 18
- RESOURCE_LIMIT initialization parameter
-
- setting with ALTER SYSTEM, 11
- RESOURCE_MANAGER_PLAN initialization parameter
-
- setting with ALTER SYSTEM, 11
- RESOURCE_VIEW, 6.8, 6.20
- RESTRICT_REFERENCES pragma
-
- of ALTER TYPE, 13
- restricted rowids, 2.1.1.23
-
- compatibility and migration of, 2.1.1.25
- RESTRICTED SESSION system privilege, 18, 18
- resumable space allocation, 11
- RESUMABLE system privilege, 18
- RESUMABLE_TIMEOUT initialization parameter
-
- setting with ALTER SYSTEM, 11
- RESUME clause
-
- of ALTER SYSTEM, 11
- RETENTION parameter
-
- of LOB storage, 16
- RETURN clause
-
- of CREATE FUNCTION, 14
- of CREATE OPERATOR, 15
- of CREATE TYPE, 17
- of CREATE TYPE BODY, 17
- RETURNING clause
-
- of DELETE, 17
- of INSERT, 18, 18
- of UPDATE, 19, 19
- REUSE clause
-
- of CREATE CONTROLFILE, 14
- of file specifications, 8
- REUSE SETTINGS clause
-
- of ALTER FUNCTION, 10.2
- of ALTER PROCEDURE, 11
- of ALTER TRIGGER, 13
- of ALTER TYPE, 13
- REVERSE clause
-
- of CREATE INDEX, 14
- reverse indexes, 14
- REVERSE parameter
-
- of ALTER INDEX ... REBUILD, 10.2, 10.2
- REVOKE clause
-
- of ALTER USER, 13
- REVOKE CONNECT THROUGH clause
-
- of ALTER USER, 13, 13
- REVOKE statement, 18
- right outer joins, 19
- RNDS attribute
-
- of PRAGMA RESTRICT_REFERENCES, 17
- RNPS attribute
-
- of PRAGMA RESTRICT_REFERENCES, 17
- roles
-
- AQ_ADMINISTRATOR_ROLE, 18
- AQ_USER_ROLE, 18
- authorization
-
- by a password, 15
- by an external service, 15
- by the database, 15
- by the enterprise directory service, 15
- changing, 11
- CONNECT, 18
- creating, 15
- DBA, 18
- DELETE_CATALOG_ROLE, 18
- disabling
-
- for the current session, 19, 19
- enabling
-
- for the current session, 19, 19
- EXECUTE_CATALOG_ROLE, 18
- EXP_FULL_DATABASE, 18
- granting, 18
-
- system privileges for, 18
- to a user, 18
- to another role, 18
- to PUBLIC, 18
- HS_ADMIN_ROLE, 18
- identifying by password, 15
- identifying externally, 15
- identifying through enterprise directory service, 15
- identifying using a package, 15
- IMP_FULL_DATABASE, 18
- RECOVERY_CATALOG_OWNER, 18
- removing from the database, 17
- RESOURCE, 18
- revoking, 18
-
- from another role, 17, 18
- from PUBLIC, 18
- from users, 17, 18
- SELECT_CATALOG_ROLE, 18
- SNMPAGENT, 18
- rollback segments
-
- granting
-
- system privileges for, 18
- removing from the database, 17
- specifying optimal size of, 8
- ROLLBACK statement, 18
- rollback undo, 11, 14
- ROLLBACK_SEGMENTS initialization parameter
-
- setting with ALTER SYSTEM, 11
- ROLLUP clause
-
- of SELECT statements, 19
- ROUND function
-
- date function, 7.121
- format models, 7.207
- number function, 7.120
- routines
-
- calling, 13
- executing, 13
- ROW EXCLUSIVE lock mode, 18
- ROW SHARE lock mode, 18
- ROW_NUMBER function, 7.122
- ROWDEPENDENCIES clause
-
- of CREATE CLUSTER, 14
- of CREATE TABLE, 16
- ROWID datatype, 2.1.1.22
- ROWID pseudocolumn, 2.1.1.22, 2.1.1.26, 3.7
- rowids
-
- block portion of, 2.1.1.23
- description of, 2.1.1.22
- extended, 2.1.1.24
-
- base 64, 2.1.1.24
- not directly available, 2.1.1.24
- file portion of, 2.1.1.23
- nonphysical, 2.1.1.26
- of foreign tables, 2.1.1.26
- of index-organized tables, 2.1.1.26
- restricted, 2.1.1.23
-
- compatibility and migration of, 2.1.1.25
- row portion of, 2.1.1.23
- uses for, 3.7
- ROWIDTOCHAR function, 7.123
- ROWIDTONCHAR function, 7.124
- row-level dependency tracking, 14, 16
- ROWNUM pseudocolumn, 3.8
-
- uses for, 3.8
- rows
-
- adding to a table, 18
- allowing movement of between partitions, 16
- inserting
-
- into partitions, 18
- into remote databases, 18
- into subpartitions, 18
- movement between partitions, 16
- removing
-
- from a cluster, 19
- from a table, 19
- from partitions and subpartitions, 17
- from tables and views, 17
- selecting in hierarchical order, 9.3
- specifying constraints on, 8
- storing if in violation of constraints, 12
- RPAD function, 7.125
- RR datetime format element, 2.4.2.4
- RTRIM function, 7.126
- run-time compilation
-
- avoiding, 11, 13
S
- SAMPLE clause
-
- of SELECT, 19
- of SELECT and subqueries, 19
- SAVEPOINT statement, 19
- savepoints
-
- erasing, 13
- rolling back to, 18, 18
- specifying, 19
- scalar subqueries, 5.10
- scalar subquery expressions, 5.10
- scale
-
- greater than precision, 2.1.1.6.3
- negative, 2.1.1.6.2
- of NUMBER datatype, 2.1.1.6
- SCHEMA clause
-
- of CREATE JAVA, 14
- schema objects, 2.7.1
-
- auditing
-
- options, 13
- defining default buffer pool for, 8
- dropping, 18
- in other schemas, 2.9.2
- list of, 2.7.1
- name resolution, 2.9.1
- namespaces, 2.8.1
- naming
-
- examples, 2.8.2
- guidelines, 2.8.3
- rules, 2.8.1
- object types, 2.1.3.1
- on remote databases, 2.9.3
- partitioned indexes, 2.9.4
- partitioned tables, 2.9.4
- parts of, 2.8
- protecting location, 16
- protecting owner, 16
- providing alternate names for, 16
- reauthorizing, 10.1.1
- recompiling, 10.1.1
- referring to, 2.9, 11
- remote, accessing, 14
- validating structure, 13
- schemas
-
- changing for a session, 11
- creating, 15
- definition of, 2.7.1
- scientific notation, 2.4.1.1
- SCOPE FOR clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW, 15
- SDO_GEOMETRY datatype, 2.1.7
- SDO_GEORASTER datatype, 2.1.7
- security
-
- enforcing, 16
- segment attributes clause
-
- of CREATE TABLE, 16
- SEGMENT MANAGEMENT clause
-
- of CREATE TABLESPACE, 16
- segments
-
- space management
-
- automatic, 16
- manual, 16
- using bitmaps, 16
- using free lists, 16
- table
-
- compacting, 10.2, 11, 11, 12
- SELECT ANY DICTIONARY system privilege, 18
- SELECT ANY SEQUENCE system privilege, 18
- SELECT ANY TABLE system privilege, 18
- select lists, 9.2
-
- ordering, 9.5
- SELECT object privilege, 18
-
- on a materialized view, 18
- on a sequence, 18
- on a table, 18
- on a view, 18
- SELECT statement, 9.1, 19
- SELECT_CATALOG_ROLE role, 18
- self joins, 9.6.3
- semijoins, 9.6.8
- sequences, 3.2, 15
-
- accessing values of, 15
- changing
-
- the increment value, 11
- creating, 15
- creating without limit, 15
- granting
-
- system privileges for, 18
- guarantee consecutive values, 15
- how to use, 3.2.2
- increment value, setting, 15
- incrementing, 15
- initial value, setting, 15
- maximum value
-
- eliminating, 11
- setting, 15
- setting or changing, 11
- minimum value
-
- eliminating, 11
- setting, 15
- setting or changing, 11
- number of cached values, changing, 11
- ordering values, 11
- preallocating values, 15
- recycling values, 11
- removing from the database, 18
- renaming, 18
- restarting, 18
-
- at a different number, 11
- at a predefined limit, 15
- values, 15
- reusing, 15
- stopping at a predefined limit, 15
- synonyms for, 16
- where to use, 3.2.1
- SERIAL_REUSE initialization parameter
-
- setting with ALTER SYSTEM, 11
- server parameter files
-
- creating, 15
- SERVERERROR event
-
- triggers on, 16, 16
- service name
-
- of remote database, 14
- SERVICE_NAMES initialization parameter
-
- setting with ALTER SYSTEM, 11
- session control statements, 10.1.4
-
- PL/SQL support of, 10.1.4
- session locks
-
- releasing, 11
- session parameters
-
- changing settings, 11
- INSTANCE, 11
- PLSQL_DEBUG, 11
- SESSION_CACHED_CURSORS initialization parameter
-
- setting with ALTER SYSTEM, 11
- SESSION_MAX_OPEN_FILES initialization parameter
-
- setting with ALTER SYSTEM, 11
- SESSION_ROLES view, 19
- sessions
-
- calculating resource cost limits, 11
- changing resource cost limits, 11
- disconnecting, 11
- granting
-
- system privileges for, 18
- limiting CPU time, 11
- limiting data block reads, 11
- limiting inactive periods, 11
- limiting private SGA space, 11
- limiting resource costs, 11
- limiting total elapsed time, 11
- limiting total resources, 11
- modifying characteristics of, 11
- restricting, 11
- restricting to privileged users, 11
- switching to a different instance, 11
- terminating, 11
- time zone setting, 11
- SESSIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- SESSIONS_PER_USER parameter
-
- of ALTER PROFILE, 11
- SESSIONTIMEZONE function, 7.128
- SET clause
-
- of ALTER SESSION, 11
- of ALTER SYSTEM, 11
- SET conditions, 6.11
- SET CONSTRAINT(S) statement, 19
- SET DANGLING TO NULL clause
-
- of ANALYZE, 13
- SET DATABASE clause
-
- of CREATE CONTROLFILE, 14
- SET function, 7.129
- set operators, 4.5, 19
-
- INTERSECT, 4.5
- MINUS, 4.5
- UNION, 4.5
- UNION ALL, 4.5
- SET ROLE statement, 19
- SET STANDBY DATABASE clause
-
- of ALTER DATABASE, 10.2
- SET STATEMENT_ID clause
-
- of EXPLAIN PLAN, 18
- SET TIME_ZONE clause
-
- of ALTER DATABASE, 10.2, 10.2
- of ALTER SESSION, 11
- of CREATE DATABASE, 14
- SET TRANSACTION statement, 19
- SET UNUSED clause
-
- of ALTER TABLE, 12
- SGA. See system global area (SGA)
- SGA_MAX_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- SGA_TARGET initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHADOW_CORE_DUMP initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHARE ROW EXCLUSIVE lock mode, 18
- SHARE UPDATE lock mode, 18
- SHARED clause
-
- of CREATE DATABASE LINK, 14
- shared pool
-
- flushing, 11
- shared server
-
- processes
-
- creating additional, 11
- terminating, 11
- system parameters, 11
- SHARED_MEMORY_ADDRESS initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHARED_POOL_RESERVED_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHARED_POOL_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHARED_SERVER_SESSIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHARED_SERVERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- SHRINK SPACE clause
-
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW, 11
- of ALTER MATERIALIZED VIEW LOG, 11
- of ALTER TABLE, 12
- SHUTDOWN clause
-
- of ALTER SYSTEM, 11
- SHUTDOWN event
-
- triggers on, 16
- siblings
-
- ordering in a hierarchical query, 19
- SIGN function, 7.130
- simple comparison conditions, 6.2.1
- simple expressions, 5.2
- SIN function, 7.131
- SINGLE TABLE clause
-
- of CREATE CLUSTER, 14
- single-row functions, 7.1.1
-
- miscellaneous, 7.1.1.7
- single-table insert, 18
- SINH function, 7.132
- SIZE clause
-
- of ALTER CLUSTER, 10.2
- of CREATE CLUSTER, 14
- of file specifications, 8
- SKIP_UNUSABLE_INDEXES initialization parameter
-
- setting with ALTER SYSTEM, 11
- SKIP_UNUSABLE_INDEXES session parameter, 11
- SMTP_OUT_SERVER initialization parameter
-
- setting with ALTER SYSTEM, 11
- SNMPAGENT role, 18
- SOME operator, 6.2
- SORT_AREA_RETAINED_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- SORT_AREA_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- SOUNDEX function, 7.133
- SP datetime format element suffix, 2.4.2.5
- special characters
-
- in passwords, 15
- spelled numbers
-
- specifying, 2.4.2.5
- SPFILE initialization parameter
-
- setting with ALTER SYSTEM, 11
- SPLIT PARTITION clause
-
- of ALTER INDEX, 10.2
- of ALTER TABLE, 12
- SPTH datetime format element suffix, 2.4.2.5
- SQL functions
-
- ABS, 7.2
- ACOS, 7.3
- ADD_MONTHS, 7.4
- aggregate, 7.1.2
- analytic, 7.1.3
- applied to LOB columns, 7.1
- ASCII, 7.5
- ASCIISTR, 7.6
- ASIN, 7.7
- ATAN, 7.8
- ATAN2, 7.9
- AVG, 7.10
- BFILENAME, 7.11
- BIN_TO_NUM, 7.12
- BITAND, 7.13
- CARDINALITY, 7.14
- CAST, 7.15
- CEIL, 7.16
- character
-
- returning character values, 7.1.1.2
- returning number values, 7.1.1.3
- CHARTOROWID, 7.17
- CHR, 7.18
- COALESCE, 7.19
- COLLECT, 7.20
- COMPOSE, 7.21
- CONCAT, 7.22
- conversion, 7.1.1.5
- CONVERT, 7.23
- CORR, 7.24
- CORR_K, 7.25.2
- CORR_S, 7.25.1
- COS, 7.26
- COSH, 7.27
- COUNT, 7.28
- COVAR_POP, 7.29
- COVAR_SAMP, 7.30
- CUME_DIST, 7.31
- CURRRENT_DATE, 7.32
- CURRRENT_TIMESTAMP, 7.33
- CV, 7.34
- date, 7.1.1.4
- DBTIMEZONE, 7.35
- DECOMPOSE, 7.37
- DENSE_RANK, 7.38
- DEREF, 7.40
- DUMP, 7.41
- EMPTY_BLOB, 7.42
- EMPTY_CLOB, 7.42
- EXISTSNODE, 7.43
- EXP, 7.44
- EXTRACT (datetime), 7.45
- EXTRACT (XML), 7.46
- EXTRACTXML, 7.47
- FIRST, 7.48
- FIRST_VALUE, 7.49
- FLOOR, 7.50
- FROM_TZ, 7.51
- GREATEST, 7.52
- GROUP_ID, 7.53
- GROUPING, 7.54
- GROUPING_ID, 7.55
- HEXTORAW, 7.56
- INITCAP, 7.57
- INSTR, 7.58
- INSTR2, 7.58
- INSTR4, 7.58
- INSTRB, 7.58
- INSTRC, 7.58
- ITERATION_NUMBER, 7.59
- LAG, 7.60
- LAST, 7.61
- LAST_DAY, 7.62
- LAST_VALUE, 7.63
- LEAD, 7.64
- LEAST, 7.65
- LENGTH, 7.66
- LENGTH2, 7.66
- LENGTH4, 7.66
- LENGTHB, 7.66
- LENGTHC, 7.66
- linear regression, 7.117
- LN, 7.67
- LNNVL, 7.68
- LOCALTIMESTAMP, 7.69
- LOG, 7.70
- LOWER, 7.71
- LPAD, 7.72
- LTRIM, 7.73
- MAKE_REF, 7.74
- MAX, 7.75
- MEDIAN, 7.76
- MIN, 7.77
- MOD, 7.78
- model, 7.1.5
- MONTHS_BETWEEN, 7.79
- NANVL, 7.80
- NCHR, 7.81
- NEW_TIME, 7.82
- NEXT_DAY, 7.83
- NLS_CHARSET_DECL_LEN, 7.84
- NLS_CHARSET_ID, 7.85
- NLS_CHARSET_NAME, 7.86
- NLS_INITCAP, 7.87
- NLS_LOWER, 7.88
- NLS_UPPER, 7.90
- NLSSORT, 7.89
- NLV2, 7.96
- NTILE, 7.91
- NULLIF, 7.92
- number, 7.1.1.1
- NUMTODSINTERVAL, 7.93
- NUMTOYMINTERVAL, 7.94
- NVL, 7.95
- object reference, 7.1.4
- ORA_HASH, 7.97
- PERCENT_RANK, 7.99
- PERCENTILE_CONT, 7.100
- PERCENTILE_DISC, 7.101
- POWER, 7.102
- POWERMULTISET, 7.103
- POWERMULTISET_BY_CARDINALITY, 7.104
- PRESENTNNV, 7.105
- PRESENTV, 7.106
- PREVIOUS, 7.107
- RANK, 7.108
- RATIO_TO_REPORT, 7.109
- RAWTOHEX, 7.110
- RAWTONHEX, 7.111
- REF, 7.112
- REFTOHEX, 7.113
- REGR_AVGX, 7.117
- REGR_AVGY, 7.117
- REGR_COUNT, 7.117
- REGR_INTERCEPT, 7.117
- REGR_R2, 7.117
- REGR_SLOPE, 7.117
- REGR_SXX, 7.117
- REGR_SXY, 7.117
- REGR_SYY, 7.117
- REMAINDER, 7.118
- REPLACE, 7.119
- ROUND (date), 7.121
- ROUND (number), 7.120
- ROW_NUMBER, 7.122
- ROWIDTOCHAR, 7.123
- ROWIDTONCHAR, 7.124
- RPAD, 7.125
- RTRIM, 7.126
- SESSIONTIMEZONE, 7.128
- SET, 7.129
- SIGN, 7.130
- SIN, 7.131
- single-row, 7.1.1
-
- miscellaneous, 7.1.1.7
- SINH, 7.132
- SOUNDEX, 7.133
- SQRT, 7.134
- STATS_BINOMIAL_TEST, 7.135
- STATS_CROSSTAB, 7.136
- STATS_F_TEST, 7.137
- STATS_KS_TEST, 7.138
- STATS_MODE, 7.139
- STATS_MW_TEST, 7.140
- STATS_ONE_WAY_ANOVA, 7.141
- STATS_T_TEST_INDEP, 7.142, 7.142.3
- STATS_T_TEST_INDEPU, 7.142, 7.142.3
- STATS_T_TEST_ONE, 7.142, 7.142.1
- STATS_T_TEST_PAIRED, 7.142, 7.142.2
- STATS_WSR_TEST, 7.143
- STDDEV, 7.144
- STDDEV_POP, 7.145
- STDDEV_SAMP, 7.146
- SUBSTR, 7.147
- SUBSTR2, 7.147
- SUBSTR4, 7.147
- SUBSTRB, 7.147
- SUBSTRC, 7.147
- SUM, 7.148
- SYS_CONNECT_BY_PATH, 7.149
- SYS_CONTEXT, 7.150
- SYS_DBURIGEN, 7.151
- SYS_EXTRACT_UTC, 7.152
- SYS_GUID, 7.153
- SYS_TYPEID, 7.154
- SYS_XMLAGG, 7.155
- SYS_XMLGEN, 7.156
- SYSDATE, 7.157
- SYSTIMESTAMP, 7.158
- TAN, 7.159
- TANH, 7.160
- TIMESTAMP_TO_SCN, 7.161
- TO_BINARY_DOUBLE, 7.162
- TO_BINARY_FLOAT, 7.163
- TO_CHAR (character), 7.164
- TO_CHAR (datetime), 7.165
- TO_CHAR (number), 7.166
- TO_CLOB, 7.167
- TO_DATE, 7.168
- TO_DSINTERVAL, 7.169
- TO_LOB, 7.170
- TO_MULTI_BYTE, 7.171
- TO_NCHAR (character), 7.172
- TO_NCHAR (datetime), 7.173
- TO_NCHAR (number), 7.174
- TO_NCLOB, 7.175
- TO_NUMBER, 7.176
- TO_SINGLE_BYTE, 7.177
- TO_TIMESTAMP, 7.178
- TO_YMINTERVAL, 7.180
- TRANSLATE, 7.181
- TRANSLATE...USING, 7.182
- TREAT, 7.183
- TRIM, 7.184
- TRUNC (date), 7.186
- TRUNC (number), 7.185
- t-test, 7.142
- TZ_OFFSET, 7.187
- UID, 7.188
- UNISTR, 7.189
- UPDATEXML, 7.190
- UPPER, 7.191
- USER, 7.192
- USERENV, 7.193
- VALUE, 7.194
- VAR_POP, 7.195
- VAR_SAMP, 7.196
- VARIANCE, 7.197
- VSIZE, 7.198
- WIDTH_BUCKET, 7.199
- XMLAGG, 7.200
- XMLCONCAT, 7.202
- SQL statements
-
- auditing
-
- by access, 13
- by proxy, 13
- by session, 13
- by user, 13
- stopping, 18
- successful, 13
- DDL, 10.1.1
- determining the execution plan for, 18
- DML, 10.1.2
- organization of, 10.2
- rolling back, 18
- session control, 10.1.4
- space allocation, resumable, 11
- suspending and completing, 11
- system control, 10.1.5
- tracking the occurrence in a session, 13
- transaction control, 10.1.3
- type of, 10.1
- undoing, 18
- SQL*Loader inserts, logging, 10.2
- SQL:99 standards, 1.2
- SQL_TRACE initialization parameter, 11
-
- setting with ALTER SYSTEM, 11
- SQL92_SECURITY initialization parameter
-
- setting with ALTER SYSTEM, 11
- SQLData Java storage format, 17
- SQL/DS datatypes, 2.1.2
-
- conversion to Oracle datatypes, 2.1.2
- restrictions on, 2.1.2
- SQLJ object types
-
- creating, 17
- mapping a Java class to, 17
- SQLTUNE_CATEGORY initialization parameter
-
- setting with ALTER SYSTEM, 11
- SQRT function, 7.134
- standalone procedures
-
- dropping, 17
- standard SQL, B
-
- Oracle extensions to, B.1.9
- standby database
-
- recovering, 10.2
- standby databases
-
- activating, 10.2
- applying archive logs, 10.2
- committing to primary status, 10.2
- controlling use, 10.2
- designing media recovery, 10.2
- mounting, 10.2
- recovering, 10.2, 10.2
- STANDBY_ARCHIVE_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- STANDBY_FILE_MANAGEMENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- STAR_TRANSFORMATION_ENABLED initialization parameter
-
- setting with ALTER SYSTEM, 11
- START LOGICAL STANDBY APPLY clause
-
- of ALTER DATABASE, 10.2
- START WITH clause
-
- of ALTER MATERIALIZED VIEW...REFRESH, 11
- of queries and subqueries, 19
- of SELECT and subqueries, 19
- START WITH parameter
-
- of CREATE SEQUENCE, 15
- STARTUP event
-
- triggers on, 16
- startup_clauses
-
- of ALTER DATABASE, 10.2
- STATIC clause
-
- of ALTER TYPE, 13
- of CREATE TYPE, 17
- statistics
-
- collection during index rebuild, 10.2
- computing exactly, 13
- deleting from the data dictionary, 13
- estimating, 13
- forcing disassociation, 17
- on index usage, 10.2
- on indexes, 14
- on scalar object attributes
-
- collecting, 13
- on schema objects
-
- collecting, 13
- deleting, 13
- user-defined
-
- dropping, 17, 17, 17, 18, 18
- statistics types
-
- associating
-
- with columns, 13
- associating with datatypes, 13, 13
- associating with domain indexes, 13, 13
- associating with functions, 13, 13
- associating with indextypes, 13, 13
- associating with packages, 13, 13
- disassociating
-
- from columns, 17
- from domain indexes, 17
- from functions, 17
- from indextypes, 17
- from packages, 17
- from types, 17
- STATISTICS_LEVEL initialization parameter
-
- setting with ALTER SYSTEM, 11
- STATS_BINOMIAL_TEST function, 7.135
- STATS_CROSSTAB function, 7.136
- STATS_F_TEST function, 7.137
- STATS_KS_TEST function, 7.138
- STATS_MODE function, 7.139
- STATS_MW_TEST function, 7.140
- STATS_ONE_WAY_ANOVA function, 7.141
- STATS_T_TEST_INDEP function, 7.142, 7.142.3
- STATS_T_TEST_INDEPU function, 7.142, 7.142.3
- STATS_T_TEST_ONE function, 7.142, 7.142.1
- STATS_T_TEST_PAIRED function, 7.142, 7.142.2
- STATS_WSR_TEST function, 7.143
- STDDEV function, 7.144
- STDDEV_POP function, 7.145
- STDDEV_SAMP function, 7.146
- STOP LOGICAL STANDBY clause
-
- of ALTER DATABASE, 10.2
- STORAGE clause
-
- of ALTER CLUSTER, 10.2
- of ALTER INDEX, 10.2
- of ALTER MATERIALIZED VIEW LOG, 11
- of CREATE MATERIALIZED VIEW LOG, 15
- of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE
- of CREATE TABLE, 8, 16
- of CREATE TABLESPACE, 16
- storage parameters
-
- default, changing, 12
- resetting, 19
- STORE IN clause
-
- of ALTER TABLE, 12, 16
- stored functions, 14
- STREAMS_POOL_SIZE initialization parameter
-
- setting with ALTER SYSTEM, 11
- string literals. See text literals.
- strings
-
- converting to ASCII values, 7.6
- converting to unicode, 7.21
- Structured Query Language (SQL)
-
- description, 1.2.1
- functions, 7.1
- keywords, A.1.1
- Oracle Tools support of, 1.7
- parameters, A.1.1
- standards, 1.2, B
- statements
-
- determining the cost of, 18
- syntax, 10.2, A.1
- SUBMULTISET condition, 6.19
- SUBPARTITION BY HASH clause
-
- of CREATE TABLE, 16, 16
- SUBPARTITION BY LIST clause
-
- of CREATE TABLE, 16
- SUBPARTITION clause
-
- of ANALYZE, 13
- of DELETE, 17
- of INSERT, 18
- of LOCK TABLE, 18
- of UPDATE, 19
- subpartition template
-
- creating, 12
- replacing, 12
- subpartition-extended table names
-
- in DML statements, 2.9.4
- restrictions on, 2.9.4
- syntax, 2.9.4
- subpartitions
-
- adding, 12
- adding rows to, 18
- allocating extents for, 12, 12
- coalescing, 12, 12
- converting into nonpartitioned tables, 12
- creating, 16
- creating a template for, 12, 16
- deallocating unused space from, 12, 12
- exchanging with tables, 12
- hash, 16
- inserting rows into, 18
- list, 16
- list, adding, 12
- locking, 18
- logging insert operations, 12
- moving to a different segment, 12
- physical attributes
-
- changing, 12
- removing rows from, 12, 17
- renaming, 12
- revising values in, 19
- specifying, 16
- template, creating, 16
- template, dropping, 12
- template, replacing, 12
- subqueries, 9.1, 9.7, 19, 19
-
- assigning names to, 19
- containing subqueries, 9.7
- correlated, 9.7
- defined, 9.1
- extended subquery unnesting, 9.8
- factoring of, 19
- inline views, 9.7
- nested, 9.7
- of past data, 19
- scalar, 5.10
-
- used as expressions, 5.10
- to insert table data, 16
- unnesting, 9.8
- using in place of expressions, 5.10
- SUBSTR function, 7.147
- SUBSTR2 function, 7.147
- SUBSTR4 function, 7.147
- SUBSTRB function, 7.147
- SUBSTRC function, 7.147
- subtotal values
-
- deriving, 19
- subtypes, 13
-
- dropping safely, 18
- SUM function, 7.148
- supertypes, 13
- supplemental logging
-
- identification key (full), 10.2
- minimal, 10.2
- SUSPEND clause
-
- of ALTER SYSTEM, 11
- sustained standby recovery mode, 10.2
- SWITCH LOGFILE clause
-
- of ALTER SYSTEM, 11
- synonyms
-
- changing the definition of, 18
- creating, 16
- granting
-
- system privileges for, 18
- local, 16
- private, dropping, 18
- public, 16
-
- dropping, 18
- remote, 16
- removing from the database, 18
- renaming, 18, 18
- synonyms for, 16
- syntax diagrams, A.1
-
- loops, A.1.3
- multipart diagrams, A.1.4
- SYS schema
-
- database triggers stored in, 16
- functions stored in, 16
- SYS user
-
- assigning password for, 14
- SYS_CONNECT_BY_PATH function, 7.149
- SYS_CONTEXT function, 7.150
- SYS_DBURIGEN function, 7.151
- SYS_EXTRACT_UTC function, 7.152
- SYS_GUID function, 7.153
- SYS_NC_ROWINFO$ column, 16, 17
- SYS_TYPEID function, 7.154
- SYS_XMLAGG function, 7.155
- SYS_XMLGEN function, 7.156
- SYSAUX clause
-
- of CREATE DATABASE, 14
- SYSAUX tablespace
-
- creating, 14, 16
- SYSDATE function, 7.157
- SYSDBA system privilege, 18
- SYSOPER system privilege, 18
- system change numbers
-
- obtaining, 3.6
- system control statements, 10.1.5
-
- PL/SQL support of, 10.1.5
- system events
-
- attributes of, 16
- triggers on, 16
- system global area
-
- flushing, 11, 11
- updating, 11
- system privileges
-
- ADMINISTER ANY SQL TUNING SET, 18
- ADMINISTER DATABASE TRIGGER, 18
- ADMINISTER SQL TUNING SET, 18
- ADVISOR, 18
- ALTER ANY CLUSTER, 18
- ALTER ANY DIMENSION, 18
- ALTER ANY INDEX, 18
- ALTER ANY INDEXTYPE, 18
- ALTER ANY MATERIALIZED VIEW, 18
- ALTER ANY OPERATOR, 18
- ALTER ANY OUTLINE, 18
- ALTER ANY PROCEDURE, 18
- ALTER ANY ROLE, 18
- ALTER ANY SEQUENCE, 18
- ALTER ANY SQL PROFILE, 18
- ALTER ANY TABLE, 18
- ALTER ANY TRIGGER, 18
- ALTER ANY TYPE, 18
- ALTER DATABASE, 18
- ALTER PROFILE, 18
- ALTER RESOURCE COST, 18
- ALTER ROLLBACK SEGMENT, 18
- ALTER SESSION, 18
- ALTER SYSTEM, 18
- ALTER TABLESPACE, 18
- ALTER USER, 18
- ANALYZE ANY, 18
- AUDIT ANY, 18
- AUDIT SYSTEM, 18
- BACKUP ANY TABLE, 18
- COMMENT ANY TABLE, 18
- CREATE ANY CLUSTER, 18
- CREATE ANY CONTEXT, 18
- CREATE ANY DIMENSION, 18
- CREATE ANY DIRECTORY, 18
- CREATE ANY INDEX, 18
- CREATE ANY INDEXTYPE, 18
- CREATE ANY JOB, 18
- CREATE ANY LIBRARY, 18
- CREATE ANY MATERIALIZED VIEW, 18
- CREATE ANY OPERATOR, 18
- CREATE ANY OUTLINE, 18
- CREATE ANY PROCEDURE, 18
- CREATE ANY SEQUENCE, 18
- CREATE ANY SQL PROFILE, 18, 18
- CREATE ANY SYNONYM, 18
- CREATE ANY TABLE, 18
- CREATE ANY TRIGGER, 18
- CREATE ANY TYPE, 18
- CREATE ANY VIEW, 18
- CREATE CLUSTER, 18
- CREATE DATABASE LINK, 18
- CREATE DIMENSION, 18
- CREATE INDEXTYPE, 18
- CREATE JOB, 18
- CREATE LIBRARY, 18
- CREATE MATERIALIZED VIEW, 18
- CREATE OPERATOR, 18
- CREATE PROCEDURE, 18
- CREATE PROFILE, 18
- CREATE PUBLIC DATABASE LINK, 18
- CREATE PUBLIC SYNONYM, 18
- CREATE ROLE, 18
- CREATE ROLLBACK SEGMENT, 18
- CREATE SEQUENCE, 18
- CREATE SESSION, 18
- CREATE SYNONYM, 18
- CREATE TABLE, 18
- CREATE TABLESPACE, 18
- CREATE TRIGGER, 18
- CREATE TYPE, 18
- CREATE USER, 18
- CREATE VIEW, 18
- DEBUG ANY PROCEDURE, 18
- DELETE ANY TABLE, 18
- DROP ANY CLUSTER, 18
- DROP ANY CONTEXT, 18
- DROP ANY DIMENSION, 18
- DROP ANY DIRECTORY, 18
- DROP ANY INDEX, 18
- DROP ANY INDEXTYPE, 18
- DROP ANY LIBRARY, 18
- DROP ANY MATERIALIZED VEIW, 18
- DROP ANY OPERATOR, 18
- DROP ANY OUTLINE, 18
- DROP ANY PROCEDURE, 18
- DROP ANY ROLE, 18
- DROP ANY SEQUENCE, 18
- DROP ANY SYNONYM, 18
- DROP ANY TABLE, 18
- DROP ANY TRIGGER, 18
- DROP ANY TYPE, 18
- DROP ANY VIEW, 18
- DROP PROFILE, 18
- DROP PUBLIC DATABASE LINK, 18
- DROP PUBLIC SYNONYM, 18
- DROP ROLLBACK SEGMENT, 18
- DROP TABLESPACE, 18
- DROP USER, 18
- EXECUTE ANY CLASS, 18
- EXECUTE ANY INDEXTYPE, 18
- EXECUTE ANY OPERATOR, 18
- EXECUTE ANY PROCEDURE, 18
- EXECUTE ANY PROGRAM, 18
- EXECUTE ANY TYPE, 18
- EXEMPT ACCESS POLICY, 18
- FLASHBACK ANY TABLE, 18, 18, 18
- for job scheduler tasks, 18
- for the Advisor framework, 18
- FORCE ANY TRANSACTION, 18
- FORCE TRANSACTION, 18
- GLOBAL QUERY REWRITE, 18
- GRANT ANY OBJECT PRIVILEGE, 18
- GRANT ANY PRIVILEGE, 18
- GRANT ANY ROLE, 18
- granting, 15, 18
-
- to a role, 18
- to a user, 18
- to PUBLIC, 18
- INSERT ANY TABLE, 18
- list of, 18
- LOCK ANY TABLE, 18
- MANAGE SCHEDULER, 18
- MANAGE TABLESPACE, 18
- ON COMMIT REFRESH, 18
- QUERY REWRITE, 18
- RESTRICTED SESSION, 18, 18
- RESUMABLE, 18
- revoking, 18
-
- from a role, 18
- from a user, 18
- from PUBLIC, 18
- SELECT ANY DICTIONARY, 18
- SELECT ANY SEQUENCE, 18
- SELECT ANY TABLE, 18
- SYSDBA, 18
- SYSOPER, 18
- UNDER ANY TYPE, 18
- UNDER ANY VIEW, 18
- UNLIMITED TABLESPACE, 18
- UPDATE ANY TABLE, 18
- SYSTEM tablespace
-
- locally managed, 14
- SYSTEM user
-
- assigning password for, 14
- SYSTIMESTAMP function, 7.158
T
- table
-
- XMLType, querying, 16
- TABLE clause
-
- of ANALYZE, 13
- of INSERT, 18
- of SELECT, 19, 19
- of TRUNCATE, 19
- of UPDATE, 19, 19
- table compression, 11, 12, 15, 16
- table functions
-
- creating, 14
- table locks
-
- disabling, 12
- duration of, 18
- enabling, 12
- EXCLUSIVE, 18, 18
- modes of, 18
- on partitions, 18
- on remote database, 18
- on subpartitions, 18
- ROW EXCLUSIVE, 18, 18
- ROW SHARE, 18, 18
- SHARE, 18
- SHARE ROW EXCLUSIVE, 18
- SHARE UPDATE, 18
- and queries, 18
- table partitions
-
- compression of, 12, 16
- table REF constraints, 8
-
- of CREATE TABLE, 16
- tables
-
- adding rows to, 18
- aliases, 2.9.5
-
- in CREATE INDEX, 14
- in DELETE, 17
- allocating extents for, 12
- assigning to a cluster, 16
- changing degree of parallelism on, 12
- changing existing values in, 19
- collecting statistics on, 13
- comments on, 13
- compression of, 12, 16
- creating, 16
-
- multiple, 15
- creating comments about, 13
- data stored outside database, 16
- deallocating unused space from, 12
- default physical attributes
-
- changing, 12
- degree of parallelism
-
- specifying, 16
- disassociating statistics types from, 18
- dropping
-
- along with cluster, 17
- along with owner, 18
- indexes of, 18
- partitions of, 18
- external, 16
-
- creating, 16
- restrictions on, 16
- externally organized, 16
- flashing back to an earlier version, 18
- granting
-
- system privileges for, 18
- heap organized, 16
- index-organized, 16
-
- overflow segment for, 16
- space in index block, 16
- inserting rows with a subquery, 16
- inserting using the direct-path method, 18
- joining in a query, 19
- LOB storage of, 8
- locking, 18
- logging
-
- insert operations, 12
- table creation, 16
- migrated and chained rows in, 13
- moving, 12
- moving to a new segment, 12
- moving, index-organized, 12
- nested
-
- creating, 17
- storage characteristics, 16
- object
-
- creating, 16
- object, querying, 16
- of XMLType, creating, 16
- organization, defining, 16
- parallel creation of, 16
- parallelism
-
- setting default degree, 16
- partition attributes of, 12
- partitioning, 2.9.4, 16, 16
-
- allowing rows to move between partitions, 12
- default attributes of, 12
- physical attributes
-
- changing, 12
- purging from the recycle bin, 18
- relational
-
- creating, 16
- remote, accessing, 14
- removing from the database, 18
- removing rows from, 17
- renaming, 12, 18
- restricting
-
- records in a block, 12
- retrieving data from, 19
- saving blocks in a cache, 16
- SQL examples, 16
- storage attributes
-
- defining, 16
- storage characteristics
-
- defining, 8
- storage properties, 16
- storage properties of, 16
- subpartition attributes of, 12
- synonyms for, 16
- tablespace for
-
- defining, 16, 16
- temporary
-
- duration of data, 16
- session-specific, 16
- transaction specific, 16
- unclustering, 17
- updating through views, 17
- validating structure, 13
- with unusable indexes, 11
- TABLESPACE clause
-
- of ALTER INDEX ... REBUILD, 10.2
- of CREATE CLUSTER, 14
- of CREATE INDEX, 14
- of CREATE MATERIALIZED VIEW, 15
- of CREATE MATERIALIZED VIEW LOG, 15
- of CREATE TABLE, 16
- tablespaces, 12
-
- allocating space for users, 17
- allowing write operations on, 12
- automatic segment-space management, 16
- backing up datafiles, 12
- bigfile, 16
-
- database default, 14
- default temporary, 14
- resizing, 12
- undo, 14
- bringing online, 12, 16
- coalescing free extents, 12
- converting
-
- from permanent to temporary, 12
- from temporary to permanent, 12
- creating, 16
- datafiles
-
- adding, 12
- renaming, 12
- default, 10.2
-
- specifying for a user, 13
- default permanent, 14
- default temporary, 10.2
-
- learning name of, 10.2
- designing media recovery, 10.2
- dropping contents, 18
- ending online backup, 12
- extent size, 16
- granting system privileges for, 18
- in FLASHBACK mode, 12, 16
- in FORCE LOGGING mode, 12, 16
- locally managed, 8
-
- altering, 12
- logging attribute, 12, 16
- managing extents of, 16
- read only, 12
- reconstructing lost or damaged, 10.2, 10.2
- recovering, 10.2, 10.2
- removing from the database, 18
- renaming, 12
- size of free extents in, 12
- smallfile, 16
-
- database default, 14
- default temporary, 14
- undo, 14
- specifying
-
- datafiles for, 16
- for a table, 16
- for a user, 17
- for index rebuild, 12
- taking offline, 12, 16
- tempfiles
-
- adding, 12
- temporary
-
- specifying for a user, 13, 17
- temporary, creating, 16
- temporary, defining for the database, 14
- undo
-
- altering, 12
- creating, 14, 16
- dropping, 18
- TAN function, 7.159
- TANH function, 7.160
- TAPE_ASYNCH_IO initialization parameter
-
- setting with ALTER SYSTEM, 11
- TEMPFILE clause
-
- of ALTER DATABASE, 10.2, 10.2
- tempfiles
-
- bringing online, 10.2
- defining for a tablespace, 16, 16, 16
- defining for the database, 14
- disabling autoextend, 10.2
- dropping, 10.2
- enabling autoextend, 8, 10.2
- extending automatically, 8
- renaming, 10.2
- resizing, 10.2
- reusing, 8
- size of, 8
- specifying, 8, 8
- taking offline, 10.2
- TEMPORARY clause
-
- of ALTER TABLESPACE, 12
- of CREATE TABLESPACE, 16
- temporary tables
-
- creating, 16, 16
- session-specific, 16
- transaction-specific, 16
- TEMPORARY TABLESPACE clause
-
- of ALTER USER, 13
- of ALTER USER. See CREATE USER
- of CREATE USER, 17
- temporary tablespace groups
-
- reassigning for a user, 13
- specifying for a user, 17
- temporary tablespaces
-
- creating, 16
- default, 10.2
- specifying extent management during database creation, 14
- specifying for a user, 13, 17
- TEST clause
-
- of ALTER DATABASE ... RECOVER, 10.2
- testing for a set, 6.11
- text
-
- date and number formats, 2.4
- literals in SQL syntax, 2.3.1
- properties of CHAR and VARCHAR2 datatypes, 2.3.1
- syntax of, 2.3.1
- text literals in SQL syntax, 2.3.1
- TH datetime format element suffix, 2.4.2.5
- THREAD initialization parameter
-
- setting with ALTER SYSTEM, 11
- THSP datetime format element suffix, 2.4.2.5
- TIME datatype
-
- DB2, 2.1.2, 2.1.2
- SQL/DS, 2.1.2, 2.1.2
- time format models
-
- short, 2.4.1.1, 2.4.2.1.2
- time zone
-
- determining for session, 7.128
- formatting, 2.4.2.1.2
- setting for the database, 14
- time zones
-
- converting data to particular, 5.6
- TIME_ZONE session parameter, 11
- TIMED_OS_STATISTICS initialization parameter
-
- setting with ALTER SYSTEM, 11
- TIMED_STATISTICS initialization parameter
-
- setting with ALTER SYSTEM, 11
- timestamp
-
- converting to local time zone, 5.6
- TIMESTAMP datatype, 2.1.1.10
-
- DB2, 2.1.2, 2.1.2
- SQL/DS, 2.1.2, 2.1.2
- TIMESTAMP WITH LOCAL TIME ZONE datatype, 2.1.1.12
- TIMESTAMP WITH TIME ZONE datatype, 2.1.1.11
- TIMESTAMP_TO_SCN function, 7.161
- TO SAVEPOINT clause
-
- of ROLLBACK, 18
- TO_BINARY_DOUBLE function, 7.162
- TO_BINARY_FLOAT function, 7.163
- TO_CHAR
-
- datetime conversion function, 7.165
- number conversion function, 7.166
- TO_CHAR (character) function, 7.164
- TO_CHAR function, 2.4.1, 2.4.2, 2.4.3
- TO_CLOB function, 7.167
- TO_DATE function, 2.4.2, 2.4.2.4, 2.4.3, 7.168
- TO_DSINTERVAL function, 7.169
- TO_LOB function, 7.170
- TO_MULTI_BYTE function, 7.171
- TO_NCHAR (character) function, 7.172
- TO_NCHAR (datetime) function, 7.173
- TO_NCHAR (number) function, 7.174
- TO_NCLOB function, 7.175
- TO_NUMBER function, 2.4.1, 7.176
- TO_SINGLE_BYTE function, 7.177
- TO_TIMESTAMP function, 7.178
- TO_TIMESTAMP_TZ function
-
- SQL functions
-
- TO_TIMESTAMP_TZ, 7.179
- TO_YMINTERVAL function, 7.180
- top-N reporting, 3.8, 7.38, 7.108, 7.122
- TRACE_ENABLED initialization parameter
-
- setting with ALTER SYSTEM, 11
- TRACEFILE_IDENTIFIER initialization parameter
-
- setting with ALTER SYSTEM, 11
- transaction control statements, 10.1.3
-
- PL/SQL support of, 10.1.3
- transactions
-
- allowing to complete, 11
- assigning
-
- rollback segment to, 19
- automatically committing, 13
- changes, making permanent, 13
- commenting on, 13
- distributed, forcing, 11
- ending, 13
- implicit commit of, 10.1.1, 10.1.2, 10.1.4, 10.1.5
- in-doubt
-
- committing, 13
- forcing, 13
- resolving, 19
- isolation level, 19
- locks, releasing, 13
- naming, 19
- read-only, 19
- read/write, 19
- rolling back, 11, 18
-
- to a savepoint, 18
- savepoints for, 19
- TRANSACTIONS initialization parameter
-
- setting with ALTER SYSTEM, 11
- TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- TRANSLATE ... USING function, 7.182
- TRANSLATE function, 7.181
- TREAT function, 7.183
- triggers
-
- AFTER, 16
- BEFORE, 16
- compiling, 13, 13
- creating, 16
-
- multiple, 16
- database
-
- altering, 13
- dropping, 18, 18
- disabling, 12, 13
- enabling, 12, 13, 13, 16
- executing
-
- with a PL/SQL block, 16
- with an external procedure, 16
- granting
-
- system privileges for, 18
- INSTEAD OF, 16
-
- dropping, 17
- on database events, 16
- on DDL events, 16
- on DML operations, 16, 16
- on views, 16
- order of firing, 16
- re-creating, 16
- removing from the database, 18
- renaming, 13
- restrictions on, 16
- row values
-
- old and new, 16
- row, specifying, 16
- SQL examples, 16
- statement, 16
- TRIM function, 7.184
- TRUNC function
-
- date function, 7.186
- format models, 7.207
- number function, 7.185
- TRUNCATE PARTITION clause
-
- of ALTER TABLE, 12
- TRUNCATE statement, 19
- TRUNCATE SUBPARTITION clause
-
- of ALTER TABLE, 12
- TRUST attribute
-
- of PRAGMA RESTRICT_REFERENCES, 17
- type constructor expressions, 5.12
- type methods
-
- return type of, 17
- types. See object types or datatypes
- TZ_OFFSET function, 7.187
U
- UID function, 7.188
- unary operators, 4.1.1
- UNDER ANY TABLE system privilege, 18
- UNDER ANY VIEW system privilege, 18
- UNDER clause
-
- of CREATE VIEW, 17
- UNDER object privilege, 18
-
- on a type, 18
- on a view, 18
- UNDER_PATH condition, 6.20
- undo
-
- rollback, 11, 14
- system managed, 11, 14
- UNDO tablespace clause
-
- of CREATE DATABASE, 14
- of CREATE TABLESPACE, 16
- undo tablespaces
-
- creating, 14, 16
- dropping, 18
- modifying, 12
- preserving unexpired data, 12, 16
- UNDO_MANAGEMENT initialization parameter
-
- setting with ALTER SYSTEM, 11
- UNDO_RETENTION initialization parameter
-
- setting with ALTER SYSTEM, 11, 18
- UNDO_TABLESPACE initialization parameter
-
- setting with ALTER SYSTEM, 11
- UNIFORM clause
-
- of CREATE TABLESPACE, 16
- UNION ALL set operator, 4.5, 19
- UNION set operator, 4.5, 19
- UNIQUE clause
-
- of CREATE INDEX, 14
- of CREATE TABLE, 16
- of SELECT, 19
- unique constraints
-
- enabling, 16
- index on, 16
- unique elements of, 7.129
- unique indexes, 14
- unique queries, 19
- UNISTR function, 7.189
- universal rowids. See urowids
- UNLIMITED TABLESPACE system privilege, 18
- unnesting collections, 19
-
- examples, 19
- unnesting subqueries, 9.8
- UNQUIESCE clause
-
- of ALTER SYSTEM, 11
- UNRECOVERABLE, 10.2, 16
-
- See also NOLOGGING clause
- unsorted indexes, 14
- UNUSABLE clause
-
- of ALTER INDEX, 10.2
- UNUSABLE LOCAL INDEXES clause
-
- of ALTER MATERIALIZED VIEW, 11
- of ALTER TABLE, 12
- UPDATE ANY TABLE system privilege, 18
- UPDATE BLOCK REFERENCES clause
-
- of ALTER INDEX, 10.2, 10.2
- UPDATE GLOBAL INDEXES clause
-
- of ALTER TABLE, 12
- UPDATE object privilege, 18
-
- on a table, 18
- on a view, 18
- update operations
-
- collecting supplemental log data for, 10.2
- UPDATE SET clause
-
- of MERGE, 18
- UPDATE statement, 19
-
- triggers on, 16
- updates
-
- and simultaneous insert, 18
- using MERGE, 18, 18
- UPDATEXML function, 7.190
- UPGRADE clause
-
- of ALTER DATABASE, 10.2
- of ALTER TABLE, 12
- UPPER function, 7.191
- URLs
-
- generating, 7.151
- UROWID datatype, 2.1.1.26
- urowids
-
- and foreign tables, 2.1.1.26
- and index-organized tables, 2.1.1.26
- description of, 2.1.1.26
- USE_INDIRECT_DATA_BUFFERS initialization parameter
-
- setting with ALTER SYSTEM, 11
- USE_PRIVATE_OUTLINES session parameter, 11
- USE_STORED_OUTLINES session parameter, 11, 11
- USER function, 7.192
- USER SYS clause
-
- of CREATE DATABASE, 14
- USER SYSTEM clause
-
- of CREATE DATABASE, 14
- USER_COL_COMMENTS data dictionary view, 13
- USER_DUMP_DEST initialization parameter
-
- setting with ALTER SYSTEM, 11
- USER_INDEXTYPE_COMMENTS data dictionary view, 13
- USER_MVIEW_COMMENTS data dictionary view, 13
- USER_OPERATOR_COMMENTS data dictionary view, 13
- USER_TAB_COMMENTS data dictionary view, 13
- user-defined aggregate functions, 14
- user-defined functions, 7.208
-
- name precedence of, 7.208.2
- naming conventions, 7.208.2.1
- restrictions on, 14
- user-defined operators, 4.7
- user-defined statistics
-
- dropping, 17, 17, 17, 18, 18
- user-defined types, 2.1.3
-
- defining, 17
- mapping to Java classes, 17
- USERENV function, 7.193
- users
-
- allocating space for, 17
- and database links, 14
- assigning
-
- default roles, 13
- profiles, 17
- authenticating, 13
- authenticating to a remote server, 14
- changing authentication, 13
- changing global authentication, 13
- creating, 17
- default tablespaces, 17
- default tablespaces for, 13
- denying access to tables and views, 18
- external, 15, 17
- global, 15, 17
- granting
-
- system privileges for, 18
- local, 15, 17
- locking accounts, 17
- password expiration of, 17
- removing from the database, 18
- SQL examples, 17
- temporary tablespaces for, 13, 17
- USING BFILE clause
-
- of CREATE JAVA, 14, 14
- USING BLOB clause
-
- of CREATE JAVA, 14
- USING clause
-
- of ALTER INDEXTYPE, 10.2
- of ASSOCIATE STATISTICS, 13, 13
- of CREATE DATABASE LINK, 14
- of CREATE INDEXTYPE, 14
- USING CLOB clause
-
- of CREATE JAVA, 14
- USING INDEX clause
-
- of ALTER MATERIALIZED VIEW, 11
- of ALTER TABLE, 12
- of constraints, 8
- of CREATE MATERIALIZED VIEW, 15
- of CREATE TABLE, 16
- USING NO INDEX clause
-
- of CREATE MATERIALIZED VIEW, 15
- USING ROLLBACK SEGMENT clause
-
- of ALTER MATERIALIZED VIEW...REFRESH, 11
- of CREATE MATERIALIZED VIEW, 15
- UTC
-
- extracting from a datetime value, 7.152
- UTC offset
-
- replacing with time zone region, 2.1.1.11
- UTL_FILE_DIR initialization parameter
-
- setting with ALTER SYSTEM, 11
- UTLCHN.SQL script, 13
- UTLEXPT1.SQL script, 12
- UTLXPLAN.SQL script, 18
V
- VALIDATE clause
-
- of DROP TYPE, 18
- VALIDATE REF UPDATE clause
-
- of ANALYZE, 13
- VALIDATE STRUCTURE clause
-
- of ANALYZE, 13
- validation
-
- of clusters, 13
- of database objects
-
- offline, 13
- of database objects, online, 13
- of indexes, 13
- of tables, 13
- VALUE function, 7.194
- VALUES clause
-
- of CREATE INDEX, 14
- of INSERT, 18
- VALUES LESS THAN clause
-
- of CREATE TABLE, 16
- VAR_POP function, 7.195
- VAR_SAMP function, 7.196
- VARCHAR datatype, 2.1.1.5
- VARCHAR2 datatype, 2.1.1.4
-
- converting to NUMBER, 2.4.1
- VARGRAPHIC datatype
-
- DB2, 2.1.2, 2.1.2
- SQL/DS, 2.1.2, 2.1.2
- variable expressions, 5.13
- VARIANCE function, 7.197
- VARRAY
-
- LOB restriction, 2.1.1.18
- VARRAY clause
-
- of ALTER TABLE, 12
- VARRAY column properties
-
- of ALTER TABLE, 12, 12
- of CREATE MATERIALIZED VIEW, 15
- of CREATE TABLE, 16, 16
- varrays, 2.1.3.3
-
- changing returned value, 12
- compared with nested tables, 2.2.6
- comparison rules, 2.2.6
- creating, 17, 17, 17
- dropping the body of, 18
- dropping the specification of, 18
- increasing size of, 13
- modifying column properties, 12
- storage characteristics, 12, 12, 16
- storing out of line, 2.1.3.3
- varying arrays. See varrays
- view constraints
-
- dropping, 18
- views
-
- base tables
-
- adding rows, 18
- changing
-
- definition, 18
- values in base tables, 19
- creating
-
- before base tables, 17
- comments about, 13
- multiple, 15
- creating object subviews, 17
- defining, 17
- dropping constraints on, 13
- granting
-
- system privileges for, 18
- modifying constraints on, 13
- object, creating, 17
- recompiling, 13
- re-creating, 17
- remote, accessing, 14
- removing
-
- from the database, 18
- rows from the base table of, 17
- renaming, 18
- retrieving data from, 19
- subquery of, 17
-
- restricting, 17
- synonyms for, 16
- updatable, 17
- with joins
-
- and key-preserved tables, 17
- with joins, making updatable, 17
- XMLType, 17
- XMLType, creating, 17
- XMLType, querying, 17
- VSIZE function, 7.198
W
- WHEN clause
-
- of CREATE TRIGGER, 16
- WHENEVER NOT SUCCESSFUL clause
-
- of NOAUDIT, 18
- WHENEVER SUCCESSFUL clause
-
- of AUDIT sql_statements, 13
- of NOAUDIT, 18
- WHERE clause
-
- of DELETE, 17
- of queries and subqueries, 19
- of SELECT, 9.3
- of UPDATE, 19
- WIDTH_BUCKET function, 7.199
- WITH ADMIN OPTION clause
-
- of GRANT, 18
- WITH CHECK OPTION clause
-
- of CREATE VIEW, 17, 17
- of DELETE, 17
- of INSERT, 18
- of SELECT, 19
- of UPDATE, 19
- WITH GRANT OPTION clause
-
- of GRANT, 18
- WITH HIERARCHY OPTION
-
- of GRANT, 18
- WITH INDEX CONTEXT clause
-
- of CREATE OPERATOR, 15
- WITH OBJECT ID clause
-
- of CREATE MATERIALIZED VIEW LOG, 15
- WITH OBJECT IDENTIFIER clause
-
- of CREATE VIEW, 17
- WITH OBJECT OID. See WITH OBJECT IDENTIFIER.
- WITH PRIMARY KEY clause
-
- of ALTER MATERIALIZED VIEW, 11
- of CREATE MATERIALIZED VIEW LOG, 15
- of CREATE MATERIALIZED VIEW...REFRESH, 15
- WITH query_name clause
-
- of SELECT, 19
- WITH READ ONLY clause
-
- of CREATE VIEW, 17, 17
- of DELETE, 17
- of INSERT, 18
- of SELECT, 19
- of UPDATE, 19
- WITH ROWID clause
-
- of column ref constraints, 8
- of CREATE MATERIALIZED VIEW LOG, 15
- of CREATE MATERIALIZED VIEW...REFRESH, 15
- WITH SEQUENCE clause
-
- of CREATE MATERIALIZED VIEW LOG, 15
- WNDS attribute
-
- of PRAGMA RESTRICT_REFERENCES, 17
- WNPS attribute
-
- of PRAGMA RESTRICT_REFERENCES, 17
- WORKAREA_SIZE_POLICY initialization parameter
-
- setting with ALTER SYSTEM, 11
- WRITE object privilege
-
- on a directory, 18
X
- XML
-
- examples, E.2
- XML data
-
- storage of, 16
- XML database repository
-
- SQL access to, 6.8, 6.20
- XML documents
-
- producing from XML fragments, 7.155
- retrieving from the database, 7.151
- XML format models, 2.4.5
- XML fragments, 7.46
- XMLAGG function, 7.200
- XMLCONCAT function, 7.202
- XMLDATA pseudocolumn, 3.9
- XMLGenFormatType object, 2.4.5
- XMLType columns
-
- properties of, 12, 16
- storage of, 16, 16
- XMLType storage clause
-
- of CREATE TABLE, 16
- XMLType tables
-
- creating, 16, 16
- creating index on, 14
- XMLType views, 17
-
- querying, 17
Z
- CREATE PACKAGE BODY statement, 15, 18