6
About SQL Statements

application  

allowing to connect as a user  

ALTER USER proxy_clause  

application server  

allowing to connect as a user  

ALTER USER proxy_clause  

auditing  

of database events  

CREATE TRIGGER  

call  

limit CPU time for  

CPU_PER_CALL parameter  

limit data blocks read  

LOGICAL_READS_PER_CALL parameter  

checkpoint  

perform explicitly  

ALTER SYSTEM CHECKPOINT  

clone database  

mount  

ALTER DATABASE MOUNT  

cluster  

cluster key, change columns of  

prohibited  

extent, allocate for  

ALTER CLUSTER allocate_extent_clause  

migrated or chained rows, identify  

ANALYZE  

parallelism of, change  

ALTER CLUSTER parallel_clause  

rename  

prohibited  

storage characteristics of, change  

ALTER CLUSTER physical_attributes_clause  

tablespace of, change  

prohibited  

unused space in, release  

ALTER CLUSTER deallocate_unused_clause  

column  

add to a table or modify  

ALTER TABLE add_column_options, modify_column_options  

define  

CREATE TABLE  

drop from a table  

ALTER TABLE drop_column_clause  

generate derived values automatically  

CREATE TRIGGER  

organization of, define  

CREATE TABLE  

commit operation  

prevent procedure or function from issuing  

ALTER SESSION  

compilation  

avoid run-time of  

ALTER FUNCTION ... COMPILE  

constraint  

add to a table or modify  

ALTER TABLE add_column_options, modify_column_options  

business, enforce  

CREATE TRIGGER  

enable, disable, or drop  

ALTER TABLE enable_disable_clause, drop_constraint_clause  

specify  

CREATE TABLE  

control file  

back up  

ALTER DATABASE controlfile_clauses  

standby, create  

ALTER DATABASE CREATE STANDBY CONTROLFILE  

currency symbol  

reset for session  

ALTER SESSION SET NLS_CURRENCY  

data  

frequently used, caching  

ALTER TABLE cache_clause  

specify as temporary or permanent  

CREATE TABLE  

data dictionary  

convert from Oracle7 to Oracle8i  

ALTER DATABASE CONVERT  

data independence  

provide  

CREATE SYNONYM  

database  

character set of, change  

ALTER DATABASE CHARACTER SET  

create script for  

ALTER DATABASE controlfile_clauses  

database character set for, specify  

CREATE DATABASE  

datafiles for, specify  

CREATE DATABASE  

datafiles of, modify  

ALTER DATABASE  

datafiles, establish number of  

CREATE DATABASE  

downgrade to an earlier release  

ALTER DATABASE RESET COMPATIBILITY  

global name of, change  

ALTER DATABASE RENAME GLOBAL_NAME  

global name resolution, enable for the session  

ALTER SESSION SET GLOBAL_NAMES  

instances, establish number of  

CREATE DATABASE  

media recovery, design  

ALTER DATABASE general_recovery_clause  

media recovery, perform ongoing  

ALTER DATABASE managed_recovery_clause  

mount  

ALTER DATABASE MOUNT  

move a subset to a different Oracle database  

ALTER TABLE exchange_partition_clause  

national character set for, specify  

CREATE DATABASE  

national character set of, change  

ALTER DATABASE CHARACTER SET  

open  

ALTER DATABASE OPEN  

parallelize recovery of  

ALTER DATABASE parallel_clause  

place in read-only mode  

ALTER DATABASE OPEN  

place in read-write mode  

ALTER DATABASE OPEN  

place in sustained standby recovery mode  

ALTER DATABASE general_recovery_clause  

prepare to re-create  

ALTER DATABASE controlfile_clauses  

recover  

ALTER DATABASE recover_clauses  

redo log file groups, establish number of  

CREATE DATABASE  

redo log files for, specify  

CREATE DATABASE  

redo log files of, create or modify  

ALTER DATABASE  

redo log files, establish number of  

CREATE DATABASE  

