Overview
After you log on to OceanBase Developer Center (ODC), the ODC homepage automatically appears.
On the ODC homepage, you can click Task, Operating Records, or Help in the top navigation bar to go to the corresponding page. You can also perform the following operations on the page: managing database connections, switching the language, setting personal information, changing the password, and logging off from ODC. On the right side of the homepage, you can also find the Help, Related Tools, and Related Resources tabs.
Manage database connections
The ODC homepage provides the Private Connection tab that shows the connections you have created in a list.
On the Private Connection tab, you can click All Modes to filter connections to the databases in MySQL or Oracle mode. For more information, see Manage connections.
Switch the theme
You can click Theme in the upper-right corner of the ODC homepage to switch the theme mode between Default Theme and Dark Theme.
Switch the language
The display language of ODC is displayed in the upper-right corner of the ODC homepage. The default language is Simplified Chinese. You can click the language option to switch the display language. ODC supports English, Simplified Chinese, and Traditional Chinese.
Personal Settings
The logged-on username is displayed in the upper-right corner of the top navigation bar. Click the username and select Personal Settings from the drop-down list that appears. The Edit Personal Settings panel appears.
In the panel, you can globally modify the settings of the customizable features. You can also select a connection and configure these features in the connection. The configurations take effect on the current connection. The priority of personal settings is lower than that of settings you configured for each connection. In addition, the personal settings are persisted.
Your modifications to fields in the Edit Personal Settings panel take global effect.
| Field | Description |
|---|---|
| Session Mode for SQL Window | Set the session mode of the SQL window. |
| Delimiter Settings | Set the default delimiter for executing PL statements in the SQL window. Five types of delimiters are supported: semi-colons ( ; ), slashes ( / ), double slashes ( // ), dollar signs ( $ ), and double dollar signs ( $$ ). |
| Transaction Commit Mode in Oracle Mode | Set the default transaction commit mode in Oracle mode. Valid values: Manual and Automatic. |
| Transaction Commit Mode in MySQL Mode | Set the default transaction commit mode in MySQL mode. Valid values: Manual and Automatic. |
| Maximum Number of Rows in Result Set | Set the default number of rows returned for an SQL statement executed in the SQL window. |
| Type of Statements Generated by Dragging and Dropping Object | Set the default type of statements generated when you drag and drop table or view objects. |
Set an application password
You do not need to log on when you start Client ODC, because a default user is used. For security purposes, Client ODC allows you to set an application password. After you set an application password, you must enter the password when you start Client ODC. If you enter the wrong password three times, the system will prompt you to reset the data. If you reset the data, connection information saved in ODC will be cleared.
Click Account in the upper-right corner of the navigation bar on the ODC homepage. In the context menu that appears, click Set Application Password . Specify a password in the dialog box. You can delete and change the password.
Help
On the Help tab, you can view tutorial documents of some common operations in ODC, new features in the current version, and FAQ.
You can click View Help Documentation on the tab to view the help documentation.
Related tools
The Related Tools tab displays other OceanBase products. Click the tool you want to view on this tab. The introduction and link to the tool are displayed in a pop-up dialog box.
Related resources
The Related Resources tab displays resources that are operated by OceanBase or that contain OceanBase information.
The tab provides links to resources such as OceanBase Official Website , OceanBase Community , OceanBase Cloud , and OceanBase College .