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 Y Z

@

• != comparison operator [2]
• " double quotation marks, with object names
• $ format element
• % character, in pattern matching
• (+) outer join operator [2]
• , format element
• . number format element
• 0 format element
• 9 format element
• << comparison operator
• <<= comparison operator
• = comparison operator
• > comparison operator
• >= comparison operator
• ^= comparison operator
• _ character, in pattern matching

  A

• A.D. format element
• A.M. format element
• abnormal termination, automatic rollback
• ABS numeric function
• AD format element
• ADD clause, of ALTER TABLE command
• ADD DATAFILE clause, of ALTER TABLESPACE command
• ADD LOGFILE clause, of ALTER DATABASE command
• ADD LOGFILE MEMBER clause, of ALTER DATABASE command
• ADD_MONTHS date function
• adding, columns to tables [2] [3]
  • comments to objects
  • datafiles
  • datafiles to databases [2]
  • datafiles to tablespaces
  • integrity constraints to columns [2]
  • integrity constraints to tables [2] [3]
  • members to redo log file groups
  • procedures to packages
  • redo log file groups to threads
  • redo log files to databases [2]
  • resource limits to profiles [2]
  • stored functions to packages
  • tables to clusters [2]
  • triggers to tables
• ADMIN OPTION, of GRANT command [2]
• ADVISE clause, of ALTER SESSION command
• AFTER option, of CREATE TRIGGER command
• alias, table
• ALL comparison operator [2]
• ALL option
  • of ARCHIVE LOG clause
  • of DEFAULT ROLE clause
  • of SELECT command
  • of SET ROLE command
  • of SQL group functions
• ALL PRIVILEGES option
  • of GRANT command
  • of REVOKE command
• ALL statement auditing short cut
• ALL TRIGGERS option
  • of DISABLE clause
  • of ENABLE clause
• ALL_INDEXES view
• ALL_TAB_COLUMNS view
• ALL_TABLES view
• ALLOCATE command
• ALLOCATE EXTENT clause
  • of ALTER CLUSTER command
  • of ALTER TABLE command [2]
• allocating
  • cursors
  • extents for tables [2]
• ALTER CLUSTER command [2]
• ALTER DATABASE command [2]
  • examples [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14]
• ALTER FUNCTION command
  • examples
• ALTER INDEX command [2]
  • examples
• ALTER object auditing option
• ALTER object privilege
  • on sequences
  • on tables
• ALTER PACKAGE command
  • examples [2]
• ALTER PROCEDURE command
  • examples
• ALTER PROFILE command
  • examples [2] [3] [4]
• ALTER RESOURCE COST command
  • examples
• ALTER ROLE command
  • examples
• ALTER ROLLBACK SEGMENT command [2]
  • examples
• ALTER SEQUENCE command
  • examples [2]
• ALTER SESSION command [2]
  • examples [2] [3] [4] [5] [6] [7] [8] [9] [10] [11]
• ALTER SNAPSHOT command
  • examples [2] [3]
• ALTER SNAPSHOT LOG command
  • examples
• ALTER SYSTEM command
  • examples [2] [3] [4]
• ALTER TABLE command [2]
  • examples
• ALTER TABLESPACE command [2]
  • examples
• ALTER TRIGGER command
  • examples
• ALTER USER command [2]
  • examples
  • syntax
• ALTER VIEW command
  • examples
• altering
  • costs of resources
  • databases
  • profiles
  • sequences
  • snapshot logs
  • snapshots
  • tables
• AM format element
• American National Standards Committee (ANSI)
• ANALYZE command
  • examples [2]
• AND logical operator
  • in a condition
  • truth table
• ANSI
  • American National Standards Institute
  • datatypes
  • X3.135-1992
• ANY comparison operator
• ARCHIVE LOG clause
  • examples [2]
  • of ALTER SYSTEM command
• ARCHIVELOG option
  • of ALTER DATABASE command
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• archiving redo log files
  • disabling
  • enabling
• arithmetic operator
• arithmetic, with DATE values
• AS clause
  • of CREATE SNAPSHOT command
  • of CREATE TABLE command
  • of CREATE VIEW command
• ASC option
  • of CREATE INDEX command
  • of ORDER BY clause
• ASCII
  • and EBCDIC
  • character function
  • character set
• AT clause
  • of COMMIT command
  • of CONNECT command
  • of DECLARE CURSOR command
  • of DECLARE STATEMENT command
  • of EXECUTE command
  • of EXECUTE IMMEDIATE command
  • of INSERT command
  • of ROLLBACK command
  • of SAVEPOINT command
  • of SELECT command
  • of UPDATE command
• AUDIT command [2] [3]
  • examples [2]
• AUDIT object auditing option
• AUDIT_TRAIL
• AUTOEXTEND clause
  • of ALTER DATABASE command
  • of CREATE DATABASE command
• AUTOEXTEND, datafile size in tablespace [2]
• AUTOMATIC option, of RECOVER clause
• AVG group function

  B

• B format element
• B.C. format element
• BACKUP CONTROLFILE clause, of ALTER DATABASE command
• BC format element
• BEFORE option, of CREATE TRIGGER command
• BEGIN BACKUP option, of ALTER TABLESPACE command
• BETWEEN comparison operator [2]
• blank-padded comparison semantics
• block size, effect on PCTINCREASE
• BODY option
  • of ALTER PACKAGE command
  • of DROP PACKAGE command
• BY ACCESS option, of AUDIT command [2]
• BY clause
  • of AUDIT command
  • of NOAUDIT command
• BY SESSION option, of AUDIT command [2]

  C

• C format element
• CACHE parameter
  • of CREATE SEQUENCE command
  • of CREATE SEQUENCE command
• CACHE_INSTANCES parameter, of ALTER SYSTEM command
• CANCEL option, of RECOVER clause
• capitalizing, date format elements
• cartesian product
• CASCADE CONSTRAINTS option
  • of DROP CLUSTER command
  • of DROP TABLE command
  • of DROP TABLESPACE command
  • of REVOKE command
• CASCADE option
  • of ANALYZE command
  • of DISABLE clause
  • of DROP clause
  • of DROP USER command
• case sensitivity
  • in pattern matching
  • in SQL statements
• CATEXP.SQL
• CEIL number function [2]
• century, storing
• change display format, format model
• CHANGE parameter, of ARCHIVE LOG clause
• changing
  • goal for the cost-based optimization approach
  • optimization approach
  • passwords
• CHAR datatype
  • comparing values of
• CHARACTER datatype
  • in V6
• CHARACTER SET parameter, of CREATE DATABASE command
• character, character sets [2]
  • comparison rules
  • datatypes
  • literal
  • operator
  • SQL functions
• CHARTOROWID conversion function
• CHECK constraint
• CHECK constraints
• CHECK DATAFILES clause, of ALTER SYSTEM command
• CHECK OPTION, of CREATE VIEW command
• CHECKPOINT clause, of ALTER SYSTEM command [2]
• CHR character function
• CLEAR LOGFILE clause, of ALTER DATABASE command
• CLOSE command
  • examples
• CLOSE DATABASE LINK clause, of ALTER SESSION command
• CLOSE_OPEN_CACHED_CURSORS clause, of ALTER SESSION command
• closing
  • cursors
  • database links
  • database links
• CLUSTER clause
  • of CREATE SNAPSHOT command
  • of CREATE TABLE command
• cluster keys
  • distinct values of
• CLUSTER option
  • of ANALYZE command
  • of CREATE INDEX command
  • of TRUNCATE command
