Index

A B C D E F G H I L M N O P Q R S T U V W X

Symbols

- (dash)

datetime format element, 7.1.2

. (period)

datetime format element, 7.1.2

/ (slash)

datetime format element, 7.1.2

SQL*Plus command, A.1

, (comma)

datetime format element, 7.1.2

: (colon)

datetime format element, 7.1.2

; (semicolon)

datetime format element, 7.1.2

@ (at sign)

SQL*Plus command, A.1

A

ABS function, 2.1

ACOS function, 2.1

ADD_MONTHS function, 2.1

ALTER CLUSTER, 1.1

ALTER DATABASE, 1.1

ALTER DIMENSION, 1.1

ALTER DISKGROUP, 1.1

ALTER FUNCTION, 1.1

ALTER INDEX, 1.1

ALTER INDEXTYPE, 1.1

ALTER JAVA, 1.1

ALTER MATERIALIZED VIEW, 1.1

ALTER MATERIALIZED VIEW LOG, 1.1

ALTER OPERATOR, 1.1

ALTER OUTLINE, 1.1

ALTER PACKAGE, 1.1

ALTER PROCEDURE, 1.1

ALTER PROFILE, 1.1

ALTER RESOURCE COST, 1.1

ALTER ROLE, 1.1

ALTER ROLLBACK SEGMENT, 1.1

ALTER SEQUENCE, 1.1, 1.1

ALTER SESSION, 1.1

ALTER SYSTEM, 1.1

ALTER TABLE, 1.1

ALTER TABLESPACE, 1.1

ALTER TRIGGER, 1.1

ALTER TYPE, 1.1

ALTER USER, 1.1

ALTER VIEW, 1.1

American National Standards Institute (ANSI)

datatypes

conversion to Oracle datatypes, 6.1.2

analytic_function function, 2.1

ANALYZE, 1.1

APPEND

SQL*Plus command, A.1

ASCII function, 2.1

ASCIISTR function, 2.1

ASIN function, 2.1

ASSOCIATE STATISTICS, 1.1

ATAN function, 2.1

ATAN2 function, 2.1

AUDIT, 1.1

AVG function, 2.1

B

BFILENAME function, 2.1

BIN_TO_NUM function, 2.1

BITAND function, 2.1

C

CALL, 1.1

CARDINALITY function, 2.1

CASE expressions, 3.1

CAST function, 2.1

CC datetime format element, 7.1.2

CEIL function, 2.1

CHANGE

SQL*Plus command, A.1

CHARTOROWID function, 2.1

CHR function, 2.1

COALESCE function, 2.1

COLLECT function, 2.1

COMMENT, 1.1

COMMIT, 1.1

COMPOSE function, 2.1

compound conditions, 4.1

compound expressions, 3.1

CONCAT function, 2.1

conditions, 4

see also SQL conditions

CONNECT

SQL*Plus command, A.1

CONVERT function, 2.1

CORR function, 2.1

CORR_K function, 2.1

CORR_S function, 2.1

COS function, 2.1

COSH function, 2.1

COUNT function, 2.1

COVAR_POP function, 2.1

COVAR_SAMP function, 2.1

CREATE CLUSTER, 1.1

CREATE CONTEXT, 1.1

CREATE CONTROLFILE, 1.1

CREATE DATABASE, 1.1

CREATE DATABASE LINK, 1.1

CREATE DIMENSION, 1.1

CREATE DIRECTORY, 1.1

CREATE DISKGROUP, 1.1

CREATE FUNCTION, 1.1

CREATE INDEX, 1.1

CREATE INDEXTYPE, 1.1

CREATE JAVA, 1.1

CREATE LIBRARY, 1.1

CREATE MATERIALIZED VIEW, 1.1

CREATE MATERIALIZED VIEW LOG, 1.1

CREATE OPERATOR, 1.1

CREATE OUTLINE, 1.1

CREATE PACKAGE, 1.1

CREATE PACKAGE BODY, 1.1