redo log, choose mode for  

CREATE DATABASE  

upgrade to Oracle8i  

ALTER DATABASE  

database character set  

specify for a database  

CREATE DATABASE  

database events  

transparent logging of  

CREATE TRIGGER  

database link  

close  

ALTER SESSION  

database security  

enforce authorizations  

CREATE TRIGGER  

datafile  

automatic extension of, allow  

ALTER DATABASE DATAFILE autoextend_clause  

create  

ALTER DATABASE CREATE DATAFILE  

put online  

ALTER DATABASE DATAFILE ONLINE  

reconstruct damaged  

ALTER DATABASE general_recovery_clause  

reconstruct lost or damaged  

ALTER DATABASE CREATE DATAFILE  

recover specified  

ALTER DATABASE general_recovery_clause  

replace an old, for recovery  

ALTER DATABASE CREATE DATAFILE  

resize  

ALTER DATABASE DATAFILE RESIZE  

take offline  

ALTER DATABASE DATAFILE ONLINE/OFFLINE  

begin or end backup of  

ALTER TABLESPACE ... BACKUP  

number of, establish for a database  

CREATE DATABASE  

online, update instance information on  

ALTER SYSTEM check_datafiles_clause  

specify for a database  

CREATE DATABASE  

dates  

format of  

See Table 2-9, "Date Format Elements".  

decimal character  

reset for session  

ALTER SESSION SET NLS_NUMERIC_CHARACTERS  

dimension  

add a level, hierarchy, or attribute to  

ALTER DIMENSION ... ADD  

change the relationships of  

ALTER DIMENSION  

drop a level, hierarchy, or attribute from  

ALTER DIMENSION ... DROP  

explicitly compile  

ALTER DIMENSION ... COMPILE  

dispatcher processes  

multi-threaded server, manage  

MTS_ parameters of ALTER SYSTEM  

domain index  

alter  

ALTER INDEX ... PARAMETERS  

rebuild  

ALTER INDEX rebuild_clause  

dump file  

limit the size of  

ALTER SESSION SET MAX_DUMP_FILE_SIZE  

error messages  

language in which displayed, change  

ALTER SESSION SET NLS_LANGUAGE  

function  

allow to or prevent from committing a transaction  

ALTER SESSION  

declaration of, change  

CREATE OR REPLACE FUNCTION  

definition of, change  

CREATE OR REPLACE FUNCTION  

recompile explicitly  

ALTER FUNCTION  

function-based index  

disable  

ALTER INDEX ... [rebuild_clause] DISABLE  

disabled, re-enable  

ALTER INDEX ... [rebuild_clause] ENABLE  

global names  

enforce resolution of  

GLOBAL_NAMES parameter of ALTER SYSTEM  

hash join operations  

data blocks for, allocate  

ALTER SESSION SET HASH_MULTIBLOCK_IO_COUNT  

in queries, enable or disable  

ALTER SESSION SET HASH_JOIN_ENABLED ...  

memory for, allocate  

ALTER SESSION SET HASH_AREA_SIZE  

index  

allow DML operations during rebuilding of  

ALTER INDEX rebuild_clause  

based on a function; see "function-based index"  

CREATE INDEX ... column_expression  

based on an indextype; see "domain index"  

CREATE INDEX domain_index_clause  

collect statistics during rebuilding of  

ALTER INDEX rebuild_clause  

default attribute values of, change  

ALTER INDEX partitioning_clauses  

degree of parallelism for, change  

ALTER INDEX parallel_clause  

direct-load INSERT operations, write to a log  

ALTER INDEX physical_attributes_clause  

extent for, allocate new  

ALTER INDEX allocate_extent_clause  

key compression, enable  

ALTER INDEX rebuild_clause  

key values, eliminate repetition of  

ALTER INDEX rebuild_clause  

merge block contents of  

ALTER INDEX rebuild_clause  

physical attributes of a partition of, change  

ALTER INDEX physical_attributes_clause  