• clusters
  • adding snapshots to
  • adding tables to [2]
  • altering
  • cluster indexes
  • creating
  • definition
  • dropping
  • indexed clusters [2]
  • order of columns in
  • physical storage of tables in
  • removing tables from
  • size
  • specifying tablespaces for
  • storage characteristics of
  • storage characteristics of [2] [3] [4] [5] [6]
  • truncating
• column constraints
• column_constraint, syntax
• columns, adding comments to [2]
  • adding integrity constraints to [2]
  • adding to tables [2] [3]
  • changing datatypes of [2] [3] [4]
  • changing default values of [2]
  • defining
  • maximum number in a table
  • maximum number in indexes
  • of cluster keys
  • order in indexes
  • qualifying names with tables and schemas
  • redefining [2] [3] [4]
  • removing integrity constraints from
  • removing comments from
  • removing integrity constraints from
  • renaming
  • selecting from tables
  • specifying datatypes for
  • vs. pseudocolumns
• COMMENT clause, of COMMIT command [2]
• COMMENT command
  • examples
• COMMENT object auditing option
• comments
  • adding to objects
  • examples
  • removing from objects
  • within SQL statements
• COMMIT command [2] [3]
  • ending a transaction [2] [3]
  • examples [2] [3]
  • summary
• COMMIT option, of ADVISE clause
• committing, transactions [2]
• comparison operators
• comparison rules
• comparison semantics
  • blank-padded
  • non-padded
• compatibility mode
• COMPILE option, of ALTER FUNCTION command [2] [3]
  • of ALTER PROCEDURE command
  • of ALTER VIEW command
• compiling
  • packages
  • procedures
  • stored functions
• COMPLETE option, of REFRESH clause [2]
• complex snapshots
• COMPOSITE_LIMIT parameter, of CREATE PROFILE command
• COMPUTE STATISTICS option, of ANALYZE command
• CONCAT character function [2]
• condition
  • example
  • multiple
  • syntax
• CONNECT BY clause
  • examples
  • of SELECT command [2] [3]
• CONNECT command
  • examples
• CONNECT role
• CONNECT statement auditing short cut
• CONNECT TO clause, of CREATE DATABASE LINK command
• CONNECT_TIME parameter
  • of ALTER RESOURCE COST command
  • of CREATE PROFILE command
• constant, literal
• CONSTRAINT clause
  • examples [2]
  • syntax
• CONSTRAINT identifier, of CONSTRAINT clause [2]
  • of WITH CHECK OPTION clause
• CONSTRAINT option
  • of DISABLE clause
  • of DROP clause
• constraints, Integrity constraints
• CONTINUE option
  • of RECOVER clause
  • of WHENEVER command
• control files, reusing
• CONTROL_FILES
• CONTROLFILE REUSE option, of CREATE DATABASE command
• controlfile, standby database
• CONVERT conversion function
• CONVERT option, of ALTER DATABASE command
• converting values
  • explicitly [2]
  • implicitly [2]
• correlated subqueries [2]
  • examples
• correlated update
• COSH number function
• cost, of executing SQL statements
• COUNT group function
• CPU_PER_CALL parameter, of CREATE PROFILE command
• CPU_PER_SESSION parameter, of CREATE PROFILE command
• CREATE CLUSTER command [2]
  • examples
• CREATE CONTROLFILE command
  • examples
• CREATE DATABASE command [2]
  • examples
• CREATE DATABASE LINK command [2]
• CREATE DATAFILE clause, of ALTER DATABASE command
• CREATE FUNCTION command
• CREATE INDEX command [2]
• CREATE PACKAGE BODY command
  • examples
• CREATE PACKAGE command
  • examples
• CREATE PROCEDURE command
• CREATE PROFILE command
  • examples
• CREATE ROLE command
  • examples
• CREATE ROLLBACK SEGMENT command [2]
  • examples
• CREATE SCHEMA command
  • examples
• CREATE SEQUENCE command
  • examples
• CREATE SNAPSHOT command
  • examples
• CREATE SNAPSHOT LOG command
  • examples
• CREATE SYNONYM command
  • examples
• CREATE TABLE command [2]
  • examples [2]
  • part of CREATE SCHEMA command
• CREATE TABLESPACE command [2]
  • examples
• CREATE TRIGGER command
  • examples [2]
• CREATE USER command
  • examples
• CREATE VIEW command
  • examples
  • part of CREATE SCHEMA command
• creating
  • clusters
  • database links
  • databases
  • dispatcher processes (DISP)
  • indexes
  • packages [2]
  • procedures
  • profiles
  • roles
  • rollback segments
  • savepoints [2]
  • schemas
  • sequences
  • shared server processes
  • snapshot logs
  • snapshots
  • stored functions
  • synonyms
  • tables
  • tablespaces
  • triggers
  • users
  • views
• CURRENT OF clause
  • of embedded SQL DELETE command
  • of embedded SQL UPDATE command
• CURRENT option, of ARCHIVE LOG clause
• CURRVAL pseudocolumn
  • examples [2] [3]
• cursor variable [2]
• cursors
  • allocating
  • closing
  • fetching rows from
  • opening
  • storing in session cache
• CYCLE option, of CREATE SEQUENCE command

  D

• D format element
• data complexity, hiding with a view
• data definition language (DDL)
• data independence, via synonyms
• data manipulation language (DML)
• database links, closing [2] [3]
  • creating
  • definition
  • dropping
  • using in DELETE command [2]
  • using in INSERT command [2]
  • using in LOCK TABLE command
  • using in SELECT command [2]
  • using in UPDATE command [2]
  • using with synonyms
• database objects, definition of
• DATABASE option, of RECOVER clause
• DATABASE parameter, of CREATE CONTROLFILE command
• database
  • deleting rollback segments from
  • disconnecting from, embedded SQL
• databases, adding datafiles to [2]
  • adding redo log files to [2]
  • altering
  • archiving redo log files [2] [3] [4]
  • creating
  • maximum number [2]
    • of instances
    • of redo log files [2]
  • mounting and dismounting
  • opening and closing
  • renaming
  • reusing control files
• DATAFILE clause
  • of ALTER DATABASE command
  • of CREATE CONTROLFILE clause
  • of CREATE DATABASE command
  • of CREATE TABLESPACE command
• DATAFILE option, of RECOVER clause
• DATAFILE parameter, of ALLOCATE EXTENT clause [2] [3]
• datafiles
  • adding
  • adding to databases [2]
  • adding to tablespaces [2]
  • backing up [2] [3]
  • maximum number [2]
  • renaming [2] [3]
  • specifying
• datatypes [2]
  • ANSI
  • changing for columns [2]
  • converting between values of different
  • converting between with SQL functions
  • DB2
  • explicit conversion
  • implicit conversion
  • of conditions
  • of expressions
  • specifying for columns [2]
  • SQL/DS
  • summary
  • user-defined type equivalencing
• DATE datatype
  • comparing values of
  • julian
• DATE format element
• date format elements
  • capitalizing
• date format model
  • default
  • examples [2] [3]
  • modifiers
  • suffixes
• date
  • arithmetic
  • comparison rules
• DAY format element
• DB2, datatypes
• DB_FILES
• DBA role [2]
• DBA statement auditing short cut
• DBA_CLUSTERS view
• DBA_INDEXES view
• DBA_TAB_COLUMNS view
• DBA_TABLES view
• DBHIGH parameter, of ALTER DATABASE command
• DBHIGH predefined label
• DBLOW parameter, of ALTER DATABASE command
• DBLOW predefined label
• DBMAC parameter, of ALTER DATABASE command [2]
• DBMS MAC mode
• DBMS_SNAPSHOT.REFRESH() procedure
• DBMSSNAP.SQL [2]
• DBMSSTDX.SQL [2] [3] [4] [5]
• DDL (data definition language)
• decimal places, negative
• DECLARE CURSOR command
  • examples
