Document Feedback

Use numerical functions in queries

Last Updated： Updated

OceanBase Cloud

Release Notes
- Release notes for 2025
- Release notes for 2024
- Release history
Product Introduction
- Overview
- Management mode and scenarios
- Core features
  - High availability with cross-cloud active-active architecture
  - High availability with cross-cloud primary-standby databases
  - Multi-level caching in shared storage
  - Multi-layer online scaling and on-demand adjustment
- Deployment modes
- Storage architecture
- Product specifications
- Product billing
  - Overview
  - Instance billing
    - Tencent Cloud instance billing
    - Alibaba Cloud instance billing
    - Huawei Cloud instance billing
    - AWS instance billing
    - GCP instance billing
  - Backup and restore billing
  - SQL audit billing
  - Migrations billing
  - Database proxy billing
  - Binlog service billing
- Supported database versions
Get Started
- Get started with a transactional instance
- Get started with an analytical instance
- Get started with a Key-Value instance
Work with Transactional Instances
- Overview
- Create an instance
  - Overview
  - Create via OceanBase Cloud official website
  - Create via AWS Marketplace
  - Create via GCP Marketplace
  - Create via Huawei Cloud Marketplace
  - Create via Alibaba Cloud Marketplace
  - Create via Azure Marketplace
- Connect to an instance
  - MySQL compatible mode
    - Overview
    - Get connection string
      - Overview
      - Connect using AWS PrivateLink
      - Connect using Google Cloud Private Service Connect
      - Connect using Huawei Cloud VPC Endpoint
      - Connect using Alibaba Cloud VPC
      - Connect using a public IP address
      - Connect using an Azure peering connection
      - Connect using a Huawei Cloud peering connection
    - Connect with clients
      - Connect to OceanBase Cloud by using Client ODC
      - Connect to OceanBase Cloud by using a MySQL client
      - Connect to OceanBase Cloud by using OBClient
    - Connect with drivers
      - Java
        Connect to OceanBase Cloud by using Spring Boot
        Connect to OceanBase Cloud by using Spring Batch
        Connect to OceanBase Cloud by using Spring JDBC
        Connect to OceanBase Cloud by using Spring Data JPA
        Connect to OceanBase Cloud by using Hibernate
        Connect to OceanBase Cloud by using MyBatis
        Connect to OceanBase Cloud using MySQL Connector/J
      - Python
        Connect to OceanBase Cloud by using mysqlclient
        Connect to OceanBase Cloud by using PyMySQL
        Connect to OceanBase Cloud using MySQL Connector/Python
      - C
        Connect to OceanBase Cloud using MySQL Connector/C
      - Go
        Connect to OceanBase Cloud using Go-SQL-Driver/MySQL
      - PHP
        Connect to OceanBase Cloud using PHP
    - Use database connection pool
      - Database connection pool configuration
      - Connect to OceanBase Cloud by using a Tomcat connection pool
      - Connect to OceanBase Cloud by using a C3P0 connection pool
      - Connect to OceanBase Cloud by using a Proxool connection pool
      - Connect to OceanBase Cloud by using a HikariCP connection pool
      - Connect to OceanBase Cloud by using a DBCP connection pool
      - Connect to OceanBase Cloud by using Commons Pool
      - Connect to OceanBase Cloud by using a Druid connection pool
  - Oracle compatible mode
    - Overview
    - Get connection string
      - Overview
      - Connect using AWS PrivateLink
      - Connect using Google Cloud Private Service Connect
      - Connect using Huawei Cloud VPC Endpoint
      - Connect using a public IP address
      - Connect using an Azure peering connection
    - Connect with clients
      - Connect to OceanBase Cloud by using OBClient
      - Connect to OceanBase Cloud by using Client ODC
    - Connect with drivers
      - Java
        Connect to OceanBase Cloud by using OceanBase Connector/J
        Connect to OceanBase Cloud by using Spring Boot
        Connect to OceanBase Cloud by using SpringBatch
        Connect to OceanBase Cloud by using Spring JDBC
        Connect to OceanBase Cloud by using Spring Data JPA
        Connect to OceanBase Cloud by using Hibernate
        Connect to OceanBase Cloud by using MyBatis
        Connect to OceanBase Cloud by using JFinal
      - C
        Connect to OceanBase Cloud by using OceanBase Connector/C
        Connect to OceanBase Cloud by using OceanBase Connector/ODBC
        Connect to OceanBase Cloud by using SqlSugar
    - Use database connection pool
      - Database connection pool configuration
      - Connect to OceanBase Cloud by using a Tomcat connection pool
      - Connect to OceanBase Cloud by using a C3P0 connection pool
      - Connect to OceanBase Cloud by using a Proxool connection pool
      - Connect to OceanBase Cloud by using a HikariCP connection pool
      - Connect to OceanBase Cloud by using a DBCP connection pool
      - Connect to OceanBase Cloud by using Commons Pool
      - Connect to OceanBase Cloud by using a Druid connection pool
- Developer guide
  - MySQL compatible mode
    - Plan database objects
      - Create a database
      - Create a table group
      - Create a table
      - Create an index
      - Create an external table
    - Write data
      - Insert data
      - Update data
      - Delete data
      - Replace data
      - Generate test data in batches
    - Read data
      - Single-table queries
      - Join tables
        INNER JOIN queries
        FULL JOIN queries
        LEFT JOIN queries
        RIGHT JOIN queries
        Subqueries
        Lateral derived tables
      - Use operators and functions in queries
        Use arithmetic operators in queries
        Use numerical functions in queries
        Use string concatenation operators in queries
        Use string functions in queries
        Use datetime functions in queries
        Use type conversion functions in queries
        Use aggregate functions in queries
        Use NULL-related functions in queries
        Use the CASE conditional operator in queries
        Use the SELECT ... FOR UPDATE statement to lock query results
        Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
      - Use a DBLink in queries
      - Set operations
    - Manage transactions
      - Overview
      - Start a transaction
      - Savepoints
        Mark a savepoint
        Roll back a transaction to a savepoint
        Release a savepoint
      - Commit a transaction
      - Roll back a transaction
  - Oracle compatible mode
    - Plan database objects
      - Create a table group
      - Create a table
      - Create an index
      - Create an external table
    - Write data
      - Insert data
      - Update data
      - Delete data
      - Replace data
      - Generate test data in batches
    - Read data
      - Single-table queries
      - Join tables
        INNER JOIN queries
        FULL JOIN queries
        LEFT JOIN queries
        RIGHT JOIN queries
        Subqueries
        Lateral derived tables
      - Use operators and functions in queries
        Use arithmetic operators in queries
        Use numerical functions in queries
        Use string concatenation operators in queries
        Use string functions in queries
        Use datetime functions in queries
        Use type conversion functions in queries
        Use aggregate functions in queries
        Use NULL-related functions in queries
        Use CASE functions in queries
        Use the SELECT ... FOR UPDATE statement to lock query results
      - Use a DBLink in queries
      - Set operations
    - Manage transactions
      - Overview
      - Start a transaction
      - Savepoints
        Mark a savepoint
        Roll back a transaction to a savepoint
      - Commit a transaction
      - Roll back a transaction
