Index

of ALTER TABLESPACE, 7-167

ADD DATAFILE clause

ADD LOGFILE clause

of ALTER DATABASE, 7-9

ADD LOGFILE GROUP clause

of ALTER DATABASE, 7-18

ADD LOGFILE MEMBER clause

of ALTER DATABASE, 7-9, 7-18

ADD LOGFILE THREAD clause

of ALTER DATABASE, 7-18

ADD OVERFLOW clause

of ALTER TABLE, 7-143

ADD PARTITION, 7-148

ADD PARTITION clause

of ALTER TABLE, 7-147, 7-148

ADD PRIMARY KEY clause

of ALTER MATERIALIZED VIEW LOG, 7-56

ADD ROWID clause

of ALTER MATERIALIZED VIEW, 7-56

of ALTER MATERIALIZED VIEW LOG, 7-56

ADD TEMPFILE clause

of ALTER TABLESPACE, 7-167

ADD_MONTHS function, 4-6

ADMINISTER ANY TRIGGER system privilege, 7-501

ADVISE clause

for expressions in view query, 7-432

AFTER clause

of CREATE TRIGGER, 7-403

AFTER triggers, 7-403

aggregate functions, 4-5

aliases

for columns, 5-18

specifying in queries and subqueries, 7-547

ALL clause

of SELECT, 7-545

of SET CONSTRAINTS, 7-568

of SET ROLE, 7-571

ALL EXCEPT clause

of SET ROLE, 7-571

ALL operator, 3-6

ALL PRIVILEGES clause

of GRANT object_privileges, 7-506

of REVOKE schema_object_privileges, 7-533

of REVOKE schema_objects_privileges, 7-533

ALL PRIVILEGES shortcut

ALL shortcut

ALL_COL_COMMENTS view, 7-212

ALL_ROWS hint, 2-59

ALL_TAB_COMMENTS view, 7-212

ALLOCATE EXTENT clause

of ALTER CLUSTER, 7-3, 7-4

of ALTER INDEX, 7-30, 7-34

of ALTER TABLE, 7-139

ALTER ANY CLUSTER system privilege, 7-495

ALTER ANY DIMENSION system privilege, 7-496

ALTER ANY INDEX system privilege, 7-496

ALTER ANY MATERIALIZED VIEW system privilege, 7-497

ALTER ANY OUTLINE system privilege, 7-498

ALTER ANY PROCEDURE system privilege, 7-498

ALTER ANY ROLE system privilege, 7-498

ALTER ANY SEQUENCE system privilege, 7-499

ALTER ANY SNAPSHOT system privilege, 7-499

ALTER ANY TABLE system privilege, 7-500

ALTER ANY TRIGGER system privilege, 7-501

ALTER ANY TYPE system privilege, 7-501

ALTER CLUSTER statement, 7-2

ALTER DATABASE

statement, 7-6

ALTER DIMENSION statement, 7-24

ALTER FUNCTION statement, 7-27

ALTER INDEX statement, 7-29

ALTER JAVA CLASS statement, 7-43

ALTER JAVA SOURCE statement, 7-43

ALTER MATERIALIZED VIEW LOG statement, 7-54

ALTER MATERIALIZED VIEW statement, 7-45

ALTER object privilege, 7-508

ALTER OUTLINE statement, 7-58

ALTER PACKAGE statement, 7-59

ALTER PROCEDURE statement, 7-62

ALTER PROFILE

statement, 7-64

ALTER RESOURCE COST

statement, 7-68

ALTER ROLE statement, 7-71

ALTER ROLLBACK SEGMENT

statement, 7-73

ALTER SEQUENCE statement, 7-76

ALTER SESSION

statement, 7-78

ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG.

ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW.

ALTER statement

triggers on, 7-405

ALTER SYSTEM

statement, 7-95

ALTER TABLE statement, 7-113

ALTER TABLESPACE

statement, 7-164

ALTER TRIGGER statement, 7-171

ALTER TYPE statement, 7-173

ALTER USER

statement, 7-179

system privilege, 7-501

ALTER VIEW statement, 7-183

AM (A.M.) date format element, 2-41, 2-43

American National Standards Institute. See ANSI.

ANALYZE ANY system privilege, 7-502

ANALYZE CLUSTER statement, 7-185

ANALYZE INDEX statement, 7-185

ANALYZE TABLE statement, 7-185

ANCILLARY TO clause

of CREATE OPERATOR, 7-321

conversion to Oracle datatypes, 2-23

standards, xi, 1-2

supported datatypes, 2-8

ANY operator, 3-6

APPEND hint, 2-61

application servers

allowing to connect as a user, 7-181

applications

allowing to connect as a user, 7-181

securing, 7-243

validating, 7-243

AQ_ADMINISTRATOR_ROLE role, 7-503

AQ_TM_PROCESSES parameter

of ALTER SYSTEM, 7-100

AQ_USER_ROLE role, 7-503

ARCHIVE LOG clause

of ALTER SYSTEM, 7-96

archived redo log files

location of, 7-13

storage locations, 7-83

ARCHIVELOG clause

of ALTER DATABASE, 7-9, 7-17

of CREATE CONTROLFILE, 7-248

ARCHVIELOG clause

OF CREATE DATABASE, 7-252

arguments of operators, 3-1

arithmetic operators, 3-3

AS 'filespec' clause

of CREATE LIBRARY, 7-299

AS clause

of CREATE JAVA, 7-296