• DECLARE DATABASE command
• DECLARE STATEMENT command
  • examples
  • scope of
• DECLARE TABLE command
  • examples
• DECODE expression
• DEFAULT option, of ALTER PROFILE command [2] [3] [4] [5] [6]
  • of AUDIT command
  • of CREATE PROFILE command
  • of CREATE TABLE command
  • of RECOVER clause
• default privilege domain
• DEFAULT profile [2] [3] [4] [5]
• DEFAULT ROLE clause, of ALTER USER command [2]
• DEFAULT STORAGE clause, of ALTER TABLESPACE clause [2]
  • of CREATE TABLESPACE command [2]
• DEFAULT TABLESPACE clause
  • of ALTER USER command
  • of CREATE USER command
• default, cluster key
• DELETE command [2] [3]
  • embedded SQL examples
  • summary
• DELETE object auditing option
• DELETE object privilege
  • on tables
  • on views
• DELETE option, of CREATE TRIGGER command [2]
• DELETE STATISTICS option, of ANALYZE command
• deleting
  • rows from tables
  • rows from tables and views
• delimited names, quoted names
• DESC option
  • of CREATE INDEX command
  • of ORDER BY clause
• DESCRIBE command
  • example
  • use with PREPARE command
• descriptor, naming
• DISABLE clause
  • examples
  • of ALTER DATABASE command
  • of ALTER TABLE command
  • of CREATE TABLE command
• DISABLE COMMIT IN PROCEDURE option, of ALTER SESSION command
• DISABLE DISTRIBUTED RECOVERY option, of ALTER SYSTEM command
• DISABLE option
  • of ALTER TRIGGER command
  • of CONSTRAINT clause
• DISABLE RESTRICTED SESSION option, of ALTER SYSTEM command
• disabling
  • distributed recovery
  • integrity constraints [2] [3]
  • redo log threads
  • resource limits [2] [3]
  • roles for sessions
  • SQL trace facility for sessions [2]
  • table locks [2]
  • triggers
• disconnect from database
  • ending a transaction
  • with the RELEASE option of ROLLBACK
• dispatcher processes (DISP), creating and terminating [2]
• DISTINCT clause, with ORDER BY clause
• DISTINCT option
  • of SELECT command
  • of SQL group functions
• distributed query, examples
• distributed query
  • restrictions on
• distributed recovery, disabling [2]
  • enabling in a single-process environment [2]
  • enabling in single-process environments
• distributed transactions [2]
• DML (data manipulation language)
• DO option, of WHENEVER command
• DROP clause
  • examples
  • of ALTER TABLE command
• DROP CLUSTER command
  • examples
• DROP DATABASE LINK command
  • examples
• DROP FUNCTION command
  • examples
• DROP INDEX command
  • examples
• DROP LOGFILE clause, of ALTER DATABASE command
• DROP LOGFILE MEMBER clause, of ALTER DATABASE command
• DROP PACKAGE command
• DROP PROCEDURE command
  • examples [2]
• DROP PROFILE command
  • examples
• DROP ROLE command
  • examples
• DROP ROLLBACK SEGMENT command [2]
  • examples
• DROP SEQUENCE command
  • examples
• DROP SNAPSHOT command
  • examples
• DROP SNAPSHOT LOG command
  • examples
• DROP STORAGE option, of TRUNCATE command
• DROP SYNONYM command
  • examples
• DROP TABLE command [2]
  • examples
• DROP TABLESPACE command
  • examples
• DROP TRIGGER command
  • examples
• DROP USER command
  • examples
• DROP VIEW command, examples
• dropping
  • clusters
  • database links
  • indexes
  • integrity constraints from tables [2] [3]
  • members from redo log file groups
  • objects contained in tablespaces
  • objects owned by users
  • package bodies
  • packages
  • procedures
  • profiles
  • redo log file groups
  • roles
  • sequences
  • snapshots
  • snapshots logs
  • stored functions
  • synonyms
  • tables
  • tablespaces [2]
  • triggers from tables
  • users
  • views
• DUAL data dictionary table
  • definition
  • example of selecting from
• DUMMY column, of DUAL table
• DUMP function
• DY format element
• dynamic performance tables, V$LOG [2]
  • V$NLS_PARAMETERS

  E

• EBCDIC
  • and ASCII
  • character set
• EEEE format element
• embedded SQL
  • DECLARE CURSOR command
  • DECLARE DATABASE command
  • DECLARE TABLE command
  • EXECUTE command
• embedded SQL
  • ALLOCATE command
  • CLOSE command
  • COMMIT command
  • CONNECT command
  • DECLARE STATEMENT command
  • DELETE command
  • DESCRIBE command
  • EXECUTE command
  • EXECUTE IMMEDIATE command
  • FETCH command
  • INSERT command
  • OPEN command
  • PREPARE command
  • ROLLBACK command
  • SAVEPOINT command
  • SELECT command
  • terms
  • TYPE command
  • UPDATE command
  • VAR command
  • WHENEVER command
• embedding, PL/SQL blocks in Oracle7 precompiler programs
• ENABLE clause
  • examples
  • of ALTER DATABASE command
  • of ALTER TABLE command
  • of CREATE TABLE command
• ENABLE COMMIT IN PROCEDURE option, of ALTER SESSION command
• ENABLE DISTRIBUTED RECOVERY option
  • of ALTER SYSTEM command
  • of ALTER SYSTEM command
• ENABLE option, of ALTER TRIGGER command
• ENABLE RESTRICTED SESSION option, of ALTER SYSTEM command
• ENABLE TABLE LOCK clause, of ALTER TABLE command [2]
• enabling, distributed recovery [2] [3]
  • integrity constraints [2] [3]
  • redo log threads
  • resource limits [2] [3] [4]
  • roles for sessions
  • SQL trace facility for sessions
  • SQL trace facility for sessions
  • triggers
• END BACKUP option, of ALTER TABLESPACE command
• END BACKUP, of ALTER DATABASE command
• ending, transactions [2]
• ENTRYID option, of USERENV function
• equijoins
• equivalencing
  • host variable equivalencing
  • user-defined type equivalencing
• error detection, error reporting
• error reporting, WHENEVER command
• ESCAPE character, of LIKE operator
• ESTIMATE STATISTICS option, of ANALYZE command
• examples, of comments
• EXCEPT clause
  • of ALTER USER command
  • of SET ROLE command
• EXCEPTIONS option, of ENABLE clause
• exclusive lock
• EXCLUSIVE option
  • of ALTER DATABASE command
  • of CREATE DATABASE command
• EXECUTE command [2]
  • examples [2]
• EXECUTE IMMEDIATE command
  • examples
• EXECUTE object auditing option
• EXECUTE object privilege, on procedures, functions, and packages
• executing, triggers
• EXISTS comparison operator
• EXP number function
• EXPLAIN PLAN command
  • examples
  • summary
  • syntax
• explicit commit or rollback
• expression
  • examples
  • use in condition
• extents, allocating for tables [2]
  • deallocating space
  • INITIAL size
  • MAXEXTENTS limit
• EXTERNALLY option
  • of IDENTIFIED clause
  • of IDENTIFIED clause [2] [3]

  F

• FALSE option, of SET RESOURCE_LIMIT clause
• FALSE, result of a condition
• FAST option, of REFRESH clause [2]
• Federal Information Processing Standard (FIPS)
• FETCH command
  • examples
  • used after OPEN command
• fetching, rows from cursors
• filespec
  • examples
• fill mode, trims trailing blanks
• FIPS
• FIPS Flagger
• FIPS
  • Federal Information Processing Standard
  • flagging
  • PUB 127-2