- Manage instances
  - Manage instances
    - View the instance list
    - Instance overview
    - Stop and restart instances
  - Manage tenants
    - Tenant overview
    - Create a tenant
    - Modify tenant specifications
    - Modify tenant names
    - Add an endpoint
    - Resource isolation
      - Overview
      - Manage resource groups
        Create a resource group
        View a resource group
        Edit a resource group
        Delete a resource group
      - Manage isolation rules
        Create an isolation rule
        View isolation rules
        Edit an isolation rule
        Delete a quarantine rule
    - Modify primary zone
    - Modify the maximum number of connections for a tenant proxy
    - Monitor tenant performance
      - Overview
      - View performance and SQL monitoring details
      - View transaction monitoring details
      - View storage and cache monitoring details
      - View Binlog service monitoring
      - Customize a monitoring dashboard for a tenant
    - Manage tenant parameters
      - Manage tenant parameters
      - Parameters for tenants
      - Parameter template overview
    - Delete a tenant
    - Manage databases and accounts
      - Create and manage accounts
      - Create a database (MySQL compatible mode)
      - Manage databases (MySQL compatible mode)
  - Monitor instance performance
    - Overview
    - Monitor the performance of databases in an instance
    - Monitor the performance of hosts in an instance
    - Customize a monitoring dashboard for an instance
  - Manage major compactions
    - Initiate major compactions
    - View compaction records
    - Update time for compactions
  - Manage instance parameters
    - Manage parameters
    - Parameters for cluster instances
  - Change instance configurations
    - Enable storage auto-scaling
    - View history of configuration changes
    - Change configuration
    - Switch the deployment mode
  - Manage standby instances
    - Overview
    - Create a standby instance
    - Create a cross-cloud standby instance
    - Create a standby instance for an Alibaba Cloud primary instance
    - View details of primary and standby instances
    - Configure global endpoint
    - Enable automatic forwarding for write requests of standby databases
    - Primary-standby instance switchover
    - Initiate Failover
    - Detach a standby instance
    - Release a standby instance
  - Release an instance
  - Database proxy
    - Overview
    - Manage database proxy
  - Manage alerts
    - Overview
    - Manage alert rules
      - Create an alert rule
      - View an alert rule
      - Edit an alert rule
      - Delete an alert rule
    - View alert history
    - Manage alert templates
      - Create an alert template
      - View an alert template
      - Edit an alert template
      - Copy an alert rule template
      - Delete an alert template
    - Manage muting rules
      - Create an alert muting rule
      - View an alert muting rule
      - Edit an alert muting rule
      - Delete an alert muting rule
    - Manage alert notification templates
      - Create an alert notification template
      - View an alert notification template
      - Edit an alert notification template
      - Copy an alert notification template
      - Delete an alert notification template
    - Manage alert contacts
      - Add an alert contact
      - Add an alert contact group
      - View an alert contact
      - Edit an alert contact
      - Delete an alert contact
      - Obtain a webhook URL
    - Monitoring metrics for alerts
  - Backup and restore
    - Backup overview
    - Backup strategies
    - Immediate backup
    - Data backup
    - Initiate restore
    - Data restore
    - Restore data from the instance recycle bin
  - Diagnostics
    - View performance monitoring data
    - Capacity diagnostics
    - One-click diagnostics
      - Initiate one-click diagnostics
      - View one-click diagnostic report
        Exceptions
        Real-time diagnostics
        Optimization suggestions
        Capacity management
        Security management
    - Real-time diagnostics
      - SQL diagnostics
        Top SQL
        Slow SQL
        Suspicious SQL
        High-risk SQL
        SQL details
        SQL monitoring metrics list
      - Session management
        Session management
      - Optimization management
        Manage active outlines
        View the optimization history
      - Request analysis
        Request analysis
    - Root cause diagnostics
      - Exception handling
      - Enable system autonomy
    - SQL audit
  - Manage read-only replicas
    - Overview
    - Instance read-only replicas
      - Add a read-only replica to an instance
      - View read-only replicas of an instance
      - Manage read-only replicas of an instance
      - Delete a read-only replica of an instance
    - Tenant read-only replicas
      - Add a read-only replica to a tenant
      - View read-only replicas of a tenant
      - Manage read-only replicas of a tenant
      - Delete a read-only replica of a tenant
  - Manage tags
- Data source management
  - Create a data source
  - Manage data sources
  - User privileges
  - Connect via private network
    - AWS
    - Huawei Cloud
    - Alibaba Cloud
    - Google Cloud
    - Azure
    - Private IP address segments
  - Connect via public network
    - AWS
    - Huawei Cloud
    - Alibaba Cloud
    - Google Cloud
    - Azure
- Data lifecycle management
  - Archive data
  - Clean up data
- Manage recycle Bin
  - Instance recycle bin
  - Manage databases and tables in recycle bin
    - Overview
    - Instance-level recycle bin
    - Tenant-level recycle bin
