A sequence is a series of numbers in a database that increments according to a defined rule. Because the values never repeat, sequences are often used as primary keys or unique keys for tables.
Sequence objects can be created in the Oracle mode of OceanBase Database V2.1.0 and later. This feature is not currently supported in MySQL mode.
In OceanBase Developer Center (ODC), click a connection name to open a connection in Oracle mode. Click the Sequences tab in the navigation pane on the left to view the list of sequences. In the list, double-click a sequence name to open its management page. This page displays the sequence's basic information, parameters, and Data Definition Language (DDL).
This chapter describes the following operations for sequence objects in ODC: