Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  

Symbols

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

A

  • ABS function 1
  • ACOS function 1
  • action_audit_clause 1
  • activate_standby_db_clause 1
  • add_binding_clause 1
  • add_column_clause 1
  • add_disk_clause 1
  • add_filegroup_clause 1
  • add_hash_index_partition 1
  • add_hash_partition_clause 1
  • add_hash_subpartition 1
  • add_list_partition_clause 1
  • add_list_subpartition 1
  • add_logfile_clauses 1
  • ADD_MONTHS function 1
  • add_mv_log_column_clause 1
  • add_overflow_clause 1
  • add_period_clause 1
  • add_range_partition_clause 1
  • add_range_subpartition 1
  • add_system_partition_clause 1
  • add_table_partition 1
  • add_update_secret 1
  • add_volume_clause 1
  • ADMINISTER KEY MANAGEMENT statement 1
  • advanced_index_compression 1
  • aggregate functions 1
  • alias_file_name 1
  • all_clause 1
  • allocate_extent_clause 1
  • allow_disallow_clustering 1
  • alter_automatic_partitioning 1
  • alter_datafile_clause 1
  • alter_external_table 1
  • alter_index_partitioning 1
  • alter_interval_partitioning 1
  • alter_iot_clauses 1
  • alter_keystore_password 1
  • alter_mapping_table_clauses 1
  • alter_mv_refresh 1
  • alter_overflow_clause 1
  • alter_query_rewrite_clause 1
  • alter_session_set_clause 1
  • alter_system_reset_clause 1
  • alter_system_set_clause 1
  • alter_table_partitioning 1
  • alter_table_properties 1
  • alter_tablespace_attrs 1
  • alter_tablespace_encryption 1
  • alter_tempfile_clause 1
  • alter_varray_col_properties 1
  • alter_XMLSchema_clause 1
  • alter_zonemap_attributes 1
  • ALTER ANALYTIC VIEW statement 1
  • ALTER ATTRIBUTE DIMENSION statement 1
  • ALTER AUDIT POLICY statement 1
  • ALTER CLUSTER statement 1
  • ALTER DATABASE LINK statement 1
  • ALTER DATABASE statement 1
  • ALTER DIMENSION statement 1
  • ALTER DISKGROUP statement 1
  • ALTER FLASHBACK ARCHIVE statement 1
  • ALTER FUNCTION statement 1
  • ALTER HIERARCHY statement 1
  • ALTER INDEX statement 1
  • ALTER INDEXTYPE statement 1
  • ALTER INMEMORY JOIN GROUP statement 1
  • ALTER JAVA statement 1
  • ALTER LIBRARY statement 1
  • ALTER LOCKDOWN PROFILE statement 1
  • ALTER MATERIALIZED VIEW LOG statement 1
  • ALTER MATERIALIZED VIEW statement 1
  • ALTER MATERIALIZED ZONEMAP statement 1
  • alternate_key_clause 1
  • ALTER OPERATOR statement 1
  • ALTER OUTLINE statement 1
  • ALTER PACKAGE statement 1
  • ALTER PLUGGABLE DATABASE statement 1
  • ALTER PROCEDURE statement 1
  • ALTER PROFILE statement 1
  • ALTER RESOURCE COST statement 1
  • ALTER ROLE statement 1
  • ALTER ROLLBACK SEGMENT statement 1
  • ALTER SEQUENCE statement 1
  • ALTER SESSION statement 1
  • ALTER SYNONYM statement 1
  • ALTER SYSTEM statement 1
  • ALTER TABLESPACE SET statement 1
  • ALTER TABLESPACE statement 1
  • ALTER TABLE statement 1
  • ALTER TRIGGER statement 1
  • ALTER TYPE statement 1
  • ALTER USER statement 1
  • ALTER VIEW statement 1
  • American National Standards Institute (ANSI)
    • converting to Oracle data types 1
  • analytic_clause 1
  • analytic functions 1
  • ANALYZE statement 1
  • ANSI-supported data types 1
  • any_types 1
  • APPENDCHILDXML function 1
  • APPEND SQL*Plus command 1
  • application_clauses 1
  • APPROX_COUNT_DISTINCT_AGG function 1
  • APPROX_COUNT_DISTINCT_DETAIL function 1
  • APPROX_COUNT_DISTINCT function 1
  • APPROX_MEDIAN function 1
  • APPROX_PERCENTILE_AGG function 1
  • APPROX_PERCENTILE_DETAIL function 1
  • APPROX_PERCENTILE function 1
  • archive_log_clause 1
  • array_DML_clause 1
  • array_step 1
  • ASCII function 1
  • ASCIISTR function 1
  • ASIN function 1
  • ASM_filename 1
  • ASSOCIATE STATISTICS statement 1
  • ATAN2 function 1
  • ATAN function 1
  • attr_dim_attributes_clause 1
  • attr_dim_level_clause 1
  • attr_dim_using_clause 1
  • attribute_clause 1
  • attribute_clustering_clause 1
  • attributes_clause 1
  • audit_operation_clause 1
  • audit_schema_object_clause 1
  • AUDIT (Traditional Auditing) statement 1
  • AUDIT (Unified Auditing) statement 1
  • auditing_by_clause 1
  • auditing_on_clause 1
  • autoextend_clause 1
  • av_meas_expression 1
  • av_measure 1
  • av_simple_expression 1
  • AVG function 1

B

  • backup_keystore 1
  • base_measure_clause 1
  • BETWEEN condition 1
  • BFILENAME function 1
  • BIN_TO_NUM function 1
  • binding_clause 1
  • BITAND function 1
  • bitmap_join_index_clause 1
  • build_clause 1
  • built-in data types 1 , 2
  • by_users_with_roles 1

