Log on to OceanBase Developer Center (ODC) and click the name of the target connection in Oracle mode to go to the corresponding connection management page. You can click Sequence in the left-side navigation pane to get a list of sequences.
You can right-click the target object in the sequence list to perform some Management actions on the object. You can also double-click the target sequence in the sequence list to go to the sequence Management page.
Management actions
The names of sequence objects support ascending example by head character by default in the sequence list.
Right-click the target object in the sequence list. 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.
Action | Description |
Create Sequence | Click this option to go to the Create Sequence page, where you can create a sequence as prompted. |
View Sequence | Click this option to go to the sequence management page , where you can view comprehensive information such as the basic information, attributes, and DDL statements of the sequence. |
Modify | Click this option to go to the Attribute tab of the sequence management page to modify the information of the sequence. |
Delete | Click this option to delete the sequence. |
Export | Export single table, see Single table export and import. |
Download | Download the SQL file for the sequence object. |
Refresh | Click this option to refresh the list after you perform management actions on the sequence, so that the list displays the latest information. |
Sequence management page
You can view the following information on the Sequence Management page.
Section | Description |
Basic Information | This tab displays the basic information of a sequence in fields such as the Sequence Name and Owner. It also provides the Edit and Refresh icons.You can click Edit to modify the value of the following fields: Increment, Minimum Value, Maximum Value, Cache Settings, Whether to Sort, and Cyclic or Not.Next Buffer Value is the value of |
DDL | This section displays the script that defines the sequence. Click the  icon to refresh the parameters. Note Click the Edit icon to go to the PL object editing page. |