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 All Connections tab, you can create a private connection, and search for, filter, sort, and refresh connections.
On the ODC homepage, you can click History in the left-side navigation pane to go to the session history page.
The page shows a list that has the following columns.
| Column | Description |
|---|---|
| Connection Name | The name of the connection you accessed. |
| Database/Schema Name | The name of the database or schema that you accessed by using the connection. |
| Recently Opened At | The time when you last accessed the connection. |
| SQL/PL Window | The workspace window that you created when you accessed the connection. Move the pointer to a window name, and the script that you edited in the window is displayed. |
| Actions | You can click Open to resume the connection in a new window. The corresponding workspace window and its content are also resumed. |
Note
By default, the historical records in the panel are stored for 48 hours. You can restore the content in an unsaved SQL window based on records in the panel.
Manage tasks
On the ODC homepage, you can click Task in the left-side navigation pane to create and view tasks. For more information, see Manage tasks.
Switch the theme
In the lower-left corner of the ODC homepage, choose Me > Theme to switch the theme to Default Theme or Dark Theme.
Switch the language
In the lower-left corner of the ODC logon page or ODC homepage, choose Me > Language to view the display language of ODC. 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
In the lower-left corner of the ODC homepage, choose Me > Preferences. 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.
In the lower-left corner of the ODC homepage, choose Me > Application Password. The Set Application Password dialog box appears.