OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Developer Center

V4.1.0Community Edition

  • Document Overview
  • What's New
    • What's new
  • Overview
    • What is ODC?
    • Benefits
    • Architecture
    • Features
    • Limits
  • Quick Start
    • Overview
    • Install ODC
    • Log on to ODC with an account
    • Create a private connection
  • Tutorials
    • Tips on the SQL Console
    • Create a connection
    • Export data
    • Import data
    • Debug a stored procedure
    • View the performance of an SQL statement
  • User Guide (Web ODC)
    • ODC homepage
    • Recycle bin
    • View operation records
    • Session management
    • Help center
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Database change tasks
      • Permission application tasks
      • SQL plan task
      • Shadow table synchronization tasks
      • Partitioning plan task
    • Use the workspace
      • Overview
      • SQL window
      • Anonymous block window
      • Command-line window
      • Stored scripts
      • Snippet
    • Public resource management
      • Overview
      • Quick start
      • Task process management
      • Manage operation records
      • Data desensitization management
      • System settings
      • Resource permissions
        • Manage public connections
        • Manage resource groups
        • Manage roles
        • Manage users
        • Automatic authorization rules
    • Database objects
      • View objects
        • Overview
        • Create a view
        • Manage views
      • Table objects
        • Create a table
        • Create a table
        • Table list
        • Manage table attributes
        • Manage table data
      • Trigger objects
        • Overview
        • Manage triggers
        • Create a trigger
      • Sequence objects
        • Overview
        • Manage sequences
        • Create a sequence
      • Package objects
        • Overview
        • Manage program packages
        • Create a program package
      • Synonym objects
        • Overview
        • Create a synonym
        • Manage synonyms
      • Function objects
        • Overview
        • Create a function
        • Manage functions
      • Type objects
        • Overview
        • Create a type
        • Manage types
      • Stored procedure objects
        • Overview
        • Create a stored procedure
        • Manage stored procedures
    • Connect to a database
      • Manage private connections
      • Create a private connection
    • Log on to ODC
      • Log on to ODC with an account
      • Change the password
    • Use tools
      • Data mocking
      • Partitioning plan
      • Database changes
      • SQL plan
      • Shadow table synchronization
      • Data export and import
        • Overview
        • Export and import formats
        • Batch export and import
        • Single table export and import
  • User Guide (Client ODC)
    • Install ODC
    • ODC homepage
    • Recycle bin
    • View operation records
    • Session management
    • Help center
    • Use tools
      • Data mocking
      • Asynchronous execution
      • Shadow table synchronization
      • Data export and import
        • Overview
        • Export and import formats
        • Batch export and import
        • Single table export and import
    • Database objects
      • Package objects
        • Create a program package
        • Manage program packages
        • Overview
      • Stored procedure objects
        • Overview
        • Create a stored procedure
        • Manage stored procedures
      • View objects
        • Overview
        • Create a view
        • Manage views
      • Table objects
        • Overview
        • Create a table
        • Table list
        • Manage table attributes
        • Manage table data
      • Type objects
        • Overview
        • Create a type
        • Manage types
      • Sequence objects
        • Overview
        • Create a sequence
        • Manage sequences
      • Function objects
        • Overview
        • Create a function
        • Manage functions
      • Synonym objects
        • Overview
        • Create a synonym
        • Manage synonyms
      • Trigger objects
        • Overview
        • Create a trigger
        • Manage triggers
    • Task management
      • Overview
      • Import tasks
      • Export tasks
      • Data mocking tasks
      • Database Change
      • Shadow table synchronization tasks
    • Use the workspace
      • Overview
      • SQL window
      • Anonymous block window
      • Command-line window
      • Stored scripts
      • Snippet
    • Connect to a database
      • Create a private connection
      • Manage connections
  • Deployment Guide
    • Deployment overview
    • Preparations before deployment
    • Deployment verification
    • Deploy ODC in high availability mode
      • Deployment process
      • Load and run an ODC image
      • Deploy SSL certificate
      • Deploy the NGINX proxy
      • Configure certificate trust
    • Deploy a single ODC node
      • Deployment process
      • Load and run an ODC image
  • Upgrade Guide
    • Overview
    • Preparations before upgrade
    • Upgrade verification
    • Rollback after upgrade failed
    • Upgrade single-node ODC
      • Upgrade process
      • Stop ODC of the earlier version
      • Load and run an ODC image
    • Upgrade high-availability
      • Upgrade process
      • Stop ODC of the earlier version
      • Load and run an ODC image
      • Upgrade NGINX image
  • FAQ