• firing, triggers
• FLAGGER clause, of ALTER SESSION command
• FLOAT, ANSI datatype
• FLOOR number function
• FLUSH SHARED_POOL option, of ALTER SYSTEM command
• FM date format element prefix, examples
• FM format model modifier
• FOR clause
  • of embedded SQL EXECUTE command
  • of embedded SQL INSERT command
  • of EXPLAIN PLAN command
• FOR EACH ROW option, of CREATE TRIGGER command
• FOR UPDATE clause, of SELECT command [2]
• FOR UPDATE OF, example
• FORCE clause, of COMMIT command [2]
  • of ROLLBACK command [2]
• FORCE option
  • of CREATE VIEW command
  • of REFRESH clause [2]
• foreign key constraints
• format model
  • date
  • definition
  • examples [2] [3] [4] [5]
  • number
• formatting
  • date values
  • number values
• FREELIST GROUPS parameter, of STORAGE clause
• FREELISTS parameter, of STORAGE clause
• FROM clause, of REVOKE command [2]
• FROM parameter, of RECOVER clause
• functions
  • PL/SQL
  • SQL
  • stored functions
  • user
• FX format model modifier

  G

• G format element
• GLB group function
• GLOBAL option
  • of CHECK DATAFILES clause
  • of CHECKPOINT clause
• GLOBAL_NAMES
• GLOBAL_NAMES parameter, of ALTER SYSTEM command
• GOTO option, of WHENEVER command
• GRANT command [2] [3] [4]
  • examples [2]
  • part of CREATE SCHEMA command
• GRANT object auditing option
• GRANT OPTION, of GRANT command
• granting
  • object privileges to users and roles
  • roles
  • system privileges and roles to users, roles
• GRAPHIC datatype
• GREATEST function
• GREATEST_LB function
• GROUP BY clause
  • group SQL functions and
  • of SELECT command [2]
• GROUP parameter
  • of ADD LOGFILE MEMBER clause
  • of DROP LOGFILE clause
• group, SQL functions

  H

• HASH parameter, of CREATE CLUSTER command
• HAVING clause, of SELECT command [2]
• HEXTORAW conversion function
• hints
  • in DELETE statements
  • in SELECT statements [2]
  • in UPDATE statements [2]
• HOLD_CURSOR option, of ORACLE Precompilers
• host variables
  • host variable equivalencing
  • in EXECUTE command
  • in OPEN command

  I

• I date format element
• IDENTIFIED clause
  • of ALTER USER command
  • of CREATE ROLE command
  • of CREATE USER command
• identifiers, names
• IDLE_TIME parameter, of CREATE PROFILE command
• IEC (International Electrotechnical Commission)
• IMMEDIATE option, of ALTER TABLESPACE command
• IN comparison operator
  • definition
• INCLUDING CONTENTS option, of DROP TABLESPACE command
• INCLUDING TABLES option, of DROP CLUSTER command
• INCREMENT BY clause, of CREATE SEQUENCE command
• incrementing, sequence values [2]
• INDEX object auditing option
• INDEX object privilege, on tables
• INDEX option
  • of ANALYZE command
  • of CREATE CLUSTER command
• INDEX_STATS view
• indexed clusters [2]
• indexes
  • altering
  • and LIKE operator
  • cluster indexes
  • creating
  • definition
  • dropping [2]
  • LONG RAW datatypes prohibit
  • multiple per table
  • storage characteristics of [2] [3] [4]
• indexing, specifying tablespaces for
• INIT.ORA parameters, initialization parameters
• INITCAP character function
• INITIAL parameter, of STORAGE clause [2]
• initialization parameters, NLS_TERRITORY
• initialization parameters
  • AUDIT_TRAIL
  • CONTROL_FILES
  • DB_FILES
  • GLOBAL_NAMES
  • INSTANCES
  • LOG_FILES
  • MAX_ENABLED_ROLES
  • MTS_DISPATCHERS
  • MTS_MAX_DISPATCHERS
  • MTS_MAX_SERVERS
  • MTS_SERVERS
  • NLS_DATE_FORMAT
  • NLS_DATE_LANGUAGE
  • NLS_LANGUAGE
  • NLS_TERRITORY [2]
  • OPEN_LINKS [2]
  • OPTIMIZER_MODE
  • OS_AUTHENT_PREFIX
  • OS_ROLES
  • ROLLBACK_SEGMENTS
  • SNAPSHOT_REFRESH_INTERVAL
  • SNAPSHOT_REFRESH_KEEP_CONNECTIONS
  • SNAPSHOT_REFRESH_PROCESSES
  • SQL_TRACE
  • THREAD
• INITRANS parameter
  • of ALTER CLUSTER command
  • of ALTER INDEX command
  • of ALTER SNAPSHOT command
  • of ALTER TABLE command
  • of CREATE CLUSTER command
  • of CREATE INDEX command
  • of CREATE SNAPSHOT command [2]
  • of CREATE TABLE command
• INSERT command [2] [3] [4]
  • embedded SQL examples
  • examples [2] [3]
  • summary
• INSERT object auditing option
• INSERT object privilege
  • on tables
  • on views
• INSERT option, of CREATE TRIGGER command [2]
• inserting, rows into tables and views [2]
• INSTANCE clause, of ALTER SESSION command
• INSTANCE parameter, of ALLOCATE EXTENT clause [2] [3]
• INSTANCES
  • maximum number
• INSTR character function
• INSTRB character function
• INTEGER datatype
• integrity constraints, adding to columns [2]
  • adding to tables [2] [3]
  • CHECK [2]
  • column definition
  • creating as parts of tables
  • defining
  • definition
  • disabling [2] [3] [4]
  • dropping from tables
  • enabling [2] [3]
  • NOT NULL
  • PRIMARY KEY [2]
  • referential [2]
  • removing from columns [2]
  • table definition [2] [3] [4]
  • UNIQUE [2]
• International Electrotechnical Commission (IEC)
• International Standards Organization (ISO)
• INTERSECT set operator
  • examples
• INTO clause
  • of ANALYZE command
  • of EXPLAIN PLAN command
  • of FETCH command
  • of SELECT command
• IS NOT NULL comparison operator
• IS NULL comparison operator [2]
• ISDBA option, of USERENV function
• ISO
  • International Standards Organization
  • ISO/IEC 9075:1992
• IW date format element
• IY date format element
• IYY date format element
• IYYY date format element

  J

• join view
• joins
  • and clusters
  • examples [2]
  • simple
• julian dates

  K

• KILL SESSION clause, of ALTER SYSTEM command

  L

• L format element
• LABEL option, of USERENV function
• LABEL parameter, of ALTER SESSION command
• LANGUAGE option, of USERENV function
• LAST_DAY date function
• LEAST function
• LEAST_UB function
• LENGTH character function
• LENGTHB character function
• LEVEL pseudocolumn
  • in SELECT command
• lexical conventions, SQL
• LICENSE_MAX_SESSION parameter, of ALTER SYSTEM command
• LICENSE_MAX_USERS parameter, of ALTER SYSTEM command
• LICENSE_SESSIONS_WARNING parameter, of ALTER SYSTEM command
• LIKE comparison operator [2] [3]
  • definition
• links, database links
• LIST option, of ANALYZE command
• literal
  • character
  • definition of
  • numeric
• LN number function
• LOCAL option
  • of CHECK DATAFILES clause
  • of CHECKPOINT clause
• location transparency, via synonyms
• LOCK object auditing option
• LOCK TABLE command [2]
  • examples
  • summary
• lock
  • and queries
  • exclusive
