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

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

activate_standby_db_clause, 5.1

add_binding_clause, 5.1

add_columns_clause, 5.1

add_disk_clause, 5.1

add_hash_index_partition, 5.1

add_hash_partition_clause, 5.1

add_hash_subpartition, 5.1

add_list_partition_clause, 5.1

add_list_subpartition, 5.1

add_logfile_clauses, 5.1

ADD_MONTHS function, 2.1

add_overflow_clause, 5.1

add_range_partition_clause, 5.1

add_range_subpartition, 5.1

add_system_partition_clause, 5.1

add_table_partition, 5.1

alias_file_name, 5.1

allocate_extent_clause, 5.1

ALTER CLUSTER statement, 1.1

ALTER DATABASE statement, 1.1

ALTER DIMENSION statement, 1.1

ALTER DISKGROUP statement, 1.1

ALTER FLASHBACK ARCHIVE statement, 1.1

ALTER FUNCTION statement, 1.1

ALTER INDEX statement, 1.1

ALTER INDEXTYPE statement, 1.1

ALTER JAVA statement, 1.1

ALTER MATERIALIZED VIEW LOG statement, 1.1

ALTER MATERIALIZED VIEW statement, 1.1

ALTER OPERATOR statement, 1.1

ALTER OUTLINE statement, 1.1

ALTER PACKAGE statement, 1.1

ALTER PROCEDURE statement, 1.1

ALTER PROFILE statement, 1.1

ALTER RESOURCE COST statement, 1.1

ALTER ROLE statement, 1.1

ALTER ROLLBACK SEGMENT statement, 1.1

ALTER SEQUENCE statement, 1.1, 1.1

ALTER SESSION statement, 1.1

ALTER SYSTEM statement, 1.1

ALTER TABLE statement, 1.1

ALTER TABLESPACE statement, 1.1

ALTER TRIGGER statement, 1.1

ALTER TYPE statement, 1.1

ALTER USER statement, 1.1

ALTER VIEW statement, 1.1

alter_attribute_definition, 5.1

alter_collection_clauses, 5.1

alter_datafile_clause, 5.1

alter_external_table_clauses, 5.1

alter_index_partitioning, 5.1

alter_interval_partitioning, 5.1

alter_iot_clauses, 5.1

alter_mapping_table_clauses, 5.1

alter_method_spec, 5.1

alter_mv_refresh, 5.1

alter_overflow_clause, 5.1

alter_session_set_clause, 5.1

alter_system_reset_clause, 5.1

alter_system_security_clauses, 5.1

alter_system_set_clause, 5.1

alter_table_partitioning, 5.1

alter_table_properties, 5.1

alter_tempfile_clause, 5.1

alter_varray_col_properties, 5.1

American National Standards Institute (ANSI)

datatypes

conversion to Oracle datatypes, 6.4

analytic functions, 2.1

analytic_clause, 5.1

ANALYZE statement, 1.1

ANSI-supported datatypes, 6.1

APPEND

SQL*Plus command, A.1

APPENDCHILDXML function, 2.1

archive_log_clause, 5.1

array_DML_clause, 5.1

ASCII function, 2.1

ASCIISTR function, 2.1

ASIN function, 2.1

ASM_filename, 5.1

ASSOCIATE STATISTICS statement, 1.1

ATAN function, 2.1

ATAN2 function, 2.1

attribute_clause, 5.1

AUDIT statement, 1.1

auditing_by_clause, 5.1

auditing_on_clause, 5.1

autoextend_clause, 5.1

AVG function, 2.1

B

BFILENAME function, 2.1

BIN_TO_NUM function, 2.1

binding_clause, 5.1

BITAND function, 2.1

bitmap_join_index_clause, 5.1

build_clause, 5.1

C

C_declaration, 5.1

CALL statement, 1.1

call_spec, 5.1

CARDINALITY function, 2.1

CASE expressions, 3.1

CAST function, 2.1

CC datetime format element, 7.1.2

CEIL function, 2.1

cell_assignment, 5.1

cell_reference_options, 5.1

CHANGE

