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

ACTIVE_INSTANCE_COUNT initialization parameter

setting with ALTER SYSTEM, 11

AD datetime format element, 2.4.2.2, 2.4.2.2

ADD clause

of ALTER DIMENSION, 10.2

of ALTER INDEXTYPE, 10.2

of ALTER TABLE, 12

of ALTER VIEW, 13

ADD DATAFILE clause

of ALTER TABLESPACE, 12

ADD LOGFILE clause

of ALTER DATABASE, 10.2

ADD LOGFILE GROUP clause

of ALTER DATABASE, 10.2

ADD LOGFILE MEMBER clause

of ALTER DATABASE, 10.2, 10.2

ADD LOGFILE THREAD clause

of ALTER DATABASE, 10.2

ADD OVERFLOW clause

of ALTER TABLE, 12

ADD PARTITION clause

of ALTER TABLE, 12, 12, 12

ADD PRIMARY KEY clause

of ALTER MATERIALIZED VIEW LOG, 11

ADD ROWID clause

of ALTER MATERIALIZED VIEW, 11

of ALTER MATERIALIZED VIEW LOG, 11

ADD SUPPLEMENTAL LOG DATA clause

of ALTER DATABASE, 10.2

ADD SUPPLEMENTAL LOG GROUP clause

of ALTER TABLE, 12

ADD TEMPFILE clause

of ALTER TABLESPACE, 12

ADD VALUES clause

of ALTER TABLE ... MODIFY PARTITION, 12

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

AFTER triggers, 16

AGENT clause

of CREATE LIBRARY, 15

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

ALTER ANY INDEX system privilege, 18

ALTER ANY INDEXTYPE system privilege, 18

ALTER ANY MATERIALIZED VIEW system privilege, 18

ALTER ANY OPERATOR system privilege, 18

ALTER ANY OUTLINE system privilege, 18

ALTER ANY PROCEDURE system privilege, 18

ALTER ANY ROLE system privilege, 18

ALTER ANY SEQUENCE system privilege, 18

ALTER ANY SQL PROFILE system privilege, 18

ALTER ANY TABLE system privilege, 18

ALTER ANY TRIGGER system privilege, 18

ALTER ANY TYPE system privilege, 18

ALTER CLUSTER statement, 10.2

ALTER DATABASE statement, 10.2

ALTER DATABASE system privilege, 18

ALTER DIMENSION statement, 10.2

ALTER DISKGROUP statement, 10.2

ALTER FUNCTION statement, 10.2

ALTER INDEX statement, 10.2

ALTER INDEXTYPE statement, 10.2

ALTER JAVA CLASS statement, 10.2

ALTER JAVA SOURCE statement, 10.2

ALTER MATERIALIZED VIEW LOG statement, 11

ALTER MATERIALIZED VIEW statement, 11

ALTER object privilege, 18

on a sequence, 18

on a table, 18

ALTER OPERATOR statement, 11

ALTER OUTLINE statement, 11

ALTER PACKAGE statement, 11

ALTER PROCEDURE statement, 11

ALTER PROFILE statement, 11

ALTER PROFILE system privilege, 18

ALTER RESOURCE COST statement, 11

ALTER RESOURCE COST system privilege, 18

ALTER ROLE statement, 11

ALTER ROLLBACK SEGMENT statement, 11

ALTER ROLLBACK SEGMENT system privilege, 18

ALTER SEQUENCE statement, 11

ALTER SESSION statement, 11

ALTER SESSION system privilege, 18

ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG

ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW

ALTER statements

triggers on, 16

ALTER SYSTEM statement, 11

ALTER SYSTEM system privilege, 18

ALTER TABLE statement, 12

ALTER TABLESPACE statement, 12

ALTER TABLESPACE system privilege, 18

ALTER TRIGGER statement, 13

ALTER TYPE statement, 13

ALTER USER statement, 13

ALTER USER system privilege, 18

ALTER VIEW statement, 13

