Skip Headers
Oracle® Database SQL Quick Reference
10g Release 2 (10.2)

Part Number B14195-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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 

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_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 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_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.1.3
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
cancel_clause, 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.1.1
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
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_partitioning, 5.1
compound conditions, 4.1
compound expressions, 3.1
compute_statistics_clause, 5.1
CONCAT function, 2.1
conditional_insert_clause, 5.1
conditions, 4
see also SQL conditions
CONNECT
SQL*Plus command, A.1
constraint, 5.1
constraint_clauses, 5.1
constraint_state, 5.1
constructor_declaration, 5.1
constructor_spec, 5.1
context_clause, 5.1
controlfile_clauses, 5.1
CONVERT function, 2.1
convert_standby_clause, 5.1
Converting to Oracle Datatypes, 6.1.3
CORR function, 2.1
CORR_K function, 2.1
CORR_S function, 2.1
COS function, 2.1
COSH function, 2.1
cost_matrix_clause, 5.1
COUNT function, 2.1
COVAR_POP function, 2.1
COVAR_SAMP function, 2.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 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 statement, 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
create_datafile_clause, 5.1
create_incomplete_type, 5.1
create_mv_refresh, 5.1
create_nested_table_type, 5.1
create_object_type, 5.1
create_varray_type, 5.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

database_file_clauses, 5.1
database_logging_clauses, 5.1
datafile_tempfile_clauses, 5.1
datafile_tempfile_spec, 5.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.1.1
db_user_proxy, 5.1
DB2 datatypes
restrictions on, 6.1.3
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
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 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
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
estimate_statistics_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
see also SQL expressions
extended_attribute_clause, 5.1
extent_management_clause, 5.1
external_data_properties, 5.1
external_table_clause, 5.1
EXTRACT (datetime) function, 2.1
EXTRACT (XML) function, 2.1
EXTRACTVALUE function, 2.1

F

FF datetime format element, 7.1.2
file_specification, 5.1
finish_clause, 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_clause, 5.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
see also SQL functions

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.1.3
SQL/DS, 6.1.3
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_partitioning, 5.1
hash_partitions_by_quantity, 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
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.1.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
level_clause, 5.1
LIKE condition, 4.1
LIST
SQL*Plus command, A.1
list_partitioning, 5.1
list_values_clause, 5.1
LN function, 2.1
LNNVL function, 2.1
LOB_parameters, 5.1
LOB_partition_storage, 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.1.3, 6.1.3
SQL/DS, 6.1.3
long_and_raw_datatypes, 6.1.1
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_hash_subpartition, 5.1
modify_index_default_attrs, 5.1
modify_index_partition, 5.1
modify_index_subpartition, 5.1
modify_list_partition, 5.1
modify_list_subpartition, 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
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.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
Oracle Built-In Datatypes, 6.1.1
Oracle built-in datatypes, 6.1
Oracle-Supplied Datatypes, 6.1.2
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
POWER function, 2.1
POWERMULTISET function, 2.1
POWERMULTISET_BY_CARDINALITY 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

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
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 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.1.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 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
SIN function, 2.1
SINH function, 2.1
SOUNDEX function, 2.1
spatial_datatypes, 6.1.2
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
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
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_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, 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
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 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 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 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
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/DS datatypes
restrictions on, 6.1.3
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
Subclauses
activate_standby_db_clause, 5.1
add_binding_clause, 5.1
add_column_clause, 5.1
add_disk_clause, 5.1
SUBMULTISET conditions, 4.1
SUBSTR function, 2.1
SUM function, 2.1
Syntax for Subclauses, 5.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.3, 6.1.3
SQL/DS, 6.1.3, 6.1.3
time format models
short, 7.1.2.1
time zone
formatting, 7.1.2.1
TIMESTAMP datatype
DB2, 6.1.3, 6.1.3
SQL/DS, 6.1.3, 6.1.3
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
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 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.1.3, 6.1.3
SQL/DS, 6.1.3, 6.1.3
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, 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
XMLTRANSFORM function, 2.1