label: SQL Tutorials
isManual: true
sections:
- label: SQL Fundamentals
sections:
- label: SQL Syntax Formats
href: ./sql_syntax_formats.md
- label: Keywords
href: ./keywords.md
- label: Constant and Macro
href: ./constant_and_macro.md
- label: Data Types
sections:
- label: Numeric Types
href: ./numeric_types.md
- label: Monetary Types
href: ./monetary_types.md
- label: Boolean Types
href: ./boolean_types.md
- label: Character Types
href: ./character_types.md
- label: Binary Types
href: ./binary_types.md
- label: Date/Time Types
href: ./date_time_types.md
- label: Geometric
href: ./geometric_type.md
- label: Network Address Types
href: ./network_address_types.md
- label: Bit String Types
href: ./bit_string_types.md
- label: Text Search Types
href: ./text_search_types.md
- label: UUID
href: ./uuid.md
- label: JSON/JSONB Types
href: ./json_jsonb_types.md
- label: HLL
href: ./hll_data_type.md
- label: Range
href: ./range_type.md
- label: OID Types
href: ./oid_types.md
- label: Pseudo-Types
href: ./pseudo_types.md
- label: Data Types Supported by Column-store Tables
href: ./data_types_supported_by_column_store_tables.md
- label: XML Type
href: ./xml_type.md
- label: Data Type Used by the Ledger Database
href: ./data_type_used_by_the_ledger_database.md
- label: SET Type
href: ./set_type.md
- label: INSERT_RIGHT_REF_DEFAULT_VALUE
href: ./insert_right_ref_default_value.md
- label: Type Conversion
sections:
- label: Overview
href: ./overview_type_conversion.md
- label: Operators
href: ./operators.md
- label: Functions
href: ./functions.md
- label: Value Storage
href: ./value_storage.md
- label: UNION, CASE, and Related Constructs
href: ./union_case_and_related_constructs.md
- label: Brief Tutorial
sections:
- label: Subqueries
href: ./subqueries.md
- label: Aliases
href: ./aliases.md
- label: Indexes
href: ./indexes.md
- label: Constraints
href: ./constraints.md
- label: Cursors
href: ./cursors.md
- label: Schemas
sections:
- label: Overview
href: ./schemas-25.md
- label: Information Schema
sections:
- label: Introduction
href: ./information_schema.md
- label: _PG_FOREIGN_DATA_WRAPPERS
href: ./_pg_foreign_data_wrappers.md
- label: _PG_FOREIGN_SERVERS
href: ./_pg_foreign_servers.md
- label: _PG_FOREIGN_TABLE_COLUMNS
href: ./_pg_foreign_table_columns.md
- label: _PG_FOREIGN_TABLES
href: ./_pg_foreign_tables.md
- label: _PG_USER_MAPPINGS
href: ./_pg_user_mappings.md
- label: INFORMATION_SCHEMA_CATALOG_NAME
href: ./information_schema_catalog_name.md
- label: DBE_PERF Schema
sections:
- label: Introduction
href: ./dbe_perf-schema.md
- label: OS
sections:
- label: OS_RUNTIME
href: ./os_runtime.md
- label: GLOBAL_OS_RUNTIME
href: ./global_os_runtime.md
- label: OS_THREADS
href: ./os_threads.md
- label: GLOBAL_OS_THREADS
href: ./global_os_threads.md
- label: Instance
sections:
- label: INSTANCE_TIME
href: ./instance_time.md
- label: GLOBAL_INSTANCE_TIME
href: ./global_instance_time.md
- label: Memory
sections:
- label: MEMORY_NODE_DETAIL
href: ./memory_node_detail.md
- label: GLOBAL_MEMORY_NODE_DETAIL
href: ./global_memory_node_detail.md
- label: GS_SHARED_MEMORY_DETAIL
href: ./gs_shared_memory_detail.md
- label: GLOBAL_SHARED_MEMORY_DETAIL
href: ./global_shared_memory_detail.md
- label: File
sections:
- label: FILE_IOSTAT
href: ./file_iostat.md
- label: SUMMARY_FILE_IOSTAT
href: ./summary_file_iostat.md
- label: GLOBAL_FILE_IOSTAT
href: ./global_file_iostat.md
- label: FILE_REDO_IOSTAT
href: ./file_redo_iostat.md
- label: SUMMARY_FILE_REDO_IOSTAT
href: ./summary_file_redo_iostat.md
- label: GLOBAL_FILE_REDO_IOSTAT
href: ./global_file_redo_iostat.md
- label: LOCAL_REL_IOSTAT
href: ./local_rel_iostat.md
- label: GLOBAL_REL_IOSTAT
href: ./global_rel_iostat.md
- label: SUMMARY_REL_IOSTAT
href: ./summary_rel_iostat.md
- label: Object
sections:
- label: STAT_USER_TABLES
href: ./stat_user_tables.md
- label: SUMMARY_STAT_USER_TABLES
href: ./summary_stat_user_tables.md
- label: GLOBAL_STAT_USER_TABLES
href: ./global_stat_user_tables.md
- label: STAT_USER_INDEXES
href: ./stat_user_indexes.md
- label: SUMMARY_STAT_USER_INDEXES
href: ./summary_stat_user_indexes.md
- label: GLOBAL_STAT_USER_INDEXES
href: ./global_stat_user_indexes.md
- label: STAT_SYS_TABLES
href: ./stat_sys_tables.md
- label: SUMMARY_STAT_SYS_TABLES
href: ./summary_stat_sys_tables.md
- label: GLOBAL_STAT_SYS_TABLES
href: ./global_stat_sys_tables.md
- label: STAT_SYS_INDEXES
href: ./stat_sys_indexes.md
- label: SUMMARY_STAT_SYS_INDEXES
href: ./summary_stat_sys_indexes.md
- label: GLOBAL_STAT_SYS_INDEXES
href: ./global_stat_sys_indexes.md
- label: STAT_ALL_TABLES
href: ./stat_all_tables.md
- label: SUMMARY_STAT_ALL_TABLES
href: ./summary_stat_all_tables.md
- label: GLOBAL_STAT_ALL_TABLES
href: ./global_stat_all_tables.md
- label: STAT_ALL_INDEXES
href: ./stat_all_indexes.md
- label: SUMMARY_STAT_ALL_INDEXES
href: ./summary_stat_all_indexes.md
- label: GLOBAL_STAT_ALL_INDEXES
href: ./global_stat_all_indexes.md
- label: STAT_DATABASE
href: ./stat_database.md
- label: SUMMARY_STAT_DATABASE
href: ./summary_stat_database.md
- label: GLOBAL_STAT_DATABASE
href: ./global_stat_database.md
- label: STAT_DATABASE_CONFLICTS
href: ./stat_database_conflicts.md
- label: SUMMARY_STAT_DATABASE_CONFLICTS
href: ./summary_stat_database_conflicts.md
- label: GLOBAL_STAT_DATABASE_CONFLICTS
href: ./global_stat_database_conflicts.md
- label: STAT_XACT_ALL_TABLES
href: ./stat_xact_all_tables.md
- label: SUMMARY_STAT_XACT_ALL_TABLES
href: ./summary_stat_xact_all_tables.md
- label: GLOBAL_STAT_XACT_ALL_TABLES
href: ./global_stat_xact_all_tables.md
- label: STAT_XACT_SYS_TABLES
href: ./stat_xact_sys_tables.md
- label: SUMMARY_STAT_XACT_SYS_TABLES
href: ./summary_stat_xact_sys_tables.md
- label: GLOBAL_STAT_XACT_SYS_TABLES
href: ./global_stat_xact_sys_tables.md
- label: STAT_XACT_USER_TABLES
href: ./stat_xact_user_tables.md
- label: SUMMARY_STAT_XACT_USER_TABLES
href: ./summary_stat_xact_user_tables.md
- label: GLOBAL_STAT_XACT_USER_TABLES
href: ./global_stat_xact_user_tables.md
- label: STAT_XACT_USER_FUNCTIONS
href: ./stat_xact_user_functions.md
- label: SUMMARY_STAT_XACT_USER_FUNCTIONS
href: ./summary_stat_xact_user_functions.md
- label: GLOBAL_STAT_XACT_USER_FUNCTIONS
href: ./global_stat_xact_user_functions.md
- label: STAT_BAD_BLOCK
href: ./stat_bad_block.md
- label: SUMMARY_STAT_BAD_BLOCK
href: ./summary_stat_bad_block.md
- label: GLOBAL_STAT_BAD_BLOCK
href: ./global_stat_bad_block.md
- label: STAT_USER_FUNCTIONS
href: ./stat_user_functions.md
- label: SUMMARY_STAT_USER_FUNCTIONS
href: ./summary_stat_user_functions.md
- label: GLOBAL_STAT_USER_FUNCTIONS
href: ./global_stat_user_functions.md
- label: Workload
sections:
- label: WORKLOAD_SQL_COUNT
href: ./workload_sql_count.md
- label: SUMMARY_WORKLOAD_SQL_COUNT
href: ./summary_workload_sql_count.md
- label: WORKLOAD_TRANSACTION
href: ./workload_transaction.md
- label: SUMMARY_WORKLOAD_TRANSACTION
href: ./summary_workload_transaction.md
- label: GLOBAL_WORKLOAD_TRANSACTION
href: ./global_workload_transaction.md
- label: WORKLOAD_SQL_ELAPSE_TIME
href: ./workload_sql_elapse_time.md
- label: SUMMARY_WORKLOAD_SQL_ELAPSE_TIME
href: ./summary_workload_sql_elapse_time.md
- label: USER_TRANSACTION
href: ./user_transaction.md
- label: GLOBAL_USER_TRANSACTION
href: ./global_user_transaction.md
- label: Session/Thread
sections:
- label: SESSION_STAT
href: ./session_stat.md
- label: GLOBAL_SESSION_STAT
href: ./global_session_stat.md
- label: SESSION_TIME
href: ./session_time.md
- label: GLOBAL_SESSION_TIME
href: ./global_session_time.md
- label: SESSION_MEMORY
href: ./session_memory.md
- label: GLOBAL_SESSION_MEMORY
href: ./global_session_memory.md
- label: SESSION_MEMORY_DETAIL
href: ./session_memory_detail.md
- label: GLOBAL_SESSION_MEMORY_DETAIL
href: ./global_session_memory_detail.md
- label: SESSION_STAT_ACTIVITY
href: ./session_stat_activity.md
- label: GLOBAL_SESSION_STAT_ACTIVITY
href: ./global_session_stat_activity.md
- label: THREAD_WAIT_STATUS
href: ./thread_wait_status.md
- label: GLOBAL_THREAD_WAIT_STATUS
href: ./global_thread_wait_status.md
- label: LOCAL_THREADPOOL_STATUS
href: ./local_threadpool_status.md
- label: GLOBAL_THREADPOOL_STATUS
href: ./global_threadpool_status.md
- label: SESSION_CPU_RUNTIME
href: ./session_cpu_runtime.md
- label: SESSION_MEMORY_RUNTIME
href: ./session_memory_runtime.md
- label: STATEMENT_IOSTAT_COMPLEX_RUNTIME
href: ./statement_iostat_complex_runtime.md
- label: LOCAL_ACTIVE_SESSION
href: ./local_active_session.md
- label: Transaction
sections:
- label: TRANSACTIONS_PREPARED_XACTS
href: ./transactions_prepared_xacts.md
- label: SUMMARY_TRANSACTIONS_PREPARED_XACTS
href: ./summary_transactions_prepared_xacts.md
- label: GLOBAL_TRANSACTIONS_PREPARED_XACTS
href: ./global_transactions_prepared_xacts.md
- label: TRANSACTIONS_RUNNING_XACTS
href: ./transactions_running_xacts.md
- label: SUMMARY_TRANSACTIONS_RUNNING_XACTS
href: ./summary_transactions_running_xacts.md
- label: GLOBAL_TRANSACTIONS_RUNNING_XACTS
href: ./global_transactions_running_xacts.md
- label: Query
sections:
- label: STATEMENT
href: ./statement.md
- label: SUMMARY_STATEMENT
href: ./summary_statement.md
- label: STATEMENT_COUNT
href: ./statement_count.md
- label: GLOBAL_STATEMENT_COUNT
href: ./global_statement_count.md
- label: SUMMARY_STATEMENT_COUNT
href: ./summary_statement_count.md
- label: GLOBAL_STATEMENT_COMPLEX_HISTORY
href: ./global_statement_complex_history.md
- label: GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
href: ./global_statement_complex_history_table.md
- label: GLOBAL_STATEMENT_COMPLEX_RUNTIME
href: ./global_statement_complex_runtime.md
- label: STATEMENT_RESPONSETIME_PERCENTILE
href: ./statement_responsetime_percentile.md
- label: STATEMENT_COMPLEX_RUNTIME
href: ./statement_complex_runtime.md
- label: STATEMENT_COMPLEX_HISTORY_TABLE
href: ./statement_complex_history_table.md
- label: STATEMENT_COMPLEX_HISTORY
href: ./statement_complex_history.md
- label: STATEMENT_WLMSTAT_COMPLEX_RUNTIME
href: ./statement_wlmstat_complex_runtime.md
- label: STATEMENT_HISTORY
href: ./statement_history.md
- label: GS_SLOW_QUERY_INFO (Discarded)
href: ./gs_slow_query_info-discarded.md
- label: GS_SLOW_QUERY_HISTORY (Discarded)
href: ./gs_slow_query_history-discarded.md
- label: GLOBAL_SLOW_QUERY_HISTORY (Discarded)
href: ./global_slow_query_history-discarded.md
- label: GLOBAL_SLOW_QUERY_INFO (Discarded)
href: ./global_slow_query_info-discarded.md
- label: Cache/IO
sections:
- label: STATIO_USER_TABLES
href: ./statio_user_tables.md
- label: SUMMARY_STATIO_USER_TABLES
href: ./summary_statio_user_tables.md
- label: GLOBAL_STATIO_USER_TABLES
href: ./global_statio_user_tables.md
- label: STATIO_USER_INDEXES
href: ./statio_user_indexes.md
- label: SUMMARY_STATIO_USER_INDEXES
href: ./summary_statio_user_indexes.md
- label: GLOBAL_STATIO_USER_INDEXES
href: ./global_statio_user_indexes.md
- label: STATIO_USER_SEQUENCES
href: ./statio_user_sequences.md
- label: SUMMARY_STATIO_USER_SEQUENCES
href: ./summary_statio_user_sequences.md
- label: GLOBAL_STATIO_USER_SEQUENCES
href: ./global_statio_user_sequences.md
- label: STATIO_SYS_TABLES
href: ./statio_sys_tables.md
- label: SUMMARY_STATIO_SYS_TABLES
href: ./summary_statio_sys_tables.md
- label: GLOBAL_STATIO_SYS_TABLES
href: ./global_statio_sys_tables.md
- label: STATIO_SYS_INDEXES
href: ./statio_sys_indexes.md
- label: SUMMARY_STATIO_SYS_INDEXES
href: ./summary_statio_sys_indexes.md
- label: GLOBAL_STATIO_SYS_INDEXES
href: ./global_statio_sys_indexes.md
- label: STATIO_SYS_SEQUENCES
href: ./statio_sys_sequences.md
- label: SUMMARY_STATIO_SYS_SEQUENCES
href: ./summary_statio_sys_sequences.md
- label: GLOBAL_STATIO_SYS_SEQUENCES
href: ./global_statio_sys_sequences.md
- label: STATIO_ALL_TABLES
href: ./statio_all_tables.md
- label: SUMMARY_STATIO_ALL_TABLES
href: ./summary_statio_all_tables.md
- label: GLOBAL_STATIO_ALL_TABLES
href: ./global_statio_all_tables.md
- label: STATIO_ALL_INDEXES
href: ./statio_all_indexes.md
- label: SUMMARY_STATIO_ALL_INDEXES
href: ./summary_statio_all_indexes.md
- label: GLOBAL_STATIO_ALL_INDEXES
href: ./global_statio_all_indexes.md
- label: STATIO_ALL_SEQUENCES
href: ./statio_all_sequences.md
- label: SUMMARY_STATIO_ALL_SEQUENCES
href: ./summary_statio_all_sequences.md
- label: GLOBAL_STATIO_ALL_SEQUENCES
href: ./global_statio_all_sequences.md
- label: GLOBAL_STAT_DB_CU
href: ./global_stat_db_cu.md
- label: GLOBAL_STAT_SESSION_CU
href: ./global_stat_session_cu.md
- label: Utility
sections:
- label: REPLICATION_STAT
href: ./replication_stat.md
- label: GLOBAL_REPLICATION_STAT
href: ./global_replication_stat.md
- label: REPLICATION_SLOTS
href: ./replication_slots.md
- label: GLOBAL_REPLICATION_SLOTS
href: ./global_replication_slots.md
- label: BGWRITER_STAT
href: ./bgwriter_stat.md
- label: GLOBAL_BGWRITER_STAT
href: ./global_bgwriter_stat.md
- label: GLOBAL_CKPT_STATUS
href: ./global_ckpt_status.md
- label: GLOBAL_DOUBLE_WRITE_STATUS
href: ./global_double_write_status.md
- label: GLOBAL_PAGEWRITER_STATUS
href: ./global_pagewriter_status.md
- label: GLOBAL_RECORD_RESET_TIME
href: ./global_record_reset_time.md
- label: GLOBAL_REDO_STATUS
href: ./global_redo_status.md
- label: GLOBAL_RECOVERY_STATUS
href: ./global_recovery_status.md
- label: CLASS_VITAL_INFO
href: ./class_vital_info.md
- label: USER_LOGIN
href: ./user_login.md
- label: SUMMARY_USER_LOGIN
href: ./summary_user_login.md
- label: GLOBAL_GET_BGWRITER_STATUS
href: ./global_get_bgwriter_status.md
- label: GLOBAL_SINGLE_FLUSH_DW_STATUS
href: ./global_single_flush_dw_status.md
- label: GLOBAL_CANDIDATE_STATUS
href: ./global_candidate_status.md
- label: PG_INDEXES_VERBOSE
href: ./pg_indexes_verbose.md
- label: Lock
sections:
- label: LOCKS
href: ./locks.md
- label: GLOBAL_LOCKS
href: ./global_locks.md
- label: Wait Events
sections:
- label: WAIT_EVENTS
href: ./wait_events.md
- label: GLOBAL_WAIT_EVENTS
href: ./global_wait_events.md
- label: Configuration
sections:
- label: CONFIG_SETTINGS
href: ./config_settings.md
- label: GLOBAL_CONFIG_SETTINGS
href: ./global_config_settings.md
- label: Operator
sections:
- label: OPERATOR_HISTORY_TABLE
href: ./operator_history_table.md
- label: OPERATOR_HISTORY
href: ./operator_history.md
- label: OPERATOR_RUNTIME
href: ./operator_runtime.md
- label: GLOBAL_OPERATOR_HISTORY
href: ./global_operator_history.md
- label: GLOBAL_OPERATOR_HISTORY_TABLE
href: ./global_operator_history_table.md
- label: GLOBAL_OPERATOR_RUNTIME
href: ./global_operator_runtime.md
- label: Workload Manager
sections:
- label: WLM_USER_RESOURCE_CONFIG
href: ./wlm_user_resource_config.md
- label: WLM_USER_RESOURCE_RUNTIME
href: ./wlm_user_resource_runtime.md
- label: Global Plancache
sections:
- label: GLOBAL_PLANCACHE_STATUS
href: ./global_plancache_status.md
- label: GLOBAL_PLANCACHE_CLEAN
href: ./global_plancache_clean.md
- label: RTO & RPO
sections:
- label: global_rto_status
href: ./global_rto_status.md
- label: WDR Snapshot Schema
sections:
- label: Introduction
href: ./wdr-snapshot-schema.md
- label: Original Information of WDR Snapshots
sections:
- label: SNAPSHOT.SNAPSHOT
href: ./snapshot-snapshot.md
- label: SNAPSHOT.TABLES_SNAP_TIMESTAMP
href: ./snapshot-tables_snap_timestamp.md
- label: SNAP_SEQ
href: ./snap_seq.md
- label: WDR Snapshot Data Table
href: ./wdr-snapshot-data-table.md
- label: Performance Report Generated Based on WDR Snapshots
href: ./performance-report-generated-based-on-wdr-snapshots.md
- label: Viewing WDRs
sections:
- label: WDRs
href: ./wdrs.md
- label: Database Stat
href: ./database-stat.md
- label: Load Profile
href: ./load-profile.md
- label: Instance Efficiency Percentages
href: ./instance-efficiency-percentages.md
- label: Top 10 Events by Total Wait Time
href: ./top-10-events-by-total-wait-time.md
- label: Wait Classes by Total Wait Time
href: ./wait-classes-by-total-wait-time.md
- label: Host CPU
href: ./host-cpu.md
- label: IO Profile
href: ./io-profile.md
- label: Memory Statistics
href: ./memory-statistics.md
- label: Time Model
href: ./time-model.md
- label: SQL Statistics
href: ./sql-statistics.md
- label: Wait Events
href: ./wait-events-29.md
- label: Cache IO Stats
href: ./cache-io-stats.md
- label: Utility status
href: ./utility-status.md
- label: Object stats
href: ./object-stats.md
- label: Configuration settings
href: ./configuration-settings.md
- label: SQL Detail
href: ./sql-detail.md
- label: DBE_PLDEBUGGER Schema
sections:
- label: Introduction
href: ./dbe_pldebugger-schema.md
- label: DBE_PLDEBUGGER.turn_on
href: ./dbe_pldebugger-turn_on.md
- label: DBE_PLDEBUGGER.turn_off
href: ./dbe_pldebugger-turn_off.md
- label: DBE_PLDEBUGGER.local_debug_server_info
href: ./dbe_pldebugger-local_debug_server_info.md
- label: DBE_PLDEBUGGER.attach
href: ./dbe_pldebugger-attach.md
- label: DBE_PLDEBUGGER.info_locals
href: ./dbe_pldebugger-info_locals.md
- label: DBE_PLDEBUGGER.next
href: ./dbe_pldebugger-next.md
- label: DBE_PLDEBUGGER.continue
href: ./dbe_pldebugger-continue.md
- label: DBE_PLDEBUGGER.abort
href: ./dbe_pldebugger-abort.md
- label: DBE_PLDEBUGGER.print_var
href: ./dbe_pldebugger-print_var.md
- label: DBE_PLDEBUGGER.info_code
href: ./dbe_pldebugger-info_code.md
- label: DBE_PLDEBUGGER.step
href: ./dbe_pldebugger-step.md
- label: DBE_PLDEBUGGER.add_breakpoint
href: ./dbe_pldebugger-add_breakpoint.md
- label: DBE_PLDEBUGGER.delete_breakpoint
href: ./dbe_pldebugger-delete_breakpoint.md
- label: DBE_PLDEBUGGER.info_breakpoints
href: ./dbe_pldebugger-info_breakpoints.md
- label: DBE_PLDEBUGGER.backtrace
href: ./dbe_pldebugger-backtrace.md
- label: DBE_PLDEBUGGER.enable_breakpoint
href: ./dbe_pldebugger-enable_breakpoint.md
- label: DBE_PLDEBUGGER.disable_breakpoint
href: ./dbe_pldebugger-disable_breakpoint.md
- label: DBE_PLDEBUGGER.finish
href: ./dbe_pldebugger-finish.md
- label: DBE_PLDEBUGGER.set_var
href: ./dbe_pldebugger-set_var.md
- label: DB4AI Schema
sections:
- label: Introduction
href: ./db4ai-schema.md
- label: DB4AI.SNAPSHOT
href: ./db4ai-snapshot.md
- label: DB4AI.CREATE_SNAPSHOT
href: ./db4ai-create_snapshot.md
- label: DB4AI.CREATE_SNAPSHOT_INTERNAL
href: ./db4ai-create_snapshot_internal.md
- label: DB4AI.PREPARE_SNAPSHOT
href: ./db4ai-prepare_snapshot.md
- label: DB4AI.PREPARE_SNAPSHOT_INTERNAL
href: ./db4ai-prepare_snapshot_internal.md
- label: DB4AI.ARCHIVE_SNAPSHOT
href: ./db4ai-archive_snapshot.md
- label: DB4AI.PUBLISH_SNAPSHOT
href: ./db4ai-publish_snapshot.md
- label: DB4AI.MANAGE_SNAPSHOT_INTERNAL
href: ./db4ai-manage_snapshot_internal.md
- label: DB4AI.SAMPLE_SNAPSHOT
href: ./db4ai-sample_snapshot.md
- label: DB4AI.PURGE_SNAPSHOT
href: ./db4ai-purge_snapshot.md
- label: DB4AI.PURGE_SNAPSHOT_INTERNAL
href: ./db4ai-purge_snapshot_internal.md
- label: DBE_PLDEVELOPER
sections:
- label: Introduction
href: ./dbe_pldeveloper.md
- label: DBE_PLDEVELOPER.gs_source
href: ./dbe_pldeveloper-gs_source.md
- label: DBE_PLDEVELOPER.gs_errors
href: ./dbe_pldeveloper-gs_errors.md
- label: DBE_SQL_UTIL Schema
sections:
- label: Introduction
href: ./dbe_sql_util-schema.md
- label: DBE_SQL_UTIL.create_hint_sql_patch
href: ./dbe_sql_util-create_hint_sql_patch.md
- label: DBE_SQL_UTIL.create_abort_sql_patch
href: ./dbe_sql_util-create_abort_sql_patch.md
- label: DBE_SQL_UTIL.drop_sql_patch
href: ./dbe_sql_util-drop_sql_patch.md
- label: DBE_SQL_UTIL.enable_sql_patch
href: ./dbe_sql_util-enable_sql_patch.md
- label: DBE_SQL_UTIL.disable_sql_patch
href: ./dbe_sql_util-disable_sql_patch.md
- label: DBE_SQL_UTIL.show_sql_patch
href: ./dbe_sql_util-show_sql_patch.md
- label: SQL Syntax
sections:
- label: DDL Syntax Overview
href: ./ddl-syntax-overview.md
- label: DML Syntax Overview
href: ./dml-syntax-overview.md
- label: DCL Syntax Overview
href: ./dcl-syntax-overview.md
- label: ABORT
href: ./abort.md
- label: ALTER AGGREGATE
href: ./alter-aggregate.md
- label: ALTER AUDIT POLICY
href: ./alter-audit-policy.md
- label: ALTER DATABASE
href: ./alter-database.md
- label: ALTER DATA SOURCE
href: ./alter-data-source.md
- label: ALTER DEFAULT PRIVILEGES
href: ./alter-default-privileges.md
- label: ALTER DIRECTORY
href: ./alter-directory.md
- label: ALTER EXTENSION
href: ./alter-extension.md
- label: ALTER EVENT
href: ./alter-event.md
- label: ALTER EVENT TRIGGER
href: ./alter-event-trigger.md
- label: ALTER FOREIGN DATA WRAPPER
href: ./alter-foreign-data-wrapper.md
- label: ALTER FOREIGN TABLE
href: ./alter-foreign-table.md
- label: ALTER FUNCTION
href: ./alter-function.md
- label: ALTER GROUP
href: ./alter-group.md
- label: ALTER INDEX
href: ./alter-index.md
- label: ALTER LANGUAGE
href: ./alter-language.md
- label: ALTER LARGE OBJECT
href: ./alter-large-object.md
- label: ALTER MASKING POLICY
href: ./alter-masking-policy.md
- label: ALTER MATERIALIZED VIEW
href: ./alter-materialized-view.md
- label: ALTER OPERATOR
href: ./alter-operator.md
- label: ALTER PACKAGE
href: ./alter-package.md
- label: ALTER PUBLICATION
href: ./alter-publication.md
- label: ALTER RESOURCE LABEL
href: ./alter-resource-label.md
- label: ALTER RESOURCE POOL
href: ./alter-resource-pool.md
- label: ALTER ROLE
href: ./alter-role.md
- label: ALTER ROW LEVEL SECURITY POLICY
href: ./alter-row-level-security-policy.md
- label: ALTER SCHEMA
href: ./alter-schema.md
- label: ALTER SEQUENCE
href: ./alter-sequence.md
- label: ALTER SERVER
href: ./alter-server.md
- label: ALTER SESSION
href: ./alter-session.md
- label: ALTER SUBSCRIPTION
href: ./alter-subscription.md
- label: ALTER SYNONYM
href: ./alter-synonym.md
- label: ALTER SYSTEM KILL SESSION
href: ./alter-system-kill-session.md
- label: ALTER SYSTEM SET
href: ./alter-system-set.md
- label: ALTER TABLE
href: ./alter-table.md
- label: ALTER TABLE INHERIT
href: ./alter-table-inherit.md
- label: ALTER TABLE PARTITION
href: ./alter-table-partition.md
- label: ALTER TABLE SUBPARTITION
href: ./alter-table-subpartition.md
- label: ALTER TABLESPACE
href: ./alter-tablespace.md
- label: ALTER TEXT SEARCH CONFIGURATION
href: ./alter-text-search-configuration.md
- label: ALTER TEXT SEARCH DICTIONARY
href: ./alter-text-search-dictionary.md
- label: ALTER TRIGGER
href: ./alter-trigger.md
- label: ALTER TYPE
href: ./alter-type.md
- label: ALTER USER
href: ./alter-user.md
- label: ALTER USER MAPPING
href: ./alter-user-mapping.md
- label: ALTER VIEW
href: ./alter-view.md
- label: ANALYZE | ANALYSE
href: ./analyze-analyse.md
- label: BEGIN
href: ./begin.md
- label: CALL
href: ./call.md
- label: CHECKPOINT
href: ./checkpoint.md
- label: CLEAN CONNECTION
href: ./clean-connection.md
- label: CLOSE
href: ./close.md
- label: CLUSTER
href: ./cluster.md
- label: COMMENT
href: ./comment.md
- label: COMMIT | END
href: ./commit-end.md
- label: COMMIT PREPARED
href: ./commit-prepared.md
- label: COPY
href: ./copy.md
- label: CREATE AGGREGATE
href: ./create-aggregate.md
- label: CREATE AUDIT POLICY
href: ./create-audit-policy.md
- label: CREATE CAST
href: ./create-cast.md
- label: CREATE CLIENT MASTER KEY
href: ./create-client-master-key.md
- label: CREATE COLUMN ENCRYPTION KEY
href: ./create-column-encryption-key.md
- label: CREATE DATABASE
href: ./create-database.md
- label: CREATE DATA SOURCE
href: ./create-data-source.md
- label: CREATE DIRECTORY
href: ./create-directory.md
- label: CREATE EXTENSION
href: ./create-extension.md
- label: CREATE EVENT
href: ./create-event.md
- label: CREATE EVENT TRIGGER
href: ./create-event-trigger.md
- label: CREATE FOREIGN DATA WRAPPER
href: ./create-foreign-data-wrapper.md
- label: CREATE FOREIGN TABLE
href: ./create-foreign-table.md
- label: CREATE FUNCTION
href: ./create-function.md
- label: CREATE GROUP
href: ./create-group.md
- label: CREATE INCREMENTAL MATERIALIZED VIEW
href: ./create-incremental-materialized-view.md
- label: CREATE INDEX
href: ./create-index.md
- label: CREATE LANGUAGE
href: ./create-language.md
- label: CREATE MASKING POLICY
href: ./create-masking-policy.md
- label: CREATE MATERIALIZED VIEW
href: ./create-materialized-view.md
- label: CREATE MODEL
href: ./create-model.md
- label: CREATE OPERATOR
href: ./create-operator.md
- label: CREATE PACKAGE
href: ./create-package.md
- label: CREATE PROCEDURE
href: ./create-procedure.md
- label: CREATE PUBLICATION
href: ./create-publication.md
- label: CREATE RESOURCE LABEL
href: ./create-resource-label.md
- label: CREATE RESOURCE POOL
href: ./create-resource-pool.md
- label: CREATE ROLE
href: ./create-role.md
- label: CREATE ROW LEVEL SECURITY POLICY
href: ./create-row-level-security-policy.md
- label: CREATE RULE
href: ./create-rule.md
- label: CREATE SCHEMA
href: ./create-schema.md
- label: CREATE SEQUENCE
href: ./create-sequence.md
- label: CREATE SERVER
href: ./create-server.md
- label: CREATE SUBSCRIPTION
href: ./create-subscription.md
- label: CREATE SYNONYM
href: ./create-synonym.md
- label: CREATE TABLE
href: ./create-table.md
- label: CREATE TABLE AS
href: ./create-table-as.md
- label: CREATE TABLE INHERITS
href: ./create-table-inherits.md
- label: CREATE TABLE PARTITION
href: ./create-table-partition.md
- label: CREATE TABLESPACE
href: ./create-tablespace.md
- label: CREATE TEXT SEARCH CONFIGURATION
href: ./create-text-search-configuration.md
- label: CREATE TEXT SEARCH DICTIONARY
href: ./create-text-search-dictionary.md
- label: CREATE TRIGGER
href: ./create-trigger.md
- label: CREATE TYPE
href: ./create-type.md
- label: CREATE USER
href: ./create-user.md
- label: CREATE USER MAPPING
href: ./create-user-mapping.md
- label: CREATE VIEW
href: ./create-view.md
- label: CREATE WEAK PASSWORD DICTIONARY
href: ./create-weak-password-dictionary.md
- label: CURSOR
href: ./cursor.md
- label: DEALLOCATE
href: ./deallocate.md
- label: DECLARE
href: ./declare.md
- label: DELETE
href: ./delete.md
- label: DO
href: ./do.md
- label: DROP AGGREGATE
href: ./drop-aggregate.md
- label: DROP AUDIT POLICY
href: ./drop-audit-policy.md
- label: DROP CAST
href: ./drop-cast.md
- label: DROP CLIENT MASTER KEY
href: ./drop-client-master-key.md
- label: DROP COLUMN ENCRYPTION KEY
href: ./drop-column-encryption-key.md
- label: DROP DATABASE
href: ./drop-database.md
- label: DROP DATA SOURCE
href: ./drop-data-source.md
- label: DROP DIRECTORY
href: ./drop-directory.md
- label: DROP EXTENSION
href: ./drop-extension.md
- label: DROP EVENT
href: ./drop-event.md
- label: DROP EVENT TRIGGER
href: ./drop-event-trigger.md
- label: DROP FOREIGN DATA WRAPPER
href: ./drop-foreign-data-wrapper.md
- label: DROP FOREIGN TABLE
href: ./drop-foreign-table.md
- label: DROP FUNCTION
href: ./drop-function.md
- label: DROP GROUP
href: ./drop-group.md
- label: DROP INDEX
href: ./drop-index.md
- label: DROP LANGUAGE
href: ./drop-language.md
- label: DROP MASKING POLICY
href: ./drop-masking-policy.md
- label: DROP MATERIALIZED VIEW
href: ./drop-materialized-view.md
- label: DROP MODEL
href: ./drop-model.md
- label: DROP OPERATOR
href: ./drop-operator.md
- label: DROP OWNED
href: ./drop-owned.md
- label: DROP PACKAGE
href: ./drop-package.md
- label: DROP PROCEDURE
href: ./drop-procedure.md
- label: DROP PUBLICATION
href: ./drop-publication.md
- label: DROP RESOURCE LABEL
href: ./drop-resource-label.md
- label: DROP RESOURCE POOL
href: ./drop-resource-pool.md
- label: DROP ROLE
href: ./drop-role.md
- label: DROP ROW LEVEL SECURITY POLICY
href: ./drop-row-level-security-policy.md
- label: DROP RULE
href: ./drop-rule.md
- label: DROP SCHEMA
href: ./drop-schema.md
- label: DROP SEQUENCE
href: ./drop-sequence.md
- label: DROP SERVER
href: ./drop-server.md
- label: DROP SUBSCRIPTION
href: ./drop-subscription.md
- label: DROP SYNONYM
href: ./drop-synonym.md
- label: DROP TABLE
href: ./drop-table.md
- label: DROP TABLESPACE
href: ./drop-tablespace.md
- label: DROP TEXT SEARCH CONFIGURATION
href: ./drop-text-search-configuration.md
- label: DROP TEXT SEARCH DICTIONARY
href: ./drop-text-search-dictionary.md
- label: DROP TRIGGER
href: ./drop-trigger.md
- label: DROP TYPE
href: ./drop-type.md
- label: DROP USER
href: ./drop-user.md
- label: DROP USER MAPPING
href: ./drop-user-mapping.md
- label: DROP VIEW
href: ./drop-view.md
- label: DROP WEAK PASSWORD DICTIONARY
href: ./drop-weak-password-dictionary.md
- label: EXECUTE
href: ./execute.md
- label: EXPLAIN
href: ./explain.md
- label: EXPLAIN PLAN
href: ./explain-plan.md
- label: FETCH
href: ./fetch.md
- label: GRANT
href: ./grant.md
- label: INSERT
href: ./insert.md
- label: LOCK
href: ./lock.md
- label: MERGE INTO
href: ./merge-into.md
- label: MOVE
href: ./move.md
- label: PREDICT BY
href: ./predict-by.md
- label: PREPARE
href: ./prepare.md
- label: PREPARE TRANSACTION
href: ./prepare-transaction.md
- label: PURGE
href: ./purge.md
- label: REASSIGN OWNED
href: ./reassign-owned.md
- label: REFRESH INCREMENTAL MATERIALIZED VIEW
href: ./refresh-incremental-materialized-view.md
- label: REFRESH MATERIALIZED VIEW
href: ./refresh-materialized-view.md
- label: REINDEX
href: ./reindex.md
- label: RELEASE SAVEPOINT
href: ./release-savepoint.md
- label: REPLACE INTO
href: ./replace_into.md
- label: RESET
href: ./reset.md
- label: REVOKE
href: ./revoke.md
- label: ROLLBACK
href: ./rollback.md
- label: ROLLBACK PREPARED
href: ./rollback-prepared.md
- label: ROLLBACK TO SAVEPOINT
href: ./rollback-to-savepoint.md
- label: SAVEPOINT
href: ./savepoint.md
- label: SELECT
href: ./select.md
- label: SELECT INTO
href: ./select-into.md
- label: SET
href: ./set.md
- label: SET CONSTRAINTS
href: ./set-constraints.md
- label: SET ROLE
href: ./set-role.md
- label: SET SESSION AUTHORIZATION
href: ./set-session-authorization.md
- label: SET TRANSACTION
href: ./set-transaction.md
- label: SHOW
href: ./show.md
- label: SHOW EVENTS
href: ./show-events.md
- label: SHUTDOWN
href: ./shutdown.md
- label: SNAPSHOT
href: ./snapshot.md
- label: START TRANSACTION
href: ./start-transaction.md
- label: TIMECAPSULE TABLE
href: ./timecapsule-table.md
- label: TRUNCATE
href: ./truncate.md
- label: UPDATE
href: ./update.md
- label: VACUUM
href: ./vacuum.md
- label: VALUES
href: ./values.md
- label: SHRINK
href: ./shrink.md
- label: ALTER PROCEDURE
href: ./alter-procedure.md
- label: ALTER GLOBAL CONFIGURATION
href: ./alter-global-configuration.md
- label: DROP GLOBAL CONFIGURATION
href: ./drop-global-configuration.md
- label: Expressions
sections:
- label: Simple Expressions
href: ./simple-expressions.md
- label: Condition Expressions
href: ./condition-expressions.md
- label: Subquery Expressions
href: ./subquery-expressions.md
- label: Array Expressions
href: ./array-expressions.md
- label: Row Expressions
href: ./row-expressions.md
- label: Functions and Operators
sections:
- label: Logical Operators
href: ./logical-operators.md
- label: Comparison Operators
href: ./comparison-operators.md
- label: Character Processing Functions and Operators
href: ./character-processing-functions-and-operators.md
- label: Binary String Functions and Operators
href: ./binary-string-functions-and-operators.md
- label: Bit String Functions and Operators
href: ./bit-string-functions-and-operators.md
- label: Mode Matching Operators
href: ./mode-matching-operators.md
- label: Mathematical Functions and Operators
href: ./mathematical-functions-and-operators.md
- label: Date and Time Processing Functions and Operators
href: ./date-and-time-processing-functions-and-operators.md
- label: Type Conversion Functions
href: ./type-conversion-functions.md
- label: Geometric Functions and Operators
href: ./geometric-functions-and-operators.md
- label: Network Address Functions and Operators
href: ./network-address-functions-and-operators.md
- label: Text Search Functions and Operators
href: ./text-search-functions-and-operators.md
- label: UUID Functions
href: ./uuid_function.md
- label: JSON/JSONB Functions and Operators
href: ./json-jsonb-functions-and-operators.md
- label: HLL Functions and Operators
href: ./hll-functions-and-operators.md
- label: SEQUENCE Functions
href: ./sequence-functions.md
- label: Array Functions and Operators
href: ./array-functions-and-operators.md
- label: Range Functions and Operators
href: ./range-functions-and-operators.md
- label: Aggregate Functions
href: ./aggregate-functions.md
- label: Window Functions
href: ./window-functions.md
- label: Security Functions
href: ./security-functions.md
- label: Ledger Database Functions
href: ./ledger-database-functions.md
- label: Encrypted Equality Functions
href: ./encrypted-equality-functions.md
- label: Set Returning Functions
href: ./set-returning-functions.md
- label: Conditional Expression Functions
href: ./conditional-expression-functions.md
- label: System Information Functions
href: ./system-information-functions.md
- label: System Administration Functions
sections:
- label: Configuration Settings Functions
href: ./configuration-settings-functions.md
- label: Universal File Access Functions
href: ./universal-file-access-functions.md
- label: Server Signal Functions
href: ./server-signal-functions.md
- label: Backup and Restoration Control Functions
href: ./backup-and-restoration-control-functions.md
- label: Snapshot Synchronization Functions
href: ./snapshot-synchronization-functions.md
- label: Database Object Functions
href: ./database-object-functions.md
- label: Advisory Lock Functions
href: ./advisory-lock-functions.md
- label: Logical Replication Functions
href: ./logical-replication-functions.md
- label: Segment-Page Storage Functions
href: ./segment-page-storage-functions.md
- label: Other Functions
href: ./other-functions.md
- label: Undo System Functions
href: ./undo-system-functions.md
- label: Row-store Compression System Functions
href: ./row-store-compression-system-functions.md
- label: Statistics Information Functions
href: ./statistics-information-functions.md
- label: Trigger Functions
href: ./trigger-functions.md
- label: Hash Function
href: ./hash-function.md
- label: Prompt Message Function
href: ./prompt-message-function.md
- label: Global Temporary Table Functions
href: ./global-temporary-table-functions.md
- label: Fault Injection System Function
href: ./fault-injection-system-function.md
- label: AI Feature Functions
href: ./ai-feature-functions.md
- label: Dynamic Data Masking Functions
href: ./dynamic-data-masking-functions.md
- label: Other System Functions
href: ./other-system-functions.md
- label: Internal Functions
href: ./internal-functions.md
- label: Obsolete Functions
href: ./obsolete-functions.md
- label: Global SysCache Feature Functions
href: ./global-syscache-feature-functions.md
- label: Data Damage Detection and Repair Functions
href: ./data-damage-detection-and-repair-functions.md
- label: Transactions and Locks
sections:
- label: Locks
href: ./locks-1.md
- label: Transactions
href: ./managing-transactions.md
- label: Controlling Transactions
href: ./controlling-transactions.md
- label: Tables and Storage
sections:
- label: Creating a Table
href: ./creating-a-table.md
- label: Partitioned Tables
href: ./partitioned-tables.md
- label: Programmability
sections:
- label: Anonymous Blocks
href: ./anonymous-blocks-1.md
- label: PL/pgSQL Functions
href: ./pl-pgsql-functions.md
- label: Triggers
href: ./triggers.md
- label: Stored Procedure
sections:
- label: Overview
href: ./stored-procedure-21.md
- label: Data Types
href: ./data-types-22.md
- label: Data Type Conversion
href: ./data-type-conversion.md
- label: Arrays
href: ./arrays.md
- label: Record
href: ./record.md
- label: DECLARE Syntax
sections:
- label: Basic Structure
href: ./basic-structure.md
- label: Anonymous Blocks
href: ./anonymous-blocks.md
- label: Subprogram
href: ./subprogram.md
- label: Basic Statements
sections:
- label: Overview
href: ./basic-statements.md
- label: Variable Definition Statements
href: ./variable-definition-statements.md
- label: Assignment Statements
href: ./assignment-statements.md
- label: Call Statements
href: ./call-statements.md
- label: Dynamic Statements
sections:
- label: Executing Dynamic Query Statements
href: ./executing-dynamic-query-statements.md
- label: Executing Dynamic Non-query Statements
href: ./executing-dynamic-non-query-statements.md
- label: Dynamically Calling Stored Procedures
href: ./dynamically-calling-stored-procedures.md
- label: Dynamically Calling Anonymous Blocks
href: ./dynamically-calling-anonymous-blocks.md
- label: Control Statements
sections:
- label: RETURN Statements
href: ./return-statements.md
- label: Conditional Statements
href: ./conditional-statements.md
- label: Loop Statements
href: ./loop-statements.md
- label: Branch Statements
href: ./branch-statements.md
- label: NULL Statements
href: ./null-statements.md
- label: Error Trapping Statements
href: ./error-trapping-statements.md
- label: GOTO Statements
href: ./goto-statements.md
- label: Transaction Management
href: ./transaction-management.md
- label: Other Statements
sections:
- label: Lock Operations
href: ./lock-operations.md
- label: Cursor Operations
href: ./cursor-operations.md
- label: Cursors
sections:
- label: Overview
href: ./overview-23.md
- label: Explicit Cursor
href: ./explicit-cursor.md
- label: Implicit Cursor
href: ./implicit-cursor.md
- label: Cursor Loop
href: ./cursor-loop.md
- label: Retry Management
href: ./retry-management.md
- label: Debugging
href: ./debugging.md
- label: Autonomous Transaction
sections:
- label: Overview
href: ./autonomous-transaction.md
- label: Stored Procedure Supporting Autonomous Transaction
href: ./stored-procedure-supporting-autonomous-transaction.md
- label: Anonymous Block Supporting Autonomous Transaction
href: ./anonymous-block-supporting-autonomous-transaction.md
- label: Function Supporting Autonomous Transaction
href: ./function-supporting-autonomous-transaction.md
- label: Restrictions
href: ./restrictions.md
- label: Materialized View
sections:
- label: Overview
href: ./materialized-view.md
- label: Complete-refresh Materialized View
href: ./complete-refresh-materialized-view.md
- label: Fast-refresh Materialized View
href: ./fast-refresh-materialized-view.md
- label: Subtype
href: ./subtype.md
- label: Full Text Search
sections:
- label: Introduction
sections:
- label: Full-Text Retrieval
href: ./full-text-retrieval.md
- label: What Is a Document?
href: ./what-is-a-document.md
- label: Basic Text Matching
href: ./basic-text-matching.md
- label: Configurations
href: ./configurations.md
- label: Tables and Indexes
sections:
- label: Searching a Table
href: ./searching-a-table.md
- label: Creating an Index
href: ./creating-an-index.md
- label: Constraints on Index Use
href: ./constraints-on-index-use.md
- label: Controlling Text Search
sections:
- label: Parsing Documents
href: ./parsing-documents.md
- label: Parsing Queries
href: ./parsing-queries.md
- label: Ranking Search Results
href: ./ranking-search-results.md
- label: Highlighting Results
href: ./highlighting-results.md
- label: Additional Features
sections:
- label: Manipulating tsvector
href: ./manipulating-tsvector.md
- label: Manipulating Queries
href: ./manipulating-queries.md
- label: Rewriting Queries
href: ./rewriting-queries.md
- label: Gathering Document Statistics
href: ./gathering-document-statistics.md
- label: Parser
href: ./parser.md
- label: Dictionaries
sections:
- label: Overview
href: ./overview-19.md
- label: Stop Words
href: ./stop-words.md
- label: Simple Dictionary
href: ./simple-dictionary.md
- label: Synonym Dictionary
href: ./synonym-dictionary.md
- label: Thesaurus Dictionary
href: ./thesaurus-dictionary.md
- label: Ispell Dictionary
href: ./ispell-dictionary.md
- label: Snowball Dictionary
href: ./snowball-dictionary.md
- label: Configuration Examples
href: ./configuration-examples.md
- label: Testing and Debugging Text Search
sections:
- label: Testing a Configuration
href: ./testing-a-configuration.md
- label: Testing a Parser
href: ./testing-a-parser.md
- label: Testing a Dictionary
href: ./testing-a-dictionary.md
- label: Limitations
href: ./limitations.md
- label: Extended Functions
href: ./extended-functions.md
- label: Extended Syntax
href: ./extended-syntax.md
- label: System Operation
href: ./system-operation.md
- label: GIN Indexes
sections:
- label: Introduction
href: ./introduction-20.md
- label: Scalability
href: ./scalability.md
- label: Implementation
href: ./implementation.md
- label: GIN Tips and Tricks
href: ./gin-tips-and-tricks.md