SQL*Plus command, A.1

character_datatypes, 6.2

character_set_clause, 5.1

CHARTOROWID function, 2.1

check_datafiles_clause, 5.1

check_diskgroup_clauses, 5.1

checkpoint_clause, 5.1

CHR function, 2.1

CLUSTER_ID function, 2.1

cluster_index_clause, 5.1

CLUSTER_PROBABILITY function, 2.1

CLUSTER_SET function, 2.1

COALESCE function, 2.1

coalesce_index_partition, 5.1

coalesce_table_partition, 5.1

coalesce_table_subpartition, 5.1

COLLECT function, 2.1

column_association, 5.1

column_clauses, 5.1

column_definition, 5.1

column_properties, 5.1

COMMENT statement, 1.1

COMMIT statement, 1.1

commit_switchover_clause, 5.1

compile_type_clause, 5.1

compiler_parameters_clause, 5.1

COMPOSE function, 2.1

composite_list_partitions, 5.1

composite_range_partitions, 5.1

compound conditions, 4.1

compound expressions, 3.1

compound_DML_trigger, 5.1

CONCAT function, 2.1

conditional_insert_clause, 5.1

conditions, 4

D

database_file_clauses, 5.1

database_logging_clauses, 5.1

datafile_tempfile_clauses, 5.1

datafile_tempfile_spec, 5.1

DATAOBJ_TO_PARTITION function, 2.1

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

datetime_datatypes, 6.2

db_user_proxy, 5.1

DB2 datatypes

restrictions on, 6.4

dblink, 5.1

dblink_authentication, 5.1

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

deallocate_unused_clause, 5.1

decimal characters

specifying, 7.1.1.1

DECODE function, 2.1

DECOMPOSE function, 2.1

default_cost_clause, 5.1

default_selectivity_clause, 5.1

default_settings_clauses, 5.1

default_tablespace, 5.1

default_temp_tablespace, 5.1

DEL

SQL*Plus command, A.1

DELETE statement, 1.1

DENSE_RANK (aggregate) function, 2.1, 2.1

dependent_handling_clause, 5.1

dependent_tables_clause, 5.1

DEPTH function, 2.1

DEREF function, 2.1

DESCRIBE

SQL*Plus command, A.1

dimension_join_clause, 5.1

DISASSOCIATE STATISTICS statement, 1.1

DISCONNECT

SQL*Plus command, A.1

diskgroup_alias_clauses, 5.1

diskgroup_availability, 5.1

diskgroup_directory_clauses, 5.1

diskgroup_template_clauses, 5.1

distributed_recov_clauses, 5.1

dml_event_clause, 5.1

dml_table_expression_clause, 5.1

domain_index_clause, 5.1

DROP CLUSTER statement, 1.1

DROP CONTEXT statement, 1.1

DROP DATABASE LINK statement, 1.1

DROP DATABASE statement, 1.1

DROP DIMENSION statement, 1.1

DROP DIRECTORY statement, 1.1

DROP DISKGROUP statement, 1.1

DROP FLASHBACK ARCHIVE statement, 1.1

DROP FUNCTION statement, 1.1

DROP INDEX statement, 1.1

DROP INDEXTYPE statement, 1.1

DROP JAVA statement, 1.1

DROP LIBRARY statement, 1.1

DROP MATERIALIZED VIEW LOG statement, 1.1

DROP MATERIALIZED VIEW statement, 1.1

DROP OPERATOR statement, 1.1

DROP OUTLINE statement, 1.1

DROP PACKAGE statement, 1.1

DROP PROCEDURE statement, 1.1

DROP PROFILE statement, 1.1

DROP RESTORE POINT statement, 1.1

DROP ROLE statement, 1.1

DROP ROLLBACK SEGMENT statement, 1.1

DROP SEQUENCE statement, 1.1

DROP SYNONYM statement, 1.1

DROP TABLE statement, 1.1

DROP TABLESPACE statement, 1.1

DROP TRIGGER statement, 1.1

DROP TYPE BODY statement, 1.1

DROP TYPE statement, 1.1