alter_external_table_clause

of ALTER TABLE, 12

AM datetime format element, 2.4.2.2, 2.4.2.2

American National Standards Institute (ANSI), B

datatypes, 2.1.2

conversion to Oracle datatypes, 2.1.2

standards, 1.2, 1.2, B.1

supported datatypes, 2.1

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

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_TM_PROCESSES initialization parameter

setting with ALTER SYSTEM, 11

AQ_USER_ROLE role, 18

ARCHIVE LOG clause

of ALTER SYSTEM, 11

archive mode

specifying, 14

ARCHIVE_LAG_TARGET initialization parameter

setting with ALTER SYSTEM, 11

archived redo logs

location, 10.2

ARCHIVELOG clause

of ALTER DATABASE, 10.2, 10.2

of CREATE CONTROLFILE, 14

of CREATE DATABASE, 14

arguments

of operators, 4

arithmetic

operators, 4.2

with DATE values, 2.1.1.15

AS clause

of CREATE JAVA, 14

AS EXTERNAL clause

of CREATE FUNCTION, 15

of CREATE TYPE BODY, 17

AS OBJECT clause

of CREATE TYPE, 17

AS subquery clause

of CREATE MATERIALIZED VIEW, 15

of CREATE TABLE, 16

of CREATE VIEW, 17

AS TABLE clause

of CREATE TYPE, 17

AS VARRAY clause

of CREATE TYPE, 17

ASC clause

of CREATE INDEX, 14

ASCII

character set, 2.2.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, 11, 14

ASM_DISKSTRING initialization parameter

setting with ALTER SYSTEM, 11, 14

ASM_POWER_LIMIT initialization parameter

setting with ALTER SYSTEM, 11

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

of dimensions, defining, 14

of user-defined types

mapping to Java fields, 17

AUDIT ANY system privilege, 18

AUDIT SYSTEM system privilege, 18

AUDIT_FILE_DEST initialization parameter

setting with ALTER SYSTEM, 11

AUDIT_SYS_OPERATIONS initialization parameter

setting with ALTER SYSTEM, 11

AUDIT_SYSLOG_LEVEL initialization parameter

setting with ALTER SYSTEM, 11

AUDIT_TRAIL initialization parameter

setting with ALTER SYSTEM, 11

auditing

options

for SQL statements, 13

policies

value-based, 13

SQL statements, 13

by a proxy, 13

by a user, 13

SQL statements, on a directory, 13

SQL statements, on a schema, 13

SQL statements, stopping, 18

system privileges, 13

AUTHENTICATED BY clause

of CREATE DATABASE LINK, 14

AUTHENTICATED clause

of ALTER USER, 13

AUTHENTICATION REQUIRED clause

of ALTER USER, 13

AUTHID CURRENT_USER clause

of ALTER JAVA, 10.2

of CREATE FUNCTION, 14, 14

of CREATE JAVA, 14, 14

of CREATE PACKAGE, 15

of CREATE PROCEDURE, 15

of CREATE TYPE, 13, 17

AUTHID DEFINER clause

of ALTER JAVA, 10.2

of CREATE FUNCTION, 14, 14

of CREATE JAVA, 14, 14

of CREATE PACKAGE, 15

of CREATE PROCEDURE, 15

of CREATE TYPE, 13, 17

AUTOALLOCATE clause

of CREATE TABLESPACE, 16

AUTOEXTEND clause

of ALTER DATABASE, 10.2

of CREATE DATABASE, 14

automatic segment-space management, 16

automatic undo mode, 11, 14

AVG function, 5.1.5

B

BACKGROUND_CORE_DUMP initialization parameter

setting with ALTER SYSTEM, 11

BACKGROUND_DUMP_DEST initialization parameter

setting with ALTER SYSTEM, 11

BACKUP ANY TABLE system privilege, 18

BACKUP CONTROLFILE clause

of ALTER DATABASE, 10.2, 10.2