CREATE PFILE, 1.1

CREATE PROCEDURE, 1.1

CREATE PROFILE, 1.1

CREATE ROLE, 1.1

CREATE ROLLBACK SEGMENT, 1.1

CREATE SCHEMA, 1.1, 1.1

CREATE SEQUENCE, 1.1

CREATE SPFILE, 1.1

CREATE SYNONYM, 1.1

CREATE TABLE, 1.1

CREATE TABLESPACE, 1.1

CREATE TRIGGER, 1.1

CREATE TYPE, 1.1

CREATE TYPE BODY, 1.1

CREATE USER, 1.1

CREATE VIEW, 1.1

CUME_DIST (aggregate) function, 2.1

CUME_DIST (analytic) function, 2.1

currency

group separators, 7.1.1.1

currency symbol

ISO, 7.1.1.1

local, 7.1.1.1

union, 7.1.1.1

CURRENT_DATE function, 2.1

CURRENT_TIMESTAMP function, 2.1

CURSOR expression, 3.1

CV function, 2.1

D

date format models, 7.1.2, 7.1.2.1

datetime format elements, 7.1.2

long, 7.1.2.1

short, 7.1.2.1

DATETIME expressions, 3.1

datetime format elements, 7.1.2

DB2 datatypes

restrictions on, 6.1.2

DBTIMEZONE function, 2.1

DD datetime format element, 7.1.2

DDAY datetime format element, 7.1.2

DDD datetime format element, 7.1.2

decimal characters

specifying, 7.1.1.1

DECODE function, 2.1

DECOMPOSE function, 2.1

DEL

SQL*Plus command, A.1

DELETE, 1.1

DENSE_RANK (aggregate) function, 2.1

DENSE_RANK (analytic) function, 2.1

DEPTH function, 2.1

DEREF function, 2.1

DESCRIBE

SQL*Plus command, A.1

DISASSOCIATE STATISTICS, 1.1

DISCONNECT

SQL*Plus command, A.1

DROP CLUSTER, 1.1

DROP CONTEXT, 1.1

DROP DATABASE, 1.1

DROP DATABASE LINK, 1.1

DROP DIMENSION, 1.1

DROP DIRECTORY, 1.1

DROP DISKGROUP, 1.1

DROP FUNCTION, 1.1

DROP INDEX, 1.1

DROP INDEXTYPE, 1.1

DROP JAVA, 1.1

DROP LIBRARY, 1.1

DROP MATERIALIZED VIEW, 1.1

DROP MATERIALIZED VIEW LOG, 1.1

DROP OPERATOR, 1.1

DROP OUTLINE, 1.1

DROP PACKAGE, 1.1

DROP PROCEDURE, 1.1

DROP PROFILE, 1.1

DROP ROLE, 1.1

DROP ROLLBACK SEGMENT, 1.1

DROP SEQUENCE, 1.1

DROP SYNONYM, 1.1

DROP TABLE, 1.1

DROP TABLESPACE, 1.1

DROP TRIGGER, 1.1

DROP TYPE, 1.1

DROP TYPE BODY, 1.1

DROP USER, 1.1

DROP VIEW, 1.1

DUMP function, 2.1

DY datetime format element, 7.1.2

E

E datetime format element, 7.1.2

EDIT

SQL*Plus command, A.1

EE datetime format element, 7.1.2

EMPTY_BLOB function, 2.1, 2.1

EQUALS_PATH condition, 4.1

EXECUTE

SQL*Plus command, A.1

EXISTSNODE function, 2.1

EXIT

SQL*Plus command, A.1

EXP function, 2.1

EXPLAIN PLAN, 1.1

expressions, 3

see also SQL expressions

EXTRACT (datetime) function, 2.1

EXTRACT (XML) function, 2.1

EXTRACTVALUE function, 2.1

F

FF datetime format element, 7.1.2

FIRST function, 2.1

FIRST_VALUE function, 2.1

FLASHBACK DATABASE, 1.1