DROP USER statement, 1.1

DROP VIEW statement, 1.1

drop_binding_clause, 5.1

drop_column_clause, 5.1

drop_constraint_clause, 5.1

drop_disk_clauses, 5.1

drop_diskgroup_file_clause, 5.1

drop_index_partition, 5.1

drop_logfile_clauses, 5.1

drop_table_partition, 5.1

drop_table_subpartition, 5.1

ds_iso_format of TO_DSINTERVAL function, 5.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

element_spec, 5.1

else_clause, 5.1

EMPTY_BLOB function, 2.1, 2.1

enable_disable_clause, 5.1

encryption_spec, 5.1

end_session_clauses, 5.1

EQUALS_PATH condition, 4.1

error_logging_clause, 5.1

exceptions_clause, 5.1

exchange_partition_subpart, 5.1

EXECUTE

SQL*Plus command, A.1

EXISTSNODE function, 2.1

EXIT

SQL*Plus command, A.1

EXP function, 2.1

EXPLAIN PLAN statement, 1.1

expr, 5.1

expression_list, 5.1

expressions, 3

F

FF datetime format element, 7.1.2

file_specification, 5.1

FIRST function, 2.1

FIRST_VALUE function, 2.1, 2.1, 2.1, 2.1

FLASHBACK DATABASE statement, 1.1

FLASHBACK TABLE statement, 1.1

flashback_mode_clause, 5.1

flashback_query_clause, 5.1

floating-point condition, 4.1

FLOOR function, 2.1

for_update_clause, 5.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

full_database_recovery, 5.1

fully_qualified_file_name, 5.1

function_association, 5.1

function_declaration, 5.1

function_spec, 5.1

functions, 2

G

general_recovery, 5.1

GET

SQL*Plus command, A.1

global_partitioned_index, 5.1

GRANT statement, 1.1

grant_object_privileges, 5.1

grant_system_privileges, 5.1

grantee_clause, 5.1

GRAPHIC datatype

DB2, 6.4

SQL/DS, 6.4

GREATEST function, 2.1

group comparison condition, 4.1

group separator

specifying, 7.1.1.1

group_by_clause, 5.1

GROUP_ID function, 2.1

GROUPING function, 2.1

grouping_expression_list, 5.1

GROUPING_ID function, 2.1

grouping_sets_clause, 5.1

H

hash_partitions, 5.1

hash_partitions_by_quantity, 5.1, 5.1

HELP

SQL*Plus command, A.1

hexadecimal value

returning, 7.1.1.1

HEXTORAW function, 2.1

HH datetime format element, 7.1.2

hierarchical_query_clause, 5.1

hierarchy_clause, 5.1

HOST

SQL*Plus command, A.1

I

implementation_clause, 5.1

IN conditions, 4.1, 4.1

incomplete_file_name, 5.1

index_attributes, 5.1

index_expr, 5.1

index_org_overflow_clause, 5.1

index_org_table_clause, 5.1

index_partition_description, 5.1

index_partitioning_clause, 5.1

index_properties, 5.1

index_subpartition_clause, 5.1

individual_hash_partitions, 5.1, 5.1

inheritance_clauses, 5.1

INITCAP function, 2.1

inline_constraint, 5.1

inline_ref_constraint, 5.1

inner_cross_join_clause, 5.1

INPUT

SQL*Plus command, A.1

INSERT statement, 1.1

insert_into_clause, 5.1

instance_clauses, 5.1

INSTR function, 2.1

integer, 5.1

INTERVAL expressions, 3.1

interval_day_to_second, 5.1

interval_year_to_month, 5.1

into_clause, 5.1

invoker_rights_clause, 5.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

J

Java_declaration, 5.1

join_clause, 5.1

K

key_compression, 5.1

L

LAG function, 2.1

large_object_datatypes, 6.2

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

level_clause, 5.1

LIKE condition, 4.1

LIST

SQL*Plus command, A.1

list_partitions, 5.1

list_values_clause, 5.1

LN function, 2.1

LNNVL function, 2.1

LOB_parameters, 5.1