BACKUP_TAPE_IO_SLAVES initialization parameter

setting with ALTER SYSTEM, 11

backups

incremental

and block change tracking, 10.2

BC datetime format element, 2.4.2.2, 2.4.2.2

BEFORE clause

of CREATE TRIGGER, 16

BEFORE triggers, 16

BEGIN BACKUP clause

of ALTER DATABASE, 10.2

of ALTER TABLESPACE, 12

beginning backup of, 10.2

BFILE

datatype, 2.1.1.19

locators, 2.1.1.19

BFILENAME function, 5.1.5

BIN_TO_NUM function, 5.1.5

binary large objects. See BLOB

binary operators, 4.1.1

BINDING clause

of CREATE OPERATOR, 15

bindings

adding to an operator, 11

dropping from an operator, 11

bit vectors

converting to numbers, 5.1.5

BITAND function, 5.1.5

BITMAP clause

of CREATE INDEX, 14

bitmap indexes, 14

creating join indexes, 14

BITMAP_MERGE_AREA_SIZE initialization parameter

setting with ALTER SYSTEM, 11

blank padding

specifying in format models, 2.4.3

suppressing, 2.4.3

BLANK_TRIMMING initialization parameter

setting with ALTER SYSTEM, 11

BLOB datatype, 2.1.1.20

transactional support, 2.1.1.20

BLOCKSIZE clause

of CREATE TABLESPACE, 16

BODY clause

of ALTER PACKAGE, 11

bottom-N reporting, 5.1.5, 5.1.5, 5.1.5

buffer cache

flushing, 11

BUFFER_POOL parameter

of STORAGE clause, 8

BUILD DEFERRED clause

of CREATE MATERIALIZED VIEW, 15

BUILD IMMEDIATE clause

of CREATE MATERIALIZED VIEW, 15

BY ACCESS clause

of AUDIT, 13

BY proxy clause

of AUDIT, 13

BY SESSION clause

of AUDIT, 13

BY user clause

of AUDIT, 13

BYTE character semantics, 2.1.1.1, 2.1.1.3

BYTE length semantics, 12

C

C clause

of CREATE TYPE, 17

of CREATE TYPE BODY, 17

C method

mapping to an object type, 17

CACHE clause

of ALTER MATERIALIZED VIEW, 11

of ALTER MATERIALIZED VIEW LOG, 11

of ALTER TABLE, 16

of CREATE CLUSTER, 14

of CREATE MATERIALIZED VIEW, 15

of CREATE MATERIALIZED VIEW LOG, 15

CACHE hint, 2.6.4.3

CACHE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE, 11

of CREATE SEQUENCE, 15

CACHE READS clause

of ALTER TABLE, 12

of CREATE TABLE, 16

cached cursors

execution plan for, 18

CALL clause

of CREATE TRIGGER, 16

CALL procedure statement

of CREATE TRIGGER, 16

call spec. See call specifications

call specifications

in procedures, 15

of CREATE PROCEDURE, 15

of CREATE TYPE, 17

of CREATE TYPE BODY, 17

CALL statement, 13

calls

limiting CPU time for, 15

limiting data blocks read, 15

CARDINALITY function, 5.1.5

Cartesian products, 9.6.4

CASCADE clause

of CREATE TABLE, 16

of DROP PROFILE, 17

of DROP USER, 18

CASCADE CONSTRAINTS clause

of DROP CLUSTER, 17

of DROP TABLE, 18

of DROP TABLESPACE, 18

of DROP VIEW, 18

of REVOKE, 18, 18

CASE expressions, 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.8

zero-length, 2.1.1.1

CHARTOROWID function, 5.1.5

CHECK clause

of constraints, 8

of CREATE TABLE, 16

check constraints, 8

CHECK DATAFILES clause

of ALTER SYSTEM, 11

CHECKPOINT clause

of ALTER SYSTEM, 11

checkpoints

forcing, 11

CHR function, 5.1.5

CHUNK clause