FLASHBACK TABLE, 1.1

floating-point condition, 4.1

FLOOR function, 2.1

format models, 7.1

date format models, 7.1.2

datetime format elements, 7.1.2

number format models, 7.1.1

number format elements, 7.1.1.1

FROM_TZ function, 2.1

functions, 2

see also SQL functions

G

GET

SQL*Plus command, A.1

GRANT, 1.1

GRAPHIC datatype

DB2, 6.1.2

SQL/DS, 6.1.2

GREATEST function, 2.1

group comparison condition, 4.1

group separator

specifying, 7.1.1.1

GROUP_ID function, 2.1

GROUPING function, 2.1

GROUPING_ID function, 2.1

H

HELP

SQL*Plus command, A.1

hexadecimal value

returning, 7.1.1.1

HEXTORAW function, 2.1

HH datetime format element, 7.1.2

HOST

SQL*Plus command, A.1

I

IN conditions, 4.1, 4.1

INITCAP function, 2.1

INPUT

SQL*Plus command, A.1

INSERT, 1.1

INSTR function, 2.1

INTERVAL expressions, 3.1

IS A SET conditions, 4.1

IS ANY condition, 4.1

IS EMPTY conditions, 4.1

IS OF TYPE conditions, 4.1

IS PRESENT condition, 4.1

ITERATION_NUMBER function, 2.1

L

LAG function, 2.1

LAST function, 2.1

LAST_DAY function, 2.1

LAST_VALUE function, 2.1

LEAD function, 2.1

LEAST function, 2.1

LENGTH function, 2.1

LIKE condition, 4.1

LIST

SQL*Plus command, A.1

LN function, 2.1

LNNVL function, 2.1

locale independent, 7.1.2.1

LOCALTIMESTAMP function, 2.1

LOCK TABLE, 1.1

LOG function, 2.1

logical conditions, 4.1

LONG VARGRAPHIC datatype

DB2, 6.1.2, 6.1.2

SQL/DS, 6.1.2

LOWER function, 2.1

LPAD function, 2.1

LTRIM function, 2.1

M

MAKE_REF function, 2.1

MAX function, 2.1

MEDIAN function, 2.1

MEMBER condition, 4.1

MERGE, 1.1

MIN function, 2.1

MOD function, 2.1

model expressions, 3.1

MONTHS_BETWEEN function, 2.1

N

NANVL function, 2.1

NCHR function, 2.1

NEW_TIME function, 2.1

NEXT_DAY function, 2.1

NLS_CHARSET_DECL_LEN function, 2.1

NLS_CHARSET_ID function, 2.1

NLS_CHARSET_NAME function, 2.1

NLS_INITCAP function, 2.1

NLS_LOWER function, 2.1

NLS_UPPER function, 2.1

NLSSORT function, 2.1

NOAUDIT, 1.1

NTILE function, 2.1

NULL conditions, 4.1

NULLIF function, 2.1

number format elements, 7.1.1.1

number format models, 7.1.1

number format elements, 7.1.1.1

NUMTODSINTERVAL function, 2.1

NUMTOYMINTERVAL function, 2.1

NVL function, 2.1

NVL2 function, 2.1

O

object access expressions, 3.1

ORA_HASH function, 2.1

P

PATH function, 2.1

PERCENT_RANK (aggregate) function, 2.1

PERCENT_RANK (analytic) function, 2.1

PERCENTILE_CONT function, 2.1

PERCENTILE_DISC function, 2.1

POWER function, 2.1

POWERMULTISET function, 2.1

POWERMULTISET_BY_CARDINALITY function, 2.1

PRESENTNNV function, 2.1

PRESENTV function, 2.1

PREVIOUS function, 2.1

PURGE, 1.1

Q

QUIT

SQL*Plus command, A.1

R

range conditions, 4.1

RANK (aggregate) function, 2.1

RANK (analytic) function, 2.1

RATIO_TO_REPORT function, 2.1

RAWTOHEX function, 2.1

