Index

Symbols 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 Z

Symbols

/ (slash) SQL*Plus command A.1
@ (at sign) SQL*Plus command A.1

A

ABS function 2.1
ACOS function 2.1
action_audit_clause 5.1
activate_standby_db_clause 5.1
add_binding_clause 5.1
add_column_clause 5.1
add_disk_clause 5.1
add_filegroup_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_period_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_update_secret 5.1
add_volume_clause 5.1
ADMINISTER KEY MANAGEMENT statement 1.1
advanced_index_compression 5.1
aggregate functions 2.1
alias_file_name 5.1
all_clause 5.1
allocate_extent_clause 5.1
allow_disallow_clustering 5.1
alter_automatic_partitioning 5.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_keystore_password 5.1
alter_mapping_table_clauses 5.1
alter_mv_refresh 5.1
alter_overflow_clause 5.1
alter_query_rewrite_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_tablespace_attrs 5.1
alter_tablespace_encryption 5.1
alter_tempfile_clause 5.1
alter_varray_col_properties 5.1
alter_XMLSchema_clause 5.1
alter_zonemap_attributes 5.1
ALTER ANALYTIC VIEW statement 1.1
ALTER ATTRIBUTE DIMENSION statement 1.1
ALTER AUDIT POLICY statement 1.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 HIERARCHY statement 1.1
ALTER INDEX statement 1.1
ALTER INDEXTYPE statement 1.1
ALTER INMEMORY JOIN GROUP statement 1.1
ALTER JAVA statement 1.1
ALTER LIBRARY statement 1.1
ALTER LOCKDOWN PROFILE statement 1.1
ALTER MATERIALIZED VIEW LOG statement 1.1
ALTER MATERIALIZED VIEW statement 1.1
ALTER MATERIALIZED ZONEMAP statement 1.1
alternate_key_clause 5.1
ALTER OPERATOR statement 1.1
ALTER OUTLINE statement 1.1
ALTER PACKAGE statement 1.1
ALTER PLUGGABLE DATABASE 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 SYNONYM statement 1.1
ALTER SYSTEM statement 1.1
ALTER TABLESPACE SET statement 1.1
ALTER TABLESPACE statement 1.1
ALTER TABLE statement 1.1
ALTER TRIGGER statement 1.1
ALTER TYPE statement 1.1
ALTER USER statement 1.1
ALTER VIEW statement 1.1
American National Standards Institute (ANSI)
- converting to Oracle data types 6.4
analytic_clause 5.1
analytic functions 2.1
ANALYZE statement 1.1
ANSI-supported data types 6.1
any_types 6.3
APPENDCHILDXML function 2.1
APPEND SQL*Plus command A.1
application_clauses 5.1
APPROX_COUNT_DISTINCT_AGG function 2.1
APPROX_COUNT_DISTINCT_DETAIL function 2.1
APPROX_COUNT_DISTINCT function 2.1
APPROX_MEDIAN function 2.1
APPROX_PERCENTILE_AGG function 2.1
APPROX_PERCENTILE_DETAIL function 2.1
APPROX_PERCENTILE function 2.1
archive_log_clause 5.1
array_DML_clause 5.1
array_step 5.1
ASCII function 2.1
ASCIISTR function 2.1
ASIN function 2.1
ASM_filename 5.1
ASSOCIATE STATISTICS statement 1.1
ATAN2 function 2.1
ATAN function 2.1
attr_dim_attributes_clause 5.1
attr_dim_level_clause 5.1
attr_dim_using_clause 5.1
attribute_clause 5.1
attribute_clustering_clause 5.1
attributes_clause 5.1
audit_operation_clause 5.1
audit_schema_object_clause 5.1
AUDIT (Traditional Auditing) statement 1.1
AUDIT (Unified Auditing) statement 1.1
auditing_by_clause 5.1
auditing_on_clause 5.1
autoextend_clause 5.1
av_meas_expression 5.1
av_measure 5.1
av_simple_expression 5.1
AVG function 2.1

B

backup_keystore 5.1
base_measure_clause 5.1
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
built-in data types 6.1, 6.2
by_users_with_roles 5.1

C