AS EXTERNAL clause

of CREATE FUNCTION, 7-271, 7-337

of CREATE TYPE BODY, 7-424

AS OBJECT clause

of CREATE TYPE, 7-414

AS subquery

of CREATE MATERIALIZED VIEW / SNAPSHOT, 7-301, 7-308

of CREATE TABLE, 7-385

of CREATE VIEW, 7-433

AS TABLE clause

of CREATE TYPE, 7-418

AS VARRAY clause

of CREATE TYPE, 7-417

ASC clause

of CREATE INDEX, 7-281

ascending indexes, 7-281

ASCII

character set, 2-29

function, 4-6

ASIN function, 4-7

ASSOCIATE STATISTICS statement, 7-194

ATAN function, 4-7

ATAN2 function, 4-8

ATTRIBUTE clause

of ALTER DIMENSION, 7-25

of CREATE DIMENSION, 7-262

attributes

adding to a dimension, 7-26

dropping from a dimension, 7-26

maximum number of in object type, 7-369

of dimensions, defining, 7-262

AUDIT (Schema Objects) statement, 7-205

AUDIT ANY system privilege, 7-502

AUDIT sql_statements statement, 7-197

AUDIT SYSTEM system privilege, 7-495

auditing

schema objects

stopping, 7-525

SQL statements, 7-200

SQL statements, stopping, 7-523

auditing options

for database objects, 7-200

for SQL statements, 7-202

AUTHENTICATED BY clause

of CREATE DATABASE LINK, 7-257

AUTHID CURRENT_USER clause

of ALTER JAVA, 7-44

of CREATE FUNCTION, 7-270

of CREATE JAVA, 7-295

of CREATE PACKAGE, 7-326

of CREATE PROCEDURE, 7-336

of CREATE TYPE, 7-415

AUTHID DEFINER clause

of ALTER JAVA, 7-44

of CREATE FUNCTION, 7-270

of CREATE JAVA, 7-295

of CREATE PACKAGE, 7-326

of CREATE PROCEDURE, 7-336

of CREATE TYPE, 7-415

AUTOEXTEND clause

for datafiles, 7-17

of ALTER DATABASE, 7-10

of ALTER TABLESPACE, 7-165, 7-167

of CREATE DATABASE, 7-250

of CREATE TABLESPACE, 7-394, 7-396

of CREATE TEMPORARY TABLESPACE, 7-399, 7-400

AVG function, 4-8

AY date format element, 2-41

B

BACKGROUND_DUMP_DEST parameter

BACKUP ANY TABLE system privilege, 7-500

BACKUP CONTROLFILE clause

of ALTER DATABASE, 7-9, 7-19

BACKUP_TAPE_IO_SLAVES parameter

BC (B.C.) date format element, 2-41, 2-43

BECOME USER system privilege, 7-502

BEFORE clause

of CREATE TRIGGER, 7-403

BEFORE triggers, 7-403

BEGIN BACKUP clause

of ALTER TABLESPACE, 7-168

BFILE

datatype, 2-20

locators, 2-20

BFILENAME function, 4-8

binary large objects. See BLOBs.

binary operators, 3-1

BINDING clause

of CREATE OPERATOR, 7-320, 7-321

BITMAP clause

of CREATE INDEX, 7-279

bitmapped indexes, 7-279

blank padding

specifying in format models, 2-46

suppressing, 2-46

BLOB

transactional support of, 2-21

BLOB datatype, 2-21

BODY clause

of ALTER PACKAGE, 7-60

BUFFER_POOL parameter

of STORAGE clause, 7-579

BUILD DEFERRED clause

BUILD IMMEDIATE clause

of AUDIT schema_objects, 7-206

BY ACCESS clause

of AUDIT (SQL statements), 7-199

BY proxy clause

of NOAUDIT sql_statements, 7-524

BY SESSION clause

of AUDIT schema_objects, 7-206

BY user clause

of NOAUDIT sql_statements, 7-524

C

C clause

of CREATE TYPE, 7-416

of CREATE TYPE BODY, 7-424

C method

mapping to an object type, 7-416

C number format element, 2-36

CACHE clause

of ALTER MATERIALIZED VIEW, 7-48

of ALTER MATERIALIZED VIEW LOG, 7-56

of ALTER SEQUENCE. See CREATE SEQUENCE., 7-76

of ALTER TABLE, 7-141

of CREATE CLUSTER, 7-240

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, 7-317

of CREATE PROCEDURE, 7-336

of CREATE SEQUENCE, 7-352

of CREATE TABLE, 7-384

CACHE hint, 2-62

CALL clause

of CREATE TRIGGER, 7-407

CALL procedure statement

of CREATE TRIGGER, 7-407

call spec

in procedures, 7-334

of CREATE FUNCTION, 7-271

of CREATE TYPE, 7-416

of CREATE TYPE BODY, 7-424

call specifications. See call spec.

CALL statement, 7-210

Cartesian products, 5-22

CASCADE clause

of CREATE TABLE, 7-384

of DROP PROFILE, 7-468

of DROP USER, 7-483

CASCADE CONSTRAINTS clause

of DROP CLUSTER, 7-447

of DROP TABLE, 7-476

of DROP TABLESPACE, 7-478

CC date format element, 2-41

CAST expressions, 5-7

CEIL function, 4-9

century

specifying, 2-42

CHANGE CATEGORY clause

of ALTER OUTLINE, 7-58