RAWTONHEX function, 2.1

REF function, 2.1

REFTOHEX function, 2.1

REGEXP_INSTR function, 2.1

REGEXP_LIKE condition, 4.1

REGEXP_REPLACE function, 2.1

REGEXP_SUBSTR function, 2.1

REGR_AVGX function, 2.1

REGR_AVGY function, 2.1

REGR_COUNT function, 2.1

REGR_INTERCEPT function, 2.1

REGR_R2 function, 2.1

REGR_SLOPE function, 2.1

REGR_SXX function, 2.1

REGR_SXY function, 2.1

REGR_SYY function, 2.1

REMAINDER function, 2.1

RENAME, 1.1

REPLACE function, 2.1

REVOKE, 1.1

ROLLBACK, 1.1

ROUND (date) function, 2.1

ROUND (number) function, 2.1

ROW_NUMBER function, 2.1

ROWIDTOCHAR function, 2.1

ROWTONCHAR function, 2.1

RPAD function, 2.1

RTRIM function, 2.1

RUN

SQL*Plus command, A.1

S

SAVE

SQL*Plus command, A.1

SAVEPOINT, 1.1

SCC datetime format element, 7.1.2

scientific notation, 7.1.1.1

SCN_TO_TIMESTAMP function, 2.1

SELECT, 1.1

SESSIONTIMEZONE function, 2.1

SET

SQL*Plus command, A.1

SET CONSTRAINT, 1.1

SET function, 2.1

SET ROLE, 1.1

SET TRANSACTION, 1.1

SHOW

SQL*Plus command, A.1

SHUTDOWN

SQL*Plus command, A.1

SIGN function, 2.1

simple comparison condition, 4.1

simple expressions, 3.1

SIN function, 2.1

SINH function, 2.1

SOUNDEX function, 2.1

SPOOL

SQL*Plus command, A.1

SQL conditions, 4

compound conditions, 4.1

EQUALS_PATH condition, 4.1

floating-point condition, 4.1

group comparison condition, 4.1

IN conditions, 4.1, 4.1

IS A SET conditions, 4.1

IS ANY condition, 4.1

IS EMPTY conditions, 4.1

IS OF TYPE conditions, 4.1

IS PRESENT condition, 4.1

LIKE condition, 4.1

logical conditions, 4.1

MEMBER condition, 4.1

NULL conditions, 4.1

range conditions, 4.1

REGEXP_LIKE condition, 4.1

simple comparison condition, 4.1

SUBMULTISET conditions, 4.1

UNDER_PATH condition, 4.1

SQL expressions, 3

CASE expressions, 3.1

compound expressions, 3.1

CURSOR expression, 3.1

DATETIME expressions, 3.1

INTERVAL expressions, 3.1

model expressions, 3.1

object access expressions, 3.1

simple expressions, 3.1

type constructor expression, 3.1

variable expression, 3.1

SQL functions, 2

ABS, 2.1

ACOS, 2.1

ADD_MONTHS, 2.1

analytic_function, 2.1

ASCII, 2.1

ASCIISTR, 2.1

ASIN, 2.1

ATAN, 2.1

ATAN2, 2.1

AVG, 2.1

BFILENAME, 2.1

BIN_TO_NUM, 2.1

BITAND, 2.1

CARDINALITY, 2.1

CAST, 2.1

CEIL, 2.1

CHARTOROWID, 2.1

CHR, 2.1

COALESCE, 2.1

COLLECT, 2.1

COMPOSE, 2.1

CONCAT, 2.1

CONVERT, 2.1

CORR, 2.1

CORR_K, 2.1

CORR_S, 2.1

COS, 2.1

COSH, 2.1

COUNT, 2.1

COVAR_POP, 2.1

COVAR_SAMP, 2.1

CUME_DIST (aggregate), 2.1

CUME_DIST (analytic), 2.1

CURRENT_DATE, 2.1

CURRENT_TIMESTAMP, 2.1

CV, 2.1

DBTIMEZONE, 2.1