physical attributes of a subpartition of, change the  

ALTER INDEX physical_attributes_clause  

physical attributes of, change  

ALTER INDEX physical_attributes_clause  

re-create  

ALTER INDEX rebuild_clause  

rebuild operations, write to a log  

ALTER INDEX rebuild_clause  

SQL*Loader operations against, write to a log  

ALTER INDEX physical_attributes_clause  

store bytes in reverse order  

ALTER INDEX rebuild_clause  

tablespace for, specify  

ALTER INDEX rebuild_clause  

tell Oracle not to use  

ALTER INDEX ... [rebuild_clause] UNUSABLE  

unused space, release  

ALTER INDEX deallocate_unused_clause  

rename  

ALTER INDEX rebuild_clause  

index partition  

create-time attributes, change  

ALTER INDEX rebuild_clause  

log direct-load INSERT operations  

ALTER INDEX physical_attributes_clause  

log SQL*Loader operations against  

ALTER INDEX physical_attributes_clause  

move to a different tablespace  

ALTER INDEX rebuild_clause  

physical attributes of, change  

ALTER INDEX physical_attributes_clause  

physical, logging, or storage characteristics of, change  

ALTER INDEX partitioning_clauses  

re-create  

ALTER INDEX rebuild_clause  

remove from the database  

ALTER INDEX partitioning_clauses  

specify a tablespace for  

ALTER INDEX rebuild_clause  

split into two partitions  

ALTER INDEX partitioning_clauses  

tell Oracle not to use  

ALTER INDEX ... UNUSABLE  

index subpartition  

change a create-time attributes, change  

ALTER INDEX rebuild_clause  

log direct-load INSERT operations  

ALTER INDEX physical_attributes_clause  

log SQL*Loader operations against  

ALTER INDEX physical_attributes_clause  

move to a different tablespace  

ALTER INDEX rebuild_clause  

physical attributes, change  

ALTER INDEX physical_attributes_clause  

physical, logging, or storage characteristics, change  

ALTER INDEX partitioning_clauses  

re-create  

ALTER INDEX rebuild_clause  

tablespace for, specify  

ALTER INDEX rebuild_clause  

tell Oracle not to use  

ALTER INDEX ... UNUSABLE  

index-organized table  

characteristics, change  

ALTER TABLE  

indexes  

on a cluster  

CREATE INDEX  

on a nested table storage table  

CREATE INDEX  

on a partitioned table  

CREATE INDEX  

on an index-organized table  

CREATE INDEX  

on columns of a table  

CREATE INDEX  

on scalar typed object attributes  

CREATE INDEX  

instance  

dynamically modify  

ALTER SYSTEM  

make an index extent available to  

ALTER INDEX allocate_extent_clause  

switch to a different  

ALTER SESSION SET INSTANCE  

instance recovery  

continue after interruption  

ALTER DATABASE general_recovery_clause  

instances  

number of, establish for a database  

CREATE DATABASE  

Java class  

force resolution of  

ALTER JAVA  

Java resource  

force compilation of  

ALTER JAVA  

Java source  

force compilation of  

ALTER JAVA  

licensing  

changing limits or thresholds  

LICENSE_ parameters of ALTER SYSTEM  

LOB columns  

add to a table or modify  

ALTER TABLE add_column_options, modify_column_options, LOB_storage_clause  

location transparency  

provide  

CREATE SYNONYM  

materialized view  

automatic refresh, change the mode or timing of  

ALTER MATERIALIZED VIEW refresh_clause  

change from rowid-based to primary-key-based  

ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEW LOG  

degree of parallelism, specify or change  

ALTER MATERIALIZED VIEW parallel_clause  

divide into partitions  

ALTER MATERIALIZED VIEW partitioning_clauses  

LOB storage characteristics, change  

ALTER MATERIALIZED VIEW modify_LOB_storage_clause  

LOB storage characteristics, specify  

ALTER MATERIALIZED VIEW LOB_storage_clause  