• locking, tables and views
• lock
  • multiple
  • released by ROLLBACK statement
  • releasing with COMMIT command
  • table
  • types of
• LOG number function
• LOG_FILES
• logarithms
  • LN number function
  • LOG number function
• LOGFILE clause
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• LOGFILE parameter
  • of ARCHIVE LOG clause
  • of RECOVER clause
• logical operator
  • definition
  • use in condition
• logical Unit of Work
• LOGICAL_READS_PER_CALL parameter, of CREATE PROFILE command
• LOGICAL_READS_PER_SESSION parameter
  • of CREATE PROFILE command
  • of ALTER RESOURCE COST command
• LONG datatype
  • maximum length
  • restrictions on
• LONG RAW datatype
  • indexing prohibited on
  • similarity to LONG datatype
• LONG VARGRAPHIC datatype
• LOWER character function [2]
• lowercase and uppercase
  • of object names
  • significance in pattern matching
• lowercase, significance in SQL statements
• LPAD character function
• LTRIM character function
• LUB group function

  M

• MAC mode [2]
• MAX group function
• MAX_ENABLE_ROLES
• MAXDATAFILES parameter
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• MAXEXTENTS parameter, of STORAGE clause [2]
• MAXINSTANCES parameter
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• MAXLOGFILES parameter
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• MAXLOGHISTORY parameter
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• MAXLOGMEMBERS parameter
  • of CREATE DATABASE command
  • of CREATE CONTROLFILE command
• MAXSIZE clause, of ALTER DATABASE command
• MAXTRANS parameter
  • of ALTER CLUSTER command
  • of ALTER INDEX command
  • of ALTER SNAPSHOT command
  • of ALTER TABLE command
  • of CREATE CLUSTER command
  • of CREATE INDEX command
  • of CREATE SNAPSHOT command [2]
  • of CREATE TABLE command
• MAXVALUE parameter, of CREATE SEQUENCE command
• MI format element
• MIN group function
• MINEXTENTS parameter, of STORAGE clause
• MINUS set operator
  • examples
• MINVALUE parameter, of CREATE SEQUENCE command
• miscellaneous operators
• MLS_LABEL_FORMAT parameter, of ALTER SESSION command
• MLSLABEL datatype
• MOD number function
• MODIFY clause, of ALTER TABLE command
• modifying, column definitions [2] [3]
  • resource limits
• MON format element
• MONTH format element
• MONTHS_BETWEEN date function
• MOUNT option, of ALTER DATABASE command
• mounting, databases
• MTS_DISPATCHERS
• MTS_DISPATCHERS parameter, of ALTER SYSTEM command [2]
• MTS_MAX_DISPATCHERS
• MTS_MAX_SERVERS
• MTS_SERVERS
• MTS_SERVERS parameter
  • of ALTER SYSTEM command
  • of ALTER SYSTEM command
• multi-threaded server, managing processes for
• multi-threaded server, managing processes for [2]

  N

• names
  • for objects
  • lowercase and uppercase
• namespaces, for objects
• names, quoted
• naming objects
• National Institute for Standards and Technology (NIST)
• National Language Support (NLS), session settings [2]
• natural logarithms
• navigation, automatic
• negative scale
• NEW_TIME date function
• NEXT clause, of ALTER DATABASE command
• NEXT option, of ARCHIVE LOG clause
• NEXT parameter, of REFRESH clause [2]
  • of STORAGE clause
• NEXT_DAY date function [2]
• NEXTVAL pseudocolumn
  • examples [2] [3] [4]
• NIST, National Institute for Standards and Technology
• NLS_CALENDAR parameter, of ALTER SESSION command
• NLS_CURRENCY parameter, of ALTER SESSION command
• NLS_DATE_FORMAT parameter, of ALTER SESSION command
• NLS_DATE_LANGUAGE parameter, of ALTER SESSION command
• NLS_INITCAP character function
• NLS_ISO_CURRENCY parameter, of ALTER SESSION command
• NLS_LANGUAGE parameter, of ALTER SESSION command
• NLS_LOWER character function
• NLS_NUMERIC_CHARACTERS parameter, of ALTER SESSION command
• NLS_SORT parameter, of ALTER SESSION command
• NLS_TERRITORY parameter, of ALTER SESSION command
• NLS_UPPER character function
• NLSSORT character function [2]
• NOARCHIVELOG option
  • of ALTER DATABASE command
  • of CREATE CONTROLFILE command
  • of CREATE DATABASE command
• NOAUDIT command [2]
  • examples [2]
• NOCACHE option, of CREATE SEQUENCE command
• NOCYCLE option, of CREATE SEQUENCE command
• NOFORCE option, of CREATE VIEW command
• NOMAXVALUE option, of CREATE SEQUENCE command
• NOMINVALUE option, of CREATE SEQUENCE command
• non-padded comparison semantics
• NONE option
  • of DEFAULT ROLE clause
  • of SET ROLE command
• NOORDER option, of CREATE SEQUENCE command
• NORESETLOGS option
  • of ALTER DATABASE command
  • of CREATE CONTROLFILE command
• normal exit from Oracle7
• NORMAL option, of ALTER TABLESPACE command
• NOSORT option, of CREATE INDEX command [2]
• NOT FOUND condition, of WHENEVER command
• NOT IN comparison operator
  • examples
• NOT LIKE comparison operator
• NOT logical operator
  • truth table
• NOT NULL clause, ALTER TABLE command
• NOT NULL constraints
• NOT option, of WHENEVER clause [2] [3] [4] [5]
• NOWAIT option
  • of FOR UPDATE clause
  • of LOCK TABLE command
• null
• NULL value, of OPTIMAL parameter [2]
• NULL
  • constraint, example
  • in a condition
  • in an index
• NUMBER datatype
  • comparing values of
• number format elements
• number format models
  • examples
• number, comparison rules [2]
  • literal
• numeric, literal
• NVL function [2]

  O

• object auditing options [2]
• object auditing short cuts
• object name, qualifiers
• object naming
• object privileges
  • granting to users and roles
  • on procedures, functions, and packages
  • on sequences
  • on snapshots
  • on synonyms
  • on tables
  • on views
  • revoking from users and roles
• object
  • naming
  • naming rules
• OF clause, of CREATE TRIGGER command
• OFFLINE option, of ALTER ROLLBACK SEGMENT command [2]
  • of ALTER TABLESPACE command
  • of CREATE TABLESPACE command [2]
  • of DATAFILE clause [2]
• ON clause, of CREATE TRIGGER command [2]
  • of GRANT command
  • of NOAUDIT command
  • of REVOKE command
• ONLINE option
  • of ALTER ROLLBACK SEGMENT command
  • of ALTER TABLESPACE command
  • of CREATE TABLESPACE command [2]
  • of DATAFILE clause
• OPEN command
  • examples [2]
• OPEN option, of ALTER DATABASE command
• OPEN_LINKS
• opening
  • cursors
  • databases
• operator
  • arithmetic
  • character
  • definition
  • logical [2] [3]
  • miscellaneous
  • NOT IN
  • set [2]
  • use in expression
• optimal size, of rollback segments [2]
• OPTIMIZER_GOAL parameter, of ALTER SESSION command
• OPTIMIZER_MODE
• optimizer
  • hints
  • SQL
• OR logical operator, truth table
• OR REPLACE option
  • of CREATE PACKAGE command
  • of CREATE FUNCTION command
  • of CREATE PACKAGE BODY command
  • of CREATE PROCEDURE command
  • of CREATE TRIGGER command
  • of CREATE VIEW command
• Oracle7 precompilers, embedded SQL
• ORDER BY clause
  • and ROWNUM pseudocolumn
  • of SELECT command [2]
