我的书签
添加书签
移除书签示例：查询中使用 Decode 函数
查询中使用 Decode 函数
- 快速入门
- SQL 调优指南
- 管理员指南
- OceanBase 数据库概览
- What’s New
- 术语表
- 常见问题
- 了解 OceanBase 数据库
- SQL 参考（MySQL 模式）
- 查询和子查询
- 运算符
- SQL语句
- SELECT
- TRANSACTION
- SHOW GRANTS
- FLASHBACK DATABASE
- TRUNCATE TABLE
- DROP TENANT
- DROP INDEX
- CREATE RESOURCE UNIT
- EXPLAIN
- CREATE OUTLINE
- ALTER OUTLINE
- FLASHBACK TENANT
- RENAME TABLE
- ALTER TABLEGROUP
- CREATE RESTORE POINT
- SCHEMA
- ALTER TENANT
- INSERT
- UPDATE
- CREATE INDEX
- PURGE TABLE
- DROP VIEW
- SET PASSWORD
- CREATE DATABASE
- RENAME USER
- FLASHBACK TABLE
- CREATE USER
- CREATE RESOURCE POOL
- 通用语法
- SAVEPOINT
- CREATE TABLEGROUP
- ALTER DATABASE
- DROP RESOURCE POOL
- DROP RESOURCE UNIT
- DROP TABLEGROUP
- PURGE DATABASE
- GRANT
- DROP USER
- PURGE RECYCLEBIN
- DROP DATABASE
- ALTER SYSTEM
- CREATE SYNONYM
- REPLACE
- PURGE TENANT
- PURGE INDEX
- SHOW RECYCLEBIN
- DROP SYNONYM
- DELETE
- REVOKE
- CREATE TENANT
- SESSION
- ALTER USER
- KILL
- DROP TABLE
- ALTER RESOURCE POOL
- CREATE VIEW
- DROP OUTLINE
- CREATE TABLE
- ALTER RESOURCE UNIT
- ALTER TABLE
- DROP RESTORE POINT
- 基本元素
- 函数
- 版本发布记录
- 参考指南（MySQL 模式）
- 系统视图
- 概述
- 性能视图
- gv$session_event
- gv$sysstat
- v$encrypted_tables
- gv$memory
- gv$concurrent_limit_sql
- v$sesstat
- v$sql_plan_monitor
- v$sysstat
- gv$sql_workarea
- v$statname
- gv$unit
- gv$plan_cache_plan_explain
- gv$tenant_px_worker_stat
- gv$plan_cache_stat
- gv$database
- v$ob_all_clusters
- gv$sql_plan_monitor
- gv$ps_stat
- v$sql
- v$obrpc_incoming
- gv$minor_merge_info
- v$ps_stat
- v$ps_item_info
- v$obrpc_outgoing
- gv$partition
- v$ob_sql_workarea_memory_info
- v$partition
- v$ob_cluster_failover_info
- gv$partition_audit
- gv$memstore
- v$lock
- v$unit
- v$tenant_px_worker_stat
- v$session_wait
- gv$session_wait
- gv$latch
- v$latch
- v$ob_cluster_stats
- gv$tenant_memstore_allocator_info
- v$ob_cluster
- v$ob_standby_status
- v$partition_audit
- v$memstore
- v$sql_plan_statistics
- gv$table
- v$session_longops
- gv$session_wait_history
- gv$server_schema_info
- v$server_schema_info
- v$sql_workarea_active
- gv$sql_plan_statistics
- v$memory
- v$ob_cluster_event_history
- v$sql_audit
- gv$plan_cache_plan_stat
- gv$tenant
- gv$memstore_info
- v$session_wait_history
- v$encrypted_tablespaces
- v$restore_point
- v$memstore_info
- v$sql_workarea
- gv$sql_audit
- gv$outline
- v$session_event
- v$ob_timestamp_service
- gv$server_memstore
- v$lock_wait_stat
- v$plan_cache_plan_explain
- gv$obrpc_incoming
- v$sql_workarea_histogram
- v$event_name
- v$plan_cache_stat
- gv$lock
- v$sql_monitor_statname
- v$plan_cache_plan_stat
- gv$sesstat
- gv$unit_load_balance_event_history
- v$system_event
- gv$lock_wait_stat
- gv$ob_sql_workarea_memory_info
- v$tenant_memstore_allocator_info
- gv$obrpc_outgoing
- v$merge_info
- gv$merge_info
- gv$sql_workarea_histogram
- gv$sql
- gv$session_longops
- 字典视图
- information_schema.STATISTICS
- information_schema.PARAMETERS
- oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK
- oceabase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG
- oceanbase.CDB_OB_BACKUP_VALIDATION_TASK_HISTORY
- mysql.time_zone_name
- mysql.help_topic
- information_schema.USER_RECYCLEBIN
- information_schema.SCHEMA_PRIVILEGES
- information_schema.GLOBAL_STATUS
- mysql.help_category
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG
- information_schema.TABLES
- information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
- information_schema.SESSION_VARIABLES
- oceanbase.CDB_OB_BACKUP_TASK_CLEAN_HISTORY
- oceanbase.CDB_CKPT_HISTORY
- oceanbase.CDB_OB_BACKUP_SET_FILES
- oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB
- oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK
- information_schema.DBA_OUTLINES
- mysql.db
- oceanbase.CDB_OB_BACKUP_SET_DETAILS
- information_schema.ROUTINES
- oceanbase.CDB_OB_BACKUP_JOB_DETAILS
- oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY
- information_schema.VIEWS
- oceanbase.CDB_OB_RESTORE_HISTORY
- information_schema.PROCESSLIST
- information_schema.KEY_COLUMN_USAGE
- oceanbase.CDB_OB_BACKUP_SET_OBSOLETE
- information_schema.REFERENTIAL_CONSTRAINTS
- oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY
- information_schema.CHARACTER_SETS
- information_schema.PARTITIONS
- oceanbase.CDB_OB_BACKUP_VALIDATION_JOB
- information_schema.ENGINES
- mysql.time_zone_transition_type
- information_schema.SCHEMATA
- oceanbase.CDB_OB_BACKUP_CLEAN_HISTORY
- information_schema.TABLE_PRIVILEGES
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG_SUMMARY
- information_schema.TABLE_CONSTRAINTS
- mysql.help_relation
- information_schema.COLUMNS
- information_schema.SESSION_STATUS
- oceanbase.CDB_OB_BACKUP_PIECE_FILES
- mysql.proc
- oceanbase.CDB_OB_BACKUP_SET_EXPIRED
- information_schema.USER_PRIVILEGES
- oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY
- mysql.time_zone
- oceanbase.CDB_OB_BACKUP_ARCHIVELOG_PROGRESS
- oceanbase.CDB_OB_BACKUP_PROGRESS
- information_schema.GLOBAL_VARIABLES
- information_schema.COLLATIONS
- mysql.help_keyword
- oceanbase.CDB_OB_RESTORE_PROGRESS
- mysql.user
- mysql.time_zone_transition
- oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY
- 系统配置项
- max_syslog_file_count
- balancer_task_timeout
- backup_backup_dest
- major_compact_trigger
- sys_bkgd_migration_change_member_list_timeout
- election_blacklist_interval
- datafile_disk_percentage
- zone_merge_concurrency
- merge_thread_count
- large_query_worker_percentage
- enable_perf_event
- backup_concurrency
- sql_audit_memory_limit
- minor_freeze_times
- virtual_table_location_cache_expire_time
- trace_log_slow_query_watermark
- tcp_keepintvl
- enable_clog_persistence_compress
- server_balance_critical_disk_waterlevel
- balancer_timeout_check_interval
- default_compress
- migrate_concurrency
- enable_upgrade_mode
- enable_sql_operator_dump
- server_cpu_quota_max
- default_progressive_merge_num
- merger_switch_leader_duration_time
- trx_force_kill_threshold
- backup_backupset_retry_interval
- sys_bkgd_io_high_percentage
- server_check_interval
- migration_disable_time
- autoinc_cache_refresh_interval
- clog_persistence_compress_func
- enable_one_phase_commit
- resource_hard_limit
- enable_rebalance
- freeze_trigger_percentage
- tenant_cpu_variation_per_server
- force_refresh_location_cache_interval
- bf_cache_priority
- enable_major_freeze
- index_info_block_cache_priority
- backup_backupset_batch_count
- cpu_reserved
- system_trace_level
- weak_read_version_refresh_interval
- major_freeze_duty_time
- auto_leader_switch_interval
- restore_concurrency
- audit_trail
- get_leader_candidate_rpc_timeout
- enable_sys_unit_standalone
- minor_merge_concurrency
- stack_size
- backup_net_limit
- sys_bkgd_io_low_percentage
- partition_table_check_interval
- px_workers_per_cpu_quota
- sys_bkgd_net_percentage
- user_row_cache_priority
- backup_zone
- syslog_io_bandwidth_limit
- cpu_quota_concurrency
- replica_safe_remove_time
- large_query_threshold
- user_iort_up_percentage
- balancer_tolerance_percentage
- plsql_v2_compatibility
- data_dir
- enable_smooth_leader_switch
- enable_manual_merge
- trace_log_sampling_interval
- enable_global_freeze_trigger
- tenant_groups
- disk_io_thread_count
- rootservice_list
- audit_sys_operations
- minor_deferred_gc_time
- dtl_buffer_size
- backup_dest_option
- enable_sql_audit
- backup_recovery_window
- enable_async_syslog
- internal_sql_execute_timeout
- log_archive_checkpoint_interval
- log_archive_concurrency
- data_disk_usage_limit_percentage
- system_cpu_quota
- backup_backup_dest_option
- mysql_port
- merge_stat_sampling_ratio
- memory_chunk_cache_size
- min_observer_version
- ssl_external_kms_info
- backup_region
- fuse_row_cache_priority
- server_cpu_quota_min
- plsql_ccflags
- enable_record_trace_log
- clog_max_unconfirmed_log_count
- ignore_replay_checksum_error
- open_cursors
- location_cache_refresh_min_interval
- datafile_size
- bf_cache_miss_count_threshold
- net_thread_count
- config_additional_dir
- rpc_port
- unit_balance_resource_weight
- flush_log_at_trx_commit
- dead_socket_detection_timeout
- enable_separate_sys_clog
- merger_check_interval
- leak_mod_to_check
- enable_monotonic_weak_read
- ssl_client_authentication
- clog_disk_utilization_threshold
- index_cache_priority
- obconfig_url
- high_priority_net_thread_count
- rpc_timeout
- sql_audit_queue_size
- tableapi_transport_compress_func
- devname
- clog_disk_usage_limit_percentage
- clog_cache_priority
- external_kms_info
- balancer_log_interval
- global_major_freeze_residual_memory
- row_compaction_update_limit
- ignore_replay_checksum_error
- zone_merge_timeout
- plsql_debug
- minor_warm_up_duration_time
- sql_work_area
- clog_transport_compress_all
- system_memory
- enable_log_archive
- backup_backup_archive_log_batch_count
- builtin_db_data_verify_cycle
- tcp_keepidle
- balancer_idle_time
- election_cpu_quota
- zone_merge_order
- backup_dest
- tde_method
- multiblock_read_size
- clog_sync_time_warn_threshold
- recyclebin_object_expire_time
- trx_2pc_retry_interval
- location_cache_priority
- schema_history_expire_time
- memory_reserved
- default_row_format
- workers_per_cpu_quota
- enable_rich_error_msg
- plan_cache_low_watermark
- max_px_worker_count
- cpu_count
- memory_limit
- tenant_task_queue_size
- server_permanent_offline_time
- rootservice_ready_check_interval
- rootservice_async_task_thread_count
- cluster_id
- 系统配置项概述
- px_task_size
- clog_transport_compress_func
- user_block_cache_priority
- server_data_copy_in_concurrency
- use_large_pages
- merger_completion_percentage
- max_string_print_length
- force_refresh_location_cache_threshold
- enable_record_trace_id
- token_reserved_percentage
- memstore_limit_percentage
- location_refresh_thread_count
- global_write_halt_residual_memory
- writing_throttling_trigger_percentage
- balance_blacklist_failure_threshold
- ob_enable_batched_multi_statement
- server_balance_disk_tolerance_percent
- log_archive_batch_buffer_limit
- ob_ssl_invited_common_names
- index_clog_cache_priority
- location_cache_cpu_quota
- zone
- ignore_replica_checksum_error
- memory_limit_percentage
- syslog_level
- merger_warm_up_duration_time
- server_balance_cpu_mem_tolerance_percent
- ob_event_history_recycle_interval
- default_compress_func
- server_temporary_offline_time
- lease_time
- resource_soft_limit
- cache_wash_threshold
- enable_rebuild_on_purpose
- log_restore_concurrency
- sys_bkgd_migration_retry_num
- location_fetch_concurrency
- enable_tcp_keepalive
- writing_throttling_maximum_duration
- enable_unit_balance_resource_weight
- enable_ddl
- data_copy_concurrency
- tcp_keepcnt
- enable_syslog_wf
- enable_early_lock_release
- wait_leader_batch_count
- global_index_build_single_replica_timeout
- plsql_optimize_level
- plsql_code_type
- workarea_size_policy
- multiblock_read_gap_size
- location_cache_expire_time
- max_kept_major_version_number
- user_tab_col_stat_cache_priority
- auto_delete_expired_backup
- switchover_process_thread_count
- trx_try_wait_lock_timeout
- sys_bkgd_io_timeout
- balancer_emergency_percentage
- all_cluster_list
- enable_rereplication
- plan_cache_high_watermark
- sys_cpu_limit_trigger
- location_cache_refresh_rpc_timeout
- backup_backup_archivelog_retry_interval
- rootservice_memory_limit
- max_stale_time_for_weak_consistency
- backup_log_archive_option
- server_data_copy_out_concurrency
- enable_pg
- rebuild_replica_data_lag_threshold
- row_purge_thread_count
- enable_election_group
- enable_rootservice_standalone
- location_cache_refresh_sql_timeout
- balance_blacklist_retry_interval
- micro_block_merge_verify_level
- cluster
- plsql_warnings
- enable_auto_leader_switch
- partition_table_scan_batch_count
- enable_merge_by_turn
- minor_compact_trigger
- tablet_size
- enable_syslog_recycle
- plan_cache_evict_interval
- rootservice_async_task_queue_size
- 系统变量
- sql_throttle_current_priority
- optimizer_capture_sql_plan_baselines
- ob_bnl_join_cache_size
- ob_tcp_invited_nodes
- character_set_system
- ob_pl_block_timeout
- ob_max_parallel_degree
- ob_enable_truncate_flashback
- undo_retention
- sql_throttle_priority
- auto_increment_offset
- interactive_timeout
- ob_read_consistency
- sql_safe_updates
- character_set_database
- collation_database
- block_encryption_mode
- auto_increment_cache_size
- foreign_key_checks
- ob_proxy_partition_hit
- validate_password_special_char_count
- query_cache_type
- ob_enable_jit
- timestamp
- ob_early_lock_release
- last_insert_id
- debug_sync
- ob_enable_trace_log
- character_set_connection
- ob_temp_tablespace_size_percentage
- sql_throttle_rt
- ob_proxy_global_variables_version
- version_comment
- secure_file_priv
- collation_server
- parallel_max_servers
- ob_enable_aggregation_pushdown
- ob_last_schema_version
- ob_timestamp_service
- ob_compatibility_mode
- sql_auto_is_null
- ob_default_replica_num
- identity
- error_on_overlap_time
- ob_capability_flag
- validate_password_number_count
- connect_timeout
- collation_connection
- sql_throttle_network
- ob_trx_timeout
- init_connect
- autocommit
- ob_stmt_parallel_degree
- ob_org_cluster_id
- ob_global_debug_sync
- max_allowed_packet
- net_buffer_length
- validate_password_length
- validate_password_mixed_case_count
- ob_plan_cache_evict_low_percentage
- performance_schema
- plugin_dir
- validate_password_check_user_name
- net_read_timeout
- datadir
- ob_trx_idle_timeout
- ob_plan_cache_percentage
- ob_enable_transformation
- ob_enable_transmission_checksum
- ob_trx_lock_timeout
- lower_case_table_names
- net_write_timeout
- tx_read_only
- is_result_accurate
- ob_route_policy
- time_zone
- sql_mode
- character_set_server
- character_set_results
- validate_password_policy
- wait_timeout
- default_password_lifetime
- explicit_defaults_for_timestamp
- ob_enable_hash_group_by
- ob_plan_cache_evict_high_percentage
- ob_reserved_meta_memory_percentage
- ob_query_timeout
- ob_create_table_strict_mode
- ob_trace_info
- div_precision_increment
- tracefile_identifier
- optimizer_use_sql_plan_baselines
- ob_sql_audit_percentage
- system_time_zone
- transaction_read_only
- binlog_row_image
- ob_enable_index_direct_select
- sql_warnings
- ob_check_sys_variable
- max_sp_recursion_depth
- version
- query_cache_size
- recyclebin
- ob_enable_plan_cache
- ob_sql_work_area_percentage
- tx_isolation
- ob_enable_blk_nestedloop_join
- sql_quote_show_create
- character_set_client
- character_set_filesystem
- license
- sql_select_limit
- ob_log_level
- max_user_connections
- auto_increment_increment
- parallel_servers_target
- transaction_isolation
- read_only
- group_concat_max_len
- ob_proxy_set_trx_executed
- 系统变量概述
- ob_enable_sql_audit
- 预留关键字
- 系统视图
- 部署 OceanBase 数据库
- 升级指南
- SQL 参考（Oracle 模式）
- 条件
- SQL 概述
- 查询和子查询
- 基本元素
- 伪列
- 函数
- 分析函数
- 函数概述
- 聚合函数
- 单行函数
- 空值相关函数
- 转换函数
- 编码解码函数
- 时间日期函数
- CURRENT_TIMESTAMP
- TO_TIMESTAMP
- TZ_OFFSET
- NEXT_DAY
- NUMTODSINTERVAL
- SYSDATE
- NUMTOYMINTERVAL
- TO_DSINTERVAL
- CURRENT_DATE
- SYS_EXTRACT_UTC
- TRUNC (date)
- LAST_DAY
- EXTRACT（datetime）
- FROM_TZ
- ROUND (date)
- MONTHS_BETWEEN
- TO_CHAR (datetime)
- TO_YMINTERVAL
- TO_TIMESTAMP_TZ
- DBTIMEZONE
- SYSTIMESTAMP
- SESSIONTIMEZONE
- LOCALTIMESTAMP
- ADD_MONTHS
- 返回字符串的字符串函数
- 通用比较函数
- 数字函数
- 返回数字的字符串函数
- 表达式
- SQL语句
- DCL
- DDL
- CREATE TABLESPACE
- DROP OUTLINE
- RENAME
- CREATE TABLEGROUP
- CREATE KEYSTORE
- CREATE USER
- TRUNCATE TABLE
- CREATE OUTLINE
- CREATE SEQUENCE
- ALTER KEYSTORE
- ALTER OUTLINE
- DROP TABLESPACE
- ALTER SESSION
- ALTER SEQUENCE
- ALTER TABLEGROUP
- DROP RESTORE POINT
- CREATE RESTORE POINT
- ALTER USER
- DROP TABLEGROUP
- ALTER TABLE
- CREATE SYNONYM
- DROP SEQUENCE
- CREATE INDEX
- CREATE TABLE
- DROP USER
- DROP VIEW
- DROP TABLE
- CREATE VIEW
- DROP SYNONYM
- DROP INDEX
- DML
- 运算符
- 开发者指南（MySQL 模式）
- 参考指南（Oracle 模式）
- 预留关键字
- 系统视图
- 性能视图
- GV$INSTANCE
- V$MEMORY
- GV$SQL_WORKAREA_ACTIVE
- GV$OB_SQL_WORKAREA_MEMORY_INFO
- V$NLS_PARAMETERS
- V$SESSION_WAIT
- V$OB_SQL_WORKAREA_MEMORY_INFO
- GV$SQL_AUDIT
- GV$PS_ITEM_INFO
- GV$MEMSTORE_INFO
- V$SESSTAT
- GV$SQL_WORKAREA_HISTOGRAM
- V$MEMSTORE
- V$TIMEZONE_NAMES
- V$ENCRYPTED_TABLES
- V$VERSION
- GV$OUTLINE
- V$PLAN_CACHE_PLAN_STAT
- GV$MEMSTORE
- GV$SESSTAT
- V$SYSSTAT
- GV$GLOBAL_TRANSACTION
- V$SQL_WORKAREA_HISTOGRAM
- GV$SYSSTAT
- GV$SESSION_WAIT
- V$PS_ITEM_INFO
- GV$SYSTEM_EVENT
- GV$PS_STAT
- GV$PLAN_CACHE_STAT
- V$SYSTEM_EVENT
- GV$PLAN_CACHE_PLAN_EXPLAIN
- GV$SQL_WORKAREA
- V$RESTORE_POINT
- V$MEMSTORE_INFO
- V$LOCK
- GV$CONCURRENT_LIMIT_SQL
- GV$LOCK
- V$SQL_MONITOR_STATNAME
- V$SQL_AUDIT
- V$PLAN_CACHE_PLAN_EXPLAIN
- V$GLOBAL_TRANSACTION
- GV$MEMORY
- V$SQL_WORKAREA
- V$SESSION_WAIT_HISTORY
- GV$PLAN_CACHE_PLAN_STAT
- V$ENCRYPTED_TABLESPACES
- V$PS_STAT
- V$PLAN_CACHE_STAT
- GV$SESSION_WAIT_HISTORY
- V$INSTANCE
- GV$SERVER_MEMSTORE
- V$SQL_WORKAREA_ACTIVE
- 字典视图
- ALL_OBJECTS
- USER_IND_PARTITIONS
- DBA_AUDIT_TRAIL
- ALL_PART_KEY_COLUMNS
- USER_TAB_COLUMNS
- USER_TRIGGERS
- DBA_RECYCLEBIN
- USER_TAB_COMMENTS
- USER_OBJECTS
- DBA_COL_PRIVS
- DBA_IND_SUBPARTITIONS
- ALL_SOURCE
- ALL_ERRORS
- ALL_TAB_PRIVS
- DBA_TAB_COMMENTS
- DBA_OBJECTS
- USER_COL_PRIVS
- USER_AUDIT_SESSION
- DBA_STMT_AUDIT_OPTS
- ALL_CONSTRAINTS
- DBA_TAB_COLUMNS
- DBA_CONS_COLUMNS
- ALL_PART_TABLES
- USER_IND_COLUMNS
- USER_PROFILES
- USER_SOURCE
- ALL_ALL_TABLES
- DBA_INDEXES
- DBA_USERS
- DBA_SCHEDULER_PROGRAM_ARGS
- USER_IND_SUBPARTITIONS
- ALL_IND_EXPRESSIONS
- USER_RECYCLEBIN
- ALL_SCHEDULER_JOB_ARGS
- DBA_TRIGGERS
- ALL_COL_COMMENTS
- DBA_TAB_PARTITIONS
- DBA_TAB_PRIVS
- USER_TAB_COLS
- USER_ERRORS
- ALL_TYPES
- ALL_PROFILES
- DBA_ROLES
- USER_ROLE_PRIVS
- ALL_TYPE_METHODS
- USER_COL_COMMENTS
- USER_ARGUMENTS
- USER_ALL_TABLES
- DBA_AUDIT_EXISTS
- DBA_COL_COMMENTS
- DBA_ROLE_PRIVS
- DBA_SYS_PRIVS
- DBA_SUBPARTITION_TEMPLATES
- DBA_TAB_COLS
- ALL_DEF_AUDIT_OPTS
- USER_TABLES
- ALL_PART_INDEXES
- DBA_TAB_SUBPARTITIONS
- USER_PART_INDEXES
- ALL_SEQUENCES
- DBA_ARGUMENTS
- ALL_USERS
- DBA_PART_KEY_COLUMNS
- ALL_TYPE_ATTRS
- USER_PROCEDURES
- USER_AUDIT_TRAIL
- DBA_IND_COLUMNS
- DBA_TYPE_METHODS
- ALL_PROCEDURES
- USER_AUDIT_OBJECT
- DBA_OBJ_AUDIT_OPTS
- DICTIONARY
- ALL_COLL_TYPES
- ALL_IND_SUBPARTITIONS
- USER_PART_TABLES
- DBA_PART_TABLES
- ALL_TABLES
- USER_CONSTRAINTS
- ALL_VIEWS
- NLS_INSTANCE_PARAMETERS
- ALL_SCHEDULER_PROGRAM_ARGS
- ALL_TAB_PARTITIONS
- DBA_AUDIT_STATEMENT
- DBA_COLL_TYPES
- ALL_INDEXES
- USER_SYNONYMS
- DBA_ALL_TABLES
- USER_SEQUENCES
- USER_TYPES
- DBA_TABLES
- USER_IND_EXPRESSIONS
- USER_TYPE_ATTRS
- ALL_TRIGGERS
- ALL_TAB_COMMENTS
- STMT_AUDIT_OPTION_MAP
- NLS_DATABASE_PARAMETERS
- DBA_AUDIT_OBJECT
- USER_INDEXES
- USER_SEGMENTS
- AUDIT_ACTIONS
- ALL_TAB_COLUMNS
- DBA_SEQUENCES
- USER_SUBPARTITION_TEMPLATES
- DBA_METHOD_PARAMS
- ALL_ARGUMENTS
- DBA_PROCEDURES
- ALL_IND_PARTITIONS
- DBA_VIEWS
- DBA_TYPE_ATTRS
- USER_TABLESPACES
- DBA_PROFILES
- USER_TAB_SUBPARTITIONS
- DBA_IND_EXPRESSIONS
- ROLE_ROLE_PRIVS
- ALL_TAB_SUBPARTITIONS
- USER_CONS_COLUMNS
- ALL_SYNONYMS
- USER_SUBPART_KEY_COLUMNS
- ALL_CONS_COLUMNS
- ROLE_TAB_PRIVS
- ALL_IND_COLUMNS
- DBA_IND_PARTITIONS
- ALL_SUBPARTITION_TEMPLATES
- DBA_SUBPART_KEY_COLUMNS
- USER_VIEWS
- ALL_SUBPART_KEY_COLUMNS
- DBA_TABLESPACES
- DBA_SCHEDULER_JOB_ARGS
- ALL_COL_PRIVS
- USER_AUDIT_STATEMENT
- ALL_METHOD_PARAMS
- DBA_SOURCE
- ALL_TAB_COLS
- USER_TYPE_METHODS
- DBA_ERRORS
- NLS_SESSION_PARAMETERS
- ROLE_SYS_PRIVS
- USER_PART_KEY_COLUMNS
- DBA_CONSTRAINTS
- DBA_SYNONYMS
- USER_SYS_PRIVS
- DICT
- USER_TAB_PARTITIONS
- DBA_PART_INDEXES
- USER_COLL_TYPES
- DBA_SEGMENTS
- DBA_AUDIT_SESSION
- DBA_TYPES
- 性能视图
- 系统变量
- performance_schema
- ob_enable_plan_cache
- ob_early_lock_release
- transaction_read_only
- recyclebin
- parallel_servers_target
- error_on_overlap_time
- character_set_results
- auto_increment_offset
- ob_default_replica_num
- tracefile_identifier
- foreign_key_checks
- sql_throttle_current_priority
- auto_increment_cache_size
- autocommit
- query_cache_type
- version
- init_connect
- ob_log_level
- system_time_zone
- sql_select_limit
- interactive_timeout
- ob_sql_work_area_percentage
- net_read_timeout
- nls_timestamp_format
- nls_date_language
- ob_create_table_strict_mode
- ob_compatibility_mode
- sql_warnings
- last_insert_id
- nls_calendar
- ob_enable_index_direct_select
- ob_enable_blk_nestedloop_join
- group_concat_max_len
- secure_file_priv
- optimizer_use_sql_plan_baselines
- ob_plan_cache_percentage
- ob_trx_idle_timeout
- time_zone
- ob_stmt_parallel_degree
- nls_comp
- debug_sync
- sql_auto_is_null
- ob_route_policy
- nls_timestamp_tz_format
- ob_enable_aggregation_pushdown
- ob_tcp_invited_nodes
- version_comment
- ob_enable_transformation
- nls_numeric_characters
- max_sp_recursion_depth
- ob_trace_info
- license
- ob_proxy_partition_hit
- sql_quote_show_create
- nls_date_format
- ob_enable_hash_group_by
- ob_enable_jit
- ob_last_schema_version
- sql_throttle_priority
- ob_global_debug_sync
- net_buffer_length
- binlog_row_image
- character_set_client
- ob_sql_audit_percentage
- ob_enable_truncate_flashback
- nls_length_semantics
- undo_retention
- nls_characterset
- ob_enable_trace_log
- plugin_dir
- lower_case_table_names
- ob_max_parallel_degree
- ob_enable_sql_audit
- ob_plan_cache_evict_low_percentage
- ob_reserved_meta_memory_percentage
- nls_sort
- ob_capability_flag
- max_user_connections
- ob_timestamp_service
- connect_timeout
- ob_pl_block_timeout
- datadir
- nls_language
- optimizer_capture_sql_plan_baselines
- transaction_isolation
- ob_proxy_set_trx_executed
- net_write_timeout
- character_set_filesystem
- ob_plan_cache_evict_high_percentage
- tx_isolation
- ob_read_consistency
- parallel_max_servers
- div_precision_increment
- ob_trx_timeout
- nls_nchar_characterset
- is_result_accurate
- ob_org_cluster_id
- ob_proxy_global_variables_version
- sql_throttle_rt
- ob_query_timeout
- identity
- timestamp
- collation_connection
- max_allowed_packet
- ob_enable_transmission_checksum
- auto_increment_increment
- read_only
- character_set_system
- query_cache_size
- ob_bnl_join_cache_size
- ob_temp_tablespace_size_percentage
- nls_nchar_conv_excp
- tx_read_only
- sql_mode
- ob_trx_lock_timeout
- character_set_connection
- 系统变量概述
- wait_timeout
- sql_throttle_network
- nls_territory
- 系统配置项
- enable_async_syslog
- minor_freeze_times
- tenant_cpu_variation_per_server
- cpu_quota_concurrency
- disk_io_thread_count
- major_compact_trigger
- max_stale_time_for_weak_consistency
- trx_2pc_retry_interval
- backup_zone
- ignore_replay_checksum_error
- global_write_halt_residual_memory
- syslog_level
- merger_check_interval
- flush_log_at_trx_commit
- writing_throttling_maximum_duration
- ob_ssl_invited_common_names
- micro_block_merge_verify_level
- zone_merge_order
- plan_cache_evict_interval
- ob_enable_batched_multi_statement
- enable_global_freeze_trigger
- datafile_disk_percentage
- log_archive_checkpoint_interval
- replica_safe_remove_time
- backup_log_archive_option
- balancer_timeout_check_interval
- stack_size
- trace_log_sampling_interval
- location_cache_refresh_min_interval
- system_cpu_quota
- balancer_task_timeout
- backup_concurrency
- internal_sql_execute_timeout
- max_kept_major_version_number
- autoinc_cache_refresh_interval
- ignore_replica_checksum_error
- syslog_io_bandwidth_limit
- merge_thread_count
- enable_separate_sys_clog
- ignore_replay_checksum_error
- dead_socket_detection_timeout
- sys_bkgd_io_low_percentage
- minor_deferred_gc_time
- sys_bkgd_migration_retry_num
- enable_rebuild_on_purpose
- tcp_keepcnt
- clog_max_unconfirmed_log_count
- tcp_keepidle
- use_large_pages
- minor_merge_concurrency
- force_refresh_location_cache_threshold
- default_row_format
- resource_hard_limit
- tenant_task_queue_size
- px_task_size
- resource_soft_limit
- enable_sql_operator_dump
- workers_per_cpu_quota
- index_info_block_cache_priority
- cache_wash_threshold
- enable_syslog_wf
- min_observer_version
- rpc_port
- backup_backup_archivelog_retry_interval
- virtual_table_location_cache_expire_time
- server_data_copy_in_concurrency
- trace_log_slow_query_watermark
- enable_perf_event
- data_dir
- enable_auto_leader_switch
- weak_read_version_refresh_interval
- default_progressive_merge_num
- minor_compact_trigger
- row_compaction_update_limit
- sql_audit_queue_size
- enable_unit_balance_resource_weight
- clog_transport_compress_func
- user_tab_col_stat_cache_priority
- clog_transport_compress_all
- devname
- clog_disk_utilization_threshold
- multiblock_read_size
- enable_manual_merge
- sql_audit_memory_limit
- balancer_emergency_percentage
- plan_cache_high_watermark
- wait_leader_batch_count
- index_cache_priority
- zone_merge_concurrency
- enable_pg
- server_data_copy_out_concurrency
- open_cursors
- cluster_id
- clog_cache_priority
- dtl_buffer_size
- enable_smooth_leader_switch
- log_restore_concurrency
- plsql_code_type
- recyclebin_object_expire_time
- leak_mod_to_check
- backup_backupset_retry_interval
- tde_method
- migrate_concurrency
- balancer_log_interval
- auto_delete_expired_backup
- unit_balance_resource_weight
- rootservice_list
- enable_clog_persistence_compress
- sys_bkgd_migration_change_member_list_timeout
- all_cluster_list
- default_compress
- clog_persistence_compress_func
- server_balance_critical_disk_waterlevel
- cpu_count
- sys_cpu_limit_trigger
- location_fetch_concurrency
- plsql_ccflags
- sys_bkgd_io_timeout
- election_blacklist_interval
- merger_switch_leader_duration_time
- plsql_optimize_level
- plsql_v2_compatibility
- election_cpu_quota
- user_block_cache_priority
- backup_backup_dest
- enable_ddl
- clog_disk_usage_limit_percentage
- location_refresh_thread_count
- large_query_threshold
- cluster
- builtin_db_data_verify_cycle
- plsql_debug
- rootservice_async_task_thread_count
- cpu_reserved
- server_cpu_quota_max
- enable_rebalance
- freeze_trigger_percentage
- log_archive_concurrency
- audit_sys_operations
- backup_backup_archive_log_batch_count
- restore_concurrency
- location_cache_refresh_sql_timeout
- merge_stat_sampling_ratio
- enable_rootservice_standalone
- location_cache_priority
- server_balance_cpu_mem_tolerance_percent
- server_check_interval
- plsql_warnings
- lease_time
- rootservice_ready_check_interval
- enable_record_trace_log
- partition_table_check_interval
- global_index_build_single_replica_timeout
- enable_one_phase_commit
- sql_work_area
- rootservice_async_task_queue_size
- max_px_worker_count
- zone
- schema_history_expire_time
- clog_sync_time_warn_threshold
- enable_record_trace_id
- large_query_worker_percentage
- max_string_print_length
- enable_rich_error_msg
- server_balance_disk_tolerance_percent
- tablet_size
- writing_throttling_trigger_percentage
- net_thread_count
- trx_try_wait_lock_timeout
- enable_early_lock_release
- balancer_tolerance_percentage
- index_clog_cache_priority
- migration_disable_time
- backup_dest_option
- location_cache_refresh_rpc_timeout
- enable_syslog_recycle
- sys_bkgd_net_percentage
- location_cache_cpu_quota
- enable_upgrade_mode
- ob_event_history_recycle_interval
- enable_sql_audit
- enable_election_group
- enable_major_freeze
- balance_blacklist_failure_threshold
- balance_blacklist_retry_interval
- sys_bkgd_io_high_percentage
- backup_backupset_batch_count
- max_syslog_file_count
- system_memory
- data_disk_usage_limit_percentage
- log_archive_batch_buffer_limit
- workarea_size_policy
- fuse_row_cache_priority
- enable_monotonic_weak_read
- memory_reserved
- location_cache_expire_time
- multiblock_read_gap_size
- system_trace_level
- obconfig_url
- switchover_process_thread_count
- partition_table_scan_batch_count
- px_workers_per_cpu_quota
- 系统配置项概述
- rootservice_memory_limit
- enable_merge_by_turn
- config_additional_dir
- audit_trail
- external_kms_info
- enable_tcp_keepalive
- trx_force_kill_threshold
- get_leader_candidate_rpc_timeout
- rpc_timeout
- backup_net_limit
- backup_dest
- enable_log_archive
- major_freeze_duty_time
- auto_leader_switch_interval
- mysql_port
- backup_region
- global_major_freeze_residual_memory
- server_temporary_offline_time
- rebuild_replica_data_lag_threshold
- balancer_idle_time
- ssl_external_kms_info
- user_iort_up_percentage
- tcp_keepintvl
- server_cpu_quota_min
- backup_recovery_window
- tenant_groups
- user_row_cache_priority
- tableapi_transport_compress_func
- ssl_client_authentication
- minor_warm_up_duration_time
- data_copy_concurrency
- row_purge_thread_count
- default_compress_func
- token_reserved_percentage
- memory_limit_percentage
- memory_limit
- merger_warm_up_duration_time
- memstore_limit_percentage
- enable_sys_unit_standalone
- memory_chunk_cache_size
- force_refresh_location_cache_interval
- enable_rereplication
- high_priority_net_thread_count
- server_permanent_offline_time
- datafile_size
- plan_cache_low_watermark
- backup_backup_dest_option
- zone_merge_timeout
- bf_cache_miss_count_threshold
- bf_cache_priority
- merger_completion_percentage
- PL 参考
- 动态 SQL
- 数据类型
- 什么是 PL
- 附录
- 存储过程与函数
- PL 语言基础
- PL 标签安全包
- 存储过程的 DDL 操作
- 程序包
- PL 系统包
- 集合与记录
- 游标
- 流程控制
- 异常处理
- 触发器
- 开发者指南（Oracle 模式）
- 构建可扩展的应用程序
- 连接 OceanBase 数据库
- 通过 ODC 探索 OceanBase Oracle 租户
- 通过 OBClient 连接 OceanBase 数据库租户
- 创建 OceanBase 示例数据库 TPCC
- 通过 MySQL 客户端连接 OceanBase 租户
- 查询表数据
- 通过 obclient 连接 OceanBase 租户
- 通过 ODC 连接 OceanBase 数据库
- 创建 OceanBase 示例数据库 TPCC
- 通过 obclient 连接 OceanBase 租户
- 通过 ODC 连接 OceanBase 数据库
- 通过 obclient 探索 OceanBase Oracle 租户
- 通过 obclient 探索 OceanBase MySQL 租户
- 查询表数据
- 通过 MySQL 客户端连接 MySQL 租户
- 附录
- 工作在全球化环境
- 创建和管理数据库对象
- 向 OceanBase 迁移数据
- 前言
- 关于 DML 语句和事务
暂无相关搜索结果！
本文档使用 全库网 构建
