Log on to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click Type in the left-side navigation pane to get a list of types The type list displays the type objects in the current database. You can right-click the target object in the type list to perform some management actions on the object. You can also double-click the target type in the type list to go to the type management page.
Structure tree
You can click the expand icon before the name of the target type in the type list, and the structure tree of the type is displayed in a drop-down list, as shown in the following figure. The structure tree of a type can have up to five levels. When you right-click an item in the tree, the shortcut menu displays some actions that you can perform on the item. For more information about these actions, see the Management actions section, where you can find the table describing the management options.
Management actions
The names of type objects support ascending order by the head character by default in the type list.
Shortcut function
The following functions are provided in the upper right corner of the tree:
Action |
Description |
|---|---|
| Create | Click this option to create type. |
| Filter | Click this option to display valid/invalid types. |
| Refresh | Click this option to refresh the structure tree after you perform management actions on the type, so that the structure tree displays the latest information. |
Right-click function
Right-click the target object in the structure tree. A shortcut menu appears, displaying some management options provided by ODC for you to conveniently manage the target object.
The following table describes the management options.
Option |
Description |
|---|---|
| View Type | Click this option to go to the type management page, where you can view the basic information and codes of the type. |
| Create Type | Click this option to go to the Create Type page, where you can create a type as prompted. |
| Download | Download the SQL file for the type object. |
| Delete | Click this option to delete the type. |
| Refresh | Click this option to refresh the list after you perform management actions on the type, so that the list displays the latest information. |
Type management page
You can double-click the name of the target type in the type list to go to the type management page. This page provides two tabs:
Basic Info : displays information such as Name , Owner , Type , Creation Time , and Modified At of the type object.
DDL : displays the script that defines the type and provides the Edit , Find , and Refresh buttons. You can click Edit to go to the type editing page.
Type editing page
You can right-click the target type in the type list and then click Edit in the shortcut menu to go to the type editing page. You can also click Edit on the DDL tab of the type management page to go to the type editing page. The code area of the editing page displays definition statements of the type. You can continue to edit the statements. In addition, the toolbar provides the following buttons:
Button |
Description |
|---|---|
| Format | Click this button to apply formatting, such as indentation, line break, and keyword highlighting, to the selected SQL statements or all the SQL statements in the current SQL window. |
| Find and Replace | You can specify search criteria in the search box to find specific content in the script and enter other content in the replacement box to replace the content found. |
| Undo | Click this button to undo the last operation. |
| Redo | Click this button to reverse an Undo operation. |
| Case Sensitivity | The system supports three configurations: All Caps , All Lowercase , and Capitalize the first letter . Click this button to convert the selected statements in the script to the corresponding capitalization format. |
| Indent | The Add Indents and Delete Indent options are provided, to allow you to add indents to or delete indents from the selected statements in the script. |
| Comment | The Add Comments and Delete Comment options are provided, which respectively allow you to convert the selected statements in the script to comments and convert comments to SQL statements. |
| Confirm modification | Click this button to apply the current modification. |