Download PDF

Document Overview What's newWhat is ODC? Benefits Architecture Features Limits Overview Install ODC Log on to ODC with an account Create a private connection Tips on the SQL Console Create a connection Export data Import data Debug a stored procedure View the performance of an SQL statement ODC homepageRecycle bin View operation records Session management Help center Overview Import tasks Export tasks Data mocking tasks Database change tasks Permission application tasks SQL plan task Shadow table synchronization tasks Partitioning plan taskOverview SQL windowAnonymous block window Command-line window Stored scripts Snippet Overview Quick start Task process managementManage operation records Data desensitization managementSystem settings Manage private connections Create a private connection Log on to ODC with an account Change the password Data mocking Partitioning planDatabase changes SQL plan Shadow table synchronizationInstall ODC ODC homepage Recycle bin View operation records Session management Help center Data mocking Asynchronous execution Shadow table synchronizationOverview Import tasks Export tasks Data mocking tasks Database Change Shadow table synchronization tasksOverview SQL windowAnonymous block window Command-line window Stored scripts Snippet Create a private connection Manage connections Deployment overview Preparations before deployment Deployment verificationDeployment process Load and run an ODC image Deploy SSL certificate Deploy the NGINX proxy Configure certificate trust Deployment process Load and run an ODC image Overview Preparations before upgrade Upgrade verification Rollback after upgrade failed Upgrade process Stop ODC of the earlier version Load and run an ODC image Upgrade process Stop ODC of the earlier version Load and run an ODC image Upgrade NGINX image FAQ
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogWhite PaperLive DemosTraining & CertificationTicket
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Developer Center
  3. V4.1.0
iconOceanBase Developer Center
V 4.1.0Community Edition
Databases
  • OceanBase Database
  • OceanBase Cloud
  • OceanBase Tugraph
  • Interactive Tutorials
  • OceanBase Best Practices
Tools
  • OceanBase Cloud Platform
  • OceanBase Migration Service
  • OceanBase Developer Center
  • OceanBase Migration Assessment
  • OceanBase Admin Tool
  • OceanBase Loader and Dumper
  • OceanBase Deployer
  • Kubernetes operator for OceanBase
  • OceanBase Diagnostic Tool
  • OceanBase Binlog Service
Connectors and Middleware
  • OceanBase Database Proxy
  • Embedded SQL in C for OceanBase
  • OceanBase Call Interface
  • OceanBase Connector/C
  • OceanBase Connector/J
  • OceanBase Connector/ODBC
  • OceanBase Connector/NET
  • V 4.4.3
  • V 4.4.2
  • V 4.4.1
  • V 4.4.0
  • V 4.3.4
  • V 4.3.3
  • V 4.3.2
  • V 4.3.1
  • V 4.3.0
  • V 4.2.4
  • V 4.2.3
  • V 4.2.2
  • V 4.2.1
  • V 4.2.0
  • V 4.1.3 and earlier
Community Edition
  • V 4.1.0
  • V 4.0.0
  • V 3.3.2
  • V 3.2.2
Enterprise Edition
  • V 4.1.3
  • V 3.4.0

Overview

Last Updated:2026-04-13 06:45:38  Updated
Share
What is on this page
Share

The workspace is the main feature module for you to develop databases in OceanBase Developer Center (ODC).

After you enter the corresponding database connection, you can click Workspace in the navigation bar on the top of the page. The drop-down list provides the following features:

  • SQL Window : An SQL window is a working area for database developers to edit SQL and PL statements. ODC also provides the Snippets button in the SQL window.

  • Anonymous Block Window : An anonymous block window is a working area for database developers to edit anonymous block scripts. (The anonymous block window is available only in Oracle mode. )

  • Command-line Window : OceanBase command-line web OBweb is integrated in the form of a command-line window. It allows you to execute SQL or PL statements and view the execution results in real time.

  • Stored Scripts : Database developers can open scripts previously stored in ODC.

  • Snippets : View and reference built-in and custom code snippets

Note
Creating anonymous block windows is only supported in Oracle mode.

This chapter describes these features in different topics.

  • SQL window

  • Anonymous block window

  • Command-line window

  • Stored scripts

  • Code snippets

Previous topic

System settings
Last

Next topic

SQL window
Next