• ORDER option, of CREATE SEQUENCE command
• OS MAC mode
• OS_AUTHENT_PREFIX, initialization parameter
• OS_ROLES
• outer join [2] [3]
• outer joins, examples
• overloading, procedures and stored functions [2]

  P

• P.M. format element
• package bodies, dropping
• PACKAGE option, of ALTER PACKAGE command
• package specifications
• packages [2] [3] [4]
• packages bodies
• packages
  • adding procedures to
  • adding stored functions to
  • auditing
  • creating [2]
  • creating package bodies for
  • creating package specifications for
  • creating synonyms for
  • dropping
  • granting object privileges on [2]
  • recompiling
  • redefining [2]
  • removing procedures from
  • removing stored functions from
  • revoking object privileges on
• PARALLEL clause
  • of RECOVER clause
• PARALLEL option, of ALTER DATABASE command
• parallel query clause
  • of ALTER TABLE command
  • of CREATE TABLE command
• parallel server, setting the instance
• PARALLEL_DEFAULT_SCANSIZE parameter
• parentheses
  • around expressions
  • overriding operator precedence
• parsing dynamic statements, PREPARE command
• partition views
• passwords
  • changing
  • establishing for users [2]
• pattern matching, definition
• PCTFREE parameter
  • of ALTER CLUSTER command
  • of ALTER SNAPSHOT command
  • of ALTER TABLE command
  • of CREATE CLUSTER command
  • of CREATE INDEX command
  • of CREATE SNAPSHOT command [2]
  • of CREATE TABLE command
• PCTINCREASE parameter, of STORAGE clause
• PCTUSED parameter
  • of ALTER CLUSTER command
  • of ALTER SNAPSHOT command
  • of ALTER TABLE command
  • of CREATE CLUSTER command
  • of CREATE SNAPSHOT command [2]
  • of CREATE TABLE command
• PL/SQL blocks, embedded in Oracle7 precompiler programs
• PL/SQL, functions
• PM format element
• POWER number function [2]
• PR format element
• precedence, definition
• precision, of NUMBER columns
• precompilers, embedded SQL
• PREPARE command
  • examples
• PRIMARY KEY option
  • of DISABLE clause
  • of DROP clause
  • of ENABLE clause
• primary keys [2]
• PRIOR operator
• PRIVATE_SGA parameter
  • of ALTER RESOURCE COST command
  • of CREATE PROFILE command
• privilege domain, changing
• privileges [2]
• procedures
  • adding to packages
  • auditing
  • creating
  • creating synonyms for
  • definition [2]
  • dropping
  • granting object privileges on
  • granting privileges on
  • overloading [2]
  • recompiling
  • redefining
  • removing from packages
  • revoking object privileges on
• PROFILE clause
  • of ALTER USER command
  • of CREATE USER command
• profiles, adding resource limits to [2]
  • altering
  • assigning to users [2] [3]
  • creating
  • DEFAULT profile [2] [3] [4]
  • definition [2]
  • dropping
  • modifying resource limits in
  • PUBLIC_DEFAULT profile [2] [3] [4] [5] [6]
  • removing resource limits from
• pseudocolumns
• PUBLIC option, of CREATE DATABASE LINK command [2]
  • of CREATE ROLLBACK SEGMENT command
  • of CREATE SYNONYM command
  • of DROP DATABASE LINK command [2]
  • of DROP SYNONYM command [2]
  • of ENABLE clause
  • of FROM clause [2]
  • of TO clause [2]
• public rollback segments
• PUBLIC_DEFAULT profile [2] [3] [4] [5]
• punctuation, in date format models

  Q

• queries
  • examples [2]
  • SELECT
• QUOTA clause
  • multiple in CREATE USER statement
  • of ALTER USER command
  • of CREATE USER command [2] [3]
• quote marks, using in text literals
• quoted names

  R

• RAW datatype
• RAWTOHEX conversion function
• RDBMS (relational database management system)
• read consistency, default
• READ ONLY option
  • of CREATE VIEW command
  • of SET TRANSACTION command
• READ WRITE option, of SET TRANSACTION command
• read-only mounts
• recompiling
  • packages
  • procedures
  • stored functions
• RECOVER clause
  • examples
  • of ALTER DATABASE command
• recoverability, of tables
• RECOVERABLE clause, of CREATE TABLE command
• RECOVERABLE keyword
• recovery
  • disabling for distributed transactions
  • disabling for distributed transactions
  • enabling for distributed transactions
  • enabling for distributed transactions [2]
• redefining
  • columns
  • packages [2]
  • procedures
  • stored functions
• redo log file members, maximum number, for redo log files
• redo log file groups
  • adding members to
  • adding to threads
  • assigning to redo log threads
  • assigning to redo log threads
  • dropping
  • dropping members from
  • maximum number
• redo log file members
  • adding to redo log file groups
  • dropping from redo log file groups
  • maximum number
  • renaming
  • specifying
• redo log files, adding to databases [2]
  • archiving [2] [3] [4] [5]
  • maximum number [2]
    • of members
  • specifying
  • switching [2] [3]
• redo log threads
  • adding redo log file groups to
  • assigning redo log file groups to
  • assigning redo log file groups to
  • disabling
  • dropping redo log file groups from
  • enabling
• REFERENCES object privilege, on tables
• REFERENCING clause, of CREATE TRIGGER command
• referential integrity constraints [2]
• REFRESH clause
  • of ALTER SNAPSHOT command
  • of CREATE SNAPSHOT command
• refresh modes, for snapshots
• refresh times, for snapshots
• refreshing, snapshots [2] [3]
  • snapshots with snapshot logs
• RELEASE_CURSOR option, of ORACLE Precompilers
• remote database, declaration of
• remote query
• remote table, identifying
• removing
  • comments from objects
  • integrity constraints from columns [2]
  • procedures from packages
  • resource limits from profiles
  • stored functions from packages
• RENAME command
  • examples
• RENAME DATAFILE clause, of ALTER TABLESPACE command
• RENAME FILE clause, of ALTER DATABASE command
• RENAME GLOBAL_NAME clause, of ALTER DATABASE command
• RENAME object auditing option
• renaming
  • databases
  • datafiles [2] [3]
  • objects
  • redo log file members
• REPLACE character function
• RESETLOGS option
  • of ALTER DATABASE command
  • of CREATE CONTROLFILE command
• RESIZE clause, of ALTER DATABASE command
• resource limits, adding to profiles [2]
  • assigning to users [2]
  • costs of resources
  • disabling [2] [3]
  • enabling [2] [3] [4]
  • exceeding
  • modifying
  • removing profiles from
• RESOURCE on tablespaces, QUOTA clause
• RESOURCE role
• RESOURCE statement auditing short cut
• RESOURCE_LIMIT option, of ALTER SYSTEM command [2]
• retrieving rows from a table, embedded SQL
• REUSE option
  • of BACKUP CONTROLFILE clause
  • of CREATE CONTROLFILE command
  • of filespec
• REUSE STORAGE option, of TRUNCATE command
• REVOKE command [2] [3]
  • examples [2]
• revoking
  • object privileges from users and roles
  • system privileges and roles from users, roles
• RN format element
• roles
  • CONNECT role
  • creating
  • DBA role
  • defined by ORACLE
  • defined by Oracle7
  • definition
  • dropping
  • enabling or disabling for sessions
  • establishing default roles for users [2] [3]
  • granting to users and roles
  • granting object privileges to
  • granting system privileges and roles to
  • RESOURCE role
  • revoking from users and roles
  • revoking object privileges from
  • revoking system privileges and roles from
• roll back
  • to a savepoint
  • to the same savepoint multiple times