C

  • cache_clause 1
  • cache_specification 1
  • calc_meas_order_by_clause 1
  • calc_measure_clause 1
  • calculated measure expressions 1
  • CALL statement 1
  • CARDINALITY function 1
  • CASE expressions 1
  • CAST function 1
  • CEIL function 1
  • cell_assignment 1
  • cell_reference_options 1
  • CHANGE SQL*Plus command 1
  • character_datatypes 1
  • character_set_clause 1
  • CHARTOROWID function 1
  • check_datafiles_clause 1
  • check_diskgroup_clause 1
  • checkpoint_clause 1
  • CHR function 1
  • classification_clause 1
  • clause_options 1
  • close_keystore 1
  • cluster_clause 1
  • CLUSTER_DETAILS (analytic) function 1
  • CLUSTER_DETAILS function 1
  • CLUSTER_DISTANCE (analytic) function 1
  • CLUSTER_DISTANCE function 1
  • CLUSTER_ID (analytic) function 1
  • CLUSTER_ID function 1
  • cluster_index_clause 1
  • CLUSTER_PROBABILITY (analytic) function 1
  • CLUSTER_PROBABILITY function 1
  • cluster_range_partitions 1
  • CLUSTER_SET (analytic) function 1
  • CLUSTER_SET function 1
  • clustering_column_group 1
  • clustering_columns 1
  • clustering_join 1
  • clustering_when 1
  • coalesce_index_partition 1
  • coalesce_table_partition 1
  • coalesce_table_subpartition 1
  • COALESCE function 1
  • COLLATION function 1
  • COLLECT function 1
  • column_association 1
  • column_clauses 1
  • column_definition 1
  • column_properties 1
  • column expressions 1
  • COMMENT statement 1
  • commit_switchover_clause 1
  • COMMIT statement 1
  • component_actions 1
  • COMPOSE function 1
  • composite_hash_partitions 1
  • composite_list_partitions 1
  • composite_range_partitions 1
  • compound conditions 1
  • compound expressions 1
  • CON_DBID_TO_ID function 1
  • CON_GUID_TO_ID function 1
  • CON_NAME_TO_ID function 1
  • CON_UID_TO_ID function 1
  • CONCAT function 1
  • conditional_insert_clause 1
  • conditions
    • see also SQL conditions 1
  • CONNECT SQL*Plus command 1
  • consistent_hash_partitions 1
  • consistent_hash_with_subpartitions 1
  • constraint 1
  • constraint_clauses 1
  • constraint_state 1
  • container_data_clause 1
  • containers_clause 1
  • context_clause 1
  • controlfile_clauses 1
  • convert_database_clause 1
  • convert_redundancy_clause 1
  • CONVERT function 1
  • converting to Oracle data types 1
  • CORR_K function 1
  • CORR_S function 1
  • CORR function 1
  • COS function 1
  • COSH function 1
  • cost_matrix_clause 1
  • COUNT function 1
  • COVAR_POP function 1
  • COVAR_SAMP function 1
  • create_datafile_clause 1
  • create_file_dest_clause 1
  • create_key 1
  • create_keystore 1
  • create_mv_refresh 1
  • create_pdb_clone 1
  • create_pdb_from_seed 1
  • create_pdb_from_xml 1
  • create_zonemap_as_subquery 1
  • create_zonemap_on_table 1
  • CREATE ANALYTIC VIEW statement 1
  • CREATE ATTRIBUTE DIMENSION statement 1
  • CREATE AUDIT POLICY statement 1
  • CREATE CLUSTER statement 1
  • CREATE CONTEXT statement 1
  • CREATE CONTROLFILE statement 1
  • CREATE DATABASE LINK statement 1
  • CREATE DATABASE statement 1
  • CREATE DIMENSION statement 1
  • CREATE DIRECTORY statement 1
  • CREATE DISKGROUP statement 1
  • CREATE EDITION statement 1
  • CREATE FLASHBACK ARCHIVE statement 1
  • CREATE FUNCTION statement 1
  • CREATE HIERARCHY statement 1
  • CREATE INDEX statement 1
  • CREATE INDEXTYPE statement 1
  • CREATE INMEMORY JOIN GROUP statement 1
  • CREATE JAVA statement 1
  • CREATE LIBRARY statement 1
  • CREATE LOCKDOWN PROFILE statement 1
  • CREATE MATERIALIZED VIEW LOG statement 1
  • CREATE MATERIALIZED VIEW statement 1
  • CREATE MATERIALIZED ZONEMAP statement 1
  • CREATE OPERATOR statement 1
  • CREATE OUTLINE statement 1
  • CREATE PACKAGE BODY statement 1
  • CREATE PACKAGE statement 1
  • CREATE PFILE statement 1
  • CREATE PLUGGABLE DATABASE statement 1
  • CREATE PROCEDURE statement 1
  • CREATE PROFILE statement 1
  • CREATE RESTORE POINT statement 1
  • CREATE ROLE statement 1
  • CREATE ROLLBACK SEGMENT statement 1
  • CREATE SCHEMA statement 1
  • CREATE SEQUENCE statement 1
  • CREATE SPFILE statement 1
  • CREATE SYNONYM statement 1
  • CREATE TABLESPACE SET statement 1
  • CREATE TABLESPACE statement 1
  • CREATE TABLE statement 1
  • CREATE TRIGGER statement 1
  • CREATE TYPE BODY statement 1
  • CREATE TYPE statement 1
  • CREATE USER statement 1
  • CREATE VIEW statement 1
  • cross_outer_apply_clause 1
  • CUBE_TABLE function 1
  • CUME_DIST (aggregate) function 1
  • CUME_DIST (analytic) function 1
  • currency
    • group separators 1
  • currency symbol
    • ISO 1
    • local 1
    • union 1
  • CURRENT_DATE function 1
  • CURRENT_TIMESTAMP function 1
  • CURSOR expressions 1
  • CV function 1
  • cycle_clause 1

D

  • database_file_clauses 1
  • database_logging_clauses 1
  • datafile_tempfile_clauses 1
  • datafile_tempfile_spec 1
  • DATAOBJ_TO_MAT_PARTITION function 1
  • DATAOBJ_TO_PARTITION function 1
  • data types
    • ANSI-supported 1
    • converting to Oracle 1
    • Oracle built-in 1 , 2
    • Oracle-supplied 1 , 2
    • overview 1
    • user-defined 1
  • date format models
    • long 1
    • short 1
  • datetime_datatypes 1
  • datetime expressions 1
  • db_user_proxy_clauses 1
  • DB2 data types
    • restrictions on 1
  • dblink 1
  • dblink_authentication 1
  • DBTIMEZONE function 1
  • deallocate_unused_clause 1
  • decimal characters
    • specifying 1
  • DECODE function 1
  • DECOMPOSE function 1
  • default_aggregate_clause 1
  • default_cost_clause 1
  • default_index_compression 1
  • default_measure_clause 1
  • default_selectivity_clause 1
  • default_settings_clauses 1
  • default_table_compression 1
  • default_tablespace 1
  • default_tablespace_params 1
  • default_temp_tablespace 1
  • deferred_segment_creation 1
  • delete_secret 1
  • DELETE statement 1
  • DELETEXML function 1
  • DEL SQL*Plus command 1
  • DENSE_RANK (aggregate) function 1
  • DENSE_RANK (analytic) function 1
  • dependent_tables_clause 1
  • DEPTH function 1
  • DEREF function 1
  • DESCRIBE SQL*Plus command 1
  • dim_by_clause 1
  • dim_key 1
  • dim_order_clause 1
  • dim_ref 1
  • dimension_join_clause 1
  • DISASSOCIATE STATISTICS statement 1
  • DISCONNECT SQL*Plus command 1
  • disk_offline_clause 1
  • disk_online_clause 1
  • disk_region_clause 1
  • diskgroup_alias_clauses 1
  • diskgroup_attributes 1
  • diskgroup_availability 1
  • diskgroup_directory_clauses 1
  • diskgroup_template_clauses 1
  • diskgroup_volume_clauses 1
  • distributed_recov_clauses 1
  • dml_table_expression_clause 1
  • domain_index_clause 1
  • drop_binding_clause 1
  • drop_column_clause 1
  • drop_constraint_clause 1
  • drop_disk_clause 1
  • drop_diskgroup_file_clause 1
  • drop_filegroup_clause 1
  • drop_index_partition 1
  • drop_logfile_clauses 1
  • drop_period_clause 1
  • drop_table_partition 1
  • drop_table_subpartition 1
  • DROP ANALYTIC VIEW statement 1
  • DROP ATTRIBUTE DIMENSION statement 1
  • DROP AUDIT POLICY statement 1
  • DROP CLUSTER statement 1
  • DROP CONTEXT statement 1
  • DROP DATABASE LINK statement 1
  • DROP DATABASE statement 1
  • DROP DIMENSION statement 1
  • DROP DIRECTORY statement 1
  • DROP DISKGROUP statement 1
  • DROP EDITION statement 1
  • DROP FLASHBACK ARCHIVE statement 1
  • DROP FUNCTION statement 1
  • DROP HIERARCHY statement 1
  • DROP INDEX statement 1
  • DROP INDEXTYPE statement 1
  • DROP INMEMORY JOIN GROUP statement 1
  • DROP JAVA statement 1
  • DROP LIBRARY statement 1
  • DROP LOCKDOWN PROFILE statement 1
  • DROP MATERIALIZED VIEW LOG statement 1
  • DROP MATERIALIZED VIEW statement 1
  • DROP MATERIALIZED ZONEMAP statement 1
  • DROP OPERATOR statement 1
  • DROP OUTLINE statement 1
  • DROP PACKAGE statement 1
  • DROP PLUGGABLE DATABASE statement 1
  • DROP PROCEDURE statement 1
  • DROP PROFILE statement 1
  • DROP RESTORE POINT statement 1
  • DROP ROLE statement 1
  • DROP ROLLBACK SEGMENT statement 1
  • DROP SEQUENCE statement 1
  • DROP SYNONYM statement 1
  • DROP TABLESPACE SET statement 1
  • DROP TABLESPACE statement 1
  • DROP TABLE statement 1
  • DROP TRIGGER statement 1
  • DROP TYPE BODY statement 1
  • DROP TYPE statement 1
  • DROP USER statement 1
  • DROP VIEW statement 1
  • ds_iso_format of TO_DSINTERVAL function 1
  • DUMP function 1