LOB_partition_storage, 5.1, 5.1

LOB_storage_clause, 5.1

local_partitioned_index, 5.1

locale independent, 7.1.2.1

LOCALTIMESTAMP function, 2.1

LOCK TABLE statement, 1.1

LOG function, 2.1

logfile_clause, 5.1

logfile_clauses, 5.1

logfile_descriptor, 5.1

logging_clause, 5.1

logical conditions, 4.1

LONG VARGRAPHIC datatype

DB2, 6.4, 6.4

SQL/DS, 6.4

long_and_raw_datatypes, 6.2

LOWER function, 2.1

LPAD function, 2.1

LTRIM function, 2.1

M

main_model, 5.1

MAKE_REF function, 2.1

managed_standby_recovery, 5.1

map_order_func_declaration, 5.1

map_order_function_spec, 5.1

mapping_table_clauses, 5.1

materialized_view_props, 5.1

MAX function, 2.1

maximize_standby_db_clause, 5.1

maxsize_clause, 5.1

MEDIAN function, 2.1

MEMBER condition, 4.1

MERGE statement, 1.1

merge_insert_clause, 5.1

merge_table_partitions, 5.1

merge_table_subpartitions, 5.1

merge_update_clause, 5.1

MIN function, 2.1

mining_attribute_clause, 5.1

MOD function, 2.1

model expressions, 3.1

model_clause, 5.1

model_column, 5.1

model_column_clauses, 5.1

model_rules_clause, 5.1

modify_col_properties, 5.1

modify_col_substitutable, 5.1

modify_collection_retrieval, 5.1

modify_column_clauses, 5.1

modify_hash_partition, 5.1

modify_index_default_attrs, 5.1

modify_index_partition, 5.1

modify_index_subpartition, 5.1

modify_list_partition, 5.1

modify_LOB_parameters, 5.1

modify_LOB_storage_clause, 5.1

modify_range_partition, 5.1

modify_table_default_attrs, 5.1

modify_table_partition, 5.1

modify_table_subpartition, 5.1

MONTHS_BETWEEN function, 2.1

move_table_clause, 5.1

move_table_partition, 5.1

move_table_subpartition, 5.1

multi_column_for_loop, 5.1

multi_table_insert, 5.1

multiset_except, 5.1

multiset_intersect, 5.1

multiset_union, 5.1

N

NANVL function, 2.1

NCHR function, 2.1

nested_table_col_properties, 5.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 statement, 1.1

non_DML_trigger, 5.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

number_datatypes, 6.2

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

Oracle Built-In Datatypes, 6.2

Oracle built-in datatypes, 6.1

Oracle-supplied datatypes, 6.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

pivot_clause, 5.1

POWER function, 2.1

POWERMULTISET function, 2.1

POWERMULTISET_BY_CARDINALITY function, 2.1

PREDICTION_BOUNDS function, 2.1

PRESENTNNV function, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1

PRESENTV function, 2.1

PREVIOUS function, 2.1

PURGE statement, 1.1

Q

query_block, 5.1

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

redo_thread_clauses

see instance_clauses

REF function, 2.1

reference partitioning, 5.1

REFTOHEX function, 2.1

REGEXP_COUNT 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 statement, 1.1

REPLACE function, 2.1

REVOKE statement, 1.1

ROLLBACK statement, 1.1

ROUND (date) function, 2.1

ROUND (number) function, 2.1

ROW_NUMBER function, 2.1

rowid_datatypes, 6.2

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 statement, 1.1

scalar subquery expression, 3.1

SCC datetime format element, 7.1.2

scientific notation, 7.1.1.1

SCN_TO_TIMESTAMP function, 2.1

SELECT statement, 1.1

SESSIONTIMEZONE function, 2.1

SET

SQL*Plus command, A.1

SET CONSTRAINT statement, 1.1

SET function, 2.1

SET ROLE statement, 1.1

SET TRANSACTION statement, 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

simple_DML_trigger, 5.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 Ecpressions

scalar subquery expression, 3.1

SQL Expression

Function expression, 3.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, 2.1