cache_clause 5.1
cache_specification 5.1
calc_meas_order_by_clause 5.1
calc_measure_clause 5.1
calculated measure expressions 3.1
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
classification_clause 5.1
clause_options 5.1
clear_free_space_clause 5.1
close_keystore 5.1
cluster_clause 5.1
CLUSTER_DETAILS (analytic) function 2.1
CLUSTER_DETAILS function 2.1
CLUSTER_DISTANCE (analytic) function 2.1
CLUSTER_DISTANCE function 2.1
CLUSTER_ID (analytic) function 2.1
CLUSTER_ID function 2.1
cluster_index_clause 5.1
CLUSTER_PROBABILITY (analytic) function 2.1
CLUSTER_PROBABILITY function 2.1
cluster_range_partitions 5.1
CLUSTER_SET (analytic) function 2.1
CLUSTER_SET function 2.1
clustering_column_group 5.1
clustering_columns 5.1
clustering_join 5.1
clustering_when 5.1
coalesce_index_partition 5.1
coalesce_table_partition 5.1
coalesce_table_subpartition 5.1
COALESCE function 2.1
COLLATION function 2.1
COLLECT function 2.1
column_association 5.1
column_clauses 5.1
column_definition 5.1
column_properties 5.1
column expressions 3.1
COMMENT statement 1.1
commit_switchover_clause 5.1
COMMIT statement 1.1
component_actions 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
CON_DBID_TO_ID function 2.1
CON_GUID_TO_ID function 2.1
CON_NAME_TO_ID function 2.1
CON_UID_TO_ID function 2.1
CONCAT function 2.1
conditional_insert_clause 5.1
conditions 4
- see also SQL conditions 4
CONNECT SQL*Plus command A.1
consistent_hash_partitions 5.1
consistent_hash_with_subpartitions 5.1
constraint 5.1
constraint_clauses 5.1
constraint_state 5.1
container_data_clause 5.1
containers_clause 5.1
context_clause 5.1
controlfile_clauses 5.1
convert_database_clause 5.1
convert_redundancy_clause 5.1
CONVERT function 2.1
converting to Oracle data types 6.4
CORR_K function 2.1
CORR_S function 2.1
CORR 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_datafile_clause 5.1
create_file_dest_clause 5.1
create_key 5.1
create_keystore 5.1
create_mv_refresh 5.1
create_pdb_clone 5.1
create_pdb_from_seed 5.1
create_pdb_from_xml 5.1
create_zonemap_as_subquery 5.1
create_zonemap_on_table 5.1
CREATE ANALYTIC VIEW statement 1.1
CREATE ATTRIBUTE DIMENSION statement 1.1
CREATE AUDIT POLICY 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 EDITION statement 1.1
CREATE FLASHBACK ARCHIVE statement 1.1
CREATE FUNCTION statement 1.1
CREATE HIERARCHY statement 1.1
CREATE INDEX statement 1.1
CREATE INDEXTYPE statement 1.1
CREATE INMEMORY JOIN GROUP statement 1.1
CREATE JAVA statement 1.1
CREATE LIBRARY statement 1.1
CREATE LOCKDOWN PROFILE statement 1.1
CREATE MATERIALIZED VIEW LOG statement 1.1
CREATE MATERIALIZED VIEW statement 1.1
CREATE MATERIALIZED ZONEMAP 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 PLUGGABLE DATABASE 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 TABLESPACE SET statement 1.1
CREATE TABLESPACE statement 1.1
CREATE TABLE 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
cross_outer_apply_clause 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_MAT_PARTITION function 2.1
DATAOBJ_TO_PARTITION function 2.1
data types
- ANSI-supported 6.1
- converting to Oracle 6.4
- Oracle built-in 6.1, 6.2
- Oracle-supplied 6.1, 6.3
- overview 6.1
- user-defined 6.1
date format models 7.1.2, 7.1.2.1
- long 7.1.2.1
- short 7.1.2.1
datetime_datatypes 6.2
datetime expressions 3.1
db_user_proxy_clauses 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_aggregate_clause 5.1
default_cost_clause 5.1
default_index_compression 5.1
default_measure_clause 5.1
default_selectivity_clause 5.1
default_settings_clauses 5.1
default_table_compression 5.1
default_tablespace 5.1
default_tablespace_params 5.1
default_temp_tablespace 5.1
deferred_segment_creation 5.1
delete_secret 5.1
DELETE statement 1.1
DEL SQL*Plus command A.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
dim_by_clause 5.1
dim_key 5.1
dim_order_clause 5.1
dim_ref 5.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
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_binding_clause 5.1
drop_column_clause 5.1
drop_constraint_clause 5.1
drop_disk_clause 5.1
drop_diskgroup_file_clause 5.1
drop_filegroup_clause 5.1
drop_index_partition 5.1
drop_logfile_clauses 5.1
drop_period_clause 5.1
drop_table_partition 5.1
drop_table_subpartition 5.1
DROP ANALYTIC VIEW statement 1.1
DROP ATTRIBUTE DIMENSION statement 1.1
DROP AUDIT POLICY 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 EDITION statement 1.1
DROP FLASHBACK ARCHIVE statement 1.1
DROP FUNCTION statement 1.1
DROP HIERARCHY statement 1.1
DROP INDEX statement 1.1
DROP INDEXTYPE statement 1.1
DROP INMEMORY JOIN GROUP statement 1.1
DROP JAVA statement 1.1
DROP LIBRARY statement 1.1
DROP LOCKDOWN PROFILE statement 1.1
DROP MATERIALIZED VIEW LOG statement 1.1
DROP MATERIALIZED VIEW statement 1.1
DROP MATERIALIZED ZONEMAP statement 1.1
DROP OPERATOR statement 1.1
DROP OUTLINE statement 1.1
DROP PACKAGE statement 1.1
DROP PLUGGABLE DATABASE 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 TABLESPACE SET statement 1.1
DROP TABLESPACE statement 1.1
DROP TABLE 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
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_volume 5.1
enable_pluggable_database 5.1
encryption_spec 5.1
end_session_clauses 5.1
EQUALS_PATH condition 4.1
error_logging_clause 5.1
evaluation_edition_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
export_keys 5.1
expr 5.1
expression_list 5.1
expressions 3
- see also SQL expressions 3
extended_attribute_clause 5.1
extent_management_clause 5.1
external_part_subpart_data_props 5.1
external_table_clause 5.1
external_table_data_props 5.1
EXTRACT (datetime) function 2.1
EXTRACT (XML) function 2.1
EXTRACTVALUE function 2.1