Work with Analytical Instances
- Overview
- Core features
- Connect to an instance
  - Overview
  - Get connection string
    - Overview
    - Connect using AWS PrivateLink
    - Connect using a public IP address
  - Connect with clients
    - Connect to OceanBase Cloud by using Client ODC
    - Connect to OceanBase Cloud by using a MySQL client
    - Connect to OceanBase Cloud by using OBClient
  - Connect with drivers
    - Java
      - Connect to OceanBase Cloud by using Spring Boot
      - Connect to OceanBase Cloud by using Spring Batch
      - Connect to OceanBase Cloud by using Spring Data JDBC
      - Connect to OceanBase Cloud by using Spring Data JPA
      - Connect to OceanBase Cloud by using Hibernate
      - Connect to OceanBase Cloud by using MyBatis
      - Connect to OceanBase Cloud using MySQL Connector/J
    - Python
      - Connect to OceanBase Cloud by using mysqlclient
      - Connect to OceanBase Cloud by using PyMySQL
      - Connect to OceanBase Cloud using MySQL Connector/Python
    - C
      - Connect to OceanBase Cloud using MySQL Connector/C
    - Go
      - Connect to OceanBase Cloud using Go-SQL-Driver/MySQL
    - PHP
      - Connect to OceanBase Cloud using PHP
  - Use database connection pool
    - Database connection pool configuration
    - Connect to OceanBase Cloud by using a Tomcat connection pool
    - Connect to OceanBase Cloud by using a C3P0 connection pool
    - Connect to OceanBase Cloud by using a Proxool connection pool
    - Connect to OceanBase Cloud by using a HikariCP connection pool
    - Connect to OceanBase Cloud by using a DBCP connection pool
    - Connect to OceanBase Cloud by using Commons Pool
    - Connect to OceanBase Cloud by using a Druid connection pool
- Create an instance
- Data table design
  - Table overview
  - Best practices
    - Unit 1: Best practices for optimizing storage structures and query performance
    - Unit 2: Best practices for creating special indexes
- Export data
- OceanBase data processing
- Query acceleration
  - Statistics
  - Materialized views for query acceleration
  - Select a query parallelism level
- Manage instances
  - Instance overview
  - Change configuration
  - Modify primary zone
  - Manage parameters
  - Backup and restore
    - Backup overview
    - Backup strategies
    - Immediate backup
    - Data backup
    - Initiate restore
    - Data restore
  - Monitor instance performance
    - View performance monitoring
    - Monitor the performance of databases in an instance
    - Monitor the performance of hosts in an instance
  - Manage major compactions
    - Initiate major compactions
    - View compaction records
    - Update time for compactions
  - Database proxy
    - Overview
    - Manage database proxy
  - Manage alerts
    - Overview
    - Manage alert rules
      - Create an alert rule
      - View an alert rule
      - Edit an alert rule
      - Delete an alert rule
    - View alert history
    - Manage alert templates
      - Create an alert template
      - View an alert template
      - Edit an alert template
      - Copy an alert template
      - Delete an alert template
    - Manage muting rules
      - Create an alert muting rule
      - View an alert muting rule
      - Edit an alert muting rule
      - Delete an alert muting rule
    - Manage alert notification templates
      - Create an alert notification template
      - View an alert notification template
      - Edit an alert notification template
      - Copy an alert notification template
      - Delete an alert notification template
    - Manage alert contacts
      - Add an alert contact
      - Add an alert contact group
      - View an alert contact
      - Edit an alert contact
      - Delete an alert contact
      - Obtain a webhook URL
    - Monitoring metrics for alerts
  - Diagnostics
    - View performance monitoring data
    - Capacity diagnostics
    - Real-time diagnostics
      - SQL diagnostics
        Top SQL
        Slow SQL
        Suspicious SQL
        High-risk SQL
        SQL details
        SQL monitoring metrics list
      - Session management
        Session management
      - Optimization management
        Manage active outlines
        View the optimization history
      - Request analysis
        Request analysis
  - Stop and restart instances
  - Release instances
  - Manage databases and accounts
    - Create and manage accounts
    - Create a database
    - Manage databases
  - Manage tags
