Manage sequences

Log in 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.

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 last_number in the sequence view. This value cannot be modified.
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.