F

failover_clause 5.1
FEATURE_COMPARE function 2.1
FEATURE_DETAILS (analytic) function 2.1
FEATURE_DETAILS function 2.1
FEATURE_ID (analytic) function 2.1
FEATURE_ID function 2.1
FEATURE_SET (analytic) function 2.1
FEATURE_SET function 2.1
FEATURE_VALUE (analytic) function 2.1
FEATURE_VALUE function 2.1
file_name_convert 5.1
file_owner_clause 5.1
file_permissions_clause 5.1
file_specification 5.1
filegroup_clauses 5.1
filter_condition 5.1
FIRST_VALUE function 2.1
FIRST function 2.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
FLASHBACK DATABASE statement 1.1
FLASHBACK TABLE statement 1.1
floating-point conditions 4.1
FLOOR function 2.1
following_boundary 5.1
for_refresh_clause 5.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_association 5.1
function expressions 3.1
functions 2
- see also SQL functions 2

G

general_recovery 5.1
GET SQL*Plus command A.1
global_partitioned_index 5.1
grant_object_privileges 5.1
grant_roles_to_programs 5.1
grant_system_privileges 5.1
grantee_clause 5.1
grantee_identified_by 5.1
GRANT statement 1.1
GRAPHIC data type
- DB2 6.4
- SQL/DS 6.4
GREATEST function 2.1
group_by_clause 5.1
GROUP_ID function 2.1
group comparison conditions 4.1
grouping_expression_list 5.1
GROUPING_ID function 2.1
grouping_sets_clause 5.1
GROUPING function 2.1
group separator
- specifying 7.1.1.1

H

hash_partitions 5.1
hash_partitions_by_quantity 5.1
hash_subparts_by_quantity 5.1
heap_org_table_clause 5.1
HELP SQL*Plus command A.1
hexadecimal value
- returning 7.1.1.1
HEXTORAW function 2.1
hier_ancestor_expression 5.1
hier_attr_clause 5.1
hier_attr_name 5.1
hier_attrs_clause 5.1
hier_lead_lag_clause 5.1
hier_lead_lag_expression 5.1
hier_navigation_expression 5.1
hier_parent_expression 5.1
hier_ref 5.1
hier_using_clause 5.1
hierarchical_query_clause 5.1
hierarchy_clause 5.1
hierarchy_ref 5.1
HOST SQL*Plus command A.1

I

identity_clause 5.1
identity_options 5.1
ilm_clause 5.1
ilm_compression_policy 5.1
ilm_inmemory_policy 5.1
ilm_policy_clause 5.1
ilm_tiering_policy 5.1
ilm_time_period 5.1
implementation_clause 5.1
import_keys 5.1
incomplete_file_name 5.1
IN condition 4.1
index_attributes 5.1
index_compression 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
indexing_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
inmemory_attributes 5.1
inmemory_clause 5.1
inmemory_column_clause 5.1
inmemory_distribute 5.1
inmemory_duplicate 5.1
inmemory_memcompress 5.1
inmemory_priority 5.1
inmemory_table_clause 5.1
inner_cross_join_clause 5.1
INPUT SQL*Plus command A.1
insert_into_clause 5.1
INSERT statement 1.1
instance_clauses 5.1
instances_clause 5.1
INSTR function 2.1
integer 5.1
interval_day_to_second 5.1
interval_year_to_month 5.1
INTERVAL expressions 3.1
into_clause 5.1
invoker_rights_clause 5.1
IS ANY condition 4.1
IS A SET condition 4.1
IS EMPTY condition 4.1
IS JSON condition 4.1
IS OF type condition 4.1
IS PRESENT condition 4.1
ITERATION_NUMBER function 2.1