E

  • EDIT SQL*Plus command 1
  • else_clause 1
  • EMPTY_BLOB function 1
  • EMPTY_CLOB function 1
  • enable_disable_clause 1
  • enable_disable_volume 1
  • enable_pluggable_database 1
  • encryption_spec 1
  • end_session_clauses 1
  • EQUALS_PATH condition 1
  • error_logging_clause 1
  • evaluation_edition_clause 1
  • exceptions_clause 1
  • exchange_partition_subpart 1
  • EXECUTE SQL*Plus command 1
  • EXISTS condition 1
  • EXISTSNODE function 1
  • EXIT SQL*Plus command 1
  • EXP function 1
  • EXPLAIN PLAN statement 1
  • export_keys 1
  • expr 1
  • expression_list 1
  • expressions
    • see also SQL expressions 1
  • extended_attribute_clause 1
  • extent_management_clause 1
  • external_part_subpart_data_props 1
  • external_table_clause 1
  • external_table_data_props 1
  • EXTRACT (datetime) function 1
  • EXTRACT (XML) function 1
  • EXTRACTVALUE function 1

F

  • failover_clause 1
  • FEATURE_COMPARE function 1
  • FEATURE_DETAILS (analytic) function 1
  • FEATURE_DETAILS function 1
  • FEATURE_ID (analytic) function 1
  • FEATURE_ID function 1
  • FEATURE_SET (analytic) function 1
  • FEATURE_SET function 1
  • FEATURE_VALUE (analytic) function 1
  • FEATURE_VALUE function 1
  • file_name_convert 1
  • file_owner_clause 1
  • file_permissions_clause 1
  • file_specification 1
  • filegroup_clauses 1
  • filter_condition 1
  • FIRST_VALUE function 1
  • FIRST function 1
  • flashback_archive_clause 1
  • flashback_archive_quota 1
  • flashback_archive_retention 1
  • flashback_mode_clause 1
  • flashback_query_clause 1
  • FLASHBACK DATABASE statement 1
  • FLASHBACK TABLE statement 1
  • floating-point conditions 1
  • FLOOR function 1
  • following_boundary 1
  • for_refresh_clause 1
  • for_update_clause 1
  • format models
    • date format models 1
    • number format models 1
  • FROM_TZ function 1
  • full_database_recovery 1
  • fully_qualified_file_name 1
  • function_association 1
  • function expressions 1
  • functions
    • see also SQL functions 1

G

  • general_recovery 1
  • GET SQL*Plus command 1
  • global_partitioned_index 1
  • grant_object_privileges 1
  • grant_roles_to_programs 1
  • grant_system_privileges 1
  • grantee_clause 1
  • grantee_identified_by 1
  • GRANT statement 1
  • GRAPHIC data type
    • DB2 1
    • SQL/DS 1
  • GREATEST function 1
  • group_by_clause 1
  • GROUP_ID function 1
  • group comparison conditions 1
  • grouping_expression_list 1
  • GROUPING_ID function 1
  • grouping_sets_clause 1
  • GROUPING function 1
  • group separator
    • specifying 1

H

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

I

  • identity_clause 1
  • identity_options 1
  • ilm_clause 1
  • ilm_compression_policy 1
  • ilm_inmemory_policy 1
  • ilm_policy_clause 1
  • ilm_tiering_policy 1
  • ilm_time_period 1
  • implementation_clause 1
  • import_keys 1
  • incomplete_file_name 1
  • IN condition 1
  • index_attributes 1
  • index_compression 1
  • index_expr 1
  • index_org_overflow_clause 1
  • index_org_table_clause 1
  • index_partition_description 1
  • index_partitioning_clause 1
  • index_properties 1
  • index_subpartition_clause 1
  • indexing_clause 1
  • individual_hash_partitions 1
  • individual_hash_subparts 1
  • INITCAP function 1
  • inline_constraint 1
  • inline_ref_constraint 1
  • inmemory_attributes 1
  • inmemory_clause 1
  • inmemory_column_clause 1
  • inmemory_distribute 1
  • inmemory_duplicate 1
  • inmemory_memcompress 1
  • inmemory_priority 1
  • inmemory_table_clause 1
  • inner_cross_join_clause 1
  • INPUT SQL*Plus command 1
  • insert_into_clause 1
  • INSERTCHILDXMLAFTER function 1
  • INSERTCHILDXMLBEFORE function 1
  • INSERTCHILDXML function 1
  • INSERT statement 1
  • INSERTXMLAFTER function 1
  • INSERTXMLBEFORE function 1
  • instance_clauses 1
  • instances_clause 1
  • INSTR function 1
  • integer 1
  • interval_day_to_second 1
  • interval_year_to_month 1
  • INTERVAL expressions 1
  • into_clause 1
  • invoker_rights_clause 1
  • IS ANY condition 1
  • IS A SET condition 1
  • IS EMPTY condition 1
  • IS JSON condition 1
  • IS OF type condition 1
  • IS PRESENT condition 1
  • ITERATION_NUMBER function 1

J

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

K

  • key_clause 1
  • key_management_clauses 1
  • keystore_clause 1
  • keystore_management_clauses 1

L

  • LAG function 1
  • large_object_datatypes 1
  • LAST_DAY function 1
  • LAST_VALUE function 1
  • LAST function 1
  • lead_lag_clause 1
  • lead_lag_expression 1
  • lead_lag_function_name 1
  • LEAD function 1
  • LEAST function 1
  • LENGTH function 1
  • level_clause 1
  • level_hier_clause 1
  • level_member_literal 1
  • level_specification 1
  • levels_clause 1
  • LIKE condition 1
  • list_partition_desc 1
  • list_partitions 1
  • list_partitionset_clause 1
  • list_partitionset_desc 1
  • list_subpartition_desc 1
  • list_values 1
  • list_values_clause 1
  • listagg_overflow_clause 1
  • LISTAGG function 1
  • LIST SQL*Plus command 1
  • LN function 1
  • LNNVL function 1
  • LOB_compression_clause 1
  • LOB_deduplicate_clause 1
  • LOB_parameters 1
  • LOB_partition_storage 1
  • LOB_partitioning_storage 1
  • LOB_retention_storage 1
  • LOB_storage_clause 1
  • LOB_storage_parameters 1
  • local_domain_index_clause 1
  • local_partitioned_index 1
  • local_XMLIndex_clause 1
  • locale independent 1
  • LOCALTIMESTAMP function 1
  • lockdown_features 1
  • lockdown_options 1
  • lockdown_statements 1
  • LOCK TABLE statement 1
  • logfile_clause 1
  • logfile_clauses 1
  • logfile_descriptor 1
  • LOG function 1
  • logging_clause 1
  • logical conditions 1
  • long_and_raw_datatypes 1
  • LONG VARGRAPHIC data type
    • DB2 1
    • SQL/DS 1
  • LOWER function 1
  • LPAD function 1
  • LTRIM function 1