of ALTER TABLE, 12

of CREATE TABLE, 16

CIRCUITS initialization parameter

setting with ALTER SYSTEM, 11

CLEAR LOGFILE clause

of ALTER DATABASE, 10.2, 10.2

CLOB datatype, 2.1.1.21

transactional support, 2.1.1.21

clone databases

mounting, 10.2

CLOSE DATABASE LINK clause

of ALTER SESSION, 11

CLUSTER clause

of ANALYZE, 13

of CREATE INDEX, 14

of CREATE TABLE, 16

of TRUNCATE, 19

CLUSTER hint, 2.6.4.4

CLUSTER_DATABASE initialization parameter

setting with ALTER SYSTEM, 11

CLUSTER_DATABASE_INSTANCES initialization parameter

setting with ALTER SYSTEM, 11

CLUSTER_ID function, 5.1.5

CLUSTER_INTERCONNECTS initialization parameter

setting with ALTER SYSTEM, 11

CLUSTER_PROBABILITY function, 5.1.5

CLUSTER_SET function, 5.1.5

clusters

assigning tables to, 16

caching retrieved blocks, 14

cluster indexes, 14

collecting statistics on, 13

creating, 14, 14

deallocating unused extents, 10.2

degree of parallelism

changing, 10.2, 10.2

when creating, 14

dropping tables, 17

extents, allocating, 10.2, 10.2

granting system privileges for, 18

hash, 14

single-table, 14

sorted, 14, 16

indexed, 14

key values

allocating space for, 14

modifying space for, 10.2

migrated and chained rows in, 13, 13

modifying, 10.2

physical attributes

changing, 10.2

specifying, 14

releasing unused space, 10.2

removing from the database, 17

SQL examples, 17

storage attributes

changing, 10.2

storage characteristics, changing, 10.2

tablespace in which created, 14

validating structure, 13

COALESCE clause

for partitions, 12

of ALTER INDEX, 10.2

of ALTER TABLE, 12, 12, 12

of ALTER TABLESPACE, 12

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

collections

inserting rows into, 18

modifying, 12

modifying retrieval method, 12

nested tables, 2.1.3.4

testing for empty, 7.6.2

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

unnesting, 19

examples, 19

varrays, 2.1.3.3

collection-typed values

converting to datatypes, 5.1.5

column REF constraints, 8

of CREATE TABLE, 16

COLUMN_VALUE pseudocolumn, 3.4

columns

adding, 12

aliases for, 9.2

altering storage, 12

associating statistics with, 13

basing an index on, 14

collecting statistics on, 13

comments on, 13

creating comments about, 13

defining, 16

dropping from a table, 12

LOB

storage attributes, 12

maximum number of, 16

modifying existing, 12

parent-child relationships between, 14

properties, altering, 12, 12

qualifying names of, 9.2

REF

describing, 8

renaming, 12

restricting values for, 8

specifying as primary key, 8

specifying constraints on, 16

specifying default values, 16

storage properties, 16

substitutable, identifying type, 5.1.5

COLUMNS clause

of ASSOCIATE STATISTICS, 13, 13

COMMENT ANY TABLE system privilege, 18

COMMENT clause

of COMMIT, 13

COMMENT statement, 13

comments, 2.6

adding to objects, 13

associating with a transaction, 13

dropping from objects, 13

in SQL statements, 2.6.1

on indextypes, 13

on operators, 13

on schema objects, 2.6.2

on table columns, 13

on tables, 13

removing from the data dictionary, 13

specifying, 2.6.1

viewing, 13

commit

asynchronous, 13

automatic, 13

COMMIT IN PROCEDURE clause

of ALTER SESSION, 11

COMMIT statement, 13

COMMIT TO SWITCHOVER clause

of ALTER DATABASE, 10.2

COMMIT_POINT_STRENGTH initialization parameter

setting with ALTER SYSTEM, 11

COMMIT_WRITE initialization parameter