changes

making permanent, 7-214

changing default storage parameters, 7-168

CHAR datatype, 2-11

converting to VARCHAR2, 2-35

CHAR VARYING datatype, ANSI, 2-24

CHARACTER datatype

of CREATE CONTROLFILE, 7-248

DB2, 2-25

SQL/DS, 2-25

character functions, 4-3

character large objects. See CLOB datatype.

character literal. See text.

CHARACTER SET clause

OF CREATE DATABASE, 7-252

CHARACTER SET parameter

of ALTER DATABASE, 7-16

character sets

common, 2-29

multibyte characters, 2-67

specifying for database, 7-252

character strings

comparison rules, 2-28

exact matching of, 2-46

fixed-length, 2-11

national character set, 2-11

variable length, 2-12

variable-length, 2-15

zero-length, 2-11

CHARACTER VARYING datatype

single, comparison rules, 2-29

characters

CHARTOROWID function, 2-32, 4-9

CHECK clause

of constraint_clause, 7-224

of CREATE TABLE, 7-370

check constraints, 7-224

CHECK DATAFILES clause

of ALTER SYSTEM, 7-98

checkpoint

forcing, 7-98

CHECKPOINT clause

of ALTER SYSTEM, 7-98

CHOOSE hint, 2-59

CHR function, 4-10

CHUNK clause

of ALTER TABLE, 7-131

of CREATE TABLE, 7-376

clause

of CREATE TABLE, 7-383

CLEAR LOGFILE clause

of ALTER DATABASE, 7-9, 7-19

CLOB datatype, 2-21

transactional support of, 2-21

clone database

mounting, 7-11

CLOSE DATABASE LINK clause

CLUSTER clause

of CREATE INDEX, 7-279

changing column names, 7-3

of CREATE TABLE, 7-378

of TRUNCATE, 7-583

CLUSTER hint, 2-59

cluster indexes, 7-279

cluster key

changing the number of columns, 7-3

clusters

allocating extents for, 7-3

assigning tables to, 7-378

caching retrieved blocks, 7-240

collecting statistics on, 7-188

creating, 7-236, 7-237

data blocks allocated to, 7-238

deallocating unused extents, 7-3

degree of parallelism

changing, 7-3

when creating, 7-240

dropping tables of, 7-447

granting

migrated and chained rows in, 7-192

hash, 7-239

single-table, 7-239

indexed, 7-239

modifying, 7-2

physical attributes

changing, 7-2

specifying, 7-238

removing from the database, 7-446

space allocated for cluster key values, 7-238

SQL examples, 7-447

storage attributes

changing, 7-2

storage characteristics, 7-575

specifying, 7-238

tablespace

changing, 7-3

tablespace in which created, 7-239

validating structure of, 7-191

COALESCE clause

for partitions, 7-148

for subpartitions, 7-145

of ALTER INDEX, 7-39

of ALTER TABLESPACE, 7-169

COALESCE SUBPARTITION clause

of ALTER TABLE, 7-145

code examples

description of, xviii

collections

inserting rows into, 7-515

modifying, 7-135

nested tables, 2-27

treating as a table, 7-441, 7-515, 7-586

unnesting, 7-547

examples, 7-564

varrays, 2-26

column constraint, 7-217

column REF constraint, 7-218

of CREATE TABLE, 7-370

column constraints, 7-221

of CREATE TABLE, 7-369

column ref constraint

column REF constraints, 7-224

columns

COLUMNS clause

of ASSOCIATE STATISTICS, 7-194, 7-195

COMMENT ANY TABLE system privilege, 7-502

COMMENT clause

of COMMIT, 7-215

COMMENT statement, 7-212

comments, 2-56

adding to objects, 7-212

associating with a transaction, 7-215

dropping from objects, 7-212

how to specify, 2-57

in SQL statements, 2-56

on schema objects, 2-58

removing from the data dictionary, 7-212

viewing, 7-212

commit

automatic, 7-214

COMMIT IN PROCEDURE clause

of character strings, 2-28

COMMIT statement, 7-214

comparison functions

MAP, 7-417, 7-423

ORDER, 7-417, 7-423

comparison operators, 3-5

comparison semantics

blank-padded, 2-28

nonpadded, 2-28

COMPILE clause

of ALTER DIMENSION, 7-26

of ALTER FUNCTION, 7-27

of ALTER JAVA SOURCE, 7-44

of ALTER MATERIALIZED VIEW, 7-51

of ALTER PACKAGE, 7-60

of ALTER PROCEDURE, 7-63

of ALTER TRIGGER, 7-172

of ALTER TYPE, 7-174

of ALTER VIEW, 7-184

of CREATE JAVA, 7-294

compiler directives, 7-416

composite foreign keys, 7-222

composite partitioning clause

of CREATE TABLE, 7-364, 7-379

composite primary keys, 7-222

composite unique constraints, 7-221

COMPOSITE_LIMIT parameter

concatenation operator, 3-3

of CREATE PROFILE, 7-341

compound conditions, 5-17

compound expressions, 5-4

COMPRESS clause

of ALTER TABLE, 7-133

of CREATE INDEX, 7-282

of CREATE TABLE, 7-374

COMPRESS parameter

of ALTER INDEX, 7-31

COMPUTE STATISTICS clause

of ANALYZE, 7-188

of CREATE INDEX, 7-283

CONCAT function, 4-10

conditions

compound, 5-17

EXISTS, 5-17