- Data Development
  - Overview
  - Workspace management
  - Worksheet management
  - Compute node pool management
  - Workflow management
  - Dashboard management
  - Manage Git repositories
  - SQL development
    - SQL editing and execution
    - Result set editing
    - Execution analysis
    - Database object management
      - Create a table
      - Create a view
      - Create a function
      - Create a stored procedure
    - Session variable management
    - Git integration
  - Sample datasets
  - Data development terms
- Data lifecycle management
  - Archive data
  - Clean up data
- Performance diagnosis and tuning
  - Use the DBMS_XPLAN package for performance diagnostics
  - Use the GV$SQL_PLAN_MONITOR view for performance analysis
  - Views related to AP performance analysis
- Performance testing
- Product integration
- Manage recycle Bin
  - View instance recycle bin
  - Manage databases and tables in recycle bin
    - Overview
    - Instance recycle bin
Work with Key-Value Instances
- Try out Key-Value instances
  - Create an instance
  - Create a tenant
  - Create an account for a database user
  - OBKV HBase data operation examples
- Use Table model
  - Create an instance
  - Manage instances
    - Manage instances
      - View the instance list
      - Instance overview
      - Stop and restart instances
      - Release an instance
    - Manage tenants
      - Create a tenant
      - Modify tenant specifications
      - Modify tenant names
      - Delete a tenant
      - Tenant overview
      - Resource isolation
        Overview
        Manage resource groups
        Create a resource group
        View a resource group
        Edit a resource group
        Delete a resource group
        Manage isolation rules
        Create an isolation rule
        View isolation rules
        Edit an isolation rule
        Delete a quarantine rule
      - Monitor tenant performance
        Overview
        View performance and SQL monitoring details
        View transaction monitoring details
        View storage and cache monitoring details
        Customize a monitoring dashboard for a tenant
      - Manage tenant parameters
        Manage tenant parameters
        Parameters for tenants
      - Manage databases and accounts
        Create and manage accounts
        Create a database
        Manage databases
      - Switch primary zone
    - Monitor instance performance
      - Overview
      - Monitor the performance of databases in an instance
      - Monitor the performance of hosts in a cluster
      - Customize monitoring dashboards for an instance
    - Manage major compactions
      - Initiate major compactions
      - View compaction records
      - Update time for compactions
    - Manage instance parameters
      - Parameter management overview
      - Parameters for cluster instances
    - Change instance configurations
      - View history of configuration changes
      - Change configuration
      - Switch the deployment mode
    - Database proxy
      - Overview
      - Manage database proxy
    - Manage alerts
      - Overview
      - Manage alert rules
        Create an alert rule
        View an alert rule
        Edit an alert rule
        Delete an alert rule
      - View alert history
      - Manage alert templates
        Create an alert template
        View an alert template
        Edit an alert template
        Copy an alert template
        Delete an alert template
      - Manage muting rules
        Create an alert muting rule
        View an alert muting rule
        Edit an alert muting rule
        Delete an alert muting rule
      - Manage alert contacts
        Add an alert contact
        Add an alert contact group
        View an alert contact
        Edit an alert contact
        Delete an alert contact
        Obtain a webhook URL
      - Monitoring metrics for alerts
    - Backup and restore
      - Backup overview
      - Backup strategies
      - Immediate backup
      - Data backup
      - Initiate restore
      - Data restore
    - Diagnostics
      - View performance monitoring data
      - Top SQL
      - Capacity diagnostics
      - Request analysis
    - Manage recycle Bin
      - View instance recycle bin
      - Manage databases and tables in recycle bin
        Overview
        Instance-level recycle bin
        Tenant-level recycle bin
    - Manage tags