• ROLLBACK command, ending a transaction
• ROLLBACK command [2] [3]
  • ending a transaction
  • examples [2]
  • summary
• ROLLBACK option, of ADVISE clause
• rollback segments
  • altering
  • creating
  • definition
  • dropping
  • optimal size of [2]
  • shrinking size [2] [3]
  • specifying tablespaces for [2]
  • storage characteristics of
  • SYSTEM rollback segment
  • taking online and offline [2] [3] [4]
• ROLLBACK_SEGMENTS
• rolling back, transactions [2]
• ROUND date function [2]
  • format models for
• ROUND number function
• rounding numeric data
  • by using scale
• row address, ROWID
• row exclusive locks
• row share locks
• ROWID
  • description of
  • pseudocolumn
• ROWIDTOCHAR conversion function
• ROWLABEL
• ROWLABEL column
• ROWLABEL, column
• ROWNUM pseudocolumn
  • and ORDER BY clause
• rows
  • accessing via ROWID
  • deleting from tables and views
  • fetching from cursors
  • identifying with ROWID values
  • inserting into tables and views [2]
  • ordering
  • selecting from tables
  • updating [2]
• RPAD character function
• RR date format element
• RTRIM character function
• RX locks

  S

• S format element
• SAMPLE parameter, of ANALYZE command
• SAVEPOINT command [2]
  • examples [2]
  • summary
• savepoints, creating [2]
  • erasing with COMMIT command
• scale
  • negative
  • of NUMBER columns
• SCAN_INSTANCES parameter, of ALTER SYSTEM command
• schema objects
  • definition of
  • namespaces for
• schemas, creating
• scope, of DECLARE STATEMENT command
• searching, for rows with an index
• security, provided by views
• SELECT clause
  • INSERT command
  • UPDATE command [2]
• SELECT command [2] [3]
  • embedded SQL examples
  • examples [2] [3] [4] [5] [6] [7] [8] [9] [10] [11]
  • summary
• select list
• SELECT object auditing option
• SELECT object privilege
  • on sequences
  • on tables
  • on views
• self joins
• SEQ parameter, of ARCHIVE LOG clause
• SEQUEL (Structured English Query Language)
• sequences
  • accessing values of [2] [3]
  • altering
  • auditing
  • creating
  • creating synonyms for
  • cycling values of
  • dropping
  • granting object privileges on [2]
  • increment between values [2]
  • incrementing values of [2] [3]
  • limiting values of
  • losing values of
  • performance benefits of
  • renaming
  • restarting
  • revoking object privileges on
  • skipping values of
• session control commands
• session cursors
• SESSION_CACHED_CURSORS
• SESSION_CACHED_CURSORS clause, of ALTER SESSION command
• SESSIONID option, of USERENV function
• SESSIONS_PER_USER parameter, of CREATE PROFILE command
• sessions
  • altering
  • beginning
  • closing database links for [2]
  • enabling and disabling roles for
  • enabling and disabling SQL trace facility for [2]
  • National Language Support (NLS) settings for [2]
  • terminating [2]
• SET clause
  • of UPDATE command
  • of EXPLAIN PLAN command
• SET DATABASE parameter, of CREATE CONTROLFILE command
• set operators
• SET ROLE command
  • examples
• SET TRANSACTION command [2]
  • examples
  • summary
• shadow processes, server processes
• share locks
• share row exclusive locks
• share update locks
• shared pool, clearing
• shared server processes, creating and terminating [2]
• shared SQL area, session cursors
• SHRINK clause, of ALTER ROLLBACK SEGMENT command [2]
• shrinking, rollback segments [2]
• SIGN number function
• simple join, example
• simple snapshots
• simultaneous update and query on tables
• SIN number function
• SINH number function
• SIZE parameter
  • of CREATE CLUSTER command
  • of ALLOCATE EXTENT clause [2] [3]
  • of ALTER CLUSTER command
  • of CREATE CLUSTER command
  • of filespec
• snapshot logs
  • altering
  • creating
  • definition
  • dropping
  • storage characteristics of [2] [3] [4]
• snapshot refresh processes
• SNAPSHOT_REFRESH_INTERVAL
• SNAPSHOT_REFRESH_KEEP_CONNECTIONS
• SNAPSHOT_REFRESH_PROCESSES
• snapshots
  • adding comments to
  • adding to clusters
  • altering
  • complex
  • creating
  • creating synonyms for
  • definition [2]
  • dropping
  • granting object privileges on [2]
  • refresh modes
  • refresh times
  • refreshing [2] [3]
  • refreshing with snapshot logs
  • removing comments from
  • revoking object privileges on
  • simple
  • storage characteristics of
  • storage characteristics of [2] [3]
  • types of
• SOME comparison operator
• SOUNDEX character function
• space, deallocating
• SQL (Structured Query Language)
• SQL functions
  • character
  • group
• SQL trace facility, enabling and disabling for sessions [2]
• SQL-92
• SQL.BSQ
• SQL/DS, datatypes
• SQL2
• SQL_CURSOR
• SQL_TRACE
• SQL
  • benefits of
  • compliance with standards
  • conversion functions
  • embedded
  • embedded terms
• SQLERROR, WHENEVER command condition
• SQL, functions [2]
  • history of
  • lexical conventions
  • optimizer
  • standards
  • standards compliance
  • summary of commands
  • unified language
• SQLWARNING, WHENEVER command condition
• SQRT number function
• SRX locks
• standard deviation
• standards, compliance
• standby database
  • ALTER DATABASE command
  • controlfile
  • RECOVER clause
• START WITH clause
  • of CREATE SEQUENCE command
  • of SELECT command [2] [3]
• START WITH parameter, of REFRESH clause [2]
• statement auditing options
• statement auditing short cuts
• STDDEV group function
• STOP option, of WHENEVER command
• storage characteristics
  • of snapshot logs
  • of clusters [2] [3] [4] [5] [6] [7]
  • of indexes [2] [3] [4] [5] [6]
  • of rollback segments [2]
  • of snapshot logs [2] [3]
  • of snapshots [2] [3] [4]
  • of tables [2] [3] [4] [5]
  • of tablespaces [2] [3]
• STORAGE clause [2] [3] [4] [5] [6]
  • examples
  • of ALTER CLUSTER command
  • of ALTER INDEX command [2]
  • of ALTER SNAPSHOT command
  • of ALTER TABLE command
  • of CREATE CLUSTER command
  • of CREATE INDEX command
  • of CREATE ROLLBACK SEGMENT command
  • of CREATE SNAPSHOT command [2]
  • of CREATE TABLE command
• storage, ALTER TABLESPACE
• stored functions
  • adding to packages
  • auditing
  • creating
  • creating synonyms for
  • definition
  • dropping
  • granting object privileges on [2]
  • overloading [2]
  • PL/SQL
  • recompiling
  • redefining
  • removing from packages
  • revoking object privileges on
• stored procedures, procedures
• subqueries
  • correlated
• SUBSTR character function
• SUM group function [2]
• suppressing blank padding, in date format models
• SWITCH LOGFILE option, of ALTER SYSTEM command [2]
• switching
  • redo log files
  • redo log files [2]
• SYEAR date format element
• synonyms
  • auditing
  • creating
  • creating synonyms for
  • definition
  • dropping
  • granting object privileges on [2]
  • renaming
  • revoking object privileges on
  • scope of
  • using with database links
• SYSDATE date function
• system change numbers, specifying for forced transactions
• system commit numbers, system change numbers
• system control commands
• system privileges
  • granting to users and roles
  • revoking from users and roles
• SYSTEM rollback segment
• SYSTEM tablespace [2]

  T

