Skip Headers
Oracle® Database SQL Language Quick Reference
11g Release 2 (11.2)

Part Number E10593-04
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
Contact Us

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  Y 

Symbols

⁄ (slash) SQL*Plus command, A.1
@ (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_column_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_mv_log_column_clause, 5.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
add_volume_clause, 5.1
aggregate functions, 2.1
alias_file_name, 5.1
allocate_extent_clause, 5.1
ALTER CLUSTER statement, 1.1
ALTER DATABASE LINK 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 LIBRARY 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
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_datafile_clause, 5.1
alter_external_table, 5.1
alter_index_partitioning, 5.1
alter_interval_partitioning, 5.1
alter_iot_clauses, 5.1
alter_mapping_table_clauses, 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_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
alter_XMLSchema_clause, 5.1
American National Standards Institute (ANSI)
converting to Oracle data types, 6.4
analytic functions, 2.1
analytic_clause, 5.1
ANALYZE statement, 1.1
ANSI-supported data types, 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
audit_operation_clause, 5.1
audit_schema_object_clause, 5.1
auditing_by_clause, 5.1
auditing_on_clause, 5.1
autoextend_clause, 5.1
AVG function, 2.1

B

BETWEEN condition, 4.1
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

CALL statement, 1.1
CARDINALITY function, 2.1
CASE expressions, 3.1
CAST function, 2.1
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_clause, 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 expressions, 3.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
COMPOSE function, 2.1
composite_hash_partitions, 5.1
composite_list_partitions, 5.1
composite_range_partitions, 5.1
compound conditions, 4.1
compound expressions, 3.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
context_clause, 5.1
controlfile_clauses, 5.1
CONVERT function, 2.1
convert_database_clause, 5.1
converting to Oracle data types, 6.4
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 EDITION statement, 1.1
CREATE FLASHBACK ARCHIVE 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
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_mv_refresh, 5.1
CUBE_TABLE function, 2.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 expressions, 3.1
CV function, 2.1
cycle_clause, 5.1

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
long, 7.1.2.1
short, 7.1.2.1
datetime expressions, 3.1
datetime_datatypes, 6.2
db_user_proxy, 5.1
DB2 data types
restrictions on, 6.4
dblink, 5.1
dblink_authentication, 5.1
DBTIMEZONE function, 2.1
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
deferred_segment_creation, 5.1
DEL SQL*Plus command, A.1
DELETE statement, 1.1
DELETEXML function, 2.1
DENSE_RANK (aggregate) function, 2.1
DENSE_RANK (analytic) function, 2.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
disk_offline_clause, 5.1
disk_online_clause, 5.1
disk_region_clause, 5.1
diskgroup_alias_clauses, 5.1
diskgroup_attributes, 5.1
diskgroup_availability, 5.1
diskgroup_directory_clauses, 5.1
diskgroup_template_clauses, 5.1
diskgroup_volume_clauses, 5.1
distributed_recov_clauses, 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 EDITION 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

E

EDIT SQL*Plus command, A.1
else_clause, 5.1
EMPTY_BLOB function, 2.1
EMPTY_CLOB function, 2.1
enable_disable_clause, 5.1
enable_disable_volumes, 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
EXISTS condition, 4.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

FEATURE_ID function, 2.1
FEATURE_SET function, 2.1
FEATURE_VALUE function, 2.1
file_owner_clause, 5.1
file_permissions_clause, 5.1
file_specification, 5.1
FIRST function, 2.1
FIRST_VALUE function, 2.1
FLASHBACK DATABASE statement, 1.1
FLASHBACK TABLE statement, 1.1
flashback_archive_clause, 5.1
flashback_archive_quota, 5.1
flashback_archive_retention, 5.1
flashback_mode_clause, 5.1
flashback_query_clause, 5.1
floating-point conditions, 4.1
FLOOR function, 2.1
for_update_clause, 5.1
format models, 7.1
date format models, 7.1.2
number format models, 7.1.1.1
FROM_TZ function, 2.1
full_database_recovery, 5.1
fully_qualified_file_name, 5.1
function expressions, 3.1
function_association, 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 data type
DB2, 6.4
SQL/DS, 6.4
GREATEST function, 2.1
group comparison conditions, 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
hash_subparts_by_quantity, 5.1
HELP SQL*Plus command, A.1
hexadecimal value
returning, 7.1.1.1
HEXTORAW function, 2.1
hierarchical_query_clause, 5.1
hierarchy_clause, 5.1
HOST SQL*Plus command, A.1

I

implementation_clause, 5.1
IN condition, 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
individual_hash_subparts, 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
INSERTCHILDXML function, 2.1
INSERTCHILDXMLAFTER function, 2.1
INSERTCHILDXMLBEFORE function, 2.1
INSERTXMLAFTER function, 2.1
INSERTXMLBEFORE function, 2.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 condition, 4.1
IS ANY condition, 4.1
IS EMPTY condition, 4.1
IS OF type condition, 4.1
IS PRESENT condition, 4.1
ITERATION_NUMBER function, 2.1

J

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_partition_desc, 5.1
list_partitions, 5.1
list_subpartition_desc, 5.1
list_values_clause, 5.1
LISTAGG function, 2.1
LN function, 2.1
LNNVL function, 2.1
LOB_compression_clause, 5.1
LOB_deduplicate_clause, 5.1
LOB_parameters, 5.1
LOB_partition_storage, 5.1
LOB_partitioning_storage, 5.1
LOB_retention_storage, 5.1
LOB_storage_clause, 5.1
LOB_storage_parameters, 5.1
local_domain_index_clause, 5.1
local_partitioned_index, 5.1
local_XMLIndex_clause, 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 data type
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
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_iterate_clause, 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_diskgroup_files, 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_mv_column_clause, 5.1
modify_mv_log_clause, 5.1
modify_range_partition, 5.1
modify_table_default_attrs, 5.1
modify_table_partition, 5.1
modify_table_subpartition, 5.1
modify_volume_clause, 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
mv_log_augmentation, 5.1
mv_log_purge_clause, 5.1

N

NANVL function, 2.1
NCHR function, 2.1
nested_table_col_properties, 5.1
nested_table_partition_spec, 5.1
NEW_TIME function, 2.1
new_values_clause, 5.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
NTH_VALUE function, 2.1
NTILE function, 2.1
null conditions, 4.1
NULLIF function, 2.1
number, 5.1
number format elements, 7.1.1.1
number format models, 7.1.1.1
number_datatypes, 6.2
numeric_file_name, 5.1
NUMTODSINTERVAL function, 2.1
NUMTOYMINTERVAL function, 2.1
NVL function, 2.1
NVL2 function, 2.1

O

object access expressions, 3.1
object_properties, 5.1
object_table, 5.1
object_table_substitution, 5.1
object_type_col_properties, 5.1
object_view_clause, 5.1
OID_clause, 5.1
OID_index_clause, 5.1
on_comp_partitioned_table, 5.1
on_hash_partitioned_table, 5.1
on_list_partitioned_table, 5.1
on_object_clause, 5.1
on_range_partitioned_table, 5.1
ORA_DST_AFFECTED function, 2.1
ORA_DST_CONVERT function, 2.1
ORA_DST_ERROR function, 2.1
ORA_HASH function, 2.1
Oracle built-in data types, 6.1, 6.2
Oracle-supplied data types, 6.1
order_by_clause, 5.1
out_of_line_constraint, 5.1
out_of_line_part_storage, 5.1
out_of_line_ref_constraint, 5.1
outer_join_clause, 5.1
outer_join_type, 5.1

P

parallel_clause, 5.1
partial_database_recovery, 5.1
partition_attributes, 5.1
partition_extended_name, 5.1
partition_extension_clause, 5.1
partition_spec, 5.1
partitioning_storage_clause, 5.1
password_parameters, 5.1
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
permanent_tablespace_clause, 5.1
physical_attributes_clause, 5.1
physical_properties, 5.1
pivot_clause, 5.1
pivot_for_clause, 5.1
pivot_in_clause, 5.1
placeholder expressions, 3.1
POWER function, 2.1
POWERMULTISET function, 2.1
POWERMULTISET_BY_CARDINALITY function, 2.1
PREDICTION function, 2.1
PREDICTION_BOUNDS function, 2.1
PREDICTION_COST function, 2.1
PREDICTION_DETAILS function, 2.1
PREDICTION_PROBABILITY function, 2.1
PREDICTION_SET function, 2.1
PRESENTNNV function, 2.1
PRESENTV function, 2.1
PREVIOUS function, 2.1
proxy_clause, 5.1
PURGE statement, 1.1

Q

qualified_disk_clause, 5.1
qualified_template_clause, 5.1
query_block, 5.1
query_partition_clause, 5.1
query_table_expression, 5.1
quiesce_clauses, 5.1
QUIT SQL*Plus command, A.1

R

range_partition_desc, 5.1
range_partitions, 5.1
range_subpartition_desc, 5.1
range_values_clause, 5.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
rebalance_diskgroup_clause, 5.1
rebuild_clause, 5.1
records_per_block_clause, 5.1
recovery_clauses, 5.1
redo_log_file_spec, 5.1
redo_thread_clauses
see instance_clauses
redundancy_clause, 5.1
REF function, 2.1
reference_model, 5.1
reference_partition_desc, 5.1
reference_partitioning, 5.1
references_clause, 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
register_logfile_clause, 5.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
relational_properties, 5.1
relational_table, 5.1
REMAINDER function, 2.1
RENAME statement, 1.1
rename_column_clause, 5.1
rename_index_partition, 5.1
rename_partition_subpart, 5.1
REPLACE function, 2.1
resize_disk_clauses, 5.1
resource_parameters, 5.1
return_rows_clause, 5.1
returning_clause, 5.1
REVOKE statement, 1.1
revoke_object_privileges, 5.1
revoke_system_privileges, 5.1
ROLLBACK statement, 1.1
rolling_migration_clause, 5.1
rollup_cube_clause, 5.1
ROUND (date) function, 2.1
ROUND (number) function, 2.1
routine_clause, 5.1
row_movement_clause, 5.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

sample_clause, 5.1
SAVE SQL*Plus command, A.1
SAVEPOINT statement, 1.1
scalar subquery expressions, 3.1
scientific notation, 7.1.1.1
SCN_TO_TIMESTAMP function, 2.1
scoped_table_ref_constraint, 5.1
search_clause, 5.1
searched_case_expression, 5.1
security_clause, 5.1
security_clauses, 5.1
segment_attribute_clause, 5.1
segment_management_clause, 5.1
SELECT statement, 1.1
select_list, 5.1
SESSIONTIMEZONE function, 2.1
SET CONSTRAINT[S] statement, 1.1
SET function, 2.1
SET ROLE statement, 1.1
SET SQL*Plus command, A.1
SET TRANSACTION statement, 1.1
set_encryption_key, 5.1
set_parameter_clause, 5.1
set_subpartition_template, 5.1
set_time_zone_clause, 5.1
SHOW SQL*Plus command, A.1
shrink_clause, 5.1
SHUTDOWN SQL*Plus command, A.1
shutdown_dispatcher_clause, 5.1
SIGN function, 2.1
simple comparison conditions, 4.1
simple expressions, 3.1
simple_case_expression, 5.1
SIN function, 2.1
single_column_for_loop, 5.1
single_table_insert, 5.1
SINH function, 2.1
size_clause, 5.1
SOUNDEX function, 2.1
split_index_partition, 5.1
split_nested_table_part, 5.1
split_table_partition, 5.1
split_table_subpartition, 5.1
SPOOL SQL*Plus command, A.1
SQL conditions, 4
BETWEEN condition, 4.1
compound conditions, 4.1
EQUALS_PATH condition, 4.1
EXISTS condition, 4.1
floating-point conditions, 4.1
group comparison conditions, 4.1
IN condition, 4.1
IS A SET condition, 4.1
IS ANY condition, 4.1
IS EMPTY condition, 4.1
IS OF type condition, 4.1
IS PRESENT condition, 4.1
LIKE condition, 4.1
logical conditions, 4.1
MEMBER condition, 4.1
null conditions, 4.1
REGEXP_LIKE condition, 4.1
simple comparison conditions, 4.1
SUBMULTISET condition, 4.1
UNDER_PATH condition, 4.1
SQL expressions, 3
CASE expressions, 3.1
column expressions, 3.1
compound expressions, 3.1
CURSOR expressions, 3.1
datetime expressions, 3.1
function expressions, 3.1
INTERVAL expressions, 3.1
model expressions, 3.1
object access expressions, 3.1
placeholder expressions, 3.1
scalar subquery expressions, 3.1
simple expressions, 3.1
type constructor expressions, 3.1
SQL functions, 2
ABS, 2.1
ACOS, 2.1
ADD_MONTHS, 2.1
aggregate functions, 2.1
analytic functions, 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
CUBE_TABLE, 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
DELETEXML, 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
EMPTY_CLOB, 2.1
EXISTSNODE, 2.1
EXP, 2.1
EXTRACT (datetime), 2.1
EXTRACT (XML), 2.1
EXTRACTVALUE, 2.1
FEATURE_ID, 2.1
FEATURE_SET, 2.1
FEATURE_VALUE, 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
INSERTCHILDXML, 2.1
INSERTCHILDXMLAFTER, 2.1
INSERTCHILDXMLBEFORE, 2.1
INSERTXMLAFTER, 2.1
INSERTXMLBEFORE, 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
LISTAGG, 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
NTH_VALUE, 2.1
NTILE, 2.1
NULLIF, 2.1
NUMTODSINTERVAL, 2.1
NUMTOYMINTERVAL, 2.1
NVL, 2.1
NVL2, 2.1
ORA_DST_AFFECTED, 2.1
ORA_DST_CONVERT, 2.1
ORA_DST_ERROR, 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, 2.1
PREDICTION_BOUNDS, 2.1
PREDICTION_COST, 2.1
PREDICTION_DETAILS, 2.1
PREDICTION_PROBABILITY, 2.1
PREDICTION_SET, 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_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_BLOB, 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 functions, 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
XMLCDATA, 2.1
XMLCOLATTVAL, 2.1
XMLCOMMENT, 2.1
XMLCONCAT, 2.1
XMLDIFF, 2.1
XMLELEMENT, 2.1
XMLEXISTS, 2.1
XMLFOREST, 2.1
XMLISVALID, 2.1
XMLPARSE, 2.1
XMLPATCH, 2.1
XMLPI, 2.1
XMLQUERY, 2.1
XMLROOT, 2.1
XMLSEQUENCE, 2.1
XMLSERIALIZE, 2.1
XMLTABLE, 2.1
XMLTRANSFORM, 2.1
SQL statements, 1
ALTER CLUSTER, 1.1
ALTER DATABASE, 1.1
ALTER DATABASE LINK, 1.1
ALTER DIMENSION, 1.1
ALTER DISKGROUP, 1.1
ALTER FLASHBACK ARCHIVE, 1.1
ALTER FUNCTION, 1.1
ALTER INDEX, 1.1
ALTER INDEXTYPE, 1.1
ALTER JAVA, 1.1
ALTER LIBRARY, 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
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 EDITION, 1.1
CREATE FLASHBACK ARCHIVE, 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 RESTORE POINT, 1.1
CREATE ROLE, 1.1
CREATE ROLLBACK SEGMENT, 1.1
CREATE SCHEMA, 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 EDITION, 1.1
DROP FLASHBACK ARCHIVE, 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 RESTORE POINT, 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[S], 1.1
SET ROLE, 1.1
SET TRANSACTION, 1.1
TRUNCATE CLUSTER, 1.1
TRUNCATE TABLE, 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_format of TO_DSINTERVAL function, 5.1
SQL/DS data types
restrictions on, 6.4
SQLPLUS SQL*Plus command, A.1
SQRT function, 2.1
standby_database_clauses, 5.1
START SQL*Plus command, A.1
start_standby_clause, 5.1
STARTUP SQL*Plus command, A.1
startup_clauses, 5.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
still_image_object_types, 5.1
stop_standby_clause, 5.1
storage_clause, 5.1
storage_table_clause, 5.1
string, 5.1
striping_clause, 5.1
SUBMULTISET condition, 4.1
subpartition_by_hash, 5.1
subpartition_by_list, 5.1
subpartition_by_range, 5.1
subpartition_extended_name, 5.1
subpartition_template, 5.1
subquery, 5.1
subquery_factoring_clause, 5.1
subquery_restriction_clause, 5.1
substitutable_column_clause, 5.1
SUBSTR function, 2.1
SUM function, 2.1
supplemental_db_logging, 5.1
supplemental_id_key_clause, 5.1
supplemental_log_grp_clause, 5.1
supplemental_logging_props, 5.1
supplemental_plsql_clause, 5.1
supplemental_table_logging, 5.1
switch_logfile_clause, 5.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
system_partitioning, 5.1
SYSTIMESTAMP function, 2.1

T

table_collection_expression, 5.1
table_compression, 5.1
table_index_clause, 5.1
table_partition_description, 5.1
table_partitioning_clauses, 5.1
table_properties, 5.1
table_reference, 5.1
tablespace_clauses, 5.1
tablespace_group_clause, 5.1
tablespace_logging_clauses, 5.1
tablespace_retention_clause, 5.1
tablespace_state_clauses, 5.1
TAN function, 2.1
TANH function, 2.1
temporary_tablespace_clause, 5.1
TIME data type
DB2, 6.4, 6.4
SQL/DS, 6.4, 6.4
time format models, 7.1.2.1
time zone formatting, 7.1.2.1
timeout_clause, 5.1
TIMESTAMP data type
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_BLOB 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
trace_file_clause, 5.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 CLUSTER statement, 1.1
TRUNCATE TABLE statement, 1.1
truncate_partition_subpart, 5.1
type constructor expressions, 3.1
TZ_OFFSET function, 2.1

U

UID function, 2.1
UNDER_PATH condition, 4.1
undo_tablespace, 5.1
undo_tablespace_clause, 5.1
undrop_disk_clause, 5.1
UNISTR function, 2.1
unpivot_clause, 5.1
unpivot_in_clause, 5.1
UPDATE statement, 1.1
update_all_indexes_clause, 5.1
update_global_index_clause, 5.1
update_index_clauses, 5.1
update_index_partition, 5.1
update_index_subpartition, 5.1
update_set_clause, 5.1
UPDATEXML function, 2.1
upgrade_table_clause, 5.1
UPPER function, 2.1
USER function, 2.1
user_clauses, 5.1
user-defined data types, 6.1
user-defined functions, 2.1
USERENV function, 2.1
usergroup_clauses, 5.1
using_function_clause, 5.1
using_index_clause, 5.1
using_statistics_type, 5.1
using_type_clause, 5.1

V

validation_clauses, 5.1
VALUE function, 2.1
values_clause, 5.1
VAR_POP function, 2.1
VAR_SAMP function, 2.1
VARGRAPHIC data type
DB2, 6.4, 6.4
SQL/DS, 6.4, 6.4
VARIANCE function, 2.1
varray_col_properties, 5.1
varray_storage_clause, 5.1
virtual_column_definition, 5.1
VSIZE function, 2.1

W

where_clause, 5.1
WIDTH_BUCKET function, 2.1
windowing_clause, 5.1

X

XML_attributes_clause, 5.1
XML_namespaces_clause, 5.1
XML_passing_clause, 5.1
XML_table_column, 5.1
XMLAGG function, 2.1
XMLCast function, 2.1
XMLCDATA function, 2.1
XMLCOLATTVAL function, 2.1
XMLCOMMENT function, 2.1
XMLCONCAT function, 2.1
XMLDIFF function, 2.1
XMLELEMENT function, 2.1
XMLEXISTS function, 2.1
XMLFOREST function, 2.1
XMLindex_clause, 5.1
XMLISVALID function, 2.1
XMLPARSE function, 2.1
XMLPATCH function, 2.1
XMLPI function, 2.1
XMLQUERY function, 2.1
XMLROOT function, 2.1
XMLSchema_spec, 5.1
XMLSEQUENCE function, 2.1
XMLSERIALIZE function, 2.1
XMLTABLE function, 2.1
XMLTABLE_options, 5.1
XMLTRANSFORM function, 2.1
XMLType_column_properties, 5.1
XMLType_storage, 5.1
XMLType_table, 5.1
XMLType_view_clause, 5.1
XMLType_virtual_columns, 5.1

Y

ym_iso_format of TO_YMINTERVAL function, 5.1