- Use HBase model
  - OBKV-HBase Overview
  - Create an instance
  - Develop in HBase model
    - Connect to an instance by using the OBKV-HBase client
  - Manage instances
    - Manage instances
      - View the instance list
      - Instance overview
      - Stop and restart instances
      - Release an instance
    - Manage tenants
      - Create a tenant
      - Modify tenant specifications
      - Modify tenant names
      - Delete a tenant
      - Tenant overview
      - Resource isolation
        Overview
        Manage resource groups
        Create a resource group
        View a resource group
        Edit a resource group
        Delete a resource group
        Manage isolation rules
        Create an isolation rule
        View isolation rules
        Edit an isolation rule
        Delete a quarantine rule
      - Monitor tenant performance
        Overview
        View performance and SQL monitoring details
        View transaction monitoring details
        View storage and cache monitoring details
        Customize a monitoring dashboard for a tenant
      - Manage tenant parameters
        Manage tenant parameters
        Parameters for tenants
      - Manage databases and accounts
        Create and manage accounts
        Create a database
        Manage databases
      - Switch primary zone
    - Monitor instance performance
      - Overview
      - Monitor the performance of databases in an instance
      - Monitor the performance of hosts in a cluster
      - Customize monitoring dashboards for an instance
    - Manage major compactions
      - Initiate major compactions
      - View compaction records
      - Update time for compactions
    - Manage instance parameters
      - Parameter management overview
      - Parameters for cluster instances
    - Change instance configurations
      - View history of configuration changes
      - Change configuration
      - Switch the deployment mode
    - Database proxy
      - Overview
      - Manage database proxy
    - Manage alerts
      - Overview
      - Manage alert rules
        Create an alert rule
        View an alert rule
        Edit an alert rule
        Delete an alert rule
      - View alert history
      - Manage alert templates
        Create an alert template
        View an alert template
        Edit an alert template
        Copy an alert template
        Delete an alert template
      - Manage muting rules
        Create an alert muting rule
        View an alert muting rule
        Edit an alert muting rule
        Delete an alert muting rule
      - Manage alert contacts
        Add an alert contact
        Add an alert contact group
        View an alert contact
        Edit an alert contact
        Delete an alert contact
        Obtain a webhook URL
      - Monitoring metrics for alerts
    - Backup and restore
      - Backup overview
      - Backup strategies
      - Immediate backup
      - Data backup
      - Initiate restore
      - Data restore
    - Diagnostics
      - View performance monitoring data
      - Top SQL
      - Capacity diagnostics
      - Request analysis
    - Manage recycle Bin
      - View instance recycle bin
      - Manage databases and tables in recycle bin
        Overview
        Instance-level recycle bin
        Tenant-level recycle bin
    - Manage tags
  - Performance test
- Connect Key-Value instances
  - Overview
  - Connect using a public IP address
Migrations
- Data migration and import solutions
- Data assessment and migration quick start
- Assess compatibility
  - Overview
  - Perform online assessment
  - Perform offline assessment
  - Manage compatibility assessment tasks
    - View a compatibility assessment task
    - View and download a compatibility assessment report
    - Stop a compatibility assessment task
    - Delete a compatibility assessment task
  - Obtain files for upload
  - Configure PrivateLink
  - Add an IP address to an allowlist
- Migrate data
  - Overview
  - Migrations specification
  - Purchase a data migration instance
  - Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database
  - Migrate data from a MySQL-compatible tenant of OceanBase Database to a MySQL database
  - Migrate data between OceanBase databases
  - Migrate data from an Oracle-compatible tenant of OceanBase Database to an Oracle database
  - Migrate data from OceanBase Database in Oracle compatible mode to an Oracle database
  - Configure a two-way synchronization task
  - Migrate data from an OceanBase database to a Kafka instance
  - Manage data migration tasks
    - View details of a data migration task
    - Rename a data migration task
    - View and modify migration objects
    - View and modify migration parameters
    - Configure alert monitoring
    - Start and stop a data migration task
    - Clone a data migration task
    - Terminate and release a data migration task
  - Features
    - Custom DML/DDL configurations
    - DDL synchronization scope
    - Use SQL conditions to filter data
    - Rename a migration object
    - Set an incremental synchronization timestamp
    - Instructions on schema migration
    - Configure and modify matching rules
    - Wildcard rules
    - Import migration objects
    - Download conflict data
    - Change a topic
    - Column filtering
    - Data formats
  - Authorize an Alibaba Cloud account
  - SQL statements for querying table objects
  - Online DDL tools
  - Supported DDL statements for synchronization and their limitations
    - DDL synchronization from Aurora MySQL DB clusters to MySQL-compatible tenants of OceanBase Database
    - DDL synchronization from MySQL-compatible tenants of OceanBase Database to Aurora MySQL DB clusters
    - DDL synchronization between MySQL-compatible tenants of OceanBase Database
    - DDL synchronization from Oracle databases to Oracle-compatible tenants of OceanBase Database
    - DDL synchronization from Oracle-compatible tenants of OceanBase Database to Oracle databases
    - DDL synchronization between Oracle-compatible tenants of OceanBase Database
    - DDL synchronization from OceanBase databases to Kafka instances