setting with ALTER SYSTEM, 11

comparison conditions, 7.2

comparison functions

MAP, 17, 17

ORDER, 17, 17

comparison semantics

of character strings, 2.2.3

COMPATIBLE initialization parameter

setting with ALTER SYSTEM, 11

COMPILE clause

of ALTER DIMENSION, 10.2

of ALTER FUNCTION, 10.2

of ALTER JAVA SOURCE, 10.2

of ALTER MATERIALIZED VIEW, 11

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

when creating a table, 16, 16

composite primary keys, 8

COMPOSITE_LIMIT parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 15

compound conditions, 7.11

compound expressions, 6.3

COMPRESS clause

of ALTER INDEX ... REBUILD, 10.2

of CREATE TABLE, 16

compression

of index keys, 10.2

COMPUTE STATISTICS clause

of ALTER INDEX, 10.2

of ANALYZE, 13

of CREATE INDEX, 14

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

for a table, 16

on a column, 16

disabling, 16

cascading, 16

disabling after table creation, 12

disabling during table creation, 16

dropping, 12, 12, 18

enabling, 16, 16

enabling after table creation, 12

enabling during table creation, 16

foreign key, 8

modifying existing, 12

on views

dropping, 13, 18

primary key, 8

attributes of index, 8

enabling, 16

referential integrity, 8

renaming, 12

restrictions, 8

setting state for a transaction, 19

storing rows in violation, 12

table REF, 8

unique

attributes of index, 8

enabling, 16

constructor methods

and object types, 17

constructors

defining for an object type, 17

user-defined, 17

CONTAINS condition, 4.1, 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 files

allowing reuse, 14, 14

backing up, 10.2

force logging mode, 14

re-creating, 14

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

setting with ALTER SYSTEM, 11

CONTROL_FILES initialization parameter

setting with ALTER SYSTEM, 11

controlfile clauses

of ALTER DATABASE, 10.2

CONTROLFILE REUSE clause

of CREATE DATABASE, 14

controlfiles

standby, creating, 10.2

conversion

functions, 5.1.1.7

rules, string to date, 2.4.4

CONVERT clause

of ALTER DATABASE, 10.2

CONVERT function, 5.1.5

CORE_DUMP_DEST initialization parameter

setting with ALTER SYSTEM, 11

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_COUNT initialization parameter

setting with ALTER SYSTEM, 11

CPU_PER_CALL parameter

of ALTER PROFILE, 11

of CREATE PROFILE, 15

CPU_PER_SESSION parameter

of ALTER PROFILE, 11

of ALTER RESOURCE COST, 11

of CREATE PROFILE, 15

CREATE ANY CLUSTER system privilege, 18

CREATE ANY CONTEXT system privilege, 18

CREATE ANY DIMENSION system privilege, 18

CREATE ANY DIRECTORY system privilege, 18

CREATE ANY INDEX system privilege, 18

CREATE ANY INDEXTYPE system privilege, 18

CREATE ANY JOB system privilege, 18

CREATE ANY LIBRARY system privilege, 18

CREATE ANY MATERIALIZED VIEW system privilege, 18

CREATE ANY OPERATOR system privilege, 18

CREATE ANY OUTLINE system privilege, 18

CREATE ANY PROCEDURE system privilege, 18

CREATE ANY SEQUENCE system privilege, 18

CREATE ANY SQL PROFILE system privilege, 18, 18

CREATE ANY SYNONYM system privilege, 18

CREATE ANY TABLE system privilege, 18

CREATE ANY TRIGGER system privilege, 18

CREATE ANY TYPE system privilege, 18

CREATE ANY VIEW system privilege, 18

CREATE CLUSTER statement, 14

CREATE CLUSTER system privilege, 18

CREATE CONTEXT statement, 14

CREATE CONTROLFILE statement, 14

CREATE DATABASE LINK statement, 14

CREATE DATABASE LINK system privilege, 18

CREATE DATABASE statement, 14