group comparison, 5-15

in SQL syntax, 5-13

LIKE, 5-17

membership, 5-16

NULL, 5-17

range, 5-16

simple comparison, 5-15

CONNECT BY clause

of SELECT, 5-20, 7-548

CONNECT clause

of SELECT and subqueries, 7-543

CONNECT role, 7-503

CONNECT shortcut

of AUDIT sql_statements, 7-198

CONNECT TO clause

of CREATE DATABASE LINK, 7-256

CONNECT_TIME parameter

of ALTER RESOURCE COST, 7-69

of CREATE PROFILE, 7-341

constant values. See literals.

DISABLE, 7-383

CONSTRAINT clause

of constraint_clause, 7-221

constraint clause, 7-217

CONSTRAINT(S) parameter

of ALTER SESSION, 7-81

constraints

adding, 7-130

check, 7-224

checking at end of transaction, 7-226

checking at start of transaction, 7-226

checking at the end of each DML statement, 7-226

column REF, 7-224

composite unique, 7-221

deferrable, 7-226, 7-568

enforcing, 7-81

defining, 7-220, 7-366

on a column, 7-370

on a table, 7-370

disabling, 7-153, 7-227, 7-382

cascading, 7-384

dropping, 7-136, 7-478

enabling, 7-153, 7-227, 7-382, 7-383

foreign key, 7-223

modifying existing, 7-133

not null, 7-222

on columns, 7-221

primary key, 7-222

attributes of index, 7-227

enabling, 7-383

recording violations, 7-384

referential integrity, 7-222, 7-223

restrictions, 7-221

scope, 7-225

setting state for a transaction, 7-568

storing rows in violation, 7-228

table REF, 7-224

unique, 7-221

attributes of index, 7-227

composite, 7-221

enabling, 7-383

validating, 7-227

constructor methods

and object types, 7-413

context namespaces

removing from the database, 7-448

contexts

creating namespaces for, 7-243

granting

associating with package, 7-243

namespace

control file

backing up, 7-19

control files

allow reuse of, 7-246

allowing reuse of, 7-251

re-creating, 7-245

CONTROL_FILE_RECORD_KEEP_TIME parameter

OF CREATE DATABASE, 7-251

controlfile clauses

of ALTER DATABASE, 7-9

CONTROLFILE REUSE clause

conversion

functions

table of, 2-32

rules, string to date, 2-48

conversion functions

SQL functions

conversion, 4-4

CONVERT clause

of ALTER DATABASE, 7-11

CONVERT function, 4-11

correlated subqueries, 5-24

correlation names

for base tables of indexes, 7-279

CPU_PER_CALL parameter

of CREATE PROFILE, 7-340

CPU_PER_SESSION parameter

of ALTER RESOURCE COST, 7-69

of CREATE PROFILE, 7-340

CREATE ANY CLUSTER system privilege, 7-495

CREATE ANY CONTEXT system privilege, 7-495

CREATE ANY DIMENSION system privilege, 7-496

CREATE ANY DIRECTORY system privilege, 7-496

CREATE ANY INDEX system privilege, 7-496

CREATE ANY INDEXTYPE system privilege, 7-496

CREATE ANY LIBRARY system privilege, 7-497

CREATE ANY MATERIALIZED VIEW system privilege, 7-497

CREATE ANY OPERATOR system privilege, 7-497

CREATE ANY OUTLINE system privilege, 7-498

CREATE ANY PROCEDURE system privilege, 7-498

CREATE ANY SEQUENCE system privilege, 7-499

CREATE ANY SNAPSHOT system privilege, 7-499

CREATE ANY SYNONYM system privilege, 7-499

CREATE ANY TABLE system privilege, 7-500

CREATE ANY TRIGGER system privilege, 7-501

CREATE ANY TYPE system privilege, 7-501

CREATE ANY VIEW system privilege, 7-502

CREATE CLUSTER

statement, 7-236

CREATE CONTEXT statement, 7-243

CREATE CONTROLFILE statement, 7-245

CREATE DATABASE LINK

statement, 7-255

CREATE DATABASE statement, 7-249

CREATE DATAFILE clause

of ALTER DATABASE, 7-8, 7-16

CREATE DIMENSION

statement, 7-259

system privilege, 7-496

CREATE DIRECTORY statement, 7-264

CREATE FUNCTION statement, 7-266

CREATE INDEX

statement, 7-273

system privilege, 7-496

CREATE INDEXTYPE

statement, 7-291

system privilege, 7-496

CREATE JAVA statement, 7-293

CREATE LIBRARY

statement, 7-298

CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG statement, 7-314

CREATE MATERIALIZED VIEW / SNAPSHOT

statement, 7-300

CREATE MATERIALIZED VIEW/SNAPSHOT

CREATE OPERATOR

statement, 7-320

CREATE OUTLINE statement, 7-323

CREATE PACKAGE BODY statement, 7-328

CREATE PACKAGE statement, 7-325

CREATE PROCEDURE

statement, 7-333

CREATE PROFILE

statement, 7-338

CREATE PUBLIC DATABASE LINK system privilege, 7-495

CREATE PUBLIC SYNONYM system privilege, 7-499

CREATE ROLE

statement, 7-344

CREATE ROLLBACK SEGMENT

statement, 7-346

CREATE SCHEMA statement, 7-348

CREATE SEQUENCE

statement, 7-350

CREATE SESSION system privilege, 7-499