M

  • main_model 1
  • MAKE_REF function 1
  • managed_standby_recovery 1
  • mapping_table_clauses 1
  • materialized_view_props 1
  • MAX function 1
  • maximize_standby_db_clause 1
  • maxsize_clause 1
  • meas_aggregate_clause 1
  • measure_ref 1
  • measures_clause 1
  • media_types 1
  • MEDIAN function 1
  • member_expression 1
  • MEMBER condition 1
  • merge_insert_clause 1
  • merge_into_existing_keystore 1
  • merge_into_new_keystore 1
  • merge_table_partitions 1
  • merge_table_subpartitions 1
  • merge_update_clause 1
  • MERGE statement 1
  • migrate_key 1
  • MIN function 1
  • mining_analytic_clause 1
  • mining_attribute_clause 1
  • model_clause 1
  • model_column_clauses 1
  • model_iterate_clause 1
  • model_rules_clause 1
  • model expressions 1
  • MOD function 1
  • modify_col_properties 1
  • modify_col_substitutable 1
  • modify_col_visibility 1
  • modify_collection_retrieval 1
  • modify_column_clauses 1
  • modify_diskgroup_file 1
  • modify_filegroup_clause 1
  • modify_hash_partition 1
  • modify_index_default_attrs 1
  • modify_index_partition 1
  • modify_index_subpartition 1
  • modify_list_partition 1
  • modify_LOB_parameters 1
  • modify_LOB_storage_clause 1
  • modify_mv_column_clause 1
  • modify_opaque_type 1
  • modify_range_partition 1
  • modify_table_default_attrs 1
  • modify_table_partition 1
  • modify_table_subpartition 1
  • modify_to_partitioned 1
  • modify_virtcol_properties 1
  • modify_volume_clause 1
  • MONTHS_BETWEEN function 1
  • move_datafile_clause 1
  • move_mv_log_clause 1
  • move_table_clause 1
  • move_table_partition 1
  • move_table_subpartition 1
  • move_to_filegroup_clause 1
  • multi_column_for_loop 1
  • multi_table_insert 1
  • multiset_except 1
  • multiset_intersect 1
  • multiset_union 1
  • mv_log_augmentation 1
  • mv_log_purge_clause 1

N

  • named_member_keys 1
  • NANVL function 1
  • NCHR function 1
  • nested_table_col_properties 1
  • nested_table_partition_spec 1
  • NEW_TIME function 1
  • new_values_clause 1
  • NEXT_DAY function 1
  • NLS_CHARSET_DECL_LEN function 1
  • NLS_CHARSET_ID function 1
  • NLS_CHARSET_NAME function 1
  • NLS_COLLATION_ID function 1
  • NLS_COLLATION_NAME function 1
  • NLS_INITCAP function 1
  • NLS_LOWER function 1
  • NLS_UPPER function 1
  • NLSSORT function 1
  • NOAUDIT (Traditional Auditing) statement 1
  • NOAUDIT (Unified Auditing) statement 1
  • NTH_VALUE function 1
  • NTILE function 1
  • null conditions 1
  • NULLIF function 1
  • number 1
  • number_datatypes 1
  • number format elements 1
  • number format models 1
  • numeric_file_name 1
  • NUMTODSINTERVAL function 1
  • NUMTOYMINTERVAL function 1
  • NVL2 function 1
  • NVL function 1

O

  • object_properties 1
  • object_step 1
  • object_table 1
  • object_table_substitution 1
  • object_type_col_properties 1
  • object_view_clause 1
  • object access expressions 1
  • OID_clause 1
  • OID_index_clause 1
  • on_comp_partitioned_table 1
  • on_hash_partitioned_table 1
  • on_list_partitioned_table 1
  • on_object_clause 1
  • on_range_partitioned_table 1
  • open_keystore 1
  • option_values 1
  • ORA_DM_PARTITION_NAME function 1
  • ORA_DST_AFFECTED function 1
  • ORA_DST_CONVERT function 1
  • ORA_DST_ERROR function 1
  • ORA_HASH function 1
  • ORA_INVOKING_USER function 1
  • ORA_INVOKING_USERID function 1
  • Oracle built-in data types 1 , 2
  • Oracle-supplied data types 1 , 2
  • order_by_clause 1
  • ordinality_column 1
  • out_of_line_constraint 1
  • out_of_line_part_storage 1
  • out_of_line_ref_constraint 1
  • outer_join_clause 1
  • outer_join_type 1

P

  • parallel_clause 1
  • parallel_pdb_creation_clause 1
  • partial_database_recovery 1
  • partial_index_clause 1
  • partition_attributes 1
  • partition_extended_name 1
  • partition_extended_names 1
  • partition_extension_clause 1
  • partition_or_key_value 1
  • partition_spec 1
  • partitioning_storage_clause 1
  • partitionset_clauses 1
  • password_parameters 1
  • path_prefix_clause 1
  • PATH function 1
  • pdb_change_state 1
  • pdb_change_state_from_root 1
  • pdb_close 1
  • pdb_datafile_clause 1
  • pdb_dba_roles 1
  • pdb_force_logging_clause 1
  • pdb_general_recovery 1
  • pdb_logging_clauses 1
  • pdb_open 1
  • pdb_recovery_clauses 1
  • pdb_refresh_mode_clause 1
  • pdb_save_or_discard_state 1
  • pdb_settings_clauses 1
  • pdb_storage_clause 1
  • pdb_unplug_clause 1
  • PERCENT_RANK (aggregate) function 1
  • PERCENT_RANK (analytic) function 1
  • PERCENTILE_CONT function 1
  • PERCENTILE_DISC function 1
  • period_definition 1
  • permanent_tablespace_attrs 1
  • permanent_tablespace_clause 1
  • physical_attributes_clause 1
  • physical_properties 1
  • pivot_clause 1
  • pivot_for_clause 1
  • pivot_in_clause 1
  • placeholder expressions 1
  • plsql_declarations 1
  • pos_member_keys 1
  • POWER function 1
  • POWERMULTISET_BY_CARDINALITY function 1
  • POWERMULTISET function 1
  • preceding_boundary 1
  • PREDICTION_BOUNDS function 1
  • PREDICTION_COST (analytic) function 1
  • PREDICTION_COST function 1
  • PREDICTION_DETAILS (analytic) function 1
  • PREDICTION_DETAILS function 1
  • PREDICTION_PROBABILITY (analytic) function 1
  • PREDICTION_PROBABILITY function 1
  • PREDICTION_SET (analytic) function 1
  • PREDICTION_SET function 1
  • PREDICTION (analytic) function 1
  • PREDICTION function 1
  • prefix_compression 1
  • PRESENTNNV function 1
  • PRESENTV function 1
  • PREVIOUS function 1
  • privilege_audit_clause 1
  • program_unit 1
  • proxy_clause 1
  • PURGE statement 1

Q

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