DECODE, 2.1

DECOMPOSE, 2.1

DENSE_RANK (aggregate), 2.1

DENSE_RANK (analytic), 2.1

DEPTH, 2.1

DEREF, 2.1

DUMP, 2.1

EMPTY_BLOB, 2.1, 2.1

EXISTSNODE, 2.1

EXP, 2.1

EXTRACT (datetime), 2.1

EXTRACT (XML), 2.1

EXTRACTVALUE, 2.1

FIRST, 2.1

FIRST_VALUE, 2.1

FLOOR, 2.1

FROM_TZ, 2.1

GREATEST, 2.1

GROUP_ID, 2.1

GROUPING, 2.1

GROUPING_ID, 2.1

HEXTORAW, 2.1

INITCAP, 2.1

INSTR, 2.1

ITERATION_NUMBER, 2.1

LAG, 2.1

LAST, 2.1

LAST_DAY, 2.1

LAST_VALUE, 2.1

LEAD, 2.1

LEAST, 2.1

LENGTH, 2.1

LN, 2.1

LNNVL, 2.1

LOCALTIMESTAMP, 2.1

LOG, 2.1

LOWER, 2.1

LPAD, 2.1

LTRIM, 2.1

MAKE_REF, 2.1

MAX, 2.1

MEDIAN, 2.1

MIN, 2.1

MOD, 2.1

MONTHS_BETWEEN, 2.1

NANVL, 2.1

NCGR, 2.1

NEW_TIME, 2.1

NEXT_DAY, 2.1

NLS_CHARSET_DECL_LEN, 2.1

NLS_CHARSET_ID, 2.1

NLS_CHARSET_NAME, 2.1

NLS_INITCAP, 2.1

NLS_LOWER, 2.1

NLS_UPPER, 2.1

NLSSORT, 2.1

NTILE, 2.1

NULLIF, 2.1

NUMTODSINTERVAL, 2.1

NUMTOYMINTERVAL, 2.1

NVL, 2.1

NVL2, 2.1

ORA_HASH, 2.1

PATH, 2.1

PERCENT_RANK (aggregate), 2.1

PERCENT_RANK (analytic), 2.1

PERCENTILE_CONT, 2.1

PERCENTILE_DISC, 2.1

POWER, 2.1

POWERMULTISET, 2.1

POWERMULTISET_BY_CARDINALITY, 2.1

PRESENTNNV, 2.1

PRESENTV, 2.1

PREVIOUS, 2.1

RANK (aggregate), 2.1

RANK (analytic), 2.1

RATIO_TO_REPORT, 2.1

RAWTOHEX, 2.1

RAWTONHEX, 2.1

REF, 2.1

REFTOHEX, 2.1

REGEXP_INSTR, 2.1

REGEXP_REPLACE, 2.1

REGEXP_SUBSTR, 2.1

REGR_AVGX, 2.1

REGR_AVGY, 2.1

REGR_COUNT, 2.1

REGR_INTERCEPT, 2.1

REGR_R2, 2.1

REGR_SLOPE, 2.1

REGR_SXX, 2.1

REGR_SXY, 2.1

REGR_SYY, 2.1

REMAINDER, 2.1

REPLACE, 2.1

ROUND (date), 2.1

ROUND (number), 2.1

ROW_NUMBER, 2.1

ROWIDTOCHAR, 2.1

ROWTONCHAR, 2.1

RPAD, 2.1

RTRIM, 2.1

SCN_TO_TIMESTAMP, 2.1

SESSIONTIMEZONE, 2.1

SET, 2.1

SIGN, 2.1

SIN, 2.1

SINH, 2.1

SOUNDEX, 2.1

SQRT, 2.1

STATS_BINOMIAL_TEST, 2.1

STATS_CROSSTAB, 2.1

STATS_F_TEST, 2.1

STATS_KS_TEST, 2.1

STATS_MODE, 2.1

STATS_MW_TEST, 2.1

STATS_ONE_WAY_ANOVA, 2.1