log changes to  

ALTER MATERIALIZED VIEW ... LOGGING  

make eligible for query rewrite  

ALTER MATERIALIZED VIEW ... QUERY REWRITE

ALTER SESSION SET QUERY_REWRITE_ENABLED  

make frequently accessed data accessible  

ALTER MATERIALIZED VIEW ... CACHE  

revalidate  

ALTER MATERIALIZED VIEW ... COMPILE  

storage characteristics, change  

ALTER MATERIALIZED VIEW physical_attributes_clause  

materialized view log  

automatic refresh, change the mode and timing of  

ALTER MATERIALIZED VIEW LOG  

change from rowid-based to primary-key-based  

ALTER MATERIALIZED VIEW LOG  

divide into partitions  

ALTER MATERIALIZED VIEW LOG partitioning_clauses  

physical and storage characteristics, change  

ALTER MATERIALIZED VIEW LOG ... physical_attributes_clause  

save both old and new values  

ALTER MATERIALIZED VIEW LOG ...NEW VALUES  

store primary key of changed rows  

ALTER MATERIALIZED VIEW LOG ... ADD  

store rowid of changed rows  

ALTER MATERIALIZED VIEW LOG ... ADD  

media recovery  

avoid on startup  

ALTER DATABASE DATAFILE END BACKUP  

from specified redo log file  

ALTER DATABASE general_recovery_clause  

prepare for  

ALTER DATABASE ARCHIVELOG  

national character set  

specify for a database  

CREATE DATABASE  

national language support  

change settings for the session  

ALTER SESSION SET NLS_ parameters  

nested table  

update in a view  

create an INSTEAD OF trigger  

nested table columns  

indexing  

CREATE INDEX  

numbers  

format  

See Table 2-7, "Number Format Elements".  

object references. See REFs  

online redo log  

reinitialize  

ALTER DATABASE CLEAR LOGFILE  

outline  

assign to a different category  

ALTER OUTLINE ... CHANGE CATEGORY TO  

recompile  

ALTER OUTLINE ... REBUILD  

rename  

ALTER OUTLINE ... RENAME  

automatically create and store  

ALTER SESSION SET CREATE_STORED_OUTLINES  

use to generate execution plans  

ALTER SESSION SET USE_STORED_OUTLINES  

package  

avoid run-time compilation  

ALTER PACKAGE  

compile explicitly  

ALTER PACKAGE  

package body  

avoid run-time compilation  

ALTER PACKAGE  

recompile explicitly  

ALTER PACKAGE  

parallelism  

specify for a table  

CREATE TABLE  

specify for DML on a table  

CREATE TABLE  

parameter, initialization  

change the setting for the current session  

ALTER SESSION set_clause  

parameter, session  

set or change the setting of  

ALTER SESSION set_clause  

partition  

add to a table or modify  

ALTER TABLE  

default attributes, change  

ALTER TABLE modify_default_attributes_clause  

logging characteristics, change  

ALTER TABLE logging_clause  

merge with another partition  

ALTER TABLE merge_partitions_clause  

point to data in a nonpartitioned table  

ALTER TABLE exchange_partition_clause  

real attributes, change  

ALTER TABLE modify_partition_clause  

password  

complexity of, guarantee  

PASSWORD_VERIFY_FUNCTION parameter  

make unavailable  

PASSWORD_REUSE_TIME parameter  

number of days account will be locked after failed login attempts, specify  

PASSWORD_LOCK_TIME parameter  

number of days before reuse, limit  

PASSWORD_REUSE_TIME parameter  

number of days in grace period, specify  

PASSWORD_GRACE_TIME parameter  

number of days usable, limit  

PASSWORD_LIFE_TIME parameter  

number of times reused, limit  

PASSWORD_REUSE_MAX parameter  

special characters in, allow  

PASSWORD_VERIFY_FUNCTION parameter  

performance  

optimize for index access path  

ALTER SESSION SET OPTIMIZER_INDEX_COST_ADJ  