- Assess performance
  - Overview
  - Obtain traffic files from a database instance
  - Create a full performance assessment task
  - Create an SQL file parsing task
  - Create an SQL file replay task
  - Manage performance assessment tasks
    - View the details of a performance assessment task
    - View a performance assessment report
    - Retry and stop a performance assessment task
    - Delete a performance assessment task
  - Obtain a database instance
  - Create an access key
- Import data
  - Import data
  - Bypass import
  - Supported file formats and encoding formats for Data Import
  - Sample data introduction
- Binlog service
  - Overview
  - Purchase the Binlog service
  - Manage Binlog Service
    - View details of the Binlog service
    - Change configuration
    - Modify the auto-scaling strategy
    - Disable the Binlog service
Security
- OceanBase Cloud account settings
  - Modify login password
  - Multi-factor authentication
  - Manage AccessKeys
  - Time zone settings
  - Manage cloud marketplace accounts
  - Account audit
- Organizations and projects
  - Overview
  - Manage organization access
  - Manage projects
  - Cross-project bidirectional authorization
  - Manage members
  - Permissions for roles
  - Operation audit
- Database accounts and privileges
  - Account privileges
- Set allowlist groups
- SSL encryption
- Transparent Data Encryption (TDE)
- Authorize cloud vendor accounts
- Support access control
- Events
- KMS key management
SQL Console
- Overview
- Access SQL Console
- SQL editing and execution
- PL compilation
- Result set editing
- Execution analysis
- Database object management
  - Create a table
  - Create a view
  - Create a function
  - Create a stored procedure
  - Create a sequence
  - Create a trigger
  - Create a type
  - Create a sequence
  - Create a synonym
- Session variable management
- Functional keys in SQL Console
ODC User Guide
- What is ODC?
  - What is ODC?
  - Limitations
- Quick Start
  - Client ODC
    - Overview
    - Install Client ODC
    - Use Client ODC
  - Web ODC
    - Overview
    - Use Web ODC
- Data Source Management
  - Create a data source
  - Data sources and project collaboration
  - Database O&M
    - Session management
    - Global variable management
    - Recycle bin management
- SQL Development
  - SQL editing and execution
  - Perform PL compilation and debugging
  - Edit and export the result set of an SQL statement
  - Execution analysis
  - Generate test data
  - Database objects
    - Table objects
      - Overview
      - Create a table
    - View objects
      - Overview
      - Create a view
      - Manage views
    - Function objects
      - Overview
      - Create a function
      - Manage functions
    - Stored procedure objects
      - Overview
      - Create a stored procedure
      - Manage stored procedures
    - Sequence objects
      - Overview
      - Create a sequence
      - Manage sequences
    - Package objects
      - Overview
      - Create a program package
      - Manage program packages
    - Trigger objects
      - Overview
      - Create a trigger
      - Manage triggers
    - Type objects
      - Overview
      - Create a type
      - Manage types
    - Synonym objects
      - Overview
      - Create a synonym
      - Manage synonyms
- Import and Export
  - Import schemas and data
  - Export schemas and data
- Database Change Management
  - User Permission Management
    - Users and roles
    - Automatic authorization
  - Project collaboration management
  - Risk levels, risk identification rules, and approval processes
  - SQL check specifications
  - SQL window specification
  - Database change management
  - Batch database change management
  - Synchronize shadow tables
  - Schema comparison
- Data Lifecycle Management
  - Partitioning Plan Management
    - Manage partitioning plans
    - Set partitioning strategies
    - Examples
  - SQL plan task