J

join_clause 5.1
JSON_agg_returning_clause 5.1
JSON_ARRAYAGG function 2.1
JSON_ARRAY function 2.1
JSON_column_definition 5.1
JSON_columns_clause 5.1
JSON_DATAGUIDE function 2.1
JSON_exists_column 5.1
JSON_exists_on_error_clause 5.1
JSON_EXISTS condition 4.1
JSON_nested_path 5.1
JSON_OBJECTAGG function 2.1
JSON_OBJECT function 2.1
JSON_on_null_clause 5.1
JSON_passing_clause 5.1
JSON_query_column 5.1
JSON_query_on_empty_clause 5.1
JSON_query_on_error_clause 5.1
JSON_query_return_type 5.1
JSON_query_returning_clause 5.1
JSON_query_wrapper_clause 5.1
JSON_QUERY function 2.1
JSON_returning_clause 5.1
JSON_table_on_error_clause 5.1
JSON_TABLE function 2.1
JSON_TEXTCONTAINS condition 4.1
JSON_TRANSFORM function 2.1
JSON_value_column 5.1
JSON_value_on_empty_clause 5.1
JSON_value_on_error_clause 5.1
JSON_value_return_type 5.1
JSON_value_returning_clause 5.1
JSON_VALUE function 2.1
JSON object access expressions 3.1

K

key_clause 5.1
key_management_clauses 5.1
keystore_clause 5.1
keystore_management_clauses 5.1

L

LAG function 2.1
large_object_datatypes 6.2
LAST_DAY function 2.1
LAST_VALUE function 2.1
LAST function 2.1
lead_lag_clause 5.1
lead_lag_expression 5.1
lead_lag_function_name 5.1
LEAD function 2.1
LEAST function 2.1
LENGTH function 2.1
level_clause 5.1
level_hier_clause 5.1
level_member_literal 5.1
level_specification 5.1
levels_clause 5.1
LIKE condition 4.1
list_partition_desc 5.1
list_partitions 5.1
list_partitionset_clause 5.1
list_partitionset_desc 5.1
list_subpartition_desc 5.1
list_values 5.1
list_values_clause 5.1
listagg_overflow_clause 5.1
LISTAGG function 2.1
LIST SQL*Plus command A.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
lockdown_features 5.1
lockdown_options 5.1
lockdown_statements 5.1
LOCK TABLE statement 1.1
logfile_clause 5.1
logfile_clauses 5.1
logfile_descriptor 5.1
LOG function 2.1
logging_clause 5.1
logical conditions 4.1
long_and_raw_datatypes 6.2
LONG VARGRAPHIC data type
- DB2 6.4
- SQL/DS 6.4
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
meas_aggregate_clause 5.1
measure 5.1
measure_ref 5.1
measures_clause 5.1
media_types 6.3
MEDIAN function 2.1
member_expression 5.1
MEMBER condition 4.1
merge_insert_clause 5.1
merge_into_existing_keystore 5.1
merge_into_new_keystore 5.1
merge_table_partitions 5.1
merge_table_subpartitions 5.1
merge_update_clause 5.1
MERGE statement 1.1
migrate_key 5.1
MIN function 2.1
mining_analytic_clause 5.1
mining_attribute_clause 5.1
model_clause 5.1
model_column_clauses 5.1
model_iterate_clause 5.1
model_rules_clause 5.1
model expressions 3.1
MOD function 2.1
modify_col_properties 5.1
modify_col_substitutable 5.1
modify_col_visibility 5.1
modify_collection_retrieval 5.1
modify_column_clauses 5.1
modify_diskgroup_file 5.1
modify_filegroup_clause 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_opaque_type 5.1
modify_range_partition 5.1
modify_table_default_attrs 5.1
modify_table_partition 5.1
modify_table_subpartition 5.1
modify_to_partitioned 5.1
modify_virtcol_properties 5.1
modify_volume_clause 5.1
MONTHS_BETWEEN function 2.1
move_datafile_clause 5.1
move_mv_log_clause 5.1
move_table_clause 5.1
move_table_partition 5.1
move_table_subpartition 5.1
move_to_filegroup_clause 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

named_member_keys 5.1
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_COLLATION_ID function 2.1
NLS_COLLATION_NAME function 2.1
NLS_INITCAP function 2.1
NLS_LOWER function 2.1
NLS_UPPER function 2.1
NLSSORT function 2.1
NOAUDIT (Traditional Auditing) statement 1.1
NOAUDIT (Unified Auditing) statement 1.1
NTH_VALUE function 2.1
NTILE function 2.1
null conditions 4.1
NULLIF function 2.1
number 5.1
number_datatypes 6.2
number format elements 7.1.1.1
number format models 7.1.1.1
numeric_file_name 5.1
NUMTODSINTERVAL function 2.1
NUMTOYMINTERVAL function 2.1
NVL2 function 2.1
NVL function 2.1

