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 To create a type, click + in the upper-right corner of the type list or click Create in the navigation bar on the top of the page.
Click Create . In the Create Type dialog box, specify the following information.
Type Name : specifies the name of the new object.
Type : specifies whether the new type object is Object Type , Array Type , or Table Type .
After you specify the preceding information, click Next: Verify SQL Statement to go to the statement compilation page. This page displays the corresponding type definition statements generated based on the information you specified in the Create Type dialog box. You need to complete the statements based on your needs. After you complete the statements, click Create to complete the type creation.
In addition, the toolbar on the editing page 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. |