CREATE DATAFILE clause

of ALTER DATABASE, 10.2, 10.2

CREATE DIMENSION

system privilege, 18

CREATE DIMENSION statement, 14

CREATE DIRECTORY statement, 14

CREATE DISKGROUP statement, 14

CREATE EXTERNAL JOB system privilege, 18

CREATE FUNCTION statement, 14

CREATE INDEX

statement, 14

CREATE INDEXTYPE

statement, 14

CREATE INDEXTYPE system privilege, 18

CREATE JAVA statement, 14

CREATE JOB system privilege, 18

CREATE LIBRARY statement, 15

CREATE LIBRARY system privilege, 18

CREATE MATERIALIZED VIEW LOG statement, 15

CREATE MATERIALIZED VIEW statement, 15

CREATE MATERIALIZED VIEW system privilege, 18

CREATE OPERATOR statement, 15

CREATE OPERATOR system privilege, 18

CREATE OUTLINE statement, 15

CREATE PACKAGE statement, 15

CREATE PFILE statement, 15

CREATE PROCEDURE statement, 15

CREATE PROCEDURE system privilege, 18

CREATE PROFILE statement, 15

CREATE PROFILE system privilege, 18

CREATE PUBLIC DATABASE LINK system privilege, 18

CREATE PUBLIC SYNONYM system privilege, 18

CREATE RESTORE POINT statement, 15

CREATE ROLE statement, 15

CREATE ROLE system privilege, 18

CREATE ROLLBACK SEGMENT statement, 15

CREATE ROLLBACK SEGMENT system privilege, 18

CREATE SCHEMA statement, 15

CREATE SEQUENCE statement, 15

CREATE SEQUENCE system privilege, 18

CREATE SESSION system privilege, 18

CREATE SPFILE statement, 15

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 10.2, 10.2

CREATE statements

triggers on, 16

CREATE SYNONYM statement, 16

CREATE SYNONYM system privilege, 18

CREATE TABLE statement, 16

CREATE TABLE system privilege, 18

CREATE TABLESPACE statement, 16

CREATE TABLESPACE system privilege, 18

CREATE TRIGGER statement, 16

CREATE TRIGGER system privilege, 18

CREATE TYPE BODY statement, 17

CREATE TYPE statement, 17

CREATE TYPE system privilege, 18

CREATE USER statement, 17

CREATE USER system privilege, 18

CREATE VIEW statement, 17

CREATE VIEW system privilege, 18

CREATE_BITMAP_AREA_SIZE initialization parameter

setting with ALTER SYSTEM, 11

CREATE_STORED_OUTLINES initialization parameter, 11

setting with ALTER SYSTEM, 11

cross joins, 19

CUBE clause

of SELECT statements, 19

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

CURSOR expressions, 6.5

CURSOR_SHARING initialization parameter

setting with ALTER SYSTEM, 11

CURSOR_SHARING_EXACT hint, 2.6.4.5

CURSOR_SPACE_FOR_TIME initialization parameter

setting with ALTER SYSTEM, 11

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

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

independence, 16

integrity checking on input, 2.1.1.6

retrieving, 9.1

specifying as temporary, 16

undo

preserving, 12, 16

data conversion, 2.2.6

between character datatypes, 2.2.6.2

implicit

disadvantages, 2.2.6.1

implicit versus explicit, 2.2.6.1

when performed implicitly, 2.2.6.2, 2.2.6.3

when specified explicitly, 2.2.6.4

data definition language (DDL)

events and triggers, 16

statements, 10.1.1

and implicit commit, 10.1.1

causing recompilation, 10.1.1

PL/SQL support, 10.1.1

statements requiring exclusive access, 10.1.1

data dictionary

adding comments to, 13

data manipulation language (DML)

allowing during indexing, 10.2

operations

and triggers, 16

during index creation, 14

during index rebuild, 12

parallelizing, 16

restricting operations, 11

retrieving affected rows, 17, 18, 19