R

  • range_partition_desc 1
  • range_partitions 1
  • range_partitionset_clause 1
  • range_partitionset_desc 1
  • range_subpartition_desc 1
  • range_values_clause 1
  • RANK (aggregate) function 1
  • RANK (analytic) function 1
  • RATIO_TO_REPORT function 1
  • RAWTOHEX function 1
  • RAWTONHEX function 1
  • read_only_clause 1
  • rebalance_diskgroup_clause 1
  • rebuild_clause 1
  • records_per_block_clause 1
  • recovery_clauses 1
  • redo_log_file_spec 1
  • redo_thread_clauses
    • see instance_clauses 1
  • redundancy_clause 1
  • reference_model 1
  • reference_partition_desc 1
  • reference_partitioning 1
  • references_clause 1
  • REF function 1
  • REFTOHEX function 1
  • REGEXP_COUNT function 1
  • REGEXP_INSTR function 1
  • REGEXP_LIKE condition 1
  • REGEXP_REPLACE function 1
  • REGEXP_SUBSTR function 1
  • register_logfile_clause 1
  • REGR_AVGX function 1
  • REGR_AVGY function 1
  • REGR_COUNT function 1
  • REGR_INTERCEPT function 1
  • REGR_R2 function 1
  • REGR_SLOPE function 1
  • REGR_SXX function 1
  • REGR_SXY function 1
  • REGR_SYY function 1
  • relational_properties 1
  • relational_table 1
  • relocate_clause 1
  • REMAINDER function 1
  • rename_column_clause 1
  • rename_disk_clause 1
  • rename_index_partition 1
  • rename_partition_subpart 1
  • RENAME statement 1
  • replace_disk_clause 1
  • REPLACE function 1
  • resize_disk_clause 1
  • resource_parameters 1
  • return_rows_clause 1
  • returning_clause 1
  • reverse_migrate_key 1
  • revoke_object_privileges 1
  • revoke_roles_from_programs 1
  • revoke_system_privileges 1
  • revokee_clause 1
  • REVOKE statement 1
  • role_audit_clause 1
  • ROLLBACK statement 1
  • rolling_migration_clauses 1
  • rolling_patch_clauses 1
  • rollup_cube_clause 1
  • ROUND (date) function 1
  • ROUND (number) function 1
  • routine_clause 1
  • row_limiting_clause 1
  • row_movement_clause 1
  • ROW_NUMBER function 1
  • row_pattern 1
  • row_pattern_aggregate_func 1
  • row_pattern_classifier_func 1
  • row_pattern_clause 1
  • row_pattern_definition 1
  • row_pattern_definition_list 1
  • row_pattern_factor 1
  • row_pattern_match_num_func 1
  • row_pattern_measure_column 1
  • row_pattern_measures 1
  • row_pattern_nav_compound 1
  • row_pattern_nav_logical 1
  • row_pattern_nav_physical 1
  • row_pattern_navigation_func 1
  • row_pattern_order_by 1
  • row_pattern_partition_by 1
  • row_pattern_permute 1
  • row_pattern_primary 1
  • row_pattern_quantifier 1
  • row_pattern_rec_func 1
  • row_pattern_rows_per_match 1
  • row_pattern_skip_to 1
  • row_pattern_subset_clause 1
  • row_pattern_subset_item 1
  • row_pattern_term 1
  • rowid_datatypes 1
  • ROWIDTOCHAR function 1
  • ROWTONCHAR function 1
  • RPAD function 1
  • RTRIM function 1
  • RUN SQL*Plus command 1