CREATE SNAPSHOT system privilege, 7-499

CREATE STANDBY CONTROLFILE clause

of ALTER DATABASE, 7-9, 7-19

CREATE statement

triggers on, 7-405

CREATE SYNONYM

statement, 7-356

CREATE TABLE statement, 7-359

CREATE TABLESPACE

statement, 7-394

CREATE TEMPORARY TABLESPACE statement, 7-399

CREATE TRIGGER

statement, 7-401

CREATE TYPE BODY statement, 7-421

CREATE TYPE

statement, 7-411

system privilege, 7-501

CREATE USER

statement, 7-425

system privilege, 7-501

CREATE VIEW

statement, 7-430

system privilege, 7-502

CREATE_STORED_OUTLINES parameter

of ALTER SESSION, 7-81

of queries and subqueries, 7-549

cross-tabulation values

deriving, 7-549

CUBE operations

currency symbol

ISO, 2-36

local, 2-37

union, 2-38

CURRENT_SCHEMA parameter

of ALTER SESSION, 7-81

CURRENT_USER

and database links, 7-256

CURRVAL pseudocolumn, 2-51, 7-351

CURSOR expressions, 5-9

cursors

number cached per session, 7-88

CYCLE clause

of ALTER SEQUENCE. See CREATE SEQUENCE., 7-76

of CREATE SEQUENCE, 7-352

D

D date format element, 2-41

D number format element, 2-36

data

integrity checking on input, 2-13

retrieving, 5-18

undo

storing, 7-346

data conversion, 2-31

implicit versus explicit, 2-33

when performed implicitly, 2-31

when specified explicitly, 2-32

data definition language. See DDL.

data dictionary

adding comments to, 7-212

data manipulation language (DML) statements, 6-4

data manipulation language. See DML.

data object number

in extended rowids, 2-22

database

allowing generation of redo logs, 7-12

allowing reuse of control files, 7-251

allowing unlimited resources to users, 7-340

cancel-based recovery, 7-13

terminating, 7-14

change-based recovery, 7-13

changing characteristics of, 7-245

changing global name, 7-15

changing the name of, 7-245, 7-246

character set

specifying, 7-252

converting from Oracle7 data dictionary, 7-11

creating, 7-250

designing media recovery, 7-12

enabling automatic extension of, 7-253

erasing all data from, 7-250

limiting resources for users, 7-339

managed recovery of, 7-8

modifying, 7-10

mounting, 7-11, 7-250

naming, 7-11

opening, 7-11, 7-250

after media recovery, 7-12

recovering, 7-13

with backup control file, 7-13

re-creating control file for, 7-245

redo log files

specifying, 7-246

remote

accessing, 5-25

authenticating users to, 7-257

connecting to, 7-256

service name of, 7-257

table locks on, 7-521

resetting

current log sequence, 7-12

to an earlier version, 7-15

restricting users to read-only transactions, 7-11

resuming activity, 7-100

specifying datafiles for, 7-247

suspending activity, 7-100

time-based recovery, 7-13

database accounts

creating, 7-426

database connect strings, 2-75

database events

and triggers, 7-405

database link

granting

creating synonyms with, 7-357

database links, 5-25

closing, 7-79

creating, 2-74, 7-255

removing from the database, 7-449

shared, 7-256

syntax of, 2-75

username and password, 2-75

database objects

dropping, 7-483

nonschema, 2-64

schema, 2-63

database triggers. See triggers.

databases

granting

of ALTER DATABASE, 7-8, 7-16

remote

inserting into, 7-515

DATAFILE clause

of CREATE CONTROLFILE, 7-247

of CREATE DATABASE, 7-253

DATAFILE clauses

of ALTER DATABASE, 7-8

DATAFILE END BACKUP clause

of ALTER DATABASE, 7-17

DATAFILE OFFLINE clause

of ALTER DATABASE, 7-16

DATAFILE ONLINE clause

of ALTER DATABASE, 7-16

DATAFILE RESIZE clause

of ALTER DATABASE, 7-17

datafiles

bringing online, 7-16

creating new, 7-16

designing media recovery, 7-12

disabling automatic extension, 7-17

enabling automatic extension, 7-17, 7-396

modifying, 7-16

recovering, 7-13

re-creating lost, 7-16

specifying for a tablespace, 7-396

taking offline, 7-16

datatype conversion

table of, 2-32

datatypes, 2-5

DATE datatype, 2-17

converting from character or numeric value, 2-17

date format elements, 2-40

RR, 2-44

date format models, 2-40

punctuation in, 2-40

date functions, 4-4

dates

arithmetic using, 2-17

comparison rules, 2-27

Julian, 2-18

DAY date format element, 2-43

DB_BLOCK_CHECKING parameter

DB_BLOCK_CHECKSUM parameter

DB_BLOCK_MAX_DIRTY_TARGET parameter

DB_FILE_MULTIBLOCK_READ_COUNT parameter

conversion to Oracle datatypes, 2-25

DB2 datatypes, 2-23

restrictions on, 2-25

DBA role, 7-503

DBA shortcut

of AUDIT sql_statements, 7-198

DBA_2PC_PENDING view, 7-79

DBA_COL_COMMENTS view, 7-212

DBA_ROLLBACK_SEGS view, 7-470

DBA_TAB_COMMENTS view, 7-212

DBMS_OUTPUT package, 7-172

DBMS_ROWID package

and extended rowids, 2-22