STATS_T_TEST_INDEP, 2.1

STATS_T_TEST_INDEPU, 2.1

STATS_T_TEST_ONE, 2.1

STATS_T_TEST_PAIRED, 2.1

STATS_WSR_TEST, 2.1

STDDEV, 2.1

STDDEV_POP, 2.1

STDDEV_SAMP, 2.1

SUBSTR, 2.1

SUM, 2.1

SYS_CONNECT_BY_PATH, 2.1

SYS_CONTEXT, 2.1

SYS_DBURIGEN, 2.1

SYS_EXTRACT_UTC, 2.1

SYS_GUID, 2.1

SYS_TYPEID, 2.1

SYS_XMLAGG, 2.1

SYS_XMLGEN, 2.1

SYSDATE, 2.1

SYSTIMESTAMP, 2.1

TAN, 2.1

TANH, 2.1

TIMESTAMP_TO_SCN, 2.1

TO_BINARY_DOUBLE, 2.1

TO_BINARY_FLOAT, 2.1

TO_CHAR (character), 2.1

TO_CHAR (datetime), 2.1

TO_CHAR (number), 2.1

TO_CLOB, 2.1

TO_DATE, 2.1

TO_DSINTERVAL, 2.1

TO_LOB, 2.1

TO_MULTI_BYTE, 2.1

TO_NCHAR (character), 2.1

TO_NCHAR (datetime), 2.1

TO_NCHAR (number), 2.1

TO_NCLOB, 2.1

TO_NUMBER, 2.1

TO_SINGLE_BYTE, 2.1

TO_TIMESTAMP, 2.1

TO_TIMESTAMP_TZ, 2.1

TO_YMINTERVAL, 2.1

TRANSLATE, 2.1

TRANSLATE...USING, 2.1

TREAT, 2.1

TRIM, 2.1

TRUNC (date), 2.1

TRUNC (number), 2.1

TZ_OFFSET, 2.1

UID, 2.1

UNISTR, 2.1

UPDATEXML, 2.1

UPPER, 2.1

USER, 2.1

user-defined function, 2.1

USERENV, 2.1

VALUE, 2.1

VAR_POP, 2.1

VAR_SAMP, 2.1

VARIANCE, 2.1

VSIZE, 2.1

WIDTH_BUCKET, 2.1

XMLAGG, 2.1

XMLCOLATTVAL, 2.1

XMLCONCAT, 2.1

XMLELEMENT, 2.1

XMLFOREST, 2.1

XMLSEQUENCE, 2.1

XMLTRANSFORM, 2.1

SQL statements, 1

ALTER CLUSTER, 1.1

ALTER DATABASE, 1.1

ALTER DIMENSION, 1.1

ALTER DISKGROUP, 1.1

ALTER FUNCTION, 1.1

ALTER INDEX, 1.1

ALTER INDEXTYPE, 1.1

ALTER JAVA, 1.1

ALTER MATERIALIZED VIEW, 1.1

ALTER MATERIALIZED VIEW LOG, 1.1

ALTER OPERATOR, 1.1

ALTER OUTLINE, 1.1

ALTER PACKAGE, 1.1

ALTER PROCEDURE, 1.1

ALTER PROFILE, 1.1

ALTER RESOURCE COST, 1.1

ALTER ROLE, 1.1

ALTER ROLLBACK SEGMENT, 1.1

ALTER SEQUENCE, 1.1, 1.1

ALTER SESSION, 1.1

ALTER SYSTEM, 1.1

ALTER TABLE, 1.1

ALTER TABLESPACE, 1.1

ALTER TRIGGER, 1.1

ALTER TYPE, 1.1

ALTER USER, 1.1

ALTER VIEW, 1.1

ANALYZE, 1.1

ASSOCIATE STATISTICS, 1.1

AUDIT, 1.1

CALL, 1.1

COMMENT, 1.1

COMMIT, 1.1

CREATE CLUSTER, 1.1