optimize for nested loop joins  

ALTER SESSION SET OPTIMIZER_INDEX_CACHING  

specify an optimizer search limit  

ALTER SESSION SET OPTIMIZER_SEARCH_LIMIT  

specify the optimizer approach for the session  

ALTER SESSION SET OPTIMIZER_MODE  

procedure  

allow to or prevent from committing a transaction  

ALTER SESSION  

avoid run-time compilation  

ALTER PROCEDURE  

recompile explicitly  

ALTER PROCEDURE  

profile  

resource limit, add to  

ALTER PROFILE  

resource limit, change  

ALTER PROFILE  

resource limit, drop from  

ALTER PROFILE  

recovery  

distributed, enable or disable  

ALTER SYSTEM distributed_recovery_clause  

recovery data  

discard  

ALTER DATABASE RESETLOGS  

redo log  

remove changes from  

ALTER DATABASE OPEN RESETLOGS  

reset sequence of  

ALTER DATABASE OPEN RESETLOGS  

specify mode of  

CREATE DATABASE  

redo log file  

add  

ALTER DATABASE ADD LOGFILE MEMBER  

automatically generates names for  

ALTER DATABASE general_recovery_clause  

clear  

ALTER DATABASE CLEAR LOGFILE  

drop  

ALTER DATABASE DROP LOGFILE  

enable or disable thread  

ALTER DATABASE ENABLE THREAD  

rename  

ALTER DATABASE RENAME FILE  

number of, establish for a database  

CREATE DATABASE  

archive manually or automatically  

ALTER SYSETM archive_log_clause  

number of, establish for a database  

CREATE DATABASE  

specify a path for  

ALTER SESSION SET LOG_ARCHIVE_DEST_n  

switch manually  

ALTER SYSTEM switch_logfile_clause  

REFS  

validate and update  

ANALYZE  

role  

change authorization required  

ALTER ROLE  

rollback segment  

bring online  

ALTER ROLLBACK SEGMENT  

reduce in size  

ALTER ROLLBACK SEGMENT  

storage characteristics, change  

ALTER ROLLBACK SEGMENT  

take offline  

ALTER ROLLBACK SEGMENT  

rowid  

examine  

query the ROWID pseudocolumn  

extended, interpreting contents  

DBMS_ROWID package; see Oracle8i Supplied Packages Reference  

schema  

change during the session  

ALTER SESSION SET CURRENT_SCHEMA  

schema object  

reference without referencing its location  

CREATE SYNONYM  

reference without referencing its owner  

CREATE SYNONYM  

specify another name for  

CREATE SYNONYM  

validate structure of  

ANALYZE  

sequence  

cached sequence values, change number of  

ALTER SEQUENCE cache_clause  

consecutive order of values, guarantee  

CREATE SEQUENCE ... ORDER

ALTER SEQUENCE ... ORDER  

create  

CREATE SEQUENCE  

determine current value of  

See "CURRVAL and NEXTVAL".  

increment value, set  

CREATE SEQUENCE ... INCREMENT BY

ALTER SEQUENCE ... INCREMENT BY  

maximum or minimum value, eliminate  

ALTER SEQUENCE  

minimum or maximum value, set  

CREATE SEQUENCE

ALTER SEQUENCE  

preallocate values for faster access  

CREATE SEQUENCE

ALTER SEQUENCE  

restart after a predefined limit  

CREATE SEQUENCE ... CYCLE

ALTER SEQUENCE ... CYCLE  

starting value, set  

CREATE SEQUENCE  

server processes  

multi-threaded server, manage  

MTS_ parameters of ALTER SYSTEM  

session  

CPU time for, limit  

CPU_PER_SESSION parameter  

data blocks read, limit  

LOGICAL_READS_PER_SESSION parameter  

enable or disable parallel transactions in  

ALTER SESSION  

inactive period duration, limit  

IDLE_TIME parameter  

private SGA space for, limit  

PRIVATE_SGA parameter  