DBMSSTDX.SQL script, 7-267, 7-325, 7-328, 7-334

and triggers, 7-402

DD date format element, 2-41

DDD date format element, 2-41

DDL events

and triggers, 7-405

DDL statements, 6-1

and implicit commit, 6-2

causing recompilation, 6-2

PL/SQL support of, 6-2

requiring exclusive access, 6-2

DEALLOCATE UNUSED clause

of ALTER CLUSTER, 7-3, 7-5

of ALTER INDEX, 7-29

of ALTER TABLE, 7-140

DEBUG clause

of ALTER FUNCTION, 7-27

of ALTER PACKAGE, 7-60

of ALTER PROCEDURE, 7-63

of ALTER TRIGGER, 7-172

of ALTER TYPE, 7-174

decimal character, 2-4

specifying, 2-37

DECIMAL datatype

of ASSOCIATE STATISTICS, 7-195, 7-196

DB2, 2-25

SQL/DS, 2-25

DECODE expressions, 5-12

DEFAULT clause

of CREATE TABLE, 7-369

DEFAULT COST clause

DEFAULT profile

assigning to users, 7-468

DEFAULT ROLE clause

of ALTER USER, 7-181

of CREATE USER, 7-427

DEFAULT SELECTIVITY clause

of ASSOCIATE STATISTICS, 7-195, 7-196

DEFAULT storage clause

of ALTER TABLESPACE, 7-168

of CREATE TABLESPACE, 7-397

DEFAULT TABLESPACE clause

of ALTER USER. See CREATE USER.

of CREATE USER, 7-427

DEFERRABLE clause

of constraint_clause, 7-226

deferrable constraints, 7-568

DEFERRED clause

of SET CONSTRAINTS, 7-568

DELETE

object privilege, 7-508

statement, 7-438

DELETE ANY TABLE system privilege, 7-500

DELETE statement

triggers on, 7-404

DELETE STATISTICS clause

of ANALYZE, 7-190

DELETE_CATALOG_ROLE role, 7-503

DEREF function, 4-13

DESC clause

of CREATE INDEX, 7-281

descending indexes, 7-281

DETERMINISTIC clause

of CREATE FUNCTION, 7-270

dimensions

attributes

changing hierarchical relationships, 7-25

compiling invalidated, 7-26

creating, 7-260

creating on unspecified tables, 7-260

examples, 7-262

granting

system privileges on, 7-496

hierarchies

levels

removing from the database, 7-450

directories

granting

system privileges on, 7-496

directories. See directory objects.

directory objects

as aliases for OS directories, 7-264

auditing, 7-206

creating, 7-264

redefining, 7-265

removing from the database, 7-451

DISABLE ALL TRIGGERS clause

of constraint_clause, 7-227

DISABLE clause

of ALTER INDEX, 7-39

of ALTER TRIGGER, 7-172

of CREATE TABLE, 7-382

DISABLE DISTRIBUTED RECOVERY clause

DISABLE NOVALIDATE constraint state, 7-383

DISABLE PARALLEL DML clause

of ALTER MATERIALIZED VIEW, 7-50

DISABLE QUERY REWRITE clause

of CREATE MATERIALIZED VIEW/SNAPSHOT, 7-308

DISABLE RESTRICTED SESSION clause

of CREATE TABLE, 7-361, 7-381

DISABLE ROW MOVEMENT clause

of ALTER TABLE, 7-152

DISABLE STORAGE IN ROW clause

of ALTER TABLE, 7-131

of CREATE TABLE, 7-375

DISABLE TABLE LOCK clause

DISABLE VALIDATE constraint state, 7-383

DISABLE THREAD clause

of ALTER DATABASE, 7-15

DISASSOCIATE STATISTICS statement, 7-444

DISCONNECT SESSION clause

creating additional, 7-105

dispatcher processes

terminating, 7-105

DISTINCT clause

of SELECT, 7-545

distinct queries, 7-545

distributed queries, 5-25

DML operations

and triggers, 7-404

during index creation, 7-283

during index rebuild, 7-133

DML statements, 6-4

PL/SQL support of, 6-4

domain indexes, 7-277, 7-285, 7-291

associating statistics with, 7-196

determining user-defined CPU and I/O costs, 7-486

invoking drop routines for, 7-475

removing from the database, 7-454

specifying alter string for, 7-38

DOUBLE PRECISION datatype

DROP ANY CLUSTER system privilege, 7-495

DRIVING_SITE hint, 2-61

DROP ANY CONTEXT system privilege, 7-495

DROP ANY DIMENSION system privilege, 7-496

DROP ANY DIRECTORY system privilege, 7-496

DROP ANY INDEX system privilege, 7-496

DROP ANY INDEXTYPE system privilege, 7-496

DROP ANY LIBRARY system privilege, 7-497

DROP ANY MATERIALIZED VIEW system privilege, 7-497

DROP ANY OPERATOR system privilege, 7-497

DROP ANY OUTLINE system privilege, 7-498

DROP ANY PROCEDURE system privilege, 7-498

DROP ANY ROLE system privilege, 7-498

DROP ANY SEQUENCE system privilege, 7-499

DROP ANY SNAPSHOT system privilege, 7-499

DROP ANY SYNONYM system privilege, 7-499

DROP ANY TABLE system privilege, 7-500

DROP ANY TRIGGER system privilege, 7-501

DROP ANY TYPE system privilege, 7-501