S

  • sample_clause 1
  • SAVEPOINT statement 1
  • SAVE SQL*Plus command 1
  • scalar subquery expressions 1
  • scientific notation 1
  • SCN_TO_TIMESTAMP function 1
  • scoped_table_ref_constraint 1
  • scrub_clause 1
  • search_clause 1
  • searched_case_expression 1
  • secret_management_clauses 1
  • security_clause 1
  • security_clauses 1
  • segment_attributes_clause 1
  • segment_management_clause 1
  • select_list 1
  • SELECT statement 1
  • service_name_convert 1
  • SESSIONTIMEZONE function 1
  • set_encryption_key 1
  • set_key 1
  • set_key_tag 1
  • set_parameter_clause 1
  • set_subpartition_template 1
  • set_time_zone_clause 1
  • SET CONSTRAINT statement 1
  • SET function 1
  • SET ROLE statement 1
  • SET SQL*Plus command 1
  • SET TRANSACTION statement 1
  • share_clause 1
  • share_of_expression 1
  • sharing_clause 1
  • SHOW SQL*Plus command 1
  • shrink_clause 1
  • shutdown_dispatcher_clause 1
  • SHUTDOWN SQL*Plus command 1
  • SIGN function 1
  • simple_case_expression 1
  • simple comparison conditions 1
  • simple expressions 1
  • SIN function 1
  • single_column_for_loop 1
  • single_table_insert 1
  • SINH function 1
  • size_clause 1
  • SOUNDEX function 1
  • source_file_directory 1
  • source_file_name_convert 1
  • spatial_types 1
  • split_index_partition 1
  • split_nested_table_part 1
  • split_table_partition 1
  • split_table_subpartition 1
  • SPOOL SQL*Plus command 1
  • sql_format of TO_DSINTERVAL function 1
  • SQL/DS data types
    • restrictions on 1
  • SQL*Plus commands
    • / (slash) 1
    • @ (at sign) 1
    • APPEND 1
    • CHANGE 1
    • CONNECT 1
    • DEL 1
    • DESCRIBE 1
    • DISCONNECT 1
    • EDIT 1
    • EXECUTE 1
    • EXIT 1
    • GET 1
    • HELP 1
    • HOST 1
    • INPUT 1
    • LIST 1
    • QUIT 1
    • RUN 1
    • SAVE 1
    • SET 1
    • SHOW 1
    • SHUTDOWN 1
    • SPOOL 1
    • SQLPLUS 1
    • START 1
    • STARTUP 1
  • SQL conditions
    • BETWEEN condition 1
    • compound conditions 1
    • EQUALS_PATH condition 1
    • EXISTS condition 1
    • floating-point conditions 1
    • group comparison conditions 1
    • IN condition 1
    • IS ANY condition 1
    • IS A SET condition 1
    • IS EMPTY condition 1
    • IS JSON condition 1
    • IS OF type condition 1
    • IS PRESENT condition 1
    • JSON_EXISTS condition 1
    • JSON_TEXTCONTAINS condition 1
    • LIKE condition 1
    • logical conditions 1
    • MEMBER condition 1
    • null conditions 1
    • REGEXP_LIKE condition 1
    • simple comparison conditions 1
    • SUBMULTISET condition 1
    • UNDER_PATH condition 1
  • SQL expressions
    • calculated measure expressions 1
    • CASE expressions 1
    • column expressions 1
    • compound expressions 1
    • CURSOR expressions 1
    • datetime expressions 1
    • function expressions 1
    • INTERVAL expressions 1
    • JSON object access expressions 1
    • model expressions 1
    • object access expressions 1
    • placeholder expressions 1
    • scalar subquery expressions 1
    • simple expressions 1
    • type constructor expressions 1
  • SQL functions
    • ABS 1
    • ACOS 1
    • ADD_MONTHS 1
    • aggregate functions 1
    • analytic functions 1
    • APPENDCHILDXML 1
    • APPROX_COUNT_DISTINCT 1
    • APPROX_COUNT_DISTINCT_AGG 1
    • APPROX_COUNT_DISTINCT_DETAIL 1
    • APPROX_MEDIAN 1
    • APPROX_PERCENTILE 1
    • APPROX_PERCENTILE_AGG 1
    • APPROX_PERCENTILE_DETAIL 1
    • ASCII 1
    • ASCIISTR 1
    • ASIN 1
    • ATAN 1
    • ATAN2 1
    • AVG 1
    • BFILENAME 1
    • BIN_TO_NUM 1
    • BITAND 1
    • CARDINALITY 1
    • CAST 1
    • CEIL 1
    • CHARTOROWID 1
    • CHR 1
    • CLUSTER_DETAILS 1
    • CLUSTER_DETAILS (analytic) 1
    • CLUSTER_DISTANCE 1
    • CLUSTER_DISTANCE (analytic) 1
    • CLUSTER_ID 1
    • CLUSTER_ID (analytic) 1
    • CLUSTER_PROBABILITY 1
    • CLUSTER_PROBABILITY (analytic) 1
    • CLUSTER_SET 1
    • CLUSTER_SET (analytic) 1
    • COALESCE 1
    • COLLATION 1
    • COLLECT 1
    • COMPOSE 1
    • CON_DBID_TO_ID 1
    • CON_GUID_TO_ID 1
    • CON_NAME_TO_ID 1
    • CON_UID_TO_ID 1
    • CONCAT 1
    • CONVERT 1
    • CORR 1
    • CORR_K 1
    • CORR_S 1
    • COS 1
    • COSH 1
    • COUNT 1
    • COVAR_POP 1
    • COVAR_SAMP 1
    • CUBE_TABLE 1
    • CUME_DIST (aggregate) 1
    • CUME_DIST (analytic) 1
    • CURRENT_DATE 1
    • CURRENT_TIMESTAMP 1
    • CV 1
    • DATAOBJ_TO_MAT_PARTITION 1
    • DATAOBJ_TO_PARTITION 1
    • DBTIMEZONE 1
    • DECODE 1
    • DECOMPOSE 1
    • DELETEXML 1
    • DENSE_RANK (aggregate) 1
    • DENSE_RANK (analytic) 1
    • DEPTH 1
    • DEREF 1
    • DUMP 1
    • EMPTY_BLOB 1
    • EMPTY_CLOB 1
    • EXISTSNODE 1
    • EXP 1
    • EXTRACT (datetime) 1
    • EXTRACT (XML) 1
    • EXTRACTVALUE 1
    • FEATURE_COMPARE 1
    • FEATURE_DETAILS 1
    • FEATURE_DETAILS (analytic) 1
    • FEATURE_ID 1
    • FEATURE_ID (analytic) 1
    • FEATURE_SET 1
    • FEATURE_SET (analytic) 1
    • FEATURE_VALUE 1
    • FEATURE_VALUE (analytic) 1
    • FIRST 1
    • FIRST_VALUE 1
    • FLOOR 1
    • FROM_TZ 1
    • GREATEST 1
    • GROUP_ID 1
    • GROUPING 1
    • GROUPING_ID 1
    • HEXTORAW 1
    • INITCAP 1
    • INSERTCHILDXML 1
    • INSERTCHILDXMLAFTER 1
    • INSERTCHILDXMLBEFORE 1
    • INSERTXMLAFTER 1
    • INSERTXMLBEFORE 1
    • INSTR 1
    • ITERATION_NUMBER 1
    • JSON_ARRAY 1
    • JSON_ARRAYAGG 1
    • JSON_DATAGUIDE 1
    • JSON_OBJECT 1
    • JSON_OBJECTAGG 1
    • JSON_QUERY 1
    • JSON_TABLE 1
    • JSON_VALUE 1
    • LAG 1
    • LAST 1
    • LAST_DAY 1
    • LAST_VALUE 1
    • LEAD 1
    • LEAST 1
    • LENGTH 1
    • LISTAGG 1
    • LN 1
    • LNNVL 1
    • LOCALTIMESTAMP 1
    • LOG 1
    • LOWER 1
    • LPAD 1
    • LTRIM 1
    • MAKE_REF 1
    • MAX 1
    • MEDIAN 1
    • MIN 1
    • MOD 1
    • MONTHS_BETWEEN 1
    • NANVL 1
    • NCGR 1
    • NEW_TIME 1
    • NEXT_DAY 1
    • NLS_CHARSET_DECL_LEN 1
    • NLS_CHARSET_ID 1
    • NLS_CHARSET_NAME 1
    • NLS_COLLATION_ID 1
    • NLS_COLLATION_NAME 1
    • NLS_INITCAP 1
    • NLS_LOWER 1
    • NLS_UPPER 1
    • NLSSORT 1
    • NTH_VALUE 1
    • NTILE 1
    • NULLIF 1
    • NUMTODSINTERVAL 1
    • NUMTOYMINTERVAL 1
    • NVL 1
    • NVL2 1
    • ORA_DM_PARTITION_NAME 1
    • ORA_DST_AFFECTED 1
    • ORA_DST_CONVERT 1
    • ORA_DST_ERROR 1
    • ORA_HASH 1
    • ORA_INVOKING_USER 1
    • ORA_INVOKING_USERID 1
    • PATH 1
    • PERCENT_RANK (aggregate) 1
    • PERCENT_RANK (analytic) 1
    • PERCENTILE_CONT 1
    • PERCENTILE_DISC 1
    • POWER 1
    • POWERMULTISET 1
    • POWERMULTISET_BY_CARDINALITY 1
    • PREDICTION 1
    • PREDICTION_BOUNDS 1
    • PREDICTION_COST 1
    • PREDICTION_COST (analytic) 1
    • PREDICTION_DETAILS 1
    • PREDICTION_DETAILS (analytic) 1
    • PREDICTION_PROBABILITY 1
    • PREDICTION_PROBABILITY (analytic) 1
    • PREDICTION_SET 1
    • PREDICTION_SET (analytic) 1
    • PREDICTION (analytic) 1
    • PRESENTNNV 1
    • PRESENTV 1
    • PREVIOUS 1
    • RANK (aggregate) 1
    • RANK (analytic) 1
    • RATIO_TO_REPORT 1
    • RAWTOHEX 1
    • RAWTONHEX 1
    • REF 1
    • REFTOHEX 1
    • REGEXP_COUNT 1
    • REGEXP_INSTR 1
    • REGEXP_REPLACE 1
    • REGEXP_SUBSTR 1
    • REGR_AVGX 1
    • REGR_AVGY 1
    • REGR_COUNT 1
    • REGR_INTERCEPT 1
    • REGR_R2 1
    • REGR_SLOPE 1
    • REGR_SXX 1
    • REGR_SXY 1
    • REGR_SYY 1
    • REMAINDER 1
    • REPLACE 1
    • ROUND (date) 1
    • ROUND (number) 1
    • ROW_NUMBER 1
    • ROWIDTOCHAR 1
    • ROWTONCHAR 1
    • RPAD 1
    • RTRIM 1
    • SCN_TO_TIMESTAMP 1
    • SESSIONTIMEZONE 1
    • SET 1
    • SIGN 1
    • SIN 1
    • SINH 1
    • SOUNDEX 1
    • SQRT 1
    • STANDARD_HASH 1
    • STATS_BINOMIAL_TEST 1
    • STATS_CROSSTAB 1
    • STATS_F_TEST 1
    • STATS_KS_TEST 1
    • STATS_MODE 1
    • STATS_MW_TEST 1
    • STATS_ONE_WAY_ANOVA 1
    • STATS_T_TEST_INDEP 1
    • STATS_T_TEST_INDEPU 1
    • STATS_T_TEST_ONE 1
    • STATS_T_TEST_PAIRED 1
    • STATS_WSR_TEST 1
    • STDDEV 1
    • STDDEV_POP 1
    • STDDEV_SAMP 1
    • SUBSTR 1
    • SUM 1
    • SYS_CONNECT_BY_PATH 1
    • SYS_CONTEXT 1
    • SYS_DBURIGEN 1
    • SYS_EXTRACT_UTC 1
    • SYS_GUID 1
    • SYS_OP_ZONE_ID 1
    • SYS_TYPEID 1
    • SYS_XMLAGG 1
    • SYS_XMLGEN 1
    • SYSDATE 1
    • SYSTIMESTAMP 1
    • TAN 1
    • TANH 1
    • TIMESTAMP_TO_SCN 1
    • TO_APPROX_COUNT_DISTINCT 1
    • TO_APPROX_PERCENTILE 1
    • TO_BINARY_DOUBLE 1
    • TO_BINARY_FLOAT 1
    • TO_BLOB (bfile) 1
    • TO_BLOB (raw) 1
    • TO_CHAR (bfile|blob) 1
    • TO_CHAR (character) 1
    • TO_CHAR (datetime) 1
    • TO_CHAR (number) 1
    • TO_CLOB (bfile|blob) 1
    • TO_CLOB (character) 1
    • TO_DATE 1
    • TO_DSINTERVAL 1
    • TO_LOB 1
    • TO_MULTI_BYTE 1
    • TO_NCHAR (character) 1
    • TO_NCHAR (datetime) 1
    • TO_NCHAR (number) 1
    • TO_NCLOB 1
    • TO_NUMBER 1
    • TO_SINGLE_BYTE 1
    • TO_TIMESTAMP 1
    • TO_TIMESTAMP_TZ 1
    • TO_YMINTERVAL 1
    • TRANSLATE 1
    • TRANSLATE...USING 1
    • TREAT 1
    • TRIM 1
    • TRUNC (date) 1
    • TRUNC (number) 1
    • TZ_OFFSET 1
    • UID 1
    • UNISTR 1
    • UPDATEXML 1
    • UPPER 1
    • USER 1
    • user-defined functions 1
    • USERENV 1
    • VALIDATE_CONVERSION 1
    • VALUE 1
    • VAR_POP 1
    • VAR_SAMP 1
    • VARIANCE 1
    • VSIZE 1
    • WIDTH_BUCKET 1
    • XMLAGG 1
    • XMLCAST 1
    • XMLCDATA 1
    • XMLCOLATTVAL 1
    • XMLCOMMENT 1
    • XMLCONCAT 1
    • XMLDIFF 1
    • XMLELEMENT 1
    • XMLEXISTS 1
    • XMLFOREST 1
    • XMLISVALID 1
    • XMLPARSE 1
    • XMLPATCH 1
    • XMLPI 1
    • XMLQUERY 1
    • XMLROOT 1
    • XMLSEQUENCE 1
    • XMLSERIALIZE 1
    • XMLTABLE 1
    • XMLTRANSFORM 1
  • SQLPLUS SQL*Plus command 1
  • SQL statements
    • ADMINISTER KEY MANAGEMENT 1
    • ALTER ANALYTIC VIEW 1
    • ALTER ATTRIBUTE DIMENSION 1
    • ALTER AUDIT POLICY 1
    • ALTER CLUSTER 1
    • ALTER DATABASE 1
    • ALTER DATABASE LINK 1
    • ALTER DIMENSION 1
    • ALTER DISKGROUP 1
    • ALTER FLASHBACK ARCHIVE 1
    • ALTER FUNCTION 1
    • ALTER HIERARCHY 1
    • ALTER INDEX 1
    • ALTER INDEXTYPE 1
    • ALTER INMEMORY JOIN GROUP 1
    • ALTER JAVA 1
    • ALTER LIBRARY 1
    • ALTER LOCKDOWN PROFILE 1
    • ALTER MATERIALIZED VIEW 1
    • ALTER MATERIALIZED VIEW LOG 1
    • ALTER MATERIALIZED ZONEMAP 1
    • ALTER OPERATOR 1
    • ALTER OUTLINE 1
    • ALTER PACKAGE 1
    • ALTER PLUGGABLE DATABASE 1
    • ALTER PROCEDURE 1
    • ALTER PROFILE 1
    • ALTER RESOURCE COST 1
    • ALTER ROLE 1
    • ALTER ROLLBACK SEGMENT 1
    • ALTER SEQUENCE 1
    • ALTER SESSION 1
    • ALTER SYNONYM 1
    • ALTER SYSTEM 1
    • ALTER TABLE 1
    • ALTER TABLESPACE 1
    • ALTER TABLESPACE SET 1
    • ALTER TRIGGER 1
    • ALTER TYPE 1
    • ALTER USER 1
    • ALTER VIEW 1
    • ANALYZE 1
    • ASSOCIATE STATISTICS 1
    • AUDIT (Traditional Auditing) 1
    • AUDIT (Unified Auditing) 1
    • CALL 1
    • COMMENT 1
    • COMMIT 1
    • CREATE ANALYTIC VIEW 1
    • CREATE ATTRIBUTE DIMENSION 1
    • CREATE AUDIT POLICY 1
    • CREATE CLUSTER 1
    • CREATE CONTEXT 1
    • CREATE CONTROLFILE 1
    • CREATE DATABASE 1
    • CREATE DATABASE LINK 1
    • CREATE DIMENSION 1
    • CREATE DIRECTORY 1
    • CREATE DISKGROUP 1
    • CREATE EDITION 1
    • CREATE FLASHBACK ARCHIVE 1
    • CREATE FUNCTION 1
    • CREATE HIERARCHY 1
    • CREATE INDEX 1
    • CREATE INDEXTYPE 1
    • CREATE INMEMORY JOIN GROUP 1
    • CREATE JAVA 1
    • CREATE LIBRARY 1
    • CREATE LOCKDOWN PROFILE 1
    • CREATE MATERIALIZED VIEW 1
    • CREATE MATERIALIZED VIEW LOG 1
    • CREATE MATERIALIZED ZONEMAP 1
    • CREATE OPERATOR 1
    • CREATE OUTLINE 1
    • CREATE PACKAGE 1
    • CREATE PACKAGE BODY 1
    • CREATE PFILE 1
    • CREATE PLUGGABLE DATABASE 1
    • CREATE PROCEDURE 1
    • CREATE PROFILE 1
    • CREATE RESTORE POINT 1
    • CREATE ROLE 1
    • CREATE ROLLBACK SEGMENT 1
    • CREATE SCHEMA 1
    • CREATE SEQUENCE 1
    • CREATE SPFILE 1
    • CREATE SYNONYM 1
    • CREATE TABLE 1
    • CREATE TABLESPACE 1
    • CREATE TABLESPACE SET 1
    • CREATE TRIGGER 1
    • CREATE TYPE 1
    • CREATE TYPE BODY 1
    • CREATE USER 1
    • CREATE VIEW 1
    • DELETE 1
    • DISASSOCIATE STATISTICS 1
    • DROP ANALYTIC VIEW 1
    • DROP ATTRIBUTE DIMENSION 1
    • DROP AUDIT POLICY 1
    • DROP CLUSTER 1
    • DROP CONTEXT 1
    • DROP DATABASE 1
    • DROP DATABASE LINK 1
    • DROP DIMENSION 1
    • DROP DIRECTORY 1
    • DROP DISKGROUP 1
    • DROP EDITION 1
    • DROP FLASHBACK ARCHIVE 1
    • DROP FUNCTION 1
    • DROP HIERARCHY 1
    • DROP INDEX 1
    • DROP INDEXTYPE 1
    • DROP INMEMORY JOIN GROUP 1
    • DROP JAVA 1
    • DROP LIBRARY 1
    • DROP LOCKDOWN PROFILE 1
    • DROP MATERIALIZED VIEW 1
    • DROP MATERIALIZED VIEW LOG 1
    • DROP MATERIALIZED ZONEMAP 1
    • DROP OPERATOR 1
    • DROP OUTLINE 1
    • DROP PACKAGE 1
    • DROP PLUGGABLE DATABASE 1
    • DROP PROCEDURE 1
    • DROP PROFILE 1
    • DROP RESTORE POINT 1
    • DROP ROLE 1
    • DROP ROLLBACK SEGMENT 1
    • DROP SEQUENCE 1
    • DROP SYNONYM 1
    • DROP TABLE 1
    • DROP TABLESPACE 1
    • DROP TABLESPACE SET 1
    • DROP TRIGGER 1
    • DROP TYPE 1
    • DROP TYPE BODY 1
    • DROP USER 1
    • DROP VIEW 1
    • EXPLAIN PLAN 1
    • FLASHBACK DATABASE 1
    • FLASHBACK TABLE 1
    • GRANT 1
    • INSERT 1
    • LOCK TABLE 1
    • MERGE 1
    • NOAUDIT (Traditional Auditing) 1
    • NOAUDIT (Unified Auditing) 1
    • PURGE 1
    • RENAME 1
    • REVOKE 1
    • ROLLBACK 1
    • SAVEPOINT 1
    • SELECT 1
    • SET CONSTRAINT 1
    • SET ROLE 1
    • SET TRANSACTION 1
    • TRUNCATE CLUSTER 1
    • TRUNCATE TABLE 1
    • UPDATE 1
  • SQRT function 1
  • standard_actions 1
  • STANDARD_HASH function 1
  • standby_database_clauses 1
  • standbys_clause 1
  • start_standby_clause 1
  • START SQL*Plus command 1
  • startup_clauses 1
  • STARTUP SQL*Plus command 1
  • statement_clauses 1
  • statements
    • see also SQL statements 1
  • STATS_BINOMIAL_TEST function 1
  • STATS_CROSSTAB function 1
  • STATS_F_TEST function 1
  • STATS_KS_TEST function 1
  • STATS_MODE function 1
  • STATS_MW_TEST function 1
  • STATS_ONE_WAY_ANOVA function 1
  • STATS_T_TEST_INDEP function 1
  • STATS_T_TEST_INDEPU function 1
  • STATS_T_TEST_ONE function 1
  • STATS_T_TEST_PAIRED function 1
  • STATS_WSR_TEST function 1
  • STDDEV_POP function 1
  • STDDEV_SAMP function 1
  • STDDEV function 1
  • still_image_object_types 1
  • stop_standby_clause 1
  • storage_clause 1
  • storage_table_clause 1
  • string 1
  • striping_clause 1
  • SUBMULTISET condition 1
  • subpartition_by_hash 1
  • subpartition_by_list 1
  • subpartition_by_range 1
  • subpartition_extended_name 1
  • subpartition_extended_names 1
  • subpartition_or_key_value 1
  • subpartition_spec 1
  • subpartition_template 1
  • subquery 1
  • subquery_factoring_clause 1
  • subquery_restriction_clause 1
  • substitutable_column_clause 1
  • SUBSTR function 1
  • SUM function 1
  • supplemental_db_logging 1
  • supplemental_id_key_clause 1
  • supplemental_log_grp_clause 1
  • supplemental_logging_props 1
  • supplemental_plsql_clause 1
  • supplemental_table_logging 1
  • supplied data types 1 , 2
  • switch_logfile_clause 1
  • switchover_clause 1
  • syntax for subclauses 1
  • SYS_CONNECT_BY_PATH function 1
  • SYS_CONTEXT function 1
  • SYS_DBURIGEN function 1
  • SYS_EXTRACT_UTC function 1
  • SYS_GUID function 1
  • SYS_OP_ZONE_ID function 1
  • SYS_TYPEID function 1
  • SYS_XMLAGG function 1
  • SYS_XMLGEN function 1
  • SYSDATE function 1
  • system_partitioning 1
  • SYSTIMESTAMP function 1