APPENDCHILDXML, 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

CLUSTER_ID, 2.1

CLUSTER_PROBABILITY, 2.1

CLUSTER_SET, 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

DATAOBJ_TO_PARTITION, 2.1

DBTIMEZONE, 2.1

DECODE, 2.1

DECOMPOSE, 2.1

DENSE_RANK (aggregate), 2.1, 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, 2.1, 2.1, 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

PREDICTION_BOUNDS, 2.1

PRESENTNNV, 2.1, 2.1, 2.1, 2.1, 2.1, 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_COUNT, 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

XMLCAST, 2.1

XMLCOLATTVAL, 2.1

XMLCONCAT, 2.1, 2.1

XMLELEMENT, 2.1

XMLExists, 2.1

XMLFOREST, 2.1

XMLSEQUENCE, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 5.1, 5.1, 5.1, 5.1

XMLTRANSFORM, 2.1

SQL statements, 1

ALTER CLUSTER statement, 1.1

ALTER DATABASE statement, 1.1

ALTER DIMENSION statement, 1.1

ALTER DISKGROUP statement, 1.1

ALTER FLASHBACK ARCHIVE, 1.1

ALTER FUNCTION statement, 1.1

ALTER INDEX statement, 1.1

ALTER INDEXTYPE statement, 1.1

ALTER JAVA statement, 1.1

ALTER MATERIALIZED VIEW LOG statement, 1.1

ALTER MATERIALIZED VIEW statement, 1.1

ALTER OPERATOR statement, 1.1

ALTER OUTLINE statement, 1.1

ALTER PACKAGE statement, 1.1

ALTER PROCEDURE statement, 1.1

ALTER PROFILE statement, 1.1

ALTER RESOURCE COST statement, 1.1

ALTER ROLE statement, 1.1

ALTER ROLLBACK SEGMENT statement, 1.1

ALTER SEQUENCE statement, 1.1, 1.1

ALTER SESSION statement, 1.1

ALTER SYSTEM statement, 1.1

ALTER TABLE statement, 1.1

ALTER TABLESPACE statement, 1.1

ALTER TRIGGER statement, 1.1

ALTER TYPE statement, 1.1

ALTER USER statement, 1.1

ALTER VIEW statement, 1.1

ANALYZE statement, 1.1

ASSOCIATE STATISTICS statement, 1.1

AUDIT statement, 1.1

CALL statement, 1.1

COMMENT statement, 1.1

COMMIT statement, 1.1

CREATE CLUSTER statement, 1.1

CREATE CONTEXT statement, 1.1

CREATE CONTROLFILE statement, 1.1

CREATE DATABASE LINK statement, 1.1

CREATE DATABASE statement, 1.1

CREATE DIMENSION statement, 1.1

CREATE DIRECTORY statement, 1.1

CREATE DISKGROUP statement, 1.1

CREATE FLASHBACK ARCHIVE, 1.1

CREATE FUNCTION statement, 1.1

CREATE INDEX statement, 1.1

CREATE INDEXTYPE statement, 1.1

CREATE JAVA statement, 1.1

CREATE LIBRARY statement, 1.1

CREATE MATERIALIZED VIEW LOG statement, 1.1

CREATE MATERIALIZED VIEW statement, 1.1

CREATE OPERATOR statement, 1.1

CREATE OUTLINE statement, 1.1

CREATE PACKAGE BODY statement, 1.1

CREATE PACKAGE statement, 1.1

CREATE PFILE statement, 1.1

CREATE PROCEDURE statement, 1.1

CREATE PROFILE statement, 1.1

CREATE RESTORE POINT, 1.1

CREATE ROLE statement, 1.1

CREATE ROLLBACK SEGMENT statement, 1.1

CREATE SCHEMA statement, 1.1, 1.1

CREATE SEQUENCE statement, 1.1

CREATE SPFILE statement, 1.1

CREATE SYNONYM statement, 1.1

CREATE TABLE statement, 1.1

CREATE TABLESPACE statement, 1.1

CREATE TRIGGER statement, 1.1