DROP ANY VIEW system privilege, 7-502

DROP clause

of ALTER DIMENSION, 7-26

DROP CLUSTER statement, 7-446

DROP COLUMN clause

DROP CONSTRAINT clause

DROP CONTEXT statement, 7-448

DROP DATABASE LINK statement, 7-449

DROP DIMENSION statement, 7-450

DROP DIRECTORY statement, 7-451

DROP FUNCTION statement, 7-452

DROP INDEX statement, 7-454

DROP INDEXTYPE statement, 7-456

DROP JAVA statement, 7-457

DROP LIBRARY

statement, 7-458

of ALTER DATABASE, 7-9, 7-18

DROP LOGFILE clause

DROP LOGFILE MEMBER clause

of ALTER DATABASE, 7-9, 7-18

DROP MATERIALIZED VIEW / SNAPSHOT statement, 7-459

DROP MATERIALIZED VIEW LOG / SNAPSHOT LOG statement, 7-461

DROP OPERATOR statement, 7-463

DROP OUTLINE statement, 7-464

DROP PACKAGE BODY statement, 7-465

DROP PACKAGE statement, 7-465

DROP PARTITION clause

of ALTER INDEX, 7-40

of ALTER TABLE, 7-148

DROP PRIMARY constraint clause

DROP PROCEDURE statement, 7-467

DROP PROFILE

statement, 7-468

DROP PUBLIC DATABASE LINK system privilege, 7-496

DROP PUBLIC SYNONYM system privilege, 7-500

DROP ROLE statement, 7-469

DROP ROLLBACK SEGMENT

statement, 7-470

DROP SEQUENCE statement, 7-471

DROP statement

triggers on, 7-405

DROP STORAGE clause

of TRUNCATE, 7-583

DROP SYNONYM statement, 7-474

DROP TABLE statement, 7-475

DROP TABLESPACE

statement, 7-477

DROP TRIGGER statement, 7-479

DROP TYPE BODY statement, 7-482

DROP TYPE statement, 7-480

DROP UNIQUE constraint clause

DROP VIEW statement, 7-485

DROP USER

statement, 7-483

system privilege, 7-502

DUAL dummy table, 2-68, 5-24

DUMP function, 4-14

DY date format element, 2-41, 2-43

E

E date format element, 2-41

E number format element, 2-36

EBCDIC character set, 2-29

EE date format element, 2-41

embedded SQL statements, xi, 1-3, 6-5

precompiler support of, 6-5

EMPTY_BLOB function, 4-15

EMPTY_CLOB function, 4-15

ENABLE ALL TRIGGERS clause

of constraint_clause, 7-227

ENABLE clause

of ALTER INDEX, 7-38

of ALTER TRIGGER, 7-171

of CREATE TABLE, 7-382

ENABLE DISTRIBUTED RECOVERY clause

ENABLE NOVALIDATE constraint state, 7-382

ENABLE PARALLEL DML clause

of ALTER MATERIALIZED VIEW, 7-50

ENABLE QUERY REWRITE clause

of CREATE MATERIALIZED VIEW/SNAPSHOT, 7-308

ENABLE RESTRICTED SESSION clause

of CREATE TABLE, 7-361, 7-381

ENABLE ROW MOVEMENT clause

of ALTER TABLE, 7-152

ENABLE STORAGE IN ROW clause

of ALTER TABLE, 7-131

of CREATE TABLE, 7-375

ENABLE TABLE LOCK clause

ENABLE VALIDATE constraint state, 7-382

ENABLE THREAD clause

of ALTER DATABASE, 7-15

ENABLE/DISABLE clause

of ALTER TABLE, 7-127, 7-153

of CREATE TABLE, 7-366

END BACKUP clause

of ALTER TABLESPACE, 7-168

equality test, 3-5

equijoins, 5-21

defining for a dimension, 7-261

equivalency tests, 3-5

ESTIMATE STATISTICS clause

of ANALYZE, 7-188

EXCEPTIONS INTO clause

of constraint_clause, 7-228

of CREATE TABLE, 7-384

EXCHANGE PARTITION clause

of ALTER TABLE, 7-151

EXCHANGE SUBPARTITION clause

of ALTER TABLE, 7-151

EXCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG, 7-57

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, 7-317

EXCLUSIVE lock mode, 7-521

EXECUTE ANY INDEXTYPE system privilege, 7-496

EXECUTE ANY OPERATOR system privilege, 7-497

EXECUTE ANY PROCEDURE system privilege, 7-498

EXECUTE ANY TYPE system privilege, 7-501

EXECUTE object privilege, 7-508

EXECUTE_CATALOG_ROLE role, 7-503

execution plans

determining, 7-486

dropping outlines for, 7-464

EXISTS

EXP_FULL_DATABASE role, 7-503

EXPLAIN PLAN statement, 7-486

explicit data conversion, 2-32, 2-33

expressions

CAST, 5-7

compound, 5-4

computing with the DUAL table, 5-24

CURSOR, 5-9

DECODE, 5-12

function, built-in, 5-5

type constructor, 5-6

user-defined function, 5-5

variable, 5-4

extended rowids, 2-22

not directly available, 2-22

EXTENT MANAGEMENT clause

for temporary tablespaces, 7-400

of CREATE TABLESPACE, 7-395, 7-397

extents

allocating for partitions, 7-139

allocating for subpartitions, 7-139

allocating for tables, 7-139

restricting access by instances, 7-34

