1. Index

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
  • currency symbol
  • 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
  • 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
  • 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
  • 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_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
  • 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
  • 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

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
  • 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_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
  • 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_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
  • 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_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
  • time format models 7.1.2.1
  • timeout_clause 5.1
  • TIMESTAMP_TO_SCN function 2.1
  • TIMESTAMP data type
  • 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
  • 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