CREATE TYPE BODY statement, 1.1

CREATE TYPE statement, 1.1

CREATE USER statement, 1.1

CREATE VIEW statement, 1.1

DELETE statement, 1.1

DISASSOCIATE STATISTICS statement, 1.1

DROP CLUSTER statement, 1.1

DROP CONTEXT statement, 1.1

DROP DATABASE LINK statement, 1.1

DROP DATABASE statement, 1.1

DROP DIMENSION statement, 1.1

DROP DIRECTORY statement, 1.1

DROP DISKGROUP statement, 1.1

DROP FLASHBACK ARCHIVE, 1.1

DROP FUNCTION statement, 1.1

DROP INDEX statement, 1.1

DROP INDEXTYPE statement, 1.1

DROP JAVA statement, 1.1

DROP LIBRARY statement, 1.1

DROP MATERIALIZED VIEW LOG statement, 1.1

DROP MATERIALIZED VIEW statement, 1.1

DROP OPERATOR statement, 1.1

DROP OUTLINE statement, 1.1

DROP PACKAGE statement, 1.1

DROP PROCEDURE statement, 1.1

DROP PROFILE statement, 1.1

DROP RESTORE POINT, 1.1

DROP ROLE statement, 1.1

DROP ROLLBACK SEGMENT statement, 1.1

DROP SEQUENCE statement, 1.1

DROP SYNONYM statement, 1.1

DROP TABLE statement, 1.1

DROP TABLESPACE statement, 1.1

DROP TRIGGER statement, 1.1

DROP TYPE BODY statement, 1.1

DROP TYPE statement, 1.1

DROP USER statement, 1.1

DROP VIEW statement, 1.1

EXPLAIN PLAN statement, 1.1

FLASHBACK DATABASE statement, 1.1

FLASHBACK TABLE statement, 1.1

GRANT statement, 1.1

INSERT statement, 1.1

LOCK TABLE statement, 1.1

MERGE statement, 1.1

NOAUDIT statement, 1.1

PURGE statement, 1.1

RENAME statement, 1.1

REVOKE statement, 1.1

ROLLBACK statement, 1.1

SAVEPOINT statement, 1.1

SELECT statement, 1.1

SET CONSTRAINT statement, 1.1

SET ROLE statement, 1.1

SET TRANSACTION statement, 1.1

TRUNCATE statement, 1.1

TRUNCATE_CLUSTER, 1.1

TRUNCATE_TABLE, 1.1

UPDATE statement, 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_format of TO_DSINTERVAL function, 5.1

SQL/DS datatypes

restrictions on, 6.4

SQLPLUS

SQL*Plus command, A.1

SQRT function, 2.1

START

SQL*Plus command, A.1

STARTUP

SQL*Plus command, A.1

statements, 1

T

TAN function, 2.1

TANH function, 2.1

TIME datatype

DB2, 6.4, 6.4

SQL/DS, 6.4, 6.4

time format models

short, 7.1.2.1

time zone

formatting, 7.1.2.1

TIMESTAMP datatype

DB2, 6.4, 6.4

SQL/DS, 6.4, 6.4

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 statement, 1.1

TRUNCATE_CLUSTER statement, 1.1

TRUNCATE_TABLE statement, 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

unpivot_clause, 5.1

UPDATE statement, 1.1

UPDATEXML function, 2.1

UPPER function, 2.1

USER function, 2.1

User-defined datatypes, 6.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.4, 6.4

SQL/DS, 6.4, 6.4

variable expression, 3.1

VARIANCE function, 2.1

VSIZE function, 2.1

W

WIDTH_BUCKET function, 2.1

X

XMLAGG function, 2.1

XMLCast function, 2.1

XMLCOLATTVAL function, 2.1

XMLCONCAT function, 2.1, 2.1

XMLELEMENT function, 2.1

XMLExists function, 2.1

XMLFOREST function, 2.1

XMLSEQUENCE function, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 5.1, 5.1, 5.1, 5.1

XMLTRANSFORM function, 2.1

Y

ym_iso_format of TO_YMINTERVAL function, 5.1