resource costs allowed, change  

ALTER RESOURCE COST  

restrict to privileged users  

ALTER SYSTEM restricted_session_clause  

terminate  

ALTER SYSTEM kill_session_clause  

total elapsed time, limit  

CONNECT_TIME parameter  

total resources for, limit  

COMPOSITE_LIMIT parameter  

SGA  

flush data from shared pool  

ALTER SYSTEM flush_shared_pool_clause  

shared pool  

flush  

ALTER SYSTEM flush_shared_pool_clause  

snapshot. See "materialized view".  

sort operations  

linguistic sequence, change  

ALTER SESSION SET NLS_SORT  

standby database  

activate  

ALTER DATABASE ACTIVATE STANDBY DATABASE  

recover  

ALTER DATABASE recover_clauses  

statistics  

on a schema object, collect  

ANALYZE  

on a schema object, delete  

ANALYZE  

on scalar object attributes, collect  

ANALYZE  

subpartition  

add to a table or modify  

ALTER TABLE  

default attributes, change  

ALTER TABLE modify_default_attributes_clause, modify_partition_clause  

logging characteristics, change  

ALTER TABLE logging_clause  

real attributes, change  

ALTER TABLE modify_subpartition_clause  

system resources  

enable or disable  

RESOURCE_LIMITS parameter of ALTER SYSTEM  

table  

allocate space for  

ALTER TABLE allocate_extent_clause  

characteristics, change  

ALTER TABLE physical_attributes_clause, storage_clauses  

column, drop from table  

ALTER TABLE drop_column_clause  

degree of parallelism, change  

ALTER TABLE parallel_clause  

logging characteristics, change  

ALTER TABLE logging_clause  

make read-only, read-write  

ALTER TABLE  

migrated or chained rows, identify  

ANALYZE  

organization, define  

CREATE TABLE  

partition, point to the contents of another table  

ALTER TABLE exchange_partition_clause  

partitioning, specify  

CREATE TABLE  

rename  

ALTER TABLE  

unused space of, release  

ALTER TABLE deallocate_unused_clause  

heap or index organized  

CREATE TABLE  

include in a cluster  

CREATE TABLE  

replicate asynchronous, maintain  

CREATE TRIGGER  

storage characteristics of, set  

CREATE TABLE  

tablespace  

allow or disallow writing to  

ALTER TABLESPACE READ WRITE/ONLY  

datafiles, add or rename  

ALTER TABLESPACE datafile/tempfile_clauses  

logging characteristics, change  

ALTER TABLESPACE  

minimum extent length, change  

ALTER TABLESPACE  

reconstruct damaged  

ALTER DATABASE general_recovery_clause  

reconstruct lost or damaged  

ALTER DATABASE CREATE DATAFILE  

recover specified  

ALTER DATABASE general_recovery_clause  

specifying for a table  

CREATE TABLE  

storage characteristics, change  

ALTER TABLESPACE  

take online or offline  

ALTER TABLESPACE  

user quota on, change  

ALTER USER  

assign to a user  

CREATE USER  

space quota for a user, allocate  

CREATE USER  

tempfile  

allow for automatic extension of  

ALTER DATABASE TEMPFILE  

resize  

ALTER DATABASE TEMPFILE  

transaction  

distributed, force commit of  

ALTER SESSION  

distributed, force rollback of  

ALTER SESSION  

trigger  

enable or disable  

ALTER TABLE  

user  

authentication, change  

ALTER USER  

database resources limits, change  

ALTER USER profile_clause  

default roles, change  

ALTER USER  

failed attempts to log in, limit  

FAILED_LOGIN_ATTEMPTS parameter  

number of sessions, limit  

SESSIONS_PER_USER parameter  

password, change  

ALTER USER  

resource limits, set  

CREATE USER  

restrict access to Oracle  

ALTER SYSTEM restricted_session_clause  

tablespace quota, allocate  

CREATE USER  

tablespaces, assign  

CREATE USER