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, 7.7.1

+ (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, 10.2

ABS function, 5.1.5

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, 5.1.5

ACTIVATE STANDBY DATABASE clause

of ALTER DATABASE, 10.2

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

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, 12

ADD_MONTHS function, 5.1.5

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, 15

AFTER triggers, 15

AGENT clause

of CREATE LIBRARY, 16

aggregate functions, 5.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, 7.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_ROWS hint, 2.6.4.1

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 CUBE DIMENSION system privilege, 18

ALTER ANY CUBE 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 MINING MODEL 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 FLASHBACK ARCHIVE 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

on a mining model, 18

on a sequence, 18

on a table, 18

on an OLAP cube, 18

on an OLAP cube dimension, 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, 15

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.3

conversion to Oracle datatypes, 2.1.3

standards, 1.2, 1.2, B.1

supported datatypes, 2.1

analytic functions, 5.1.3

AVG, 5.1.5

CORR, 5.1.5

COUNT, 5.1.5

COVAR_POP, 5.1.5

COVAR_SAMP, 5.1.5

CUME_DIST, 5.1.5

DENSE_RANK, 5.1.5

FIRST, 5.1.5

FIRST_VALUE, 5.1.5

LAG, 5.1.5

LAST, 5.1.5

LAST_VALUE, 5.1.5

LEAD, 5.1.5

MAX, 5.1.5

MIN, 5.1.5

NTILE, 5.1.5

OVER clause, 5.1.3

PERCENT_CONT, 5.1.5

PERCENT_DISC, 5.1.5

PERCENT_RANK, 5.1.5

RANK, 5.1.5

RATIO_TO_REPORT, 5.1.5

ROW_NUMBER, 5.1.5

STDDEV, 5.1.5

STDDEV_POP, 5.1.5

STDDEV_SAMP, 5.1.5

SUM, 5.1.5

syntax, 5.1.3

user-defined, 14

VAR_POP, 5.1.5

VAR_SAMP, 5.1.5

VARIANCE, 5.1.5

ANALYZE ANY system privilege, 18

ANALYZE CLUSTER statement, 13

ANALYZE INDEX statement, 13

ANALYZE TABLE statement, 13

ANCILLARY TO clause

of CREATE OPERATOR, 16

AND condition, 7.4, 7.4

AND DATAFILES clause

of DROP TABLESPACE, 18, 18

ANSI. See American National Standards Institute (ANSI)

antijoins, 9.6.7

ANY operator, 7.2

APPEND hint, 2.6.4.2

APPENDCHILDXML function, 5.1.5

application servers

allowing connection as user, 13

applications

allowing connection as user, 13

securing, 14

validating, 14

AQ_ADMINISTRATOR_ROLE role, 18

AQ_USER_ROLE role, 18

ARCHIVE LOG clause

of ALTER SYSTEM, 11

archive mode

specifying, 14

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.16

AS clause

of CREATE JAVA, 14

AS EXTERNAL clause

of CREATE FUNCTION, 16

of CREATE TYPE BODY, 17

AS OBJECT clause

of CREATE TYPE, 17

AS subquery clause

of CREATE MATERIALIZED VIEW, 16

of CREATE TABLE, 15

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.3

ASCII function, 5.1.5

ASCIISTR function, 5.1.5

ASIN function, 5.1.5

ASM_DISKGROUPS initialization parameter

setting with ALTER SYSTEM, 10.2, 14

ASM_DISKSTRING initialization parameter

setting with ALTER SYSTEM, 14

ASSOCIATE STATISTICS statement, 13

asynchronous commit, 13

ATAN function, 5.1.5

ATAN2 function, 5.1.5

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, 15

of dimensions, defining, 14

of disk groups, 10.2, 14

of user-defined types

mapping to Java fields, 17

AUDIT ANY system privilege, 18

AUDIT SYSTEM system privilege, 18

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, 16

of CREATE PROCEDURE, 16

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, 16

of CREATE PROCEDURE, 16

of CREATE TYPE, 13, 17

AUTOALLOCATE clause

of CREATE TABLESPACE, 15

AUTOEXTEND clause

of ALTER DATABASE, 10.2

of CREATE DATABASE, 14

automatic segment-space management, 15

Automatic Storage Management

migrating nodes in a cluster, 11

automatic undo mode, 11, 14

AVG function, 5.1.5

B

BACKUP ANY TABLE system privilege, 18

BACKUP CONTROLFILE clause

of ALTER DATABASE, 10.2, 10.2

backups

incremental

and block change tracking, 10.2

BC datetime format element, 2.4.2.2, 2.4.2.2

BECOME USER system privilege, 18

BEFORE clause

of CREATE TRIGGER, 15

BEFORE triggers, 15

BEGIN BACKUP clause

of ALTER DATABASE, 10.2

of ALTER TABLESPACE, 12

beginning backup of, 10.2

BFILE

datatype, 2.1.1.20

locators, 2.1.1.20

BFILENAME function, 5.1.5

BIN_TO_NUM function, 5.1.5

binary large objects. See BLOB

binary operators, 4.1.1

binary XML format, 15

binary XML storage, 15

BINDING clause

of CREATE OPERATOR, 16

bindings

adding to an operator, 11

dropping from an operator, 11

bit vectors

converting to numbers, 5.1.5

BITAND function, 5.1.5

BITMAP clause

of CREATE INDEX, 14

bitmap indexes, 14

creating join indexes, 14

blank padding

specifying in format models, 2.4.3

suppressing, 2.4.3

BLOB datatype, 2.1.1.21

transactional support, 2.1.1.21

BLOCKSIZE clause

of CREATE TABLESPACE, 15

BODY clause

of ALTER PACKAGE, 11

bottom-N reporting, 5.1.5, 5.1.5, 5.1.5

BRADV299, 16

buffer cache

flushing, 11

BUFFER_POOL parameter

of STORAGE clause, 8

BUILD DEFERRED clause

of CREATE MATERIALIZED VIEW, 16

BUILD IMMEDIATE clause

of CREATE MATERIALIZED VIEW, 16

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, 15

of CREATE CLUSTER, 14

of CREATE MATERIALIZED VIEW, 16

of CREATE MATERIALIZED VIEW LOG, 16

CACHE hint, 2.6.4.3

CACHE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE, 11

of CREATE SEQUENCE, 16

CACHE READS clause

of ALTER TABLE, 12

of CREATE TABLE, 15

cached cursors

execution plan for, 18

call spec. See call specifications

call specifications

in procedures, 16

of CREATE PROCEDURE, 16

of CREATE TYPE, 17

of CREATE TYPE BODY, 17

CALL statement, 13

calls

limiting CPU time for, 16

limiting data blocks read, 16

CARDINALITY function, 5.1.5

Cartesian products, 9.6.4

CASCADE clause

of CREATE TABLE, 15

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, 6.4

searched, 6.4

simple, 6.4

CAST function, 5.1.5

MULTISET parameter, 5.1.5

CATSEARCH condition, 4.1, 7.1

CEIL function, 5.1.5

chained rows

listing, 13

of clusters, 13

CHANGE CATEGORY clause

of ALTER OUTLINE, 11

CHANGE NOTIFICATION system privilege, 18

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, 5.1.1.2, 5.1.1.4

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.3

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.9

zero-length, 2.1.1.1

CHARTOROWID function, 5.1.5

CHECK clause

of constraints, 8

of CREATE TABLE, 15

check constraints, 8

CHECK DATAFILES clause

of ALTER SYSTEM, 11

CHECKPOINT clause

of ALTER SYSTEM, 11

checkpoints

forcing, 11

CHR function, 5.1.5

CHUNK clause

of ALTER TABLE, 12

of CREATE TABLE, 15

CLEAR LOGFILE clause

of ALTER DATABASE, 10.2, 10.2

CLOB datatype, 2.1.1.22

transactional support, 2.1.1.22

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, 15

of TRUNCATE, 19

CLUSTER hint, 2.6.4.4

CLUSTER_ID function, 5.1.5

CLUSTER_PROBABILITY function, 5.1.5

CLUSTER_SET function, 5.1.5

clusters

assigning tables to, 15

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, 15

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, 5.1.5

as a variety of CASE expression, 5.1.5

COALESCE SUBPARTITION clause

of ALTER TABLE, 12

COLLECT function, 5.1.5

collection functions, 5.1.1.9

collection types

multilevel, 15

collections

inserting rows into, 18

modifying, 12

modifying retrieval method, 12

nested tables, 2.1.4.4

testing for empty, 7.6.2

treating as a table, 18, 19, 19, 19

unnesting, 19

examples, 19

varrays, 2.1.4.3

collection-typed values

converting to datatypes, 5.1.5

column expressions, 6.5

column REF constraints, 8

of CREATE TABLE, 15

column values

unpivoting into rows, 19

COLUMN_VALUE pseudocolumn, 3.4

columns

adding, 12

aliases for, 9.2

altering storage, 12

associating statistics with, 13

basing an index on, 14

comments on, 13

creating comments about, 13

defining, 15

dropping from a table, 12

LOB

storage attributes, 12

maximum number of, 15

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, 15

specifying default values, 15

storage properties, 15

substitutable, identifying type, 5.1.5

virtual

adding to a table, 12

modifying, 12

virtual, creating, 15

COLUMNS clause

of ASSOCIATE STATISTICS, 13, 13

COMMENT ANY MINING MODEL system privilege, 18

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

asynchronous, 13

automatic, 13

COMMIT IN PROCEDURE clause

of ALTER SESSION, 11

COMMIT statement, 13

COMMIT TO SWITCHOVER clause

of ALTER DATABASE, 10.2

comparison conditions, 7.2

comparison functions

MAP, 17, 17

ORDER, 17, 17

comparison semantics

of character strings, 2.2.3

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 PACKAGE, 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, 11, 13, 13

COMPOSE function, 5.1.5

composite foreign keys, 8

composite partitioning

range-list, 12, 15

when creating a table, 15, 15

composite primary keys, 8

composite range partitions, 15

COMPOSITE_LIMIT parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

compound conditions, 7.11

compound expressions, 6.3

compound triggers

creating, 15

COMPRESS clause

of ALTER INDEX ... REBUILD, 10.2

of CREATE TABLE, 15

compression

of index keys, 10.2

CONCAT function, 5.1.5

concatenation operator, 4.3

conditions

comparison, 7.2

compound, 7.11

EXISTS, 7.10.1, 7.12

floating-point, 7.3

group comparison, 7.2.2

IN, 7.13

in SQL syntax, 7

IS [NOT] EMPTY, 7.6.2

IS ANY, 7.5.1

IS OF type, 7.14

IS PRESENT, 7.5.2

LIKE, 7.7.1

logical, 7.4

MEMBER, 7.6.3

membership, 7.6.3, 7.13

model, 7.5

multiset, 7.6

null, 7.9

pattern matching, 7.7

range, 7.8

SET, 7.6.1

simple comparison, 7.2.1

SUBMULTISET, 7.6.4

UNDER_PATH, 7.10.2

XML, 7.10

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, 15

for a table, 15

on a column, 15

disabling, 15

cascading, 15

disabling after table creation, 12

disabling during table creation, 15

dropping, 12, 12, 18

enabling, 15, 15

enabling after table creation, 12

enabling during table creation, 15

foreign key, 8

modifying existing, 12

on views

dropping, 13, 18

partitioning referential, 12, 15

primary key, 8

attributes of index, 8

enabling, 15

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, 15

constructor methods

and object types, 17

constructors

defining for an object type, 17

user-defined, 17

CONTAINS condition, 4.1, 7.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 file clauses

of ALTER DATABASE, 10.2

control files

allowing reuse, 14, 14

backing up, 10.2

force logging mode, 14

re-creating, 14

standby, creating, 10.2

CONTROLFILE REUSE clause

of CREATE DATABASE, 14

conversion

functions, 5.1.1.7

rules, string to date, 2.4.4

CONVERT function, 5.1.5

CORR function, 5.1.5

CORR_K function, 5.1.5

CORR_S function, 5.1.5

correlated subqueries, 9.7

correlation functions

Kendall's tau-b, 5.1.5

Pearson's, 5.1.5

Spearman's rho, 5.1.5

correlation names

for base tables of indexes, 14

in DELETE, 17

in SELECT, 19

COS function, 5.1.5

COSH function, 5.1.5

COUNT function, 5.1.5

COVAR_POP function, 5.1.5

COVAR_SAMP function, 5.1.5

CPU_PER_CALL parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

CPU_PER_SESSION parameter

of ALTER PROFILE, 11

of ALTER RESOURCE COST, 11

of CREATE PROFILE, 16

CREATE ANY CLUSTER system privilege, 18

CREATE ANY CONTEXT system privilege, 18

CREATE ANY CUBE BUILD PROCESS system privilege, 18

CREATE ANY CUBE DIMENSION system privilege, 18

CREATE ANY CUBE 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 MEASURE FOLDER system privilege, 18

CREATE ANY MINING MODEL 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 CUBE BUILD PROCESS system privilege, 18

CREATE CUBE DIMENSION system privilege, 18

CREATE CUBE system privilege, 18

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 EXTERNAL JOB system privilege, 18

CREATE FLASHBACK ARCHIVE 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, 16

CREATE LIBRARY system privilege, 18

CREATE MATERIALIZED VIEW LOG statement, 16

CREATE MATERIALIZED VIEW statement, 16

CREATE MATERIALIZED VIEW system privilege, 18

CREATE MEASURE FOLDER system privilege, 18

CREATE MINING MODEL system privilege, 18

CREATE OPERATOR statement, 16

CREATE OPERATOR system privilege, 18

CREATE OUTLINE statement, 16

CREATE PACKAGE statement, 16

CREATE PFILE statement, 16, 16

CREATE PROCEDURE statement, 16

CREATE PROCEDURE system privilege, 18

CREATE PROFILE statement, 16

CREATE PROFILE system privilege, 18

CREATE PUBLIC DATABASE LINK system privilege, 18

CREATE PUBLIC SYNONYM system privilege, 18

CREATE RESTORE POINT statement, 16

CREATE ROLE statement, 16

CREATE ROLE system privilege, 18

CREATE ROLLBACK SEGMENT statement, 16

CREATE ROLLBACK SEGMENT system privilege, 18

CREATE SCHEMA statement, 16

CREATE SEQUENCE statement, 16

CREATE SEQUENCE system privilege, 18

CREATE SESSION system privilege, 18

CREATE SPFILE statement, 16

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 10.2, 10.2

CREATE statements

triggers on, 15

CREATE SYNONYM statement, 15

CREATE SYNONYM system privilege, 18

CREATE TABLE statement, 15

CREATE TABLE system privilege, 18

CREATE TABLESPACE statement, 15

CREATE TABLESPACE system privilege, 18

CREATE TRIGGER statement, 15

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

cross joins, 19

CUBE clause

of SELECT statements, 19

CUBE_TABLE function, 5.1.5

cubes

extracting data, 5.1.5

CUME_DIST function, 5.1.5

cumulative distributions, 5.1.5

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, 5.1.5

CURRENT_SCHEMA session parameter, 11

CURRENT_TIMESTAMP function, 5.1.5

CURRENT_USER clause

of CREATE DATABASE LINK, 14

CURRVAL pseudocolumn, 3.2, 16

CURSOR expressions, 6.6

CURSOR_SHARING_EXACT hint, 2.6.4.5

cursors

cached, 18

CustomDatum Java storage format, 17

CV function, 5.1.5

CYCLE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE, 11

of CREATE SEQUENCE, 16

D

data

aggregation

composite columns of GROUP BY, 19

concatenated grouping sets of GROUP BY, 19

grouping sets, 19

analyzing a subset, 5.1.5

caching frequently used, 15

independence, 15

integrity checking on input, 2.1.1.6

pivoting, 19

retrieving, 9.1

specifying as temporary, 15

undo

preserving, 12, 15

unpivoting, 19

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, 15

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, 15

during index creation, 14

during index rebuild, 12

parallelizing, 15

restricting operations, 11

retrieving affected rows, 17, 19

retrieving rows affected by, 17, 18, 19

statements, 10.1.2

PL/SQL support, 10.1.2

data mining functions, 5.1.1.11

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, 15

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, 16

archive mode

specifying, 14

blocks

specifying size, 15

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

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, 15

auditing, 15

transparent logging of, 15

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, 16

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

namespace, 2.8.1

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, 15

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, 5.1.5

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, 15, 15, 15

defining for the database, 14

designing media recovery, 10.2

dropping, 12, 18, 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, 15

specifying for database, 14

system generated, 10.2

taking offline, 10.2, 10.2

temporary

shrinking, 12

DATAOBJ_TO_PARTITION function, 5.1.5

datatypes, 2.1

"Any" types, 2.1.6

ANSI-supported, 2.1

associating statistics with, 13, 13

BFILE, 2.1.1.20

BLOB, 2.1.1.21

CHAR, 2.1.1.1

character, 2.1.1

CLOB, 2.1.1.22

comparison rules, 2.2

converting to collection-typed values, 5.1.5

converting to other datatypes, 5.1.5

DATE, 2.1.1.10

datetime, 2.1.1.9

interval, 2.1.1.9

INTERVAL DAY TO SECOND, 2.1.1.15

INTERVAL YEAR TO MONTH, 2.1.1.14

length semantics, 2.1.1.1, 2.1.1.3

LONG, 2.1.1.9

LONG RAW, 2.1.1.19

media types, 2.1.9

NCHAR, 2.1.1.2

NCLOB, 2.1.1.23

NUMBER, 2.1.1.6

NVARCHAR2, 2.1.1.3

Oracle-supplied types, 2.1.5

RAW, 2.1.1.19

ROWID, 2.1.2

SDO_TOPO_GEOMETRY, 2.1.8.2

spatial types, 2.1.8

TIMESTAMP, 2.1.1.11

TIMESTAMP WITH LOCAL TIME ZONE, 2.1.1.13

TIMESTAMP WITH TIME ZONE, 2.1.1.12

UROWID, 2.1.2.2

user-defined, 2.1.4

VARCHAR, 2.1.1.5

VARCHAR2, 2.1.1.4

XML types, 2.1.7

DATE columns

converting to datetime columns, 12

DATE datatype, 2.1.1.10

julian, 2.1.1.10.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, 5.1.1.5

dates

arithmetic, 2.1.1.16

comparison rules, 2.2.2

datetime arithmetic, 2.1.1.16

boundary cases, 11

calculating daylight saving time, 2.1.1.17

datetime columns

creating from DATE columns, 12

datetime datatypes, 2.1.1.9

daylight saving time, 2.1.1.17

datetime expressions, 6.7

datetime field

extracting from a datetime or interval value, 5.1.5

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, 5.1.1.5

datetime literals, 2.3.3

DAY datetime format element, 2.4.2.2

daylight saving time, 2.1.1.17

boundary cases, 2.1.1.17

going into or coming out of effect, 2.1.1.17

DB2 datatypes, 2.1.3

restrictions on, 2.1.3

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.2.1

DBMSSTDX.SQL script, 14, 16, 16, 16

and triggers, 15

DBTIMEZONE function, 5.1.5

DDL. See data definition language (DDL)

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 PACKAGE, 11

of ALTER PROCEDURE, 11

of ALTER TRIGGER, 13

of ALTER TYPE, 13

DEBUG object privilege

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, 5.1.5

decoding functions, 5.1.1.13

DECOMPOSE function, 5.1.5

DEFAULT clause

of ALTER TABLE, 12

of CREATE TABLE, 15, 15

DEFAULT COST clause

of ASSOCIATE STATISTICS, 13, 13, 13

default index, suppressing, 16

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, 15

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 CUBE DIMENSION system privilege, 18

DELETE ANY MEASURE FOLDER system privilege, 18

DELETE ANY TABLE system privilege, 18

DELETE object privilege

on a table, 18

on a view, 18

on an OLAP cube dimension, 18

on an OLAP measures folder, 18

DELETE statement, 17

error logging, 17

triggers on, 15

DELETE STATISTICS clause

of ANALYZE, 13

DELETE_CATALOG_ROLE role, 18

deletes during, 18

DELETEXML function, 5.1.5

DENSE_RANK function, 5.1.5

DEREF function, 5.1.5

DESC clause

of CREATE INDEX, 14

DETERMINISTIC clause

of CREATE FUNCTION, 14

dimensional objects

extracting data, 5.1.5

dimensions

attributes

adding, 10.2

changing, 10.2

defining, 14

dropping, 10.2

compiling invalidated, 10.2

creating, 14

defining levels, 14

examples, 14

extracting data, 5.1.5

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

parent-child hierarchy, 14

removing from the database, 17

directories. See directory objects

directory objects

as aliases for operating system directories, 14

auditing, 13, 13

creating, 14

granting system privileges for, 18

redefining, 14

removing from the database, 17

direct-path INSERT, 2.6.4.2, 18

DISABLE ALL TRIGGERS clause

of ALTER TABLE, 12

DISABLE clause

of ALTER INDEX, 10.2

of CREATE TABLE, 15

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, 16

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, 15, 15

DISABLE STORAGE IN ROW clause

of ALTER TABLE, 12

of CREATE TABLE, 15

DISABLE TABLE LOCK clause

of ALTER TABLE, 12

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, 15

creating failure groups, 10.2, 14

creating files in, 8

dropping, 17

rebalancing, 10.2

setting attributes, 10.2, 14

specifying files in, 8

specifying files in control files, 14

disks

bringing online, 10.2

taking offline, 10.2

dispatcher processes

creating additional, 11

terminating, 11

DISTINCT clause

of SELECT, 19

distinct queries, 19

distributed queries, 9.10

restrictions on, 9.10

distribution

hints for, 2.6.4.56

DML. See data manipulation language (DML)

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

local partitioned, 14

modifying, 10.2

parallelizing creation of, 14

rebuilding, 10.2

removing from the database, 17

system managed, 14

associating statistics, 13

domain_index_clause

of CREATE INDEX, 14

DOWNGRADE clause

of ALTER DATABASE, 10.2

DRIVING_SITE hint, 2.6.4.6

DROP ANY CLUSTER system privilege, 18

DROP ANY CONTEXT system privilege, 18

DROP ANY CUBE BUILD PROCESS system privilege, 18

DROP ANY CUBE DIMENSION system privilege, 18

DROP ANY CUBE 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 MEASURE FOLDER system privilege, 18

DROP ANY MINING MODEL 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 FLASHBACK ARCHIVE 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 RESTORE POINT statement, 17

DROP ROLE statement, 17

DROP ROLLBACK SEGMENT statement, 17

DROP ROLLBACK SEGMENT system privilege, 18

DROP SEQUENCE statement, 18

DROP statements

triggers on, 15

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, 12

DROP VIEW statement, 18

DUAL dummy table, 2.8.1, 9.9

DUMP function, 5.1.5

DY datetime format element, 2.4.2.2

DYNAMIC_SAMPLING hint, 2.6.4.7

E

EBCDIC character set, 2.2.3

embedded SQL, 10.1.6

precompiler support, 10.1.6

EMPTY_BLOB function, 5.1.5

EMPTY_CLOB function, 5.1.5

ENABLE ALL TRIGGERS clause

of ALTER TABLE, 12

ENABLE clause

of ALTER INDEX, 10.2

of ALTER TRIGGER, 13

of CREATE TABLE, 15

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, 16

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, 15, 15

ENABLE STORAGE IN ROW clause

of ALTER TABLE, 12

of CREATE TABLE, 15

ENABLE TABLE LOCK clause

of ALTER TABLE, 12

ENABLE VALIDATE constraint state, 8

encoding functions, 5.1.1.13

encryption, 15

of tablespaces, 8, 15

encryption keys

generating, 11

END BACKUP clause

of ALTER DATABASE, 10.2

of ALTER DATABASE ... DATAFILE, 10.2

of ALTER TABLESPACE, 12

enterprise users

allowing connection as database users, 13

environment functions, 5.1.1.15

equality test, 7.2

equijoins, 9.6.2

defining for a dimension, 14

equivalency tests, 7.13

error logging

of DELETE operations, 17

of INSERT operations, 18

of MERGE operations, 18

ERROR_ON_OVERLAP_TIME session parameter, 11

EXCEPTIONS INTO clause

of ALTER TABLE, 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, 16

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

on a library, 18

on an object type, 18

on an operator, 18

EXECUTE_CATALOG_ROLE role, 18

execution plans

determining, 18

dropping outlines for, 17

saving, 16

EXEMPT ACCESS POLICY system privilege, 18

EXISTS condition, 7.10.1, 7.12, 7.12

EXISTSNODE function, 5.1.5

EXP function, 5.1.5

EXP_FULL_DATABASE role, 18

EXPLAIN PLAN statement, 18

explicit data conversion, 2.2.7.1, 2.2.7.4

expressions

CASE, 6.4

changing declared type of, 5.1.5

column, 6.5

comparing, 5.1.5

compound, 6.3

computing with the DUAL table, 9.9

CURSOR, 6.6

datetime, 6.7

in SQL syntax, 6.1

interval, 6.9

lists of, 6.15

model, 6.10

object access, 6.11

placeholder, 6.12

scalar subqueries as, 6.13

simple, 6.2

type constructor, 6.14

extended rowids

base 64, 2.1.2.1

not directly available, 2.1.2.1

extensible indexing

example, E.1

EXTENT MANAGEMENT clause

of CREATE DATABASE, 14

of CREATE TABLESPACE, 15, 15

EXTENT MANAGEMENT DICTIONARY clause

of CREATE TABLESPACE, 15

EXTENT MANAGEMENT LOCAL clause

of CREATE DATABASE, 14

of CREATE TABLESPACE, 15

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, 16, 16

external LOBs, 2.1.1.19

external procedures, 16

running from remote database, 16

external tables, 15

access drivers, 15

altering, 12

creating, 15

ORACLE_DATAPUMP access driver, 15

ORACLE_LOADER access driver, 15

restrictions on, 15

external users, 16, 17

EXTRACT (datetime) function, 5.1.5

EXTRACT (XML) function, 5.1.5

EXTRACTVALUE function, 5.1.5

F

FACT hint, 2.6.4.8

FAILED_LOGIN_ATTEMPTS parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

failure groups

creating for a disk group, 10.2, 14

FEATURE_ID function, 5.1.5

FEATURE_SET function, 5.1.5

FEATURE_VALUE function, 5.1.5

files

specifying as a redo log file group, 8

specifying as datafiles, 8

specifying as tempfiles, 8

FINAL clause

of CREATE TYPE, 17, 17

FIPS

compliance, B.10

flagging, 11

FIRST function, 5.1.5

FIRST_ROWS(n) hint, 2.6.4.9

FIRST_VALUE function, 5.1.5

FLAGGER session parameter, 11

FLASHBACK ANY TABLE system privilege, 18, 18, 18

FLASHBACK ARCHIVE ADMINISTER system privilege, 18

FLASHBACK ARCHIVE object privilege, 18

flashback data archives

creating, 14

dropping, 17

modifying, 10.2

privileges for, 18

specifying for a table, 12, 15

FLASHBACK DATABASE statement, 18

flashback queries, 19

pseudocolumns for, 3.3

using with inserts, 18, 19

FLASHBACK TABLE statement, 18

floating-point conditions, 7.3

floating-point numbers, 2.1.1.8

converting to, 5.1.5, 5.1.5

handling NaN, 5.1.5

FLOOR function, 5.1.5

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 CREATE INDEXTYPE, 14

of EXPLAIN PLAN, 18, 18

FOR EACH ROW clause

of CREATE TRIGGER, 15

FOR UPDATE clause

of CREATE MATERIALIZED VIEW, 16

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, 15

FORCE PARALLEL DML clause

of ALTER SESSION, 11

FORCE TRANSACTION system privilege, 18

foreign key constraints, 8

foreign tables

rowids of, 2.1.2.2

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, 15

FREELIST GROUPS parameter

of STORAGE clause, 8

FREELISTS parameter

of STORAGE clause, 8

FREEPOOLS parameter

of LOB storage, 15

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, 5.1.5

FULL hint, 2.6.4.10

full outer joins, 19

function expressions

built-in, 6.8

user-defined, 6.8

function-based indexes, 14

creating, 14

enabling, 10.2, 10.2, 10.2

enabling and disabling, 10.2

refreshing, 10.2, 10.2

functions

3GL, calling, 16

G

general recovery clause

of ALTER DATABASE, 10.2, 10.2

geoimaging, 2.1.8

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, 15

global users, 16, 17

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, 13

GRAPHIC datatype

DB2, 2.1.3

SQL/DS, 2.1.3

greater than or equal to tests, 7.2

greater than tests, 7.2

GREATEST function, 5.1.5

GROUP BY clause

CUBE extension, 19

identifying duplicate groupings, 5.1.5

of SELECT and subqueries, 19, 19

ROLLUP extension of, 19

group comparison conditions, 7.2.2

group separator

specifying, 2.4.1.1

GROUP_ID function, 5.1.5

GROUPING function, 5.1.5

grouping sets, 19

GROUPING SETS clause

of SELECT and subqueries, 19

GROUPING_ID function, 5.1.5

groupings

filtering out duplicate, 5.1.5

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 hint, 2.6.4.11

HASH IS clause

of CREATE CLUSTER, 14

hash partitioning clause

of CREATE TABLE, 15, 15

hash partitions

adding, 12

coalescing, 12

HASHKEYS clause

of CREATE CLUSTER, 14

HAVING condition

of GROUP BY clause, 19

heap-organized tables

creating, 15

hexadecimal value

returning, 2.4.1.1

HEXTORAW function, 5.1.5

hierarchical function, 5.1.1.10

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, 5.1.5

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

ALL_ROWS, 2.6.4.1

APPEND, 2.6.4.2

CACHE, 2.6.4.3

CLUSTER, 2.6.4.4

CURSOR_SHARING_EXACT, 2.6.4.5

DRIVING_SITE, 2.6.4.6

DYNAMIC_SAMPLING, 2.6.4.7

FACT, 2.6.4.8

FIRST_ROWS(n), 2.6.4.9

FULL, 2.6.4.10

HASH, 2.6.4.11

in SQL statements, 2.6.3

INDEX, 2.6.4.12

INDEX_ASC, 2.6.4.13

INDEX_COMBINE, 2.6.4.14

INDEX_DESC, 2.6.4.15

INDEX_FFS, 2.6.4.16

INDEX_JOIN, 2.6.4.17

INDEX_SS, 2.6.4.18

INDEX_SS_ASC, 2.6.4.19

INDEX_SS_DESC, 2.6.4.20

LEADING, 2.6.4.21

location syntax, 2.6.3

MERGE, 2.6.4.22

MODEL_MIN_ANALYSIS, 2.6.4.23

MONITOR, 2.6.4.24

NO_EXPAND, 2.6.4.27

NO_FACT, 2.6.4.28

NO_INDEX, 2.6.4.29

NO_INDEX_FFS, 2.6.4.30

NO_INDEX_SS, 2.6.4.31

NO_MERGE, 2.6.4.32

NO_MONITOR, 2.6.4.33

NO_PARALLEL, 2.6.4.34

NO_PARALLEL_INDEX, 2.6.4.36

NO_PUSH_PRED, 2.6.4.38

NO_PUSH_SUBQ, 2.6.4.39

NO_PX_JOIN_FILTER, 2.6.4.40

NO_QUERY_TRANSFORMATION, 2.6.4.41

NO_REWRITE, 2.6.4.43

NO_STAR_TRANSFORMATION, 2.6.4.45

NO_UNNEST, 2.6.4.46

NO_USE_HASH, 2.6.4.47

NO_USE_MERGE, 2.6.4.48

NO_USE_NL, 2.6.4.49

NO_XML_QUERY_REWRITE, 2.6.4.51

NO_XMLINDEX_REWRITE, 2.6.4.50

NOAPPEND, 2.6.4.25

NOCACHE, 2.6.4.26

NOPARALLEL, 2.6.4.34

NOPARALLEL_INDEX, 2.6.4.36

NOREWRITE, 2.6.4.43

OPT_PARAM, 2.6.4.52

ORDERED, 2.6.4.53

PARALLEL, 2.6.4.54

PARALLEL_INDEX, 2.6.4.55

passing to the optimizer, 19

PQ_DISTRIBUTE, 2.6.4.56

PUSH_PRED, 2.6.4.57

PUSH_SUBQ, 2.6.4.58

PX_JOIN_FILTER, 2.6.4.59

QB_NAME, 2.6.4.60

REWRITE, 2.6.4.62

specifying a query block, 2.6.3

STAR_TRANSFORMATION, 2.6.4.63

syntax, 2.6.3

UNNEST, 2.6.4.64

USE_CONCAT, 2.6.4.65

USE_HASH, 2.6.4.66

USE_MERGE, 2.6.4.67

USE_NL, 2.6.4.68

USE_NL_WITH_INDEX, 2.6.4.69

histograms

creating equiwidth, 5.1.5

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, 16

of CREATE USER, 17

IDENTIFIED GLOBALLY clause

of ALTER ROLE. See CREATE ROLE

of CREATE ROLE, 16

of CREATE USER, 17

identifier functions, 5.1.1.15

IDLE_TIME parameter

of ALTER PROFILE, 11

IEEE754

floating-point arithmetic, 2.1.1.8.2

Oracle conformance with, 2.1.1.8.2

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, 7.13

IN OUT parameter

of CREATE FUNCTION, 14

of CREATE PROCEDURE, 16

IN parameter

of CREATE function, 14

of CREATE PROCEDURE, 16

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, 16

INCLUDING TABLES clause

of DROP CLUSTER, 17

incomplete object types, 17

creating, 17

INCREMENT BY clause

of ALTER SEQUENCE. See CREATE SEQUENCE

INCREMENT BY parameter

of CREATE SEQUENCE, 16

INDEX clause

of ANALYZE, 13

of CREATE CLUSTER, 14

INDEX hint, 2.6.4.12

index keys

compression, 10.2

INDEX object privilege

on a table, 18

index partitions

creating subpartitions, 14

index subpartitions, 14

INDEX_ASC hint, 2.6.4.13

INDEX_COMBINE hint, 2.6.4.14

INDEX_DESC hint, 2.6.4.15

INDEX_FFS hint, 2.6.4.16

INDEX_JOIN hint, 2.6.4.17

INDEX_SS hint, 2.6.4.18

INDEX_SS_ASC hint, 2.6.4.19

INDEX_SS_DESC hint, 2.6.4.20

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

creating, 14

creating as unusable, 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

full fast scans, 2.6.4.16

function-based, 14

creating, 14

global partitioned, creating, 14

globally partitioned, 14, 14

updating, 12

granting system privileges for, 18

invisible to the optimizer, 10.2, 14

join, bitmap, 14

key compression of, 10.2

key compression, enabling, 10.2

keys, eliminating repetition, 10.2

local domain, 14

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 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, 15

validating structure, 13

on range-partitioned tables, 14, 14, 14

index-organized tables

bitmap indexes on, creating, 15

creating, 15

mapping tables, 12

creating, 15

moving, 12

merging contents of index blocks, 12

modifying, 12, 12

moving, 12

overflow segments

specifying storage, 12, 15

partitioned, updating secondary indexes, 10.2

PCT_ACCESS_DIRECT statistics, 13

primary key indexes

coalescing, 12

rebuilding, 12

rowids of, 2.1.2.2

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, 7.2

INITCAP function, 5.1.5

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, 15

inline views, 9.7

inner joins, 9.6.5, 19

inner-N reporting, 5.1.5

INSERT ANY CUBE DIMENSION system privilege, 18

INSERT ANY MEASURE FOLDER system privilege, 18

INSERT ANY TABLE system privilege, 18

INSERT clause

of MERGE, 18

INSERT object privilege

on a table, 18

on a view, 18

on an OLAP cube dimension, 18

on an OLAP measures folder, 18

INSERT statement, 18

append, 2.6.4.2

error logging, 18

triggers on, 15

INSERTCHILDXML function, 5.1.5

inserts

and simultaneous update, 18

conditional, 18

conventional, 18

direct-path, 18

multitable, 18, 18

multitable, examples, 18

single-table, 18

using MERGE, 18

INSERTXMLBEFORE function, 5.1.5

instance recovery

continue after interruption, 10.2

INSTANCE session parameter, 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, 15

INSTEAD OF triggers, 15

INSTR function, 5.1.5

INSTR2 function, 5.1.5

INSTR4 function, 5.1.5

INSTRB function, 5.1.5

INSTRC function, 5.1.5

integers

generating unique, 16

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.19

International Standards Organization (ISO), B

standards, 1.2, 1.2, B.1

INTERSECT set operator, 4.5, 19

interval

arithmetic, 2.1.1.16

datatypes, 2.1.1.9

literals, 2.3.4

INTERVAL DAY TO SECOND datatype, 2.1.1.15

INTERVAL expressions, 6.9

interval partitioning, 12

changing the interval, 12

partitioning

interval, 15

INTERVAL YEAR TO MONTH datatype, 2.1.1.14

INTO clause

of EXPLAIN PLAN, 18

of INSERT, 18

INVALIDATE GLOBAL INDEXES clause

of ALTER TABLE, 12

inverse distribution functions, 5.1.5, 5.1.5

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, 16

defining for a procedure, 16

defining for an object type, 17

invoker-rights functions

defining, 14

IS [NOT] EMPTY conditions, 7.6.2

IS ANY condition, 7.5.1

IS NOT NULL operator, 7.9

IS NULL operator, 7.9

IS OF type condition, 7.14

IS PRESENT condition, 7.5.2

ISO. See International Standards Organization (ISO)

ISOLATION_LEVEL session parameter, 11

ITERATION_NUMBER function, 5.1.5

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

job scheduler object privileges, 18

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, 18, 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

parallel, 2.6.4.56

right outer, 19

self, 9.6.3

semijoins, 9.6.8

without join conditions, 9.6.4

Julian dates, 2.1.1.10.1

K

KEEP keyword

of FIRST function, 5.1.5

of LAST function, 5.1.5

with aggregate functions, 5.1.2

key compression, 15

definition, 10.2

disabling, 10.2, 14

enabling, 10.2

of index rebuild, 12

of indexes

disabling, 10.2

of index-organized tables, 15

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, 5.1.5

LANGUAGE clause

of CREATE PROCEDURE, 16

of CREATE TYPE, 17

of CREATE TYPE BODY, 17

large object functions, 5.1.1.8

large objects. See LOB datatypes

LAST function, 5.1.5

LAST_DAY function, 5.1.5

LAST_VALUE function, 5.1.5

LEAD function, 5.1.5

LEADING hint, 2.6.4.21

LEAST function, 5.1.5

left outer joins, 19

LENGTH function, 5.1.5

LENGTH2 function, 5.1.5

LENGTH4 function, 5.1.5

LENGTHB function, 5.1.5

LENGTHC function, 5.1.5

less than tests, 7.2

LEVEL clause

of ALTER DIMENSION, 10.2

of CREATE DIMENSION, 14, 14

level columns

specifying default values, 15

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, 16

granting system privileges for, 18

re-creating, 16

removing from the database, 17

library units. See Java schema objects

LIKE conditions, 7.7.1

linear regression functions, 5.1.5

LIST CHAINED ROWS clause

of ANALYZE, 13

list partitioning

adding default partition, 12

adding partitions, 12

adding values, 12, 12

creating a default partition, 15

creating partitions, 15

dropping values, 12, 12

merging default with nondefault partitions, 12

splitting default partition, 12

list subpartitions

adding, 12

listeners

registering, 11

literals

datetime, 2.3.3

in SQL statements and functions, 2.3

in SQL syntax, 2.3

interval, 2.3.4

LN function, 5.1.5

LNNVL function, 5.1.5

LOB columns

adding, 12

compressing, 15

creating from LONG columns, 2.1.1.9, 12

deduplication, 15

defining properties

for materialized views, 16

encrypting, 15

modifying, 12

modifying storage, 12

restricted in joins, 9.6.1

restrictions on, 2.1.1.19

storage characteristics of materialized views, 11

LOB datatypes, 2.1.1.19

LOB storage clause

for partitions, 12

of ALTER MATERIALIZED VIEW, 11, 11

of ALTER TABLE, 12, 12

of CREATE MATERIALIZED VIEW, 16, 16, 16, 16

of CREATE TABLE, 15, 15

LOBs

attributes, initializing, 2.1.1.19

columns

difference from LONG and LONG RAW, 2.1.1.19

populating, 2.1.1.19

external, 2.1.1.19

internal, 2.1.1.19

locators, 2.1.1.19

logging attribute, 15

modifying physical attributes, 12

number of bytes manipulated in, 15

saving old versions, 15, 15

saving values in a cache, 12, 15

specifying directories for, 14

storage

attributes, 15

characteristics, 8

in-line, 15

tablespace for

defining, 15

LOCAL clause

of CREATE INDEX, 14, 14

local users, 16, 17

locale independent, 2.4.2.1.2

locally managed tablespaces

altering, 12

storage attributes, 8

locally partitioned indexes, 14

LOCALTIMESTAMP function, 5.1.5

location transparency, 15

LOCK ANY TABLE system privilege, 18

LOCK TABLE statement, 18

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, 5.1.5

log groups

adding, 12

dropping, 12

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, 12

supplemental, dropping log groups, 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, 16

of CREATE MATERIALIZED VIEW LOG, 16

of CREATE TABLE, 15

of CREATE TABLESPACE, 15

logical conditions, 7.4

logical standby database

aborting, 10.2, 10.2

activating, 10.2

stopping, 10.2, 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, 12, 15

LOGOFF database event

triggers on, 15

LOGON database event

triggers on, 15

LONG columns

and domain indexes, 12

converting to LOB, 2.1.1.9, 12

restrictions on, 2.1.1.9

to store text strings, 2.1.1.9

to store view definitions, 2.1.1.9

where referenced from, 2.1.1.9

LONG datatype, 2.1.1.9

in triggers, 2.1.1.9

LONG RAW datatype, 2.1.1.19

converting from CHAR data, 2.1.1.19

LONG VARGRAPHIC datatype

DB2, 2.1.3, 2.1.3

SQL/DS, 2.1.3

LOWER function, 5.1.5

LPAD function, 5.1.5

LTRIM function, 5.1.5

M

MAKE_REF function, 5.1.5

MANAGE SCHEDULER system privilege, 18

MANAGE TABLESPACE system privilege, 18

managed recovery

of database, 10.2

managed standby recovery

as background process, 10.2

create a logical standby from the physical standby, 10.2

overriding delays, 10.2

returning control during, 10.2, 10.2

terminating existing, 10.2, 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, 15

modifying, 12

master databases, 16

master tables, 16

MATCHES condition, 4.1, 7.1

materialized join views, 16

materialized view logs, 16

adding columns, 11

creating, 16

excluding new values from, 11

logging changes to, 11

object ID based, 11

parallelizing creation, 16

partition attributes, changing, 11

partitioned, 16

physical attributes

changing, 11

specifying, 16

removing from the database, 17

required for fast refresh, 16

rowid based, 11

saving new values in, 11

saving old values in, 16

storage attributes

specifying, 16

materialized views, 16

allowing update of, 16

changing from rowid-based to primary-key-based, 11

changing to primary-key-based, 11

complete refresh, 11, 16

compression of, 11, 16

constraints on, 8

creating, 16

creating comments about, 13

degree of parallelism, 11, 11

during creation, 16

enabling and disabling query rewrite, 16

examples, 16, 16

fast refresh, 11, 16, 16

forced refresh, 11

granting system privileges for, 18

index characteristics

changing, 11

indexes that maintain, 16

join, 16

LOB storage attributes, 11

logging changes to, 11

master table, dropping, 17

object type, creating, 16

partitions, 11

compression of, 11, 16

physical attributes, 16

changing, 11

primary key, 16

recording values in master table, 11

query rewrite

eligibility for, 8

enabling and disabling, 11

re-creating during refresh, 11

refresh, 10.2

after DML on master table, 11, 16

mode, changing, 11

on next COMMIT, 11, 16

using trusted constraints, 16

refresh, time, changing, 11

refreshing, 10.2

removing from the database, 17

restricting scope of, 16

retrieving data from, 19

revalidating, 11

rowid, 16

rowid values

recording in master table, 11

saving blocks in a cache, 11

storage attributes, 16

changing, 11

subquery, 16

suppressing creation of default index, 16

synonyms for, 15

when to populate, 16

for replication, 16, 16

MAX function, 5.1.5

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, 16

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

performing ongoing, 10.2

preparing for, 10.2, 10.2

restrictions, 10.2

sustained standby recovery, 10.2

MEDIAN function, 5.1.5

median values, 5.1.5

MEMBER clause

of ALTER TYPE, 13

of CREATE TYPE, 17

MEMBER conditions, 7.6.3

membership conditions, 7.6.3, 7.13

MERGE ANY VIEW system privilege, 18

MERGE hint, 2.6.4.22

MERGE PARTITIONS clause

of ALTER TABLE, 12

MERGE statement, 18, 18

error logging, 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, 5.1.5

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, 15

mining models

auditing, 13

comments on, 13

MINUS set operator, 4.5, 19

MINVALUE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE

of CREATE SEQUENCE, 16

MOD function, 5.1.5

MODE clause

of LOCK TABLE, 18

MODEL clause

of SELECT, 19, 19

model conditions, 7.5

IS ANY, 7.5.1

IS PRESENT, 7.5.2

model expression, 6.10

model functions, 5.1.5

CV, 5.1.5

ITERATION_NUMBER, 5.1.5

PRESENTNNV, 5.1.5

PRESENTV, 5.1.5

PREVIOUS, 5.1.5

MODEL_MIN_ANALYSIS hint, 2.6.4.23

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

MODIFY VARRAY clause

of ALTER TABLE, 12, 12

MON datetime format element, 2.4.2.2

MONITOR hint, 2.6.4.24

MONITORING USAGE clause

of ALTER INDEX, 10.2

MONTH datetime format element, 2.4.2.2

MONTHS_BETWEEN function, 5.1.5

MOUNT clause

of ALTER DATABASE, 10.2

MOVE clause

of ALTER TABLE, 12, 12

MOVE ONLINE clause

of ALTER TABLE, 12

MOVE SUBPARTITION clause

of ALTER TABLE, 12

MTS. See shared server

multilevel collections, 15

multiset conditions, 7.6

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, 5.1.5

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

namespace, database, 2.8.1

namespaces

and object naming rules, 2.8.1

for nonschema objects, 2.8.1

for schema objects, 2.8.1

NANVL function, 5.1.5

national character set

changing, 10.2

fixed versus variable width, 2.1.1.3

multibyte character data, 2.1.1.23

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, 5.1.5

NCLOB datatype, 2.1.1.23

transactional support of, 2.1.1.23

nested subqueries, 9.7

NESTED TABLE clause

of ALTER TABLE, 12, 12

of CREATE TABLE, 15, 15

of CREATE TRIGGER, 15

nested tables, 2.1.4.4, 5.1.5, 5.1.5, 7.6.1

changing returned value, 12

combining, 4.6

compared with varrays, 2.2.5

comparison rules, 2.2.5

creating, 17, 17

creating from existing columns, 5.1.5

defining as index-organized tables, 12

determining hierarchy, 7.6.4

dropping the body of, 18

dropping the specification of, 18

in materialized views, 16, 16

indexing columns of, 14

modifying, 12, 13

modifying column properties, 12

multilevel, 15

of scalar types, modifying, 13

storage characteristics of, 12, 15

update in a view, 15

NEW_TIME function, 5.1.5

NEXT clause

of ALTER MATERIALIZED VIEW ... REFRESH, 11

NEXT parameter

of STORAGE clause, 8

NEXT_DAY function, 5.1.5

NEXTVAL pseudocolumn, 3.2, 16

NLS character functions, 5.1.1.3

NLS_CHARSET_DECL_LEN function, 5.1.5

NLS_CHARSET_ID function, 5.1.5

NLS_CHARSET_NAME function, 5.1.5

NLS_DATE_LANGUAGE initialization parameter, 2.4.2.2

NLS_INITCAP function, 5.1.5

NLS_LANGUAGE initialization parameter, 2.4.2.2, 9.5

NLS_LENGTH_SEMANTICS initialization parameter

overriding, 2.1.1.1

setting with ALTER SYSTEM, 10.2

NLS_LOWER function, 5.1.5

NLS_SORT initialization parameter, 9.5

NLS_TERRITORY initialization parameter, 2.4.2.2

NLS_UPPER function, 5.1.5

NLSSORT function, 5.1.5

NO FORCE LOGGING clause

of ALTER DATABASE, 10.2

of ALTER TABLESPACE, 12

NO_EXPAND hint, 2.6.4.27

NO_FACT hint, 2.6.4.28

NO_INDEX hint, 2.6.4.29

NO_INDEX_FFS hint, 2.6.4.30

NO_INDEX_SS hint, 2.6.4.31

NO_MERGE hint, 2.6.4.32

NO_MONITOR hint, 2.6.4.33

NO_PARALLEL hint, 2.6.4.34

NO_PARALLEL_INDEX, 2.6.4.36

NO_PUSH_PRED hint, 2.6.4.38

NO_PUSH_SUBQ hint, 2.6.4.39

NO_PX_JOIN_FILTER hint, 2.6.4.40

NO_QUERY_TRANSFORMATION hint, 2.6.4.41

NO_RESULT_CACHE hint, 2.6.4.42

NO_REWRITE hint, 2.6.4.43

NO_STAR_TRANSFORMATION hint, 2.6.4.45

NO_UNNEST hint, 2.6.4.46

NO_USE_HASH hint, 2.6.4.47

NO_USE_MERGE hint, 2.6.4.48

NO_USE_NL hint, 2.6.4.49

NO_XML_QUERY_REWRITE hint, 2.6.4.51

NO_XMLINDEX_REWRITE hint, 2.6.4.50

NOAPPEND hint, 2.6.4.25

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, 15

of CREATE CLUSTER, 14

of CREATE MATERIALIZED VIEW, 16

of CREATE MATERIALIZED VIEW LOG, 16

of CREATE SEQUENCE, 16

NOCACHE hint, 2.6.4.26

NOCOMPRESS clause

of ALTER INDEX ... REBUILD, 10.2

of CREATE INDEX, 14

of CREATE TABLE, 15

NOCOPY clause

of CREATE FUNCTION, 14

of CREATE PROCEDURE, 16

NOCYCLE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE, 11

of CREATE SEQUENCE, 16

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, 16

NOMINIMIZE RECORDS PER BLOCK clause

of ALTER TABLE, 12

NOMINVALUE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE, 11

of CREATE SEQUENCE, 16

NOMONITORING USAGE clause

of ALTER INDEX, 10.2

NONE clause

of SET ROLE, 19

nonempty subsets of, 5.1.5

nonequivalency tests, 7.13

nonschema objects

list of, 2.7.2

namespaces, 2.8.1

NOORDER parameter

of ALTER SEQUENCE. See CREATE SEQUENCE, 11

of CREATE SEQUENCE, 16

NOPARALLEL clause

of CREATE INDEX, 8, 15

NOPARALLEL hint, 2.6.4.34

NOPARALLEL_INDEX hint, 2.6.4.36

NORELY clause

of constraints, 8

NORESETLOGS clause

of CREATE CONTROLFILE, 14

NOREVERSE parameter

of ALTER INDEX ... REBUILD, 10.2, 10.2

NOREWRITE hint, 2.6.4.43

NOROWDEPENDENCIES clause

of CREATE CLUSTER, 14

of CREATE TABLE, 15

NOSORT clause

of ALTER INDEX, 14

NOT condition, 7.4, 7.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, 16

NOT IN subqueries

converting to NOT EXISTS subqueries, 5.1.5

NOT INSTANTIABLE clause

of CREATE TYPE, 17, 17

NOT NULL clause

of CREATE TABLE, 15

NOWAIT clause

of LOCK TABLE, 18

NTILE function, 5.1.5

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, 7.9

NULLIF function, 5.1.5

as a form of CASE expression, 5.1.5

NULL-related functions, 5.1.1.14

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, 5.1.1.1

numbers

comparison rules, 2.2.1

floating-point, 2.1.1.6, 2.1.1.8

in SQL syntax, 2.3.2

precision of, 2.3.2.2

spelling out, 2.4.2.5

syntax of, 2.3.2.2

numeric precedence, 2.1.1.9

NUMTODSINTERVAL function, 5.1.5

NUMTOYMINTERVAL function, 5.1.5

NVARCHAR2 datatype, 2.1.1.3

NVL function, 5.1.5

NVL2 function, 5.1.5

O

object access expressions, 6.11

OBJECT IDENTIFIER clause

of CREATE TABLE, 15

object identifiers

contained in REFs, 2.1.4.2

of object views, 17

primary key, 15

specifying, 15, 17

specifying an index on, 15

system-generated, 15

object instances

types of, 7.14

object privileges

FLASHBACK ARCHIVE, 18

granting, 16

multiple, 16

on specific columns, 18

on a database object

revoking, 18

from a role, 18, 18

from a user, 18, 18

from PUBLIC, 18

object reference functions, 5.1.4

object tables

adding rows to, 18

as part of hierarchy, 15

creating, 15, 15

querying, 15

system-generated column name, 15, 15, 17, 17

updating to latest version, 12

upgrading, 12

object type columns

defining properties

for materialized views, 16, 16

in a type hierarchy, 15

membership in hierarchy, 12

modifying properties

for tables, 12, 12

substitutability, 12

object type materialized views

creating, 16

object types, 2.1.4.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, 15

membership in hierarchy, 12

substitutability, 12

bodies

creating, 17

re-creating, 17

SQL examples, 17

comparison rules, 2.2.4

MAP function, 2.2.4

ORDER function, 2.2.4

compiling the specification and body, 13

components of, 2.1.4.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.5

incomplete, 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.6

varrays, 17

object views, 17

base tables

adding rows, 18

creating, 17

creating subviews, 17

defining, 17

querying, 17

OBJECT_ID pseudocolumn, 3.5, 15, 15, 17, 17

OBJECT_VALUE pseudocolumn, 3.6

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, 15

OIDINDEX clause

of CREATE TABLE, 15

OIDs. See object identifiers

OLAP functions

CUBE_TABLE, 5.1.5

ON clause

of CREATE OUTLINE, 16

ON COMMIT clause

of CREATE TABLE, 15

ON COMMIT REFRESH object privilege

on a materialized view, 18

ON COMMIT REFRESH system privilege, 18

ON DATABASE clause

of CREATE TRIGGER, 15

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, 13

of NOAUDIT, 18

ON MINING MODEL clause

of AUDIT, 13

ON NESTED TABLE clause

of CREATE TRIGGER, 15

ON object clause

of NOAUDIT, 18

of REVOKE, 18

ON PREBUILT TABLE clause

of CREATE MATERIALIZED VIEW, 16

ON SCHEMA clause

of CREATE TRIGGER, 15

online backup

of tablespaces, ending, 12

ONLINE clause

of ALTER TABLESPACE, 12

of CREATE INDEX, 14

of CREATE TABLESPACE, 15

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

operands, 4

operating system files

dropping, 18, 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, 16

unary, 4.1.1

user-defined, 4.7

binding to a function, 11, 16

creating, 16

dropping, 17

how bindings are implemented, 16

implementation type, 16

return type of binding, 16

user-defined, compiling, 11

OPT_PARAM hint, 2.6.4.52

OPTIMAL parameter

of STORAGE clause, 8

OR condition, 7.4, 7.4

OR REPLACE clause

of CREATE CONTEXT, 14

of CREATE DIRECTORY, 14

of CREATE FUNCTION, 14, 14

of CREATE LIBRARY, 16

of CREATE OUTLINE, 16

of CREATE PACKAGE, 16

of CREATE PACKAGE BODY, 16

of CREATE PROCEDURE, 16

of CREATE TRIGGER, 15

of CREATE TYPE, 17

of CREATE TYPE BODY, 17

of CREATE VIEW, 17

ORA_HASH function, 5.1.5

ORA_ROWSCN pseudocolumns, 3.7

Oracle Call Interface, 1.5

Oracle Expression Filter

conditions, 7.1

operators, 4.1

Oracle reserved words, D

Oracle Text

built-in conditions, 4.1, 7.1

CATSEARCH, 4.1, 7.1

CONTAINS, 4.1, 7.1

creating domain indexes, 14

MATCHES, 4.1, 7.1

Oracle Tools

support of SQL, 1.5

ORDAudio datatype, 2.1.9.1

ORDDicom datatype, 2.1.9.5

ORDDoc datatype, 2.1.9.4

ORDER BY clause

of queries, 9.5

of SELECT, 9.5, 19, 19

with ROWNUM, 3.9

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, 16

ORDER SIBLINGS BY clause

of SELECT, 19

ORDERED hint, 2.6.4.53

ORDImage datatype, 2.1.9.2

ORDImageSignature datatype, 2.1.9.13

ordinal numbers

specifying, 2.4.2.5

spelling out, 2.4.2.5

ORDVideo datatype, 2.1.9.3

ORGANIZATION EXTERNAL clause

of CREATE TABLE, 15, 15

ORGANIZATION HEAP clause

of CREATE TABLE, 15

ORGANIZATION INDEX clause

of CREATE TABLE, 15

OUT parameter

of CREATE FUNCTION, 14

of CREATE PROCEDURE, 16

outer joins, 9.6.6

restrictions, 9.6.6

outlines

assign to a different category, 11

assigning to a different category, 11, 11

copying, 16

creating, 16

creating on statements, 16

dropping from the database, 17

enabling and disabling dynamically, 16

for use by current session, 16

for use by PUBLIC, 16

granting

system privileges for, 18

private, use by the optimizer, 11

rebuilding, 11, 11

recompiling, 11

renaming, 11, 11, 11

replacing, 16

storing groups of, 16

use by the optimizer, 11

use to generate execution plans, 11

used to generate execution plans, 16

out-of-line constraints

of CREATE TABLE, 15

OVER clause

of analytic functions, 5.1.3

OVERFLOW clause

of ALTER INDEX, 10.2

of ALTER TABLE, 12

of CREATE TABLE, 15

OVERRIDING clause

of ALTER TYPE, 13

of CREATE TYPE, 17

P

package bodies

creating, 16

re-creating, 16

removing from the database, 17

packaged procedures

dropping, 17

packages

associating statistics with, 13, 13

avoiding run-time compilation, 11

creating, 16

disassociating statistics types from, 17

invoker rights, 16

recompiling explicitly, 11

redefining, 16

removing from the database, 17

specifying schema and privileges of, 16

synonyms for, 15

PARALLEL clause

of ALTER CLUSTER, 10.2, 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, 16, 16

of CREATE MATERIALIZED VIEW LOG, 16, 16

of CREATE TABLE, 15, 15

parallel execution

hints, 2.6.4.54

of DDL statements, 11

of DML statements, 11

PARALLEL hint, 2.6.4.54

PARALLEL_ENABLE clause

of CREATE FUNCTION, 14

PARALLEL_INDEX hint, 2.6.4.55

parameter files

creating, 16, 16

from memory, 16

parameters

in syntax

optional, A.1.2

required, A.1.1

PARAMETERS clause

of CREATE INDEX, 14, 14

PARTITION ... LOB storage clause

of ALTER TABLE, 12

PARTITION BY HASH clause

of CREATE TABLE, 15

PARTITION BY LIST clause

of CREATE TABLE, 15

PARTITION BY RANGE clause

of CREATE TABLE, 15, 15

partition by reference, 15

PARTITION clause

of ANALYZE, 13

of CREATE INDEX, 14

of CREATE TABLE, 15

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, 15

clauses

of ALTER INDEX, 10.2

of ALTER TABLE, 12

of materialized view logs, 11, 16

of materialized views, 11, 16, 16

range with interval partitions, 15

system, 15

partitioning referential constraint, 12, 15

partitions

adding, 12

adding rows to, 18

allocating extents for, 12

based on literal values, 15

composite

specifying, 15

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, 15

index, 14

inserting rows into, 18

list, adding, 12

LOB storage characteristics of, 12

locking, 18

logging attribute, 15

logging insert operations, 12

merging, 12

modifying, 12, 12

physical attributes

changing, 12

range

adding, 12

specifying, 15

removing rows from, 12, 17

renaming, 12

revising values in, 19

splitting, 12

storage characteristics, 8

tablespace for

defining, 15

PASSWORD EXPIRE clause

of ALTER USER. See CREATE USER

of CREATE USER, 17

PASSWORD_GRACE_TIME parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

PASSWORD_LIFE_TIME parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

PASSWORD_LOCK_TIME parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

PASSWORD_REUSE_MAX parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

PASSWORD_REUSE_TIME parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

PASSWORD_VERIFY_FUNCTION parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 16

passwords

expiration of, 17

grace period, 16

guaranteeing complexity, 16

limiting use and reuse, 16

locking, 16

making unavailable, 16

parameters

of CREATE PROFILE, 16

special characters in, 17

PATH_VIEW, 7.10.1, 7.10.2

pattern-matching conditions, 7.7

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, 15

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, 15

of LOB storage clause, 12

PERCENT_RANK function, 5.1.5

PERCENTILE_CONT function, 5.1.5

PERCENTILE_DISC function, 5.1.5

PERMANENT clause

of ALTER TABLESPACE, 12

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, 16

of CREATE TABLE, 15, 15

physical standby database

activating, 10.2

converting to snapshot standby database, 10.2

PIPELINED clause

of CREATE FUNCTION, 14

pivot operations, 19

examples, 19

syntax, 19

placeholder expressions, 6.12

plan stability, 16

PLAN_TABLE sample table, 18

PL/SQL

program body

of CREATE FUNCTION, 14

PL/SQL compiler

parameters, 10.2, 11, 11, 13, 13

P.M. datetime format element, 2.4.2.2, 2.4.2.2

POSIX regular expression standard, C

POWER function, 5.1.5

POWERMULTISET function, 5.1.5

POWERMULTISET_BY_CARDINALITY function, 5.1.5

PQ_DISTRIBUTE hint, 2.6.4.56

PRAGMA clause

of ALTER TYPE, 13

of CREATE TYPE, 17, 17

PRAGMA RESTRICT_REFERENCES, 13

precedence

of conditions, 7.1.1

of numbers, 2.1.1.9

of operators, 4.1.2

precision

number of digits of, 2.3.2.2

of NUMBER datatype, 2.1.1.6

precompilers, 1.5

predefined roles, 18

PREDICTION function, 5.1.5

PREDICTION_BOUNDS function, 5.1.5

PREDICTION_COST function, 5.1.5

PREDICTION_DETAILS function, 5.1.5

PREDICTION_PROBABILITY function, 5.1.5

PREDICTION_SET function, 5.1.5

PREPARE TO SWITCHOVER clause

of ALTER DATABASE, 10.2

PRESENTNNV function, 5.1.5

PRESENTV function, 5.1.5

PREVIOUS function, 5.1.5

primary database

converting to physical standby database, 10.2

PRIMARY KEY clause

of constraints, 8

of CREATE TABLE, 15

primary key constraints, 8

enabling, 15

index on, 15

primary keys

generating values for, 16

PRIOR clause

of hierarchical queries, 9.3

PRIOR operator, 4.4.1

PRIVATE clause

of CREATE OUTLINE, 16

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, 16

avoid run-time compilation, 11

calling, 13

compile explicitly, 11

creating, 16

declaring

as a Java method, 16

as C functions, 16

executing, 13

external, 16

running from remote database, 16

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, 16

removing from the database, 17

schema executed in, 13, 17

specifying schema and privileges for, 16

synonyms for, 15

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, 16

examples, 16

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, 13

pseudocolumns, 3

COLUMN_VALUE, 3.4

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.5, 15, 15, 17, 17

OBJECT_VALUE, 3.6

ORA_ROWSCN, 3.7

ROWID, 3.8

ROWNUM, 3.9

uses for, 3.9

versions queries, 3.3

XMLDATA, 3.10

PUBLIC clause

of CREATE OUTLINE, 16

of CREATE SYNONYM, 15

of DROP DATABASE LINK, 17

public database links

dropping, 17

public synonyms, 15

dropping, 18

PURGE statement, 18

PUSH_PRED hint, 2.6.4.57

PUSH_SUBQ hint, 2.6.4.58

PX_JOIN_FILTER hint, 2.6.4.59

Q

QB_NAME hint, 2.6.4.60

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.9

query rewrite

and dimensions, 14

defined, 19

QUERY REWRITE object privilege

on a materialized view, 18

QUERY REWRITE system privilege, 18

QUIESCE RESTRICTED clause

of ALTER SYSTEM, 11

QUOTA clause

of ALTER USER. See CREATE USER

of CREATE USER, 17

R

range conditions, 7.8

range partitioning

converting to interval partitioning, 12

range partitions

adding, 12

creating, 15

values of, 15

RANK function, 5.1.5

RATIO_TO_REPORT function, 5.1.5

RAW datatype, 2.1.1.19

converting from CHAR data, 2.1.1.19

RAWTOHEX function, 5.1.5

RAWTONHEX function, 5.1.5

READ object privilege

on a materialized directory, 18

READ ONLY clause

of ALTER TABLESPACE, 12

READ WRITE clause

of ALTER TABLESPACE, 12

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, 15

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, 6.13

scale

greater than precision, 2.1.1.6

of NUMBER datatype, 2.1.1.6

SCHEMA clause

of CREATE JAVA, 14

schema objects, 2.7.1

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.4.1

on remote databases, 2.9.3

partitioned indexes, 2.9.4

partitioned tables, 2.9.4

parts of, 2.8

protecting location, 15

protecting owner, 15

providing alternate names for, 15

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, 16

definition of, 2.7.1

scientific notation, 2.4.1.1

SCOPE FOR clause

of ALTER MATERIALIZED VIEW, 11

of CREATE MATERIALIZED VIEW, 16

SDO_GEOMETRY datatype, 2.1.8

SDO_GEORASTER datatype, 2.1.8

SDO_TOPO_GEOMETRY datatype, 2.1.8.2

security

enforcing, 15

security clauses

of ALTER SYSTEM, 11

segment attributes clause

of CREATE TABLE, 15

SEGMENT MANAGEMENT clause

of CREATE TABLESPACE, 15

segments

space management

automatic, 15

manual, 15

using bitmaps, 15

using free lists, 15

table

compacting, 10.2, 11, 11, 12

SELECT ANY CUBE DIMENSION system privilege, 18

SELECT ANY CUBE system privilege, 18

SELECT ANY DICTIONARY system privilege, 18

SELECT ANY MINING MODEL 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

on a materialized view, 18

on a mining model, 18

on a sequence, 18

on a table, 18

on a view, 18

on an OLAP cube, 18

on an OLAP cube dimension, 18

SELECT statement, 9.1, 19

SELECT_CATALOG_ROLE role, 18

self joins, 9.6.3

semijoins, 9.6.8

sequences, 3.2, 16

accessing values of, 16

changing

the increment value, 11

creating, 16

creating without limit, 16

granting

system privileges for, 18

guarantee consecutive values, 16

how to use, 3.2.2

increment value, setting, 16

incrementing, 16

initial value, setting, 16

maximum value

eliminating, 11

setting, 16

setting or changing, 11

minimum value

eliminating, 11

setting, 16

setting or changing, 11

number of cached values, changing, 11

ordering values, 11

preallocating values, 16

recycling values, 11

removing from the database, 18

renaming, 18

restarting, 18

at a different number, 11

at a predefined limit, 16

values, 16

reusing, 16

stopping at a predefined limit, 16

synonyms for, 15

where to use, 3.2.1

server parameter files

creating, 16

from memory, 16

server wallet

keys, 11

SERVERERROR event

triggers on, 15, 15

service name

of remote database, 14

session control statements, 10.1.4

PL/SQL support of, 10.1.4

session locks

releasing, 11

session parameters

changing settings, 11

INSTANCE, 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

terminating across instances, 11

time zone setting, 11

SESSIONS_PER_USER parameter

of ALTER PROFILE, 11

SESSIONTIMEZONE function, 5.1.5

SET clause

of ALTER SESSION, 11

of ALTER SYSTEM, 11

SET conditions, 7.6.1

SET CONSTRAINT(S) statement, 19

SET DANGLING TO NULL clause

of ANALYZE, 13

SET DATABASE clause

of CREATE CONTROLFILE, 14

SET function, 5.1.5

SET KEY clause

of ALTER SYSTEM, 11

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

SET WALLET clause

of ALTER SYSTEM, 11

SGA. See system global area (SGA)

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

short-circuit evaluation

DECODE function, 5.1.5

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, 15

SI_AverageColor datatype, 2.1.9.8

SI_Color datatype, 2.1.9.7

SI_ColorHistogram datatype, 2.1.9.9

SI_FeatureList datatype, 2.1.9.12

SI_PositionalColorHistogram datatype, 2.1.9.10

SI_StillImage datatype, 2.1.9.6

SI_Texture datatype, 2.1.9.11

siblings

ordering in a hierarchical query, 19

SIGN function, 5.1.5

simple comparison conditions, 7.2.1

simple expressions, 6.2

SIN function, 5.1.5

SINGLE TABLE clause

of CREATE CLUSTER, 14

single-row functions, 5.1.1

single-table insert, 18

SINH function, 5.1.5

SIZE clause

of ALTER CLUSTER, 10.2

of CREATE CLUSTER, 14

of file specifications, 8

SNMPAGENT role, 18

SOME operator, 7.2

SOUNDEX function, 5.1.5

SP datetime format element suffix, 2.4.2.5

special characters

in passwords, 16

SPECIFICATION clause

of ALTER PACKAGE, 11

spelled numbers

specifying, 2.4.2.5

SPLIT PARTITION clause

of ALTER INDEX, 10.2

of ALTER TABLE, 12

SPTH datetime format element suffix, 2.4.2.5

SQL comments

XMLCOMMENT, 5.1.5

SQL Developer, 1.5

SQL functions

ABS, 5.1.5

ACOS, 5.1.5

ADD_MONTHS, 5.1.5

aggregate, 5.1.2

analytic, 5.1.3

APPENDCHILDXML, 5.1.5

applied to LOB columns, 5.1

ASCII, 5.1.5

ASCIISTR, 5.1.5

ASIN, 5.1.5

ATAN, 5.1.5

ATAN2, 5.1.5

AVG, 5.1.5

BFILENAME, 5.1.5

BIN_TO_NUM, 5.1.5

BITAND, 5.1.5

CARDINALITY, 5.1.5

CAST, 5.1.5

CEIL, 5.1.5

character

returning character values, 5.1.1.2

returning number values, 5.1.1.4

CHARTOROWID, 5.1.5

CHR, 5.1.5

CLUSTER_ID, 5.1.5

CLUSTER_PROBABILITY, 5.1.5

CLUSTER_SET, 5.1.5

COALESCE, 5.1.5

COLLECT, 5.1.5

collection, 5.1.1.9

COMPOSE, 5.1.5

CONCAT, 5.1.5

conversion, 5.1.1.7

CONVERT, 5.1.5

CORR, 5.1.5

CORR_K, 5.1.5

CORR_S, 5.1.5

COS, 5.1.5

COSH, 5.1.5

COUNT, 5.1.5

COVAR_POP, 5.1.5

COVAR_SAMP, 5.1.5

CUBE_TABLE, 5.1.5

CUME_DIST, 5.1.5

CURRRENT_DATE, 5.1.5

CURRRENT_TIMESTAMP, 5.1.5

CV, 5.1.5

data mining, 5.1.1.11

DATAOBJ_TO_PARTITION, 5.1.5

date, 5.1.1.5

DBTIMEZONE, 5.1.5

DECOMPOSE, 5.1.5

DELETEXML, 5.1.5

DENSE_RANK, 5.1.5

DEREF, 5.1.5

DUMP, 5.1.5

EMPTY_BLOB, 5.1.5

EMPTY_CLOB, 5.1.5

encoding and decoding, 5.1.1.13

environment and identifier, 5.1.1.15

EXISTSNODE, 5.1.5

EXP, 5.1.5

EXTRACT (datetime), 5.1.5

EXTRACT (XML), 5.1.5

EXTRACTXML, 5.1.5

FEATURE_ID, 5.1.5

FEATURE_SET, 5.1.5

FEATURE_VALUE, 5.1.5

FIRST, 5.1.5

FIRST_VALUE, 5.1.5

FLOOR, 5.1.5

FROM_TZ, 5.1.5

general comparison functions, 5.1.1.6

GREATEST, 5.1.5

GROUP_ID, 5.1.5

GROUPING, 5.1.5

GROUPING_ID, 5.1.5

HEXTORAW, 5.1.5

hierarchical, 5.1.1.10

INITCAP, 5.1.5

INSERTCHILDXML, 5.1.5

INSERTXMLBEFORE, 5.1.5

INSTR, 5.1.5

INSTR2, 5.1.5

INSTR4, 5.1.5

INSTRB, 5.1.5

INSTRC, 5.1.5

ITERATION_NUMBER, 5.1.5

LAG, 5.1.5

large object, 5.1.1.8

LAST, 5.1.5

LAST_DAY, 5.1.5

LAST_VALUE, 5.1.5

LEAD, 5.1.5

LEAST, 5.1.5

LENGTH, 5.1.5

LENGTH2, 5.1.5

LENGTH4, 5.1.5

LENGTHB, 5.1.5

LENGTHC, 5.1.5

linear regression, 5.1.5

LN, 5.1.5

LNNVL, 5.1.5

LOCALTIMESTAMP, 5.1.5

LOG, 5.1.5

LOWER, 5.1.5

LPAD, 5.1.5

LTRIM, 5.1.5

MAKE_REF, 5.1.5

MAX, 5.1.5

MEDIAN, 5.1.5

MIN, 5.1.5

MOD, 5.1.5

model, 5.1.5

MONTHS_BETWEEN, 5.1.5

NANVL, 5.1.5

NCHR, 5.1.5

NEW_TIME, 5.1.5

NEXT_DAY, 5.1.5

NLS character, 5.1.1.3

NLS_CHARSET_DECL_LEN, 5.1.5

NLS_CHARSET_ID, 5.1.5

NLS_CHARSET_NAME, 5.1.5

NLS_INITCAP, 5.1.5

NLS_LOWER, 5.1.5

NLS_UPPER, 5.1.5

NLSSORT, 5.1.5

NLV2, 5.1.5

NTILE, 5.1.5

NULLIF, 5.1.5

NULL-related, 5.1.1.14

number, 5.1.1.1

NUMTODSINTERVAL, 5.1.5

NUMTOYMINTERVAL, 5.1.5

NVL, 5.1.5

object reference, 5.1.4

ORA_HASH, 5.1.5

PERCENT_RANK, 5.1.5

PERCENTILE_CONT, 5.1.5

PERCENTILE_DISC, 5.1.5

POWER, 5.1.5

POWERMULTISET, 5.1.5

POWERMULTISET_BY_CARDINALITY, 5.1.5

PREDICTION, 5.1.5

PREDICTION_BOUNDS, 5.1.5

PREDICTION_COST, 5.1.5

PREDICTION_DETAILS, 5.1.5

PREDICTION_PROBABILITY, 5.1.5

PREDICTION_SET, 5.1.5

PRESENTNNV, 5.1.5

PRESENTV, 5.1.5

PREVIOUS, 5.1.5

RANK, 5.1.5

RATIO_TO_REPORT, 5.1.5

RAWTOHEX, 5.1.5

RAWTONHEX, 5.1.5

REF, 5.1.5

REFTOHEX, 5.1.5

REGEXP_COUNT, 5.1.5

REGEXP_INSTR, 5.1.5

REGEXP_REPLACE, 5.1.5

REGEXP_SUBSTR, 5.1.5

REGR_AVGX, 5.1.5

REGR_AVGY, 5.1.5

REGR_COUNT, 5.1.5

REGR_INTERCEPT, 5.1.5

REGR_R2, 5.1.5

REGR_SLOPE, 5.1.5

REGR_SXX, 5.1.5

REGR_SXY, 5.1.5

REGR_SYY, 5.1.5

REMAINDER, 5.1.5

REPLACE, 5.1.5

ROUND (date), 5.1.5

ROUND (number), 5.1.5

ROW_NUMBER, 5.1.5

ROWIDTOCHAR, 5.1.5

ROWIDTONCHAR, 5.1.5

RPAD, 5.1.5

RTRIM, 5.1.5

SESSIONTIMEZONE, 5.1.5

SET, 5.1.5

SIGN, 5.1.5

SIN, 5.1.5

single-row, 5.1.1

SINH, 5.1.5

SOUNDEX, 5.1.5

SQRT, 5.1.5

STATS_BINOMIAL_TEST, 5.1.5

STATS_CROSSTAB, 5.1.5

STATS_F_TEST, 5.1.5

STATS_KS_TEST, 5.1.5

STATS_MODE, 5.1.5

STATS_MW_TEST, 5.1.5

STATS_ONE_WAY_ANOVA, 5.1.5

STATS_T_TEST_INDEP, 5.1.5, 5.1.5

STATS_T_TEST_INDEPU, 5.1.5, 5.1.5

STATS_T_TEST_ONE, 5.1.5, 5.1.5

STATS_T_TEST_PAIRED, 5.1.5, 5.1.5

STATS_WSR_TEST, 5.1.5

STDDEV, 5.1.5

STDDEV_POP, 5.1.5

STDDEV_SAMP, 5.1.5

SUBSTR, 5.1.5

SUBSTR2, 5.1.5

SUBSTR4, 5.1.5

SUBSTRB, 5.1.5

SUBSTRC, 5.1.5

SUM, 5.1.5

SYS_CONNECT_BY_PATH, 5.1.5

SYS_CONTEXT, 5.1.5

SYS_DBURIGEN, 5.1.5

SYS_EXTRACT_UTC, 5.1.5

SYS_GUID, 5.1.5

SYS_TYPEID, 5.1.5

SYS_XMLAGG, 5.1.5

SYS_XMLGEN, 5.1.5

SYSDATE, 5.1.5

SYSTIMESTAMP, 5.1.5

TAN, 5.1.5

TANH, 5.1.5

TIMESTAMP_TO_SCN, 5.1.5

TO_BINARY_DOUBLE, 5.1.5

TO_BINARY_FLOAT, 5.1.5

TO_CHAR (character), 5.1.5

TO_CHAR (datetime), 5.1.5

TO_CHAR (number), 5.1.5

TO_CLOB, 5.1.5

TO_DATE, 5.1.5

TO_DSINTERVAL, 5.1.5

TO_LOB, 5.1.5

TO_MULTI_BYTE, 5.1.5

TO_NCHAR (character), 5.1.5

TO_NCHAR (datetime), 5.1.5

TO_NCHAR (number), 5.1.5

TO_NCLOB, 5.1.5

TO_NUMBER, 5.1.5

TO_SINGLE_BYTE, 5.1.5

TO_TIMESTAMP, 5.1.5

TO_YMINTERVAL, 5.1.5

TRANSLATE, 5.1.5

TRANSLATE ... USING, 5.1.5

TREAT, 5.1.5

TRIM, 5.1.5

TRUNC (date), 5.1.5

TRUNC (number), 5.1.5

t-test, 5.1.5

TZ_OFFSET, 5.1.5

UID, 5.1.5

UNISTR, 5.1.5

UPDATEXML, 5.1.5

UPPER, 5.1.5

USER, 5.1.5

USERENV, 5.1.5

VALUE, 5.1.5

VAR_POP, 5.1.5

VAR_SAMP, 5.1.5

VARIANCE, 5.1.5

VSIZE, 5.1.5

WIDTH_BUCKET, 5.1.5

XML functions, 5.1.1.12

XMLAGG, 5.1.5

XMLCAST, 5.1.5

XMLCDATA, 5.1.5

XMLCONCAT, 5.1.5

XMLDiff, 5.1.5

XMLExists, 5.1.5

XMLPARSE, 5.1.5

XMLPI, 5.1.5

XMLQUERY, 5.1.5

XMLROOT, 5.1.5

XMLSERIALIZE, 5.1.5

XMLTABLE, 5.1.5

SQL statements

ALTER FLASHBACK ARCHIVE, 10.2

auditing

by access, 13

by proxy, 13

by session, 13

by user, 13

stopping, 18

successful, 13

CREATE FLASHBACK ARCHIVE, 14

DDL, 10.1.1

determining the execution plan for, 18

DML, 10.1.2

DROP FLASHBACK ARCHIVE, 17

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

SQLData Java storage format, 17

SQL/DS datatypes, 2.1.3

restrictions on, 2.1.3

SQLJ object types

creating, 17

mapping a Java class to, 17

SQRT function, 5.1.5

standalone procedures

dropping, 17

standard SQL, B

Oracle extensions to, B.11

standby database

recovering, 10.2

standby databases

activating, 10.2

and Data Guard, 10.2

committing to primary status, 10.2

controlling use, 10.2

converting to physical standby, 10.2

designing media recovery, 10.2

mounting, 10.2

recovering, 10.2, 10.2

STAR_TRANSFORMATION hint, 2.6.4.63

STAR_TRANSFORMATION_ENABLED initialization parameter, 2.6.4.63

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, 16

STARTUP event

triggers on, 15

startup_clauses

of ALTER DATABASE, 10.2

STATIC clause

of ALTER TYPE, 13

of CREATE TYPE, 17

statistics

collection during index rebuild, 10.2

deleting from the data dictionary, 13

forcing disassociation, 17

on index usage, 10.2

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

with datatypes, 13

with functions, 13

with packages, 13

associating with datatypes, 13

associating with domain indexes, 13, 13

associating with functions, 13

associating with indextypes, 13, 13

associating with packages, 13

disassociating

from columns, 17

from domain indexes, 17

from functions, 17

from indextypes, 17

from packages, 17

from types, 17

STATS_BINOMIAL_TEST function, 5.1.5

STATS_CROSSTAB function, 5.1.5

STATS_F_TEST function, 5.1.5

STATS_KS_TEST function, 5.1.5

STATS_MODE function, 5.1.5

STATS_MW_TEST function, 5.1.5

STATS_ONE_WAY_ANOVA function, 5.1.5

STATS_T_TEST_INDEP function, 5.1.5, 5.1.5

STATS_T_TEST_INDEPU function, 5.1.5, 5.1.5

STATS_T_TEST_ONE function, 5.1.5, 5.1.5

STATS_T_TEST_PAIRED function, 5.1.5, 5.1.5

STATS_WSR_TEST function, 5.1.5

STDDEV function, 5.1.5

STDDEV_POP function, 5.1.5

STDDEV_SAMP function, 5.1.5

STOP LOGICAL STANDBY clause

of ALTER DATABASE, 10.2, 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, 16

of CREATE MATERIALIZED VIEW LOG. See CREATE TABLE

of CREATE TABLE, 8, 15

storage parameters

default, changing, 12

resetting, 19, 19

STORE IN clause

of ALTER TABLE, 12, 15

stored functions, 14

string literals. See text literals.

strings

converting to ASCII values, 5.1.5

converting to unicode, 5.1.5

strings. See text literals.

Structured Query Language (SQL)

description, 1.2.1

functions, 5.1

keywords, A.1.1

Oracle Tools support of, 1.5

parameters, A.1.1

standards, 1.2, B

statements

determining the cost of, 18

syntax, 10.2, A.1

subexpressions

of regular expressions, 5.1.5, 5.1.5

SUBMULTISET condition, 7.6.4

SUBPARTITION BY HASH clause

of CREATE TABLE, 15, 15

SUBPARTITION BY LIST clause

of CREATE TABLE, 15

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, 12

adding rows to, 18

allocating extents for, 12

coalescing, 12, 12

converting into nonpartitioned tables, 12

creating, 15

creating a template for, 12, 15

deallocating unused space from, 12

exchanging with tables, 12

hash, 15

inserting rows into, 18

list, 15

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, 15

template, creating, 15

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, 6.13

to insert table data, 15

unnesting, 9.8

using in place of expressions, 6.13

SUBSTR function, 5.1.5

SUBSTR2 function, 5.1.5

SUBSTR4 function, 5.1.5

SUBSTRB function, 5.1.5

SUBSTRC function, 5.1.5

subtotal values

deriving, 19

subtypes, 13

dropping safely, 18

SUM function, 5.1.5

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, 15

granting

system privileges for, 18

local, 15

private, dropping, 18

public, 15

dropping, 18

remote, 15

removing from the database, 18

renaming, 18, 18

synonyms for, 15

syntax diagrams, A.1

loops, A.1.3

multipart diagrams, A.1.4

SYS user

assigning password for, 14

SYS_CONNECT_BY_PATH function, 5.1.5

SYS_CONTEXT function, 5.1.5

SYS_DBURIGEN function, 5.1.5

SYS_EXTRACT_UTC function, 5.1.5

SYS_GUID function, 5.1.5

SYS_NC_ROWINFO$ column, 15, 17

SYS_TYPEID function, 5.1.5

SYS_XMLAGG function, 5.1.5

SYS_XMLGEN function, 5.1.5

SYSAUX clause

of CREATE DATABASE, 14

SYSAUX tablespace

creating, 14, 15

SYSDATE function, 5.1.5

SYSDBA system privilege, 18

SYSOPER system privilege, 18

system change numbers

obtaining, 3.7

system control statements, 10.1.5

PL/SQL support of, 10.1.5

system events

triggers on, 15

system global area

flushing, 11, 11

updating, 11

system partitioning, 15

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 CUBE, 18

ALTER ANY CUBE DIMENSION, 18

ALTER ANY DIMENSION, 18

ALTER ANY INDEX, 18

ALTER ANY INDEXTYPE, 18

ALTER ANY MATERIALIZED VIEW, 18

ALTER ANY MINING MODEL, 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

BECOME USER, 18

CHANGE NOTIFICATION, 18

COMMENT ANY MINING MODEL, 18

COMMENT ANY TABLE, 18

CREATE ANY CLUSTER, 18

CREATE ANY CONTEXT, 18

CREATE ANY CUBE, 18

CREATE ANY CUBE BUILD PROCESS, 18

CREATE ANY CUBE DIMENSION, 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 MEASURE FOLDER, 18

CREATE ANY MINING MODEL, 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 CUBE, 18

CREATE CUBE BUILD PROCESS, 18

CREATE CUBE DIMENSION, 18

CREATE DATABASE LINK, 18

CREATE DIMENSION, 18

CREATE EXTERNAL JOB, 18

CREATE INDEXTYPE, 18

CREATE JOB, 18

CREATE LIBRARY, 18

CREATE MATERIALIZED VIEW, 18

CREATE MEASURE FOLDER, 18

CREATE MINING MODEL, 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 CUBE DIMENSION, 18

DELETE ANY MEASURE FOLDER, 18

DELETE ANY TABLE, 18

DROP ANY CLUSTER, 18

DROP ANY CONTEXT, 18

DROP ANY CUBE, 18

DROP ANY CUBE BUILD PROCESS, 18

DROP ANY CUBE DIMENSION, 18

DROP ANY DIMENSION, 18

DROP ANY DIRECTORY, 18

DROP ANY INDEX, 18

DROP ANY INDEXTYPE, 18

DROP ANY LIBRARY, 18

DROP ANY MATERIALIZED VIEW, 18

DROP ANY MEASURE FOLDER, 18

DROP ANY MINING MODEL, 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

FLASHBACK ARCHIVE ADMINISTER, 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, 16, 18

to a role, 18

to a user, 18

to PUBLIC, 18

INSERT ANY CUBE DIMENSION, 18

INSERT ANY MEASURE FOLDER, 18

INSERT ANY TABLE, 18

list of, 13, 18

LOCK ANY TABLE, 18

MANAGE SCHEDULER, 18

MANAGE TABLESPACE, 18

MERGE ANY VIEW, 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 CUBE, 18

SELECT ANY CUBE DIMENSION, 18

SELECT ANY DICTIONARY, 18

SELECT ANY MINING MODEL, 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 CUBE, 18

UPDATE ANY CUBE BUILD PROCESS, 18

UPDATE ANY CUBE DIMENSION, 18

UPDATE ANY TABLE, 18

SYSTEM tablespace

locally managed, 14

SYSTEM user

assigning password for, 14

SYSTIMESTAMP function, 5.1.5

T

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, 15

table REF constraints, 8

of CREATE TABLE, 15

tables

adding rows to, 18

aliases, 2.9.5

in CREATE INDEX, 14

in DELETE, 17

allocating extents for, 12

assigning to a cluster, 15

changing degree of parallelism on, 12

changing existing values in, 19

collecting statistics on, 13

comments on, 13

compression of, 12, 15

creating, 15

multiple, 16

creating comments about, 13

data stored outside database, 15

deallocating unused space from, 12

default physical attributes

changing, 12

degree of parallelism

specifying, 15

disassociating statistics types from, 18

dropping

along with cluster, 17

along with owner, 18

indexes of, 18

partitions of, 18

enabling tracking, 15

external, 15

creating, 15

restrictions on, 15

externally organized, 15

flashing back to an earlier version, 18

granting

system privileges for, 18

heap organized, 15

index-organized, 15

overflow segment for, 15

space in index block, 15

inserting rows with a subquery, 15

inserting using the direct-path method, 18

joining in a query, 19

LOB storage of, 8

locking, 18

logging

insert operations, 12

table creation, 15

migrated and chained rows in, 13

moving, 12

moving to a new segment, 12

moving, index-organized, 12

nested

creating, 17

storage characteristics, 15

object

creating, 15

querying, 15

of XMLType, creating, 15

organization, defining, 15

parallel creation of, 15

parallelism

setting default degree, 15

partition attributes of, 12

partitioning, 2.9.4, 15, 15

allowing rows to move between partitions, 12

default attributes of, 12

physical attributes

changing, 12

purging from the recycle bin, 18

read-only mode, 12

read/write mode, 12

reference-partitioned, 12, 12, 15

relational

creating, 15

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, 15

SQL examples, 15

storage attributes

defining, 15

storage characteristics

defining, 8

storage properties, 15

storage properties of, 15

subpartition attributes of, 12

synonyms for, 15

tablespace for

defining, 15, 15

temporary

duration of data, 15

session-specific, 15

transaction specific, 15

unclustering, 17

updating through views, 17

validating structure, 13

XMLType, querying, 15

TABLESPACE clause

of ALTER INDEX ... REBUILD, 10.2

of CREATE CLUSTER, 14

of CREATE INDEX, 14

of CREATE MATERIALIZED VIEW, 16

of CREATE MATERIALIZED VIEW LOG, 16

of CREATE TABLE, 15

tablespaces, 12

allocating space for users, 17

allowing write operations on, 12

automatic segment-space management, 15

backing up datafiles, 12

bigfile, 15

database default, 14

default temporary, 14

resizing, 12

undo, 14

bringing online, 12, 15

coalescing free extents, 12

converting

from permanent to temporary, 12

from temporary to permanent, 12

creating, 15

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

encrypting, 8, 15

ending online backup, 12

extent size, 15

granting system privileges for, 18

in FLASHBACK mode, 12, 15

in FORCE LOGGING mode, 12, 15

locally managed, 8

altering, 12

logging attribute, 12, 15

managing extents of, 15

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, 15

database default, 14

default temporary, 14

undo, 14

specifying

datafiles for, 15

for a table, 15

for a user, 17

for index rebuild, 12

taking offline, 12, 15

tempfiles

adding, 12

temporary

shrinking, 12

specifying for a user, 13, 17

temporary, creating, 15

temporary, defining for the database, 14

undo

altering, 12

creating, 14, 15

dropping, 18

TAN function, 5.1.5

TANH function, 5.1.5

TEMPFILE clause

of ALTER DATABASE, 10.2, 10.2

tempfiles

bringing online, 10.2

defining for a tablespace, 15, 15, 15

defining for the database, 14

disabling autoextend, 10.2

dropping, 10.2, 12

enabling autoextend, 8, 10.2

extending automatically, 8

renaming, 10.2

resizing, 10.2

reusing, 8

shrinking, 12

size of, 8

specifying, 8, 8

taking offline, 10.2

TEMPORARY clause

of ALTER TABLESPACE, 12

of CREATE TABLESPACE, 15

temporary tables

creating, 15, 15

session-specific, 15

transaction-specific, 15

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, 15

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, 7.6.1

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

conversion to database character set, 2.3.1

TH datetime format element suffix, 2.4.2.5

throughput

optimizing, 2.6.4.1

THSP datetime format element suffix, 2.4.2.5

TIME datatype

DB2, 2.1.3, 2.1.3

SQL/DS, 2.1.3, 2.1.3

time format models

short, 2.4.1.1, 2.4.2.1.2

time zone

determining for session, 5.1.5

formatting, 2.4.2.1.2

setting for the database, 14

time zones

converting data to particular, 6.7

TIME_ZONE session parameter, 11

timestamp

converting to local time zone, 6.7

TIMESTAMP datatype, 2.1.1.11

DB2, 2.1.3, 2.1.3

SQL/DS, 2.1.3, 2.1.3

TIMESTAMP WITH LOCAL TIME ZONE datatype, 2.1.1.13

TIMESTAMP WITH TIME ZONE datatype, 2.1.1.12

TIMESTAMP_TO_SCN function, 5.1.5

TO SAVEPOINT clause

of ROLLBACK, 18

TO_BINARY_DOUBLE function, 5.1.5

TO_BINARY_FLOAT function, 5.1.5

TO_CHAR

datetime conversion function, 5.1.5

number conversion function, 5.1.5

TO_CHAR (character) function, 5.1.5

TO_CHAR function, 2.4.1, 2.4.2, 2.4.3

TO_CLOB function, 5.1.5

TO_DATE function, 2.4.2, 2.4.2.4, 2.4.3, 5.1.5

TO_DSINTERVAL function, 5.1.5

TO_LOB function, 5.1.5

TO_MULTI_BYTE function, 5.1.5

TO_NCHAR (character) function, 5.1.5

TO_NCHAR (datetime) function, 5.1.5

TO_NCHAR (number) function, 5.1.5

TO_NCLOB function, 5.1.5

TO_NUMBER function, 2.4.1, 5.1.5

TO_SINGLE_BYTE function, 5.1.5

TO_TIMESTAMP function, 5.1.5

TO_TIMESTAMP_TZ function

SQL functions

TO_TIMESTAMP_TZ, 5.1.5

TO_YMINTERVAL function, 5.1.5

top-N reporting, 3.9, 5.1.5, 5.1.5, 5.1.5

tracking

enabling for a table, 12, 15

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

TRANSLATE ... USING function, 5.1.5

TRANSLATE function, 5.1.5

transparent data encryption, 15

master key, 11

TREAT function, 5.1.5

trigger body

defining, 15

triggers

AFTER, 15

BEFORE, 15

compiling, 13, 13

compound, 15

creating, 15

creating enabled or disabled, 15

database

altering, 13

dropping, 18, 18

disabling, 12, 13, 15

enabling, 12, 13, 13, 15

executing

with a PL/SQL block, 15

following other triggers, 15

granting

system privileges for, 18

INSTEAD OF, 15

dropping, 17

on database events, 15

on DDL events, 15

on DML operations, 15, 15

on views, 15

preceding other triggers, 15

re-creating, 15

removing from the database, 18

renaming, 13

restrictions on, 15

row values

old and new, 15

row, specifying, 15

sequential, 15

SQL examples, 15

statement, 15

TRIM function, 5.1.5

TRUNC function

date function, 5.1.5

format models, 5.1.5

number function, 5.1.5

TRUNCATE PARTITION clause

of ALTER TABLE, 12

TRUNCATE SUBPARTITION clause

of ALTER TABLE, 12

TRUNCATE_CLUSTER statement, 19

TRUNCATE_TABLE statement, 19

TRUST attribute

of PRAGMA RESTRICT_REFERENCES, 17

type constructor expressions, 6.14

type methods

return type of, 17

types. See object types or datatypes

TZ_OFFSET function, 5.1.5

U

UID function, 5.1.5

unary operators, 4.1.1

UNDER ANY TYPE system privilege, 18

UNDER ANY VIEW system privilege, 18

UNDER clause

of CREATE VIEW, 17

UNDER object privilege

on a type, 18

on a view, 18

UNDER_PATH condition, 7.10.2

undo

rollback, 11, 14

system managed, 11, 14

UNDO tablespace clause

of CREATE DATABASE, 14

of CREATE TABLESPACE, 15

undo tablespaces

creating, 14, 15

dropping, 18

modifying, 12

preserving unexpired data, 12, 15

UNDO_RETENTION initialization parameter

setting with ALTER SYSTEM, 18

UNIFORM clause

of CREATE TABLESPACE, 15

UNION ALL set operator, 4.5, 19

UNION set operator, 4.5, 19

UNIQUE clause

of CREATE INDEX, 14

of CREATE TABLE, 15

of SELECT, 19

unique constraints

conditional, 14

enabling, 15

index on, 15

unique elements of, 5.1.5

unique indexes, 14

unique queries, 19

UNISTR function, 5.1.5

universal rowids. See urowids

UNLIMITED TABLESPACE system privilege, 18

UNNEST hint, 2.6.4.64

unnesting collections, 19

examples, 19

unnesting subqueries, 9.8

unpivot operations, 19

examples, 19

syntax, 19

UNQUIESCE clause

of ALTER SYSTEM, 11

UNRECOVERABLE, 10.2, 15

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, 5.1.5

VALUES clause

of CREATE INDEX, 14

of INSERT, 18

VALUES LESS THAN clause

of CREATE TABLE, 15

VAR_POP function, 5.1.5

VAR_SAMP function, 5.1.5

VARCHAR datatype, 2.1.1.5

VARCHAR2 datatype, 2.1.1.4

converting to NUMBER, 2.4.1

VARGRAPHIC datatype

DB2, 2.1.3, 2.1.3

SQL/DS, 2.1.3, 2.1.3

VARIANCE function, 5.1.5

VARRAY clause

of ALTER TABLE, 12, 12

VARRAY column properties

of ALTER TABLE, 12, 12, 12

of CREATE MATERIALIZED VIEW, 16, 16

of CREATE TABLE, 15, 15

varrays, 2.1.4.3

changing returned value, 12

compared with nested tables, 2.2.5

comparison rules, 2.2.5

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, 15

storing out of line, 2.1.4.3

varying arrays. See varrays

view constraints, 8, 17

and materialized views, 8

dropping, 18

modifying, 13

views

base tables

adding rows, 18

changing

definition, 18

values in base tables, 19

creating

before base tables, 17

comments about, 13

multiple, 16

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, 15

updatable, 17

with joins

and key-preserved tables, 17

with joins, making updatable, 17

XMLType, 17

XMLType, creating, 17

XMLType, querying, 17

virtual columns

adding to a table, 12

creating, 15

modifying, 12

VSIZE function, 5.1.5

W

WHEN clause

of CREATE TRIGGER, 15

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, 5.1.5

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, 16

WITH OBJECT ID clause

of CREATE MATERIALIZED VIEW LOG, 16

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 ... REFRESH, 16

of CREATE MATERIALIZED VIEW LOG, 16

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 ... REFRESH, 16

of CREATE MATERIALIZED VIEW LOG, 16

WITH SEQUENCE clause

of CREATE MATERIALIZED VIEW LOG, 16

WNDS attribute

of PRAGMA RESTRICT_REFERENCES, 17

WNPS attribute

of PRAGMA RESTRICT_REFERENCES, 17

WRITE clause

of COMMIT, 13

WRITE object privilege

on a directory, 18

X

XML

examples, E.2

XML conditions, 7.10

XML data

storage of, 15

XML database repository

SQL access to, 7.10.1, 7.10.2

XML documents

producing from XML fragments, 5.1.5

retrieving from the database, 5.1.5

XML format models, 2.4.5

XML fragments, 5.1.5

XML functions, 5.1.1.12

XMLAGG function, 5.1.5

XMLCAST function, 5.1.5

XMLCDATA function, 5.1.5

XMLCOMMENT function, 5.1.5

XMLCONCAT function, 5.1.5

XMLDATA pseudocolumn, 3.10

XMLDiff function, 5.1.5

XMLExists function, 5.1.5

XMLGenFormatType object, 2.4.5

XMLIndex

creating, 14

modifying, 10.2

XMLPARSE function, 5.1.5

XMLPI function, 5.1.5

XMLQUERY function, 5.1.5

XMLROOT function, 5.1.5

XMLSchemas

adding to a table, 12, 15

removing from a table, 12

single and multiple, 15

XMLSERIALIZE function, 5.1.5

XMLTABLE function, 5.1.5

XMLType columns

properties of, 12, 15

storage of, 15, 15

storing in binary XML format, 15

XMLType storage clause

of CREATE TABLE, 15

XMLType tables

creating, 15, 15

creating index on, 14

XMLType views, 17

querying, 17

Z

CREATE PACKAGE BODY statement, 16, 18