retrieving rows affected by, 17, 18, 19

statements, 10.1.2

PL/SQL support, 10.1.2

data mining functions, 5.1.1.11

data object number

in extended rowids, 2.1.1.24

database

flashing back, 18

returning to a past time, 18

database links, 9.10

closing, 11

creating, 2.9.3.1, 14

creating synonyms with, 16

current user, 14

granting system privileges for, 18

naming, 2.9.3.1.1

public, 14

dropping, 17

referring to, 2.9.3.2

removing from the database, 17

shared, 14

syntax, 2.9.3.1.1

username and password, 2.9.3.1.2

database objects

dropping, 18

nonschema, 2.7.2, 2.7.2

schema, 2.7.1

database triggers. See triggers

databases, 10.2

accounts

creating, 17

allowing changes to, 11

allowing generation of redo logs, 10.2

allowing reuse of control files, 14

allowing unlimited resources to users, 15

archive mode

specifying, 14

blocks

specifying size, 16

cancel-based recovery, 10.2

terminating, 10.2

change-based recovery, 10.2

changing characteristics, 14

changing global name, 10.2

changing name, 14, 14

character set, specifying, 14

character sets

specifying, 14

committing to standby status, 10.2

connect strings, 2.9.3.1.3

controlling, 10.2

controlling use, 10.2

converting from Oracle7 data dictionary, 10.2

create script for, 10.2

creating, 14

datafiles

modifying, 10.2

specifying, 14

designing media recovery, 10.2

dropping, 17

ending backup of, 10.2

erasing all data from, 14

events

and triggers, 16

auditing, 16

transparent logging of, 16

granting system privileges for, 18

in FLASHBACK mode, 10.2

in FORCE LOGGING mode, 10.2, 14, 14

instances of, 14

limiting resources for users, 15

log files

modifying, 10.2

specifying, 14

managed recovery, 10.2

modifying, 10.2

mounting, 10.2, 10.2, 14

moving a subset to a different database, 12

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

restricting users to read-only transactions, 10.2

resuming activity, 11

standby

adding log files, 10.2

suspending activity, 11

system user passwords, 14

tempfiles

modifying, 10.2

time zone

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

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

specifying for database, 14

system generated, 10.2

taking offline, 10.2, 10.2

datatypes, 2.1

"Any" types, 2.1.5

ANSI-supported, 2.1

associating statistics with, 13, 13

BFILE, 2.1.1.19

BLOB, 2.1.1.20

CHAR, 2.1.1.1

character, 2.1.1

CLOB, 2.1.1.21

comparison rules, 2.2

converting to collection-typed values, 5.1.5

converting to other datatypes, 5.1.5

DATE, 2.1.1.9

datetime, 2.1.1.8

interval, 2.1.1.8

INTERVAL DAY TO SECOND, 2.1.1.14

INTERVAL YEAR TO MONTH, 2.1.1.13

length semantics, 2.1.1.1, 2.1.1.3

LONG, 2.1.1.8

LONG RAW, 2.1.1.18

media types, 2.1.8

NCHAR, 2.1.1.2

NCLOB, 2.1.1.22

NUMBER, 2.1.1.6

NVARCHAR2, 2.1.1.3

Oracle-supplied types, 2.1.4

RAW, 2.1.1.18

ROWID, 2.1.1.22

SDO_TOPO_GEOMETRY, 2.1.7.2

spatial types, 2.1.7

TIMESTAMP, 2.1.1.10

TIMESTAMP WITH LOCAL TIME ZONE, 2.1.1.12

TIMESTAMP WITH TIME ZONE, 2.1.1.11

UROWID, 2.1.1.26

user-defined, 2.1.3

VARCHAR, 2.1.1.5

VARCHAR2, 2.1.1.4

XML types, 2.1.6

DATE columns

converting to datetime columns, 12

DATE datatype, 2.1.1.9

julian, 2.1.1.9.1