- Data Desensitization and Auditing
  - Desensitize data
  - Operation records
- Notification Management
  - Overview
  - View notification records
  - Manage Notification Channel
    - Create a notification channel
    - View, edit, and delete a notification channel
    - Configure a custom channel
  - Manage notification rules
Integrations
- Overview
- Schema evolution
  - Liquibase
  - Flyway
- Data ingestion
  - Canal
  - dbt
  - Debezium
  - Flink
  - Glue
  - Informatica Cloud
  - Kafka
  - Maxwell
  - SeaTunnel
  - DataWorks
  - NiFi
- SQL development
  - DataGrip
  - DBeaver
  - Navicat
  - TablePlus
- Orchestration
  - DolphinScheduler
  - Linkis
  - Airflow
- Visualization
  - Grafana
  - Power BI
  - Quick BI
  - Superset
  - Tableau
- Observability
  - Datadog
  - Prometheus
- Database management
  - Bytebase
- AI
  - LlamaIndex
  - Dify
  - LangChain
  - Qwen
  - OpenAI
  - n8n
  - Trae
  - SpringAI
  - Cline
  - Cursor
  - Continue
  - Toolbox
  - CamelAI
  - Firecrawl
  - Hugging Face
  - Ollama
  - Google Gemini
  - Cloudflare Workers AI
  - Jina AI
  - Augment Code
  - Claude Code
  - Kiro
References
- System architecture
- System management
- Database object management
- Database design and specification constraints
- SQL reference
- System views
- Parameters and system variables
- Error codes
- Performance tuning
- Open API References
  - Overview
  - Service endpoints
  - Using API
  - Open API List
    - Cluster management
      - DescribeInstances
      - DescribeInstance
      - CreateInstance
      - DeleteInstance
      - ModifyInstanceName
      - DescribeNodeOptions
      - StopCluster
      - StartCluster
      - ModifyInstanceSpec
    - Tenant management
      - DescribeTenants
      - DescribeTenant
      - CreateTenants
      - DeleteTenants
      - ModifyTenantName
      - ModifyTenant
      - CreateConstraints
      - CreateCpuConstraints
      - CreateMemConstraints
      - ModifyCpuConstraints
      - ModifyMemConstraints
      - CreateTenantSecurityIpGroup
      - DescribeTenantSecurityIpGroups
      - ModifyTenantSecurityIpGroup
      - DeleteTenantSecurityIpGroup
      - DescribeTenantPrivateLink
      - DeletePrivatelinkConnection
      - CreatePrivatelinkService
      - ConnectPrivatelinkService
      - AddPrivatelinkServiceUser
    - Tenant user management
      - CreateTenantUser
      - DescribeTenantUsers
      - DeleteTenantUsers
      - ModifyTenantUserPassword
      - ModifyTenantUserRoles
    - Database management
      - CreateDatabase
      - DescribeDatabases
      - DeleteDatabases
    - Database proxy management
      - CreateTenantAddress
      - CreateTenantSingleTunnelSLBAddress
      - DeleteTenantAddress
      - DescribeTenantAddress
      - ModifyOdpClusterSpec
      - ModifyTenantAddressPort
      - ModifyTenantAddressDomainPrefix
      - ConfirmPrivatelinkConnection
    - Monitoring management
      - DescribeTenantMetrics
      - DescribeMetricsData
      - DescribeNodeMetrics
    - Diagnostic management
      - DescribeOasTopSQLList
      - DescribeOasAnomalySQLList
      - DescribeOasSlowSQLList
      - DescribeOasSQLText
      - DescribeSqlAudits
    - Historical event management
      - DescribeOperationEvents
- Download OBClient
  - Download OBClient
  - Download OceanBase Connector/J
  - Download client ODC
  - Download OceanBase Connector/ODBC
  - Download OBClient Libs
Billing
- View billing overview
- View the monthly bill
- View payment details
- View orders
- Use vouchers for payment
- View invoices
Relevant Agreements
- OceanBase Cloud Services Agreement
- Service Level Agreement
- OceanBase Data Processing Addendum
- OceanBase Cloud Migrations Service Level Agreement