T

  • table_collection_expression 1
  • table_compression 1
  • table_index_clause 1
  • table_partition_description 1
  • table_partitioning_clauses 1
  • table_properties 1
  • table_reference 1
  • tablespace_clauses 1
  • tablespace_datafile_clauses 1
  • tablespace_encryption_clause 1
  • tablespace_encryption_spec 1
  • tablespace_group_clause 1
  • tablespace_logging_clauses 1
  • tablespace_retention_clause 1
  • tablespace_state_clauses 1
  • TAN function 1
  • TANH function 1
  • tempfile_reuse_clause 1
  • temporary_tablespace_clause 1
  • TIME data type
    • DB2 1
    • SQL/DS 1
  • time format models 1
  • timeout_clause 1
  • TIMESTAMP_TO_SCN function 1
  • TIMESTAMP data type
    • DB2 1
    • SQL/DS 1
  • time zone formatting 1
  • TO_APPROX_COUNT_DISTINCT function 1
  • TO_APPROX_PERCENTILE function 1
  • TO_BINARY_DOUBLE function 1
  • TO_BINARY_FLOAT function 1
  • TO_BLOB (bfile) function 1
  • TO_BLOB (raw) function 1
  • TO_CHAR (bfile|blob) function 1
  • TO_CHAR (character) function 1
  • TO_CHAR (datetime) function 1
  • TO_CHAR (number) function 1
  • TO_CLOB (bfile|blob) function 1
  • TO_CLOB (character) function 1
  • TO_DATE function 1
  • TO_DSINTERVAL function 1
  • TO_LOB function 1
  • TO_MULTI_BYTE function 1
  • TO_NCHAR (character) function 1
  • TO_NCHAR (datetime) function 1
  • TO_NCHAR (number) function 1
  • TO_NCLOB function 1
  • TO_NUMBER function 1
  • TO_SINGLE_BYTE function 1
  • TO_TIMESTAMP_TZ function 1
  • TO_TIMESTAMP function 1
  • TO_YMINTERVAL function 1
  • trace_file_clause 1
  • TRANSLATE...USING function 1
  • TRANSLATE function 1
  • TREAT function 1
  • TRIM function 1
  • TRUNC (date) function 1
  • TRUNC (number) function 1
  • truncate_partition_subpart 1
  • TRUNCATE CLUSTER statement 1
  • TRUNCATE TABLE statement 1
  • ts_file_name_convert 1
  • type constructor expressions 1
  • TZ_OFFSET function 1