CREATE CONTEXT, 1.1

CREATE CONTROLFILE, 1.1

CREATE DATABASE, 1.1

CREATE DATABASE LINK, 1.1

CREATE DIMENSION, 1.1

CREATE DIRECTORY, 1.1

CREATE DISKGROUP, 1.1

CREATE FUNCTION, 1.1

CREATE INDEX, 1.1

CREATE INDEXTYPE, 1.1

CREATE JAVA, 1.1

CREATE LIBRARY, 1.1

CREATE MATERIALIZED VIEW, 1.1

CREATE MATERIALIZED VIEW LOG, 1.1

CREATE OPERATOR, 1.1

CREATE OUTLINE, 1.1

CREATE PACKAGE, 1.1

CREATE PACKAGE BODY, 1.1

CREATE PFILE, 1.1

CREATE PROCEDURE, 1.1

CREATE PROFILE, 1.1

CREATE ROLE, 1.1

CREATE ROLLBACK SEGMENT, 1.1

CREATE SCHEMA, 1.1, 1.1

CREATE SEQUENCE, 1.1

CREATE SPFILE, 1.1

CREATE SYNONYM, 1.1

CREATE TABLE, 1.1

CREATE TABLESPACE, 1.1

CREATE TRIGGER, 1.1

CREATE TYPE, 1.1

CREATE TYPE BODY, 1.1

CREATE USER, 1.1

CREATE VIEW, 1.1

DELETE, 1.1

DISASSOCIATE STATISTICS, 1.1

DROP CLUSTER, 1.1

DROP CONTEXT, 1.1

DROP DATABASE, 1.1

DROP DATABASE LINK, 1.1

DROP DIMENSION, 1.1

DROP DIRECTORY, 1.1

DROP DISKGROUP, 1.1

DROP FUNCTION, 1.1

DROP INDEX, 1.1

DROP INDEXTYPE, 1.1

DROP JAVA, 1.1

DROP LIBRARY, 1.1

DROP MATERIALIZED VIEW, 1.1

DROP MATERIALIZED VIEW LOG, 1.1

DROP OPERATOR, 1.1

DROP OUTLINE, 1.1

DROP PACKAGE, 1.1

DROP PROCEDURE, 1.1

DROP PROFILE, 1.1

DROP ROLE, 1.1

DROP ROLLBACK SEGMENT, 1.1

DROP SEQUENCE, 1.1

DROP SYNONYM, 1.1

DROP TABLE, 1.1

DROP TABLESPACE, 1.1

DROP TRIGGER, 1.1

DROP TYPE, 1.1

DROP TYPE BODY, 1.1

DROP USER, 1.1

DROP VIEW, 1.1

EXPLAIN PLAN, 1.1

FLASHBACK DATABASE, 1.1

FLASHBACK TABLE, 1.1

GRANT, 1.1

INSERT, 1.1

LOCK TABLE, 1.1

MERGE, 1.1

NOAUDIT, 1.1

PURGE, 1.1

RENAME, 1.1

REVOKE, 1.1

ROLLBACK, 1.1

SAVEPOINT, 1.1

SELECT, 1.1

SET CONSTRAINT, 1.1

SET ROLE, 1.1

SET TRANSACTION, 1.1

TRUNCATE, 1.1

UPDATE, 1.1

SQL*Plus commands, A, A.1

/ (slash), A.1

@ (at sign), A.1

APPEND, A.1

CHANGE, A.1

CONNECT, A.1

DEL, A.1

DESCRIBE, A.1

DISCONNECT, A.1

EDIT, A.1

EXECUTE, A.1

EXIT, A.1

GET, A.1

HELP, A.1

HOST, A.1

INPUT, A.1

LIST, A.1

QUIT, A.1

RUN, A.1

SAVE, A.1

SET, A.1

SHOW, A.1

SHUTDOWN, A.1

SPOOL, A.1

SQLPLUS, A.1

START, A.1

STARTUP, A.1

SQL/DS datatypes