specifying maximum number for an object, 7-578

specifying number allocated upon object creation, 7-577

specifying the first for an object, 7-577

specifying the percentage of size increase, 7-577

specifying the second for an object, 7-577

external datatypes

associated with host variables, 2-6

recognized by precompilers, 2-6

external functions, 7-267, 7-334

external LOBs, 2-19

external procedures, 7-334

external users, 7-345, 7-427

F

FAILED_LOGIN_ATTEMPTS parameter

of ALTER PROFILE, 7-65

of CREATE PROFILE, 7-341

FAST_START_IO_TARGET parameter

of ALTER SESSION, 7-82, 7-102

FAST_START_PARALLEL_ROLLBACK parameter

specifying as a redo log file group, 7-490

files

specifying as datafiles, 7-490

specifying as tempfiles, 7-490

filespec clause, 7-490

of CREATE CONTROLFILE, 7-245

of CREATE DATABASE, 7-250

of CREATE LIBRARY, 7-298

of CREATE TABLESPACE, 7-394

of CREATE TEMPORARY TABLESPACE, 7-399

FIPS compliance, B - 3

FIPS flagging, 7-82

FIRST_ROWS hint, 2-59

FIXED_DATE parameter

FLAGGER parameter

FLOAT datatype

floating-point numbers, 2-15

DB2, 2-25

SQL/DS, 2-25

FLOOR function, 4-15

FLUSH SHARED POOL clause

FM format model modifier, 2-46

FM number format element, 2-36

FOR CATEGORY clause

of CREATE OUTLINE, 7-323

FOR clause

of ANALYZE ... COMPUTE STATISTICS, 7-189

of ANALYZE ... ESTIMATE STATISTICS, 7-189

of CREATE INDEXTYPE, 7-292

of CREATE SYNONYM, 7-357

of EXPLAIN PLAN, 7-487

FOR EACH ROW clause

of CREATE TRIGGER, 7-406

FOR UPDATE clause

of CREATE MATERIALIZED VIEW/SNAPSHOT, 7-308

of SELECT, 7-544, 7-551

FORCE ANY TRANSACTION system privilege, 7-502

FORCE CLAUSE

of DROP OPERATOR, 7-463

FORCE clause

of COMMIT, 7-215

of CREATE DIMENSION, 7-260

of CREATE VIEW, 7-432

of DROP INDEX, 7-455

of DROP INDEXTYPE, 7-456

of DROP TYPE, 7-481

of ROLLBACK, 7-538

FORCE PARALLEL DML clause

FORCE TRANSACTION system privilege, 7-502

FOREIGN KEY clause

of constraint_clause, 7-219, 7-223

foreign key constraints, 7-223

foreign tables

rowids of, 2-23

format models, 2-33

changing the return format, 2-34

date, 2-40

date, changing, 2-40

date, default, 2-40

date, format elements, 2-40

date, maximum length, 2-40

modifiers, 2-46

number, 2-35

number, elements of, 2-36

specifying, 2-35

formats

for dates and numbers. See format models.

of return values from the database, 2-33

of values stored in the database, 2-33

FREELIST GROUPS parameter

of STORAGE clause, 7-578

freelists

specifying for a table, partition, cluster, or index, 7-578

FREELISTS parameter

of STORAGE clause, 7-578

FROM clause

of queries, 5-22

of REVOKE system_privileges_and_roles, 7-530

of SELECT, 7-546

FROM COLUMNS clause

FROM FUNCTIONS clause

FROM INDEXES clause

FROM INDEXTYPES clause

FROM PACKAGES clause

FROM PUBLIC clause

FROM role clause

FROM TYPES clause

FROM user clause

function-based indexes, 7-277

FULL hint, 2-59

function expressions

built-in, 5-5

function specification

of CREATE TYPE, 7-416

and query rewrite, 7-87

creating, 7-280

disabling, 7-39, 7-106

enabling, 7-36, 7-38, 7-106

functions

3GL, calling, 7-298

access to tables and packages, 7-416

associating statistics with, 7-196

avoiding run-time compilation, 7-27

calling, 7-210

changing the declaration of, 7-27

datatype of return value, 7-270

declaring

as a Java method, 7-271

as C functions, 7-271

defining an index on, 7-280

disassociating statistics types from, 7-452

examples, 7-271

executing, 7-210

from parallel query process, 7-270

external, 7-267, 7-334

invalidating local objects dependent on, 7-452

issuing COMMIT or ROLLBACK statements, 7-79

naming rules, 2-69

privileges executed with, 7-415

recompiling invalid, 7-27

re-creating, 7-268, 7-294

removing from the database, 7-452

schema executed in, 7-415

specifying schema and user privileges for, 7-270

stored, 7-267

storing return value of, 7-211

synonyms for, 7-356

user-defined, 4-56

using a saved copy of, 7-270

FUNCTIONS clause

of ASSOCIATE STATISTICS, 7-194, 7-196

FX format model modifier, 2-46

G

G number format element, 2-36

GC_DEFER_TIME parameter

of ALTER DATABASE, 7-7, 7-12

general recovery clause

GLOBAL PARTITION BY RANGE clause

of CREATE INDEX, 7-283

GLOBAL QUERY REWRITE system privilege, 7-496, 7-497, 7-499

GLOBAL TEMPORARY clause

of CREATE TABLE, 7-368

global users, 7-345, 7-427

GLOBAL_NAMES parameter