Index

A B C D E F G H I L&nb sp; 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 elemen t, 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< /dd>

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 OUTL INE, 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 SESSIO N, 1.1

ALTER SYSTEM, 1.1

ALTER TABLE, 1.1

ALTER TABLESPACE, 1.1< /a>

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

C ASE 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, < a href="sqlqr01.htm#sthref80">1.1

COMMIT, 1.1

COMP OSE function, 2.1

compound conditions, 4.1< /a>

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

CREA TE 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 SPF ILE, 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

restrictio ns on, 6.1.2

DBTIMEZONE function, 2.1

DD datetime format element, 7.1.2

DDAY datet ime 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

DENS E_RANK (analytic) function, 2.1

DEPTH function, 2.1

DEREF function, 2.1

DESCRIBE

< dl class="l2ix">

SQL*Plus command, A.1

DISASSOCI ATE 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< /a>

DROP DISKGROUP, 1.1

DROP FUNCTION, 1.1

DROP INDEX, 1.1

DROP INDEXT YPE, 1.1

DROP JAVA, 1.1

DROP LIBRARY, 1.1

DROP MATERIALIZED VIEW, 1.1

DROP MATERIALIZED VIEW LOG, 1.1

DROP OP ERATOR, 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< /dd>

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

< dd class="l1ix">DUMP function, 2.1

DY datetime format element, 7.1.2

E

< dl class="l1ix">

E datetime format element, 7.1.2

EDIT

SQL*Plus command, A.1

E E 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

FL OOR function, 2.1

format models, 7.1

date format models, 7.1.2

datetime format elements, 7.1.2

number format mo dels, 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

GROU PING_ID function, 2.1

H

HELP

SQL*Plus command, A.1

hexadecimal value

r eturning, 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 fu nction, 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< /a>

LEAD function, 2.1

LEAST function, 2.1

LENGTH function, 2.1

LIKE c ondition, 4.1

LIST

SQL*Plus co mmand, 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 fu nction, 2.1

M

MAKE_REF function, 2.1

MAX function, 2.1

MEDIAN function, 2.1< /dd>

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_CHAR SET_DECL_LEN function, 2.1

NLS_CHARSET_ID function, 2.1

NLS_CHARSET_NAME function, 2.1

NLS_I NITCAP 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

NU MTODSINTERVAL function, 2.1

NUMTOYMINTERVAL function, 2.1

NVL function, 2.1

NVL2 function, < a href="sqlqr02.htm#sthref461">2.1

O

object access expressions, 3.1

O RA_HASH function, 2.1

P

PATH function, 2.1

PERCENT_RANK (aggregate) function, 2.1

PERCENT_RANK (analytic) functi on, 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 f unction, 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 functio n, 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, < a href="sqlqr02.htm#sthref535">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< /dd>

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 conditi ons, 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

I S ANY condition, 4.1

IS EMPTY conditions, 4 .1

IS OF TYPE conditions, 4.1

IS PRESENT conditio n, 4.1

LIKE condition, 4.1

logical conditions, 4.1

MEMBER condition, 4.1

NULL conditions, 4.1

range condition s, 4.1

REGEXP_LIKE condition, 4.1

simple comparison condition, 4.1

SUBMULTISET conditions, < a href="sqlqr04.htm#sthref776">4.1

UNDER_PATH condition, 4.1

< /dd>

SQL expressions, 3

CASE expres sions, 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 constr uctor 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

CARDIN ALITY, 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

< dd class="l2ix">CUME_DIST (analytic), 2.1

CURRENT_DATE, 2.1

CURRENT_TIMESTAMP, 2.1

CV, 2.1

DBTIMEZONE, 2.1

DE CODE, 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

IN STR, 2.1

ITERATION_NUMBER, 2.1

LAG, 2.1

LAST, 2.1

< dd class="l2ix">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< /dd>

NEXT_DAY, 2.1

NLS_CHARSET_DECL_LEN, 2.1

NLS_CHARSET_ID, 2.1

NLS_CHARSE T_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, < a href="sqlqr02.htm#sthref458">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

PERCENTIL E_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< /dd>

REGR_AVGY, 2.1

REGR_COUNT, 2.1

REGR_INTERCEPT, 2.1

REGR_R2, 2.1

REGR_SLOPE, 2.1

REGR_SX X, 2.1

REGR_SXY, 2.1

REGR_SYY, 2.1

REMAINDER, 2.1

< dd class="l2ix">REPLACE, 2.1

ROUND (date), 2.1

ROUND (number), 2.1

ROW_NUMBER, 2.1

ROWIDTOCHAR, 2.1

ROWTONCHA R, 2.1

RPAD, 2.1

RTRIM, 2.1

SCN_TO_TIMESTAMP, 2.1

< dd class="l2ix">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

STDDE V, 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

S YS_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

< dd class="l2ix">TO_CHAR (character), 2.1

TO_CHAR (datetime), 2.1

TO_CHAR (number), 2.1

TO_CL OB, 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_N CHAR (number), 2.1

TO_NCLOB, 2.1

< dd class="l2ix">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

U SER, 2.1

user-defined function, 2.1

USERENV, 2.1

VALUE, 2.1< /a>

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 FUNC TION, 1.1

ALTER INDEX, 1.1

ALTER INDEXTYPE, 1.1

ALTER JAVA, 1.1< /a>

ALTER MATERIALIZED VIEW, 1.1

ALTER MATERIALIZED VI EW 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 TY PE, 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

CREAT E 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

CREA TE 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< /dd>

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 OUTLIN E, 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

DR OP 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

R EVOKE, 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 href="sqlqraa.htm#sthref869">A.1

INPUT, A.1

LIS T, 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

SQR T 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 fun ction, 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< /dd>

STATS_T_TEST_INDEPU function, 2.1

STATS_T_TEST_ONE fu nction, 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 f unction, 2.1

SYS_CONNECT_BY_PATH function, 2.1

SYS_CONTEXT function, 2.1

SYS_DBURIGEN functi on, 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< /dd>

DB2, 6.1.2, 6.1.2

SQL/DS, 6.1.2, 6.1.2

< dd class="l1ix">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_FLO AT 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, < a href="sqlqr02.htm#sthref633">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

T O_SINGLE_BYTE function, 2.1

TO_TIMESTAMP function, 2.1

TO_TIMESTAMP_TZ function, 2.1

TO_YMIN TERVAL 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 constructo r 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

U PPER 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

VARIAN CE 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

X MLFOREST function, 2.1

XMLSEQUENCE function, 2.1

XMLTRANSFORM function, 2.1