restrictions on, 6.1.2

SQLPLUS

SQL*Plus command, A.1

SQRT function, 2.1

START

SQL*Plus command, A.1

STARTUP

SQL*Plus command, A.1

statements, 1

see also SQL statements

STATS_BINOMIAL_TEST function, 2.1

STATS_CROSSTAB function, 2.1

STATS_F_TEST function, 2.1

STATS_KS_TEST function, 2.1

STATS_MODE function, 2.1

STATS_MW_TEST function, 2.1

STATS_ONE_WAY_ANOVA function, 2.1

STATS_T_TEST_INDEP function, 2.1

STATS_T_TEST_INDEPU function, 2.1

STATS_T_TEST_ONE function, 2.1

STATS_T_TEST_PAIRED function, 2.1

STATS_WSR_TEST function, 2.1

STDDEV function, 2.1

STDDEV_POP function, 2.1

STDDEV_SAMP function, 2.1

SUBMULTISET conditions, 4.1

SUBSTR function, 2.1

SUM function, 2.1

SYS_CONNECT_BY_PATH function, 2.1

SYS_CONTEXT function, 2.1

SYS_DBURIGEN function, 2.1

SYS_EXTRACT_UTC function, 2.1

SYS_GUID function, 2.1

SYS_TYPEID function, 2.1

SYS_XMLAGG function, 2.1

SYS_XMLGEN function, 2.1

SYSDATE function, 2.1

SYSTIMESTAMP function, 2.1

T

TAN function, 2.1

TANH function, 2.1

TIME datatype

DB2, 6.1.2, 6.1.2

SQL/DS, 6.1.2, 6.1.2

time format models

short, 7.1.2.1

time zone

formatting, 7.1.2.1

TIMESTAMP datatype

DB2, 6.1.2, 6.1.2

SQL/DS, 6.1.2, 6.1.2

TIMESTAMP_TO_SCN function, 2.1

TO_BINARY_DOUBLE function, 2.1

TO_BINARY_FLOAT function, 2.1

TO_CHAR (character) function, 2.1

TO_CHAR (datetime) function, 2.1

TO_CHAR (number) function, 2.1

TO_CLOB function, 2.1

TO_DATE function, 2.1

TO_DSINTERVAL function, 2.1

TO_LOB function, 2.1

TO_MULTI_BYTE function, 2.1

TO_NCHAR (character) function, 2.1

TO_NCHAR (datetime) function, 2.1

TO_NCHAR (number) function, 2.1

TO_NCLOB function, 2.1

TO_NUMBER function, 2.1

TO_SINGLE_BYTE function, 2.1

TO_TIMESTAMP function, 2.1

TO_TIMESTAMP_TZ function, 2.1

TO_YMINTERVAL function, 2.1

TRANSLATE function, 2.1

TRANSLATE...USING function, 2.1

TREAT function, 2.1

TRIM function, 2.1

TRUNC (date) function, 2.1

TRUNC (number) function, 2.1

TRUNCATE, 1.1

type constructor expression, 3.1

TZ_OFFSET function, 2.1

U

UID function, 2.1

UNDER_PATH condition, 4.1

UNISTR function, 2.1

UPDATE, 1.1

UPDATEXML function, 2.1

UPPER function, 2.1

USER function, 2.1

user-defined function, 2.1

USERENV function, 2.1

V

VALUE function, 2.1

VAR_POP function, 2.1

VAR_SAMP function, 2.1

VARGRAPHIC datatype

DB2, 6.1.2, 6.1.2

SQL/DS, 6.1.2, 6.1.2

variable expression, 3.1

VARIANCE function, 2.1

VSIZE function, 2.1

W

WIDTH_BUCKET function, 2.1

X

XMLAGG function, 2.1

XMLCOLATTVAL function, 2.1

XMLCONCAT function, 2.1

XMLELEMENT function, 2.1

XMLFOREST function, 2.1

XMLSEQUENCE function, 2.1

XMLTRANSFORM function, 2.1