date format models, 2.4.2, 2.4.2.1.2

long, 2.4.2.1.2

punctuation in, 2.4.2.1.2

short, 2.4.2.1.2

text in, 2.4.2.1.2

date functions, 5.1.1.5

dates

arithmetic, 2.1.1.15

comparison rules, 2.2.2

datetime arithmetic, 2.1.1.15

boundary cases, 11

calculating daylight saving time, 2.1.1.16

datetime columns

creating from DATE columns, 12

datetime datatypes, 2.1.1.8

daylight saving time, 2.1.1.16

datetime expressions, 6.6

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

boundary cases, 2.1.1.16

going into or coming out of effect, 2.1.1.16

DB_BLOCK_CHECKING initialization parameter

setting with ALTER SYSTEM, 11, 11

DB_BLOCK_CHECKSUM initialization parameter

setting with ALTER SYSTEM, 11

DB_BLOCK_SIZE initialization parameter

setting with ALTER SYSTEM, 11

DB_CACHE_ADVICE initialization parameter

setting with ALTER SYSTEM, 11

DB_CACHE_SIZE initialization parameter

setting with ALTER SYSTEM, 11

DB_CREATE_FILE_DEST initialization parameter

setting with ALTER SYSTEM, 11

DB_CREATE_ONLINE_LOG_DEST_n initialization parameter

setting with ALTER SYSTEM, 11

DB_DOMAIN initialization parameter

setting with ALTER SYSTEM, 11

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter

setting with ALTER SYSTEM, 11

DB_FILE_NAME_CONVERT initialization parameter

setting with ALTER SYSTEM, 11

DB_FILES initialization parameter

setting with ALTER SYSTEM, 11

DB_FLASHBACK_RETENTION_TARGET initialization parameter

setting with ALTER SYSTEM, 11

DB_KEEP_CACHE_SIZE initialization parameter

setting with ALTER SYSTEM, 11

DB_NAME initialization parameter

setting with ALTER SYSTEM, 11

DB_nK_CACHE_SIZE initialization parameter

setting with ALTER SYSTEM, 11

DB_RECOVERY_FILE_DEST initialization parameter

setting with ALTER SYSTEM, 11

DB_RECOVERY_FILE_DEST_SIZE initialization parameter

setting with ALTER SYSTEM, 11

DB_RECYCLE_CACHE_SIZE initialization parameter

setting with ALTER SYSTEM, 11

DB_UNIQUE_NAME initialization parameter

setting with ALTER SYSTEM, 11

DB_WRITER_PROCESSES initialization parameter

setting with ALTER SYSTEM, 11

DB2 datatypes, 2.1.2

restrictions on, 2.1.2

DBA role, 18

DBA_2PC_PENDING data dictionary view, 11

DBA_COL_COMMENTS data dictionary view, 13

DBA_INDEXTYPE_COMMENTS data dictionary view, 13

DBA_MVIEW_COMMENTS data dictionary view, 13

DBA_OPERATOR_COMMENTS data dictionary view, 13

DBA_ROLLBACK_SEGS data dictionary view, 17

DBA_TAB_COMMENTS data dictionary view, 13

DBMS_OUTPUT package, 13

DBMS_ROWID package

and extended rowids, 2.1.1.24

DBMSSTDX.SQL script, 14, 15, 15, 15

and triggers, 16

DBTIMEZONE function, 5.1.5

DBWR_IO_SLAVES initialization parameter

setting with ALTER SYSTEM, 11

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

on a function, procedure, or package, 18

on a table, 18

on a view, 18

on an object type, 18

debugging

granting system privileges for, 18

decimal characters, 2.3.2.2

specifying, 2.4.1.1

DECODE function, 5.1.5

decoding functions, 5.1.1.13

DECOMPOSE function, 5.1.5

DEFAULT clause

of ALTER TABLE, 12

of CREATE TABLE, 16, 16

DEFAULT COST clause

of ASSOCIATE STATISTICS,