U

  • UID function 1
  • UNDER_PATH condition 1
  • undo_mode_clause 1
  • undo_tablespace 1
  • undo_tablespace_clause 1
  • undrop_disk_clause 1
  • UNISTR function 1
  • unpivot_clause 1
  • unpivot_in_clause 1
  • unusable_editions_clause 1
  • update_all_indexes_clause 1
  • update_global_index_clause 1
  • update_index_clauses 1
  • update_index_partition 1
  • update_index_subpartition 1
  • update_set_clause 1
  • UPDATE statement 1
  • UPDATEXML function 1
  • upgrade_table_clause 1
  • UPPER function 1
  • use_key 1
  • user_clauses 1
  • user_tablespaces_clause 1
  • user-defined data types 1
  • user-defined functions 1
  • USERENV function 1
  • USER function 1
  • usergroup_clauses 1
  • using_clause 1
  • using_function_clause 1
  • using_index_clause 1
  • using_statistics_type 1
  • using_type_clause 1

V

  • VALIDATE_CONVERSION function 1
  • validation_clauses 1
  • VALUE function 1
  • values_clause 1
  • VAR_POP function 1
  • VAR_SAMP function 1
  • VARGRAPHIC data type
    • DB2 1
    • SQL/DS 1
  • VARIANCE function 1
  • varray_col_properties 1
  • varray_storage_clause 1
  • virtual_column_definition 1
  • VSIZE function 1

W

  • where_clause 1
  • WIDTH_BUCKET function 1
  • window_clause 1
  • window_expression 1
  • windowing_clause 1
  • with_clause 1

X

  • XML_attributes_clause 1
  • XML_passing_clause 1
  • XML_table_column 1
  • XML_types 1
  • XMLAGG function 1
  • XMLCast function 1
  • XMLCDATA function 1
  • XMLCOLATTVAL function 1
  • XMLCOMMENT function 1
  • XMLCONCAT function 1
  • XMLDIFF function 1
  • XMLELEMENT function 1
  • XMLEXISTS function 1
  • XMLFOREST function 1
  • XMLIndex_clause 1
  • XMLISVALID function 1
  • XMLnamespaces_clause 1
  • XMLPARSE function 1
  • XMLPATCH function 1
  • XMLPI function 1
  • XMLQUERY function 1
  • XMLROOT function 1
  • XMLSchema_spec 1
  • XMLSEQUENCE function 1
  • XMLSERIALIZE function 1
  • XMLTABLE_options 1
  • XMLTABLE function 1
  • XMLTRANSFORM function 1
  • XMLType_column_properties 1
  • XMLType_storage 1
  • XMLType_table 1
  • XMLType_view_clause 1
  • XMLType_virtual_columns 1

Y

  • ym_iso_format of TO_YMINTERVAL function 1

Z

  • zonemap_attributes 1
  • zonemap_clause 1
  • zonemap_refresh_clause 1