All Products
Search
Document Center

:Manage sequences

更新時間:Feb 24, 2023

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.

Image 196

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

DDL

This section displays the script that defines the sequence.

Click the

Refresh

icon to refresh the parameters.

Note

Click the Edit icon to go to the PL object editing page.