Log in to the OceanBase Developer Center (ODC) and click the name of the Oracle mode connection that you want to manage. You can click Sequence in the left-side navigation pane to get a list of sequences. In the upper-right corner of the sequence list, you can click + to create a sequence, or you can choose Create > Sequence in the top navigation bar to create the required objects. Creating a sequence includes the following two steps:
Set Basic Info : You need to specify Sequence Name and User. The User parameter is automatically specified based on the current account.
Set columns (optional). You need to specify the following parameters to set columns:
ParameterDescriptionFrom Specifies the initial value of the sequence, which must not be less than the value of Minimum Value. Increment Specifies the step size for the auto-increment of sequence values. The value can be a negative number. Minimum Value Specifies the minimum value that can be obtained by the sequence. The minimum value supported by the database is -10^26. Maximum Value Specifies the maximum value that can be obtained by the sequence. The maximum value supported by the database is 10^27. Cache Settings Specifies the cache size for the sequence. A proper cache size can improve the performance in obtaining sequence values. You can also set the value to No Cache. Whether to Sort Specifies whether the sequence obtains values in an ordered manner. The performance of the sequence in obtaining values in an ordered manner is inferior to that in an unordered manner. Cyclic or Not Specifies whether to start from the minimum value again when the sequence value reaches the maximum value. Click Next: Verify SQL Statement to go to the Create Sequence page.
An SQL script is pre-generated based on the information you specified. After the SQL script is verified, click Create in the upper-right corner to run the script and generate a sequence.