• table alias
• table constraints
  • example
• table locks, disabling [2]
• TABLE option
  • of ANALYZE command
  • of TRUNCATE command
• tables, adding columns to [2] [3]
  • adding comments to
  • adding integrity constraints to [2] [3]
  • adding to clusters
  • adding triggers to
  • aliases for
  • allocating extents for [2]
  • allowing writes
  • altering
  • auditing
  • creating
  • creating snapshot logs for
  • creating synonyms for [2]
  • creating views on
  • definition
  • deleting rows from [2] [3]
  • disallowing writes
  • dropping
  • dropping integrity constraints from
  • dropping triggers from
  • granting object privileges on [2]
  • inserting rows into [2]
  • locking
• TABLESPACE option
  • of CREATE CLUSTER command
  • of CREATE INDEX command
  • of CREATE ROLLBACK SEGMENT command
  • of CREATE SNAPSHOT command [2]
  • of CREATE TABLE command
  • of RECOVER clause
• tablespaces
  • altering
  • assigning to users
  • backing up
  • backing up [2]
  • changing future storage allocations
  • creating [2]
  • creating clusters in
  • creating indexes in
  • creating rollback segments in [2]
  • datafiles of [2] [3] [4]
  • dropping [2]
  • establishing default tablespaces for users [2] [3]
  • establishing tablespace quotas for users [2] [3]
  • establishing temporary tablespaces for users [2] [3]
  • specifying for tables
  • storage characteristics of [2]
  • storage characteristics of
  • SYSTEM tablespace [2]
  • taking online and offline [2] [3] [4] [5] [6] [7]
• tables
  • recoverability
  • redefining columns of
  • removing comments from
  • removing from clusters
  • renaming
  • revoking object privileges on
  • selecting data from
  • specifying tablespaces for
  • storage characteristics of
  • storage characteristics of [2] [3] [4] [5] [6] [7] [8]
  • truncating
  • unrecoverable
  • updating rows in [2]
• TAN number function
• TANH number function
• TEMPORARY option, of ALTER TABLESPACE command
• TEMPORARY TABLESPACE clause
  • of ALTER USER command
  • of CREATE USER command
• TERMINAL option, of USERENV function
• terminating
  • dispatcher processes (DISP)
  • sessions [2]
  • shared shadow processes
• text, definition of
• THREAD parameter
  • of ADD LOGFILE clause
  • of ARCHIVE LOG clause
• threads, redo log threads
• TO clause, of GRANT command [2]
  • of ROLLBACK command [2]
• TO parameter, of ARCHIVE LOG clause
• TO_CHAR conversion function [2] [3] [4]
  • examples [2] [3] [4] [5]
• TO_DATE conversion function [2]
  • examples
• TO_LABEL conversion function
• TO_MULTI_BYTE conversion function
• TO_NUMBER conversion function [2]
• TO_SINGLE_BYTE conversion function
• transaction control commands
• transactions [2]
  • committing [2]
  • distributed [2]
  • establishing as read-only
  • read consistency
  • read only
  • rolling back [2] [3]
• TRANSLATE character function
• triggered action
• triggers
  • creating
  • definition [2]
  • dropping from tables
  • enabling and disabling
  • executing
  • firing
  • LONG datatype
• TRUE option, of SET RESOURCE_LIMIT clause
• TRUE, result of a condition
• TRUNC date function [2]
  • format models for
• TRUNC number function
• TRUNCATE command
  • examples
• truncating
  • clusters
  • tables
• truth tables [2] [3]
• TYPE command
  • examples

  U

• UID function
• UNARCHIVED option, of CLEAR LOGFILE clause
• undo a transaction
• UNION ALL set operator
  • examples
• UNION set operator
  • examples
• unique keys [2]
• UNIQUE option
  • of DISABLE clause
  • of ENABLE clause
• UNLIMITED clause, of ALTER DATABASE command
• UNLIMITED option, of ALTER PROFILE command [2]
  • of CREATE PROFILE command
  • of QUOTA clause [2]
• unrecoverability, of tables
• UNRECOVERABLE
• UNRECOVERABLE clause, of CREATE TABLE command
• UNRECOVERABLE keyword
• UNTIL CANCEL option, of RECOVER clause
• UNTIL CHANGE parameter, of RECOVER clause
• UNTIL TIME parameter, of RECOVER clause
• UPDATE command [2] [3] [4]
  • embedded SQL examples
  • examples
  • subquery
• UPDATE object auditing options
• UPDATE object privilege
  • on tables
  • on views
• UPDATE option, of CREATE TRIGGER command [2]
• updating
  • rows in tables and views
  • rows in tables and views
• UPPER character function
• uppercase and lowercase, significance in pattern matching
• uppercase, significance in SQL statements
• USE ROLLBACK SEGMENT option, of SET TRANSACTION command
• user function [2]
  • expression syntax
• user functions
• user-defined type equivalencing
• USER_CLUSTERS view
• USER_INDEXES view
• USER_TAB_COLUMNS view
• USER_TABLES view
• USERENV function
• users
  • altering
  • assigning profiles to [2] [3]
  • assigning resource limits to [2]
  • assigning tablespaces to
  • changing passwords
  • creating
  • definition
  • dropping
  • establishing default roles for [2] [3]
  • establishing default tablespaces for [2] [3]
  • establishing passwords for [2]
  • establishing tablespace quotas for
  • establishing tablespace quotas for [2]
  • establishing temporary tablespaces for [2] [3]
  • granting object privileges to
  • granting system privileges and roles to
  • revoking object privileges from
  • revoking system privileges and roles from
• USING BACKUP CONTROLFILE parameter, of RECOVER clause
• USING clause
  • of CREATE DATABASE LINK command
  • of FETCH command
  • of OPEN command [2]
• using dbstring, SQL*Net database id specification
• USING INDEX option
  • of ALTER SNAPSHOT command
  • of CONSTRAINT clause
  • of CREATE SNAPSHOT command
  • of ENABLE clause
• UTLEXCPT.SQL
• UTLSAMPL.SQL
• UTLXPLAN.SQL

  V

• V format element
• V$LOG table [2]
• V$NLS_PARAMETERS table
• VALIDATE INDEX command
• VALIDATE STRUCTURE option, of ANALYZE command
• VALUES clause, of embedded SQL INSERT command [2]
  • of INSERT command [2] [3]
• value, use in expression
• VAR command
  • examples
• VARCHAR datatype
  • in V6
• VARCHAR2
• VARCHAR2 datatype
  • comparing values of
  • similarity to RAW datatype
• VARGRAPHIC datatype
• variable length, date format models
• views
  • adding comments to
  • and DML commands
  • auditing
  • creating
  • creating synonym for
  • definition
  • deleting rows from
  • dropping
  • granting object privileges on [2]
  • inserting rows into [2]
  • join views
    • updatable
  • locking
  • partition
  • redefining
  • removing comments from
  • renaming
  • revoking object privileges on
  • updating rows in [2]
  • uses of
• VSIZE function

  W

• WHEN clause, of CREATE TRIGGER command
• WHENEVER clause, of AUDIT command [2]
  • of NOAUDIT command [2]
• WHENEVER command
  • examples
• WHERE clause
  • of DELETE command
  • of SELECT command
  • of UPDATE command [2] [3]
• wildcard characters
  • in pattern matching
  • pattern matching
• WITH ADMIN OPTION
• WITH CHECK OPTION
• WITH GRANT OPTION
• WITH READ ONLY, CREATE VIEW
• WORK option
  • of ROLLBACK command
  • of COMMIT command [2]
  • of ROLLBACK command
• WW date format element

  X

  Y

• YEAR date format element
• year, storing

  Z