O

object_properties 5.1
object_step 5.1
object_table 5.1
object_table_substitution 5.1
object_type_col_properties 5.1
object_view_clause 5.1
object access expressions 3.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
open_keystore 5.1
option_values 5.1
ORA_DM_PARTITION_NAME function 2.1
ORA_DST_AFFECTED function 2.1
ORA_DST_CONVERT function 2.1
ORA_DST_ERROR function 2.1
ORA_HASH function 2.1
ORA_INVOKING_USER function 2.1
ORA_INVOKING_USERID function 2.1
Oracle built-in data types 6.1, 6.2
Oracle-supplied data types 6.1, 6.3
order_by_clause 5.1
ordinality_column 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
parallel_pdb_creation_clause 5.1
partial_database_recovery 5.1
partial_index_clause 5.1
partition_attributes 5.1
partition_extended_name 5.1
partition_extended_names 5.1
partition_extension_clause 5.1
partition_or_key_value 5.1
partition_spec 5.1
partitioning_storage_clause 5.1
partitionset_clauses 5.1
password_parameters 5.1
path_prefix_clause 5.1
PATH function 2.1
pdb_change_state 5.1
pdb_change_state_from_root 5.1
pdb_close 5.1
pdb_datafile_clause 5.1
pdb_dba_roles 5.1
pdb_force_logging_clause 5.1
pdb_general_recovery 5.1
pdb_logging_clauses 5.1
pdb_open 5.1
pdb_recovery_clauses 5.1
pdb_refresh_mode_clause 5.1
pdb_save_or_discard_state 5.1
pdb_settings_clauses 5.1
pdb_storage_clause 5.1
pdb_unplug_clause 5.1
PERCENT_RANK (aggregate) function 2.1
PERCENT_RANK (analytic) function 2.1
PERCENTILE_CONT function 2.1
PERCENTILE_DISC function 2.1
period_definition 5.1
permanent_tablespace_attrs 5.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
plsql_declarations 5.1
pos_member_keys 5.1
POWER function 2.1
POWERMULTISET_BY_CARDINALITY function 2.1
POWERMULTISET function 2.1
preceding_boundary 5.1
PREDICTION_BOUNDS function 2.1
PREDICTION_COST (analytic) function 2.1
PREDICTION_COST function 2.1
PREDICTION_DETAILS (analytic) function 2.1
PREDICTION_DETAILS function 2.1
PREDICTION_PROBABILITY (analytic) function 2.1
PREDICTION_PROBABILITY function 2.1
PREDICTION_SET (analytic) function 2.1
PREDICTION_SET function 2.1
PREDICTION (analytic) function 2.1
PREDICTION function 2.1
prefix_compression 5.1
PRESENTNNV function 2.1
PRESENTV function 2.1
PREVIOUS function 2.1
privilege_audit_clause 5.1
program_unit 5.1
proxy_clause 5.1
PURGE statement 1.1

Q

qdr_expression 5.1
qualified_disk_clause 5.1
qualified_template_clause 5.1
qualifier 5.1
query_block 5.1
query_partition_clause 5.1
query_rewrite_clause 5.1
query_table_expression 5.1
quiesce_clauses 5.1
QUIT SQL*Plus command A.1
quotagroup_clauses 5.1

R

range_partition_desc 5.1
range_partitions 5.1
range_partitionset_clause 5.1
range_partitionset_desc 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
read_only_clause 5.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 5.1
redundancy_clause 5.1
reference_model 5.1
reference_partition_desc 5.1
reference_partitioning 5.1
references_clause 5.1
REF function 2.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
relocate_clause 5.1
REMAINDER function 2.1
rename_column_clause 5.1
rename_disk_clause 5.1
rename_index_partition 5.1
rename_partition_subpart 5.1
RENAME statement 1.1
replace_disk_clause 5.1
REPLACE function 2.1
resize_disk_clause 5.1
resource_parameters 5.1
return_rows_clause 5.1
returning_clause 5.1
reverse_migrate_key 5.1
revoke_object_privileges 5.1
revoke_roles_from_programs 5.1
revoke_system_privileges 5.1
revokee_clause 5.1
REVOKE statement 1.1
role_audit_clause 5.1
ROLLBACK statement 1.1
rolling_migration_clauses 5.1
rolling_patch_clauses 5.1
rollup_cube_clause 5.1
ROUND (date) function 2.1
ROUND (number) function 2.1
routine_clause 5.1
row_limiting_clause 5.1
row_movement_clause 5.1
ROW_NUMBER function 2.1
row_pattern 5.1
row_pattern_aggregate_func 5.1
row_pattern_classifier_func 5.1
row_pattern_clause 5.1
row_pattern_definition 5.1
row_pattern_definition_list 5.1
row_pattern_factor 5.1
row_pattern_match_num_func 5.1
row_pattern_measure_column 5.1
row_pattern_measures 5.1
row_pattern_nav_compound 5.1
row_pattern_nav_logical 5.1
row_pattern_nav_physical 5.1
row_pattern_navigation_func 5.1
row_pattern_order_by 5.1
row_pattern_partition_by 5.1
row_pattern_permute 5.1
row_pattern_primary 5.1
row_pattern_quantifier 5.1
row_pattern_rec_func 5.1
row_pattern_rows_per_match 5.1
row_pattern_skip_to 5.1
row_pattern_subset_clause 5.1
row_pattern_subset_item 5.1
row_pattern_term 5.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
SAVEPOINT statement 1.1
SAVE SQL*Plus command A.1
scalar subquery expressions 3.1
scientific notation 7.1.1.1
SCN_TO_TIMESTAMP function 2.1
scoped_table_ref_constraint 5.1
scrub_clause 5.1
search_clause 5.1
searched_case_expression 5.1
secret_management_clauses 5.1
security_clause 5.1
security_clauses 5.1
segment_attributes_clause 5.1
segment_management_clause 5.1
select_list 5.1
SELECT statement 1.1
service_name_convert 5.1
SESSIONTIMEZONE function 2.1
set_encryption_key 5.1
set_key 5.1
set_key_tag 5.1
set_parameter_clause 5.1
set_subpartition_template 5.1
set_time_zone_clause 5.1
SET CONSTRAINT statement 1.1
SET function 2.1
SET ROLE statement 1.1
SET SQL*Plus command A.1
SET TRANSACTION statement 1.1
share_clause 5.1
share_of_expression 5.1
sharing_clause 5.1
SHOW SQL*Plus command A.1
shrink_clause 5.1
shutdown_dispatcher_clause 5.1
SHUTDOWN SQL*Plus command A.1
SIGN function 2.1
simple_case_expression 5.1
simple comparison conditions 4.1
simple expressions 3.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
source_file_directory 5.1
source_file_name_convert 5.1
spatial_types 6.3
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_format of TO_DSINTERVAL function 5.1
SQL/DS data types
- restrictions on 6.4
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 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 ANY condition 4.1
- IS A SET condition 4.1
- IS EMPTY condition 4.1
- IS JSON condition 4.1
- IS OF type condition 4.1
- IS PRESENT condition 4.1
- JSON_EXISTS condition 4.1
- JSON_TEXTCONTAINS 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
- calculated measure expressions 3.1
- 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
- JSON object access 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, 2.1
- ABS 2.1
- ACOS 2.1
- ADD_MONTHS 2.1
- aggregate functions 2.1
- analytic functions 2.1
- APPROX_COUNT_DISTINCT 2.1
- APPROX_COUNT_DISTINCT_AGG 2.1
- APPROX_COUNT_DISTINCT_DETAIL 2.1
- APPROX_MEDIAN 2.1
- APPROX_PERCENTILE 2.1
- APPROX_PERCENTILE_AGG 2.1
- APPROX_PERCENTILE_DETAIL 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_DETAILS 2.1
- CLUSTER_DETAILS (analytic) 2.1
- CLUSTER_DISTANCE 2.1
- CLUSTER_DISTANCE (analytic) 2.1
- CLUSTER_ID 2.1
- CLUSTER_ID (analytic) 2.1
- CLUSTER_PROBABILITY 2.1
- CLUSTER_PROBABILITY (analytic) 2.1
- CLUSTER_SET 2.1
- CLUSTER_SET (analytic) 2.1
- COALESCE 2.1
- COLLATION 2.1
- COLLECT 2.1
- COMPOSE 2.1
- CON_DBID_TO_ID 2.1
- CON_GUID_TO_ID 2.1
- CON_NAME_TO_ID 2.1
- CON_UID_TO_ID 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_MAT_PARTITION 2.1
- DATAOBJ_TO_PARTITION 2.1
- DBTIMEZONE 2.1
- DECODE 2.1
- DECOMPOSE 2.1
- DENSE_RANK (aggregate) 2.1
- DENSE_RANK (analytic) 2.1
- DEPTH 2.1
- DEREF 2.1
- DUMP 2.1
- EMPTY_BLOB 2.1
- EMPTY_CLOB 2.1
- EXISTSNODE 2.1
- EXP 2.1
- EXTRACT (datetime) 2.1
- EXTRACT (XML) 2.1
- EXTRACTVALUE 2.1
- FEATURE_COMPARE 2.1
- FEATURE_DETAILS 2.1
- FEATURE_DETAILS (analytic) 2.1
- FEATURE_ID 2.1
- FEATURE_ID (analytic) 2.1
- FEATURE_SET 2.1
- FEATURE_SET (analytic) 2.1
- FEATURE_VALUE 2.1
- FEATURE_VALUE (analytic) 2.1
- FIRST 2.1
- FIRST_VALUE 2.1
- FLOOR 2.1
- FROM_TZ 2.1
- GREATEST 2.1
- GROUP_ID 2.1
- GROUPING 2.1
- GROUPING_ID 2.1
- HEXTORAW 2.1
- INITCAP 2.1
- INSTR 2.1
- ITERATION_NUMBER 2.1
- JSON_ARRAY 2.1
- JSON_ARRAYAGG 2.1
- JSON_DATAGUIDE 2.1
- JSON_OBJECT 2.1
- JSON_OBJECTAGG 2.1
- JSON_QUERY 2.1
- JSON_TABLE 2.1
- JSON_TRANSFORM 2.1
- JSON_VALUE 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_COLLATION_ID 2.1
- NLS_COLLATION_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_DM_PARTITION_NAME 2.1
- ORA_DST_AFFECTED 2.1
- ORA_DST_CONVERT 2.1
- ORA_DST_ERROR 2.1
- ORA_HASH 2.1
- ORA_INVOKING_USER 2.1
- ORA_INVOKING_USERID 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_COST (analytic) 2.1
- PREDICTION_DETAILS 2.1
- PREDICTION_DETAILS (analytic) 2.1
- PREDICTION_PROBABILITY 2.1
- PREDICTION_PROBABILITY (analytic) 2.1
- PREDICTION_SET 2.1
- PREDICTION_SET (analytic) 2.1
- PREDICTION (analytic) 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
- STANDARD_HASH 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_OP_ZONE_ID 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_APPROX_COUNT_DISTINCT 2.1
- TO_APPROX_PERCENTILE 2.1
- TO_BINARY_DOUBLE 2.1
- TO_BINARY_FLOAT 2.1
- TO_BLOB (bfile) 2.1
- TO_BLOB (raw) 2.1
- TO_CHAR (bfile|blob) 2.1
- TO_CHAR (character) 2.1
- TO_CHAR (datetime) 2.1
- TO_CHAR (number) 2.1
- TO_CLOB (bfile|blob) 2.1
- TO_CLOB (character) 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
- UPPER 2.1
- USER 2.1
- user-defined functions 2.1
- USERENV 2.1
- VALIDATE_CONVERSION 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
SQLPLUS SQL*Plus command A.1
SQL statements 1
- ADMINISTER KEY MANAGEMENT 1.1
- ALTER ANALYTIC VIEW 1.1
- ALTER ATTRIBUTE DIMENSION 1.1
- ALTER AUDIT POLICY 1.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 HIERARCHY 1.1
- ALTER INDEX 1.1
- ALTER INDEXTYPE 1.1
- ALTER INMEMORY JOIN GROUP 1.1
- ALTER JAVA 1.1
- ALTER LIBRARY 1.1
- ALTER LOCKDOWN PROFILE 1.1
- ALTER MATERIALIZED VIEW 1.1
- ALTER MATERIALIZED VIEW LOG 1.1
- ALTER MATERIALIZED ZONEMAP 1.1
- ALTER OPERATOR 1.1
- ALTER OUTLINE 1.1
- ALTER PACKAGE 1.1
- ALTER PLUGGABLE DATABASE 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 SYNONYM 1.1
- ALTER SYSTEM 1.1
- ALTER TABLE 1.1
- ALTER TABLESPACE 1.1
- ALTER TABLESPACE SET 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 (Traditional Auditing) 1.1
- AUDIT (Unified Auditing) 1.1
- CALL 1.1
- COMMENT 1.1
- COMMIT 1.1
- CREATE ANALYTIC VIEW 1.1
- CREATE ATTRIBUTE DIMENSION 1.1
- CREATE AUDIT POLICY 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 HIERARCHY 1.1
- CREATE INDEX 1.1
- CREATE INDEXTYPE 1.1
- CREATE INMEMORY JOIN GROUP 1.1
- CREATE JAVA 1.1
- CREATE LIBRARY 1.1
- CREATE LOCKDOWN PROFILE 1.1
- CREATE MATERIALIZED VIEW 1.1
- CREATE MATERIALIZED VIEW LOG 1.1
- CREATE MATERIALIZED ZONEMAP 1.1
- CREATE OPERATOR 1.1
- CREATE OUTLINE 1.1
- CREATE PACKAGE 1.1
- CREATE PACKAGE BODY 1.1
- CREATE PFILE 1.1
- CREATE PLUGGABLE DATABASE 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 TABLESPACE SET 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 ANALYTIC VIEW 1.1
- DROP ATTRIBUTE DIMENSION 1.1
- DROP AUDIT POLICY 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 HIERARCHY 1.1
- DROP INDEX 1.1
- DROP INDEXTYPE 1.1
- DROP INMEMORY JOIN GROUP 1.1
- DROP JAVA 1.1
- DROP LIBRARY 1.1
- DROP LOCKDOWN PROFILE 1.1
- DROP MATERIALIZED VIEW 1.1
- DROP MATERIALIZED VIEW LOG 1.1
- DROP MATERIALIZED ZONEMAP 1.1
- DROP OPERATOR 1.1
- DROP OUTLINE 1.1
- DROP PACKAGE 1.1
- DROP PLUGGABLE DATABASE 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 TABLESPACE SET 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 (Traditional Auditing) 1.1
- NOAUDIT (Unified Auditing) 1.1
- PURGE 1.1
- RENAME 1.1
- REVOKE 1.1
- ROLLBACK 1.1
- SAVEPOINT 1.1
- SELECT 1.1
- SET CONSTRAINT 1.1
- SET ROLE 1.1
- SET TRANSACTION 1.1
- TRUNCATE CLUSTER 1.1
- TRUNCATE TABLE 1.1
- UPDATE 1.1
SQRT function 2.1
standard_actions 5.1
STANDARD_HASH function 2.1
standby_database_clauses 5.1
standbys_clause 5.1
start_standby_clause 5.1
START SQL*Plus command A.1
startup_clauses 5.1
STARTUP SQL*Plus command A.1
statement_clauses 5.1
statements 1
- see also SQL statements 1
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_POP function 2.1
STDDEV_SAMP function 2.1
STDDEV 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_extended_names 5.1
subpartition_or_key_value 5.1
subpartition_spec 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
supplied data types 6.1, 6.3
switch_logfile_clause 5.1
switchover_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_OP_ZONE_ID 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_datafile_clauses 5.1
tablespace_encryption_clause 5.1
tablespace_encryption_spec 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
tempfile_reuse_clause 5.1
temporary_tablespace_clause 5.1
TIME data type
- DB2 6.4
- SQL/DS 6.4
time format models 7.1.2.1
timeout_clause 5.1
TIMESTAMP_TO_SCN function 2.1
TIMESTAMP data type
- DB2 6.4
- SQL/DS 6.4
time zone formatting 7.1.2.1
TO_APPROX_COUNT_DISTINCT function 2.1
TO_APPROX_PERCENTILE function 2.1
TO_BINARY_DOUBLE function 2.1
TO_BINARY_FLOAT function 2.1
TO_BLOB (bfile) function 2.1
TO_BLOB (raw) function 2.1
TO_CHAR (bfile|blob) function 2.1
TO_CHAR (character) function 2.1
TO_CHAR (datetime) function 2.1
TO_CHAR (number) function 2.1
TO_CLOB (bfile|blob) function 2.1
TO_CLOB (character) 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_TZ function 2.1
TO_TIMESTAMP function 2.1
TO_YMINTERVAL function 2.1
trace_file_clause 5.1
TRANSLATE...USING function 2.1
TRANSLATE function 2.1
TREAT function 2.1
TRIM function 2.1
TRUNC (date) function 2.1
TRUNC (number) function 2.1
truncate_partition_subpart 5.1
TRUNCATE CLUSTER statement 1.1
TRUNCATE TABLE statement 1.1
ts_file_name_convert 5.1
type constructor expressions 3.1
TZ_OFFSET function 2.1

U

UID function 2.1
UNDER_PATH condition 4.1
undo_mode_clause 5.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
unusable_editions_clause 5.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
UPDATE statement 1.1
upgrade_table_clause 5.1
UPPER function 2.1
use_key 5.1
user_clauses 5.1
user_tablespaces_clause 5.1
user-defined data types 6.1
user-defined functions 2.1
USERENV function 2.1
USER function 2.1
usergroup_clauses 5.1
using_clause 5.1
using_function_clause 5.1
using_index_clause 5.1
using_statistics_type 5.1
using_type_clause 5.1

V

VALIDATE_CONVERSION function 2.1
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
- SQL/DS 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
window_clause 5.1
window_expression 5.1
windowing_clause 5.1
with_clause 5.1

X

XML_attributes_clause 5.1
XML_passing_clause 5.1
XML_table_column 5.1
XML_types 6.3
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
XMLnamespaces_clause 5.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_options 5.1
XMLTABLE function 2.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

Z

zonemap_attributes 5.1
zonemap_clause 5.1
zonemap_refresh_clause 5.1