Help Center/ Distributed Database Middleware/ User Guide (ME-Abu Dhabi Region)/ SQL Syntax/ Global Sequence/ Using NEXTVAL and CURRVAL to Query Global Sequence Numbers
Updated on 2022-12-08 GMT+08:00
View PDF
Share

Using NEXTVAL and CURRVAL to Query Global Sequence Numbers

  • NEXTVAL returns the next sequence number, and CURRVAL returns the current sequence number. NEXTVAL(N) returns n unique sequence numbers.
  • NEXTVAL(N) can be used only in select sequence.nextval(n) and does not support cross-schema operations.
  • CURRVAL(N) is not supported.

Procedure

  1. Connect to the required DDM instance using a client.
  2. Open the required schema.
  3. Run the following command to create a global sequence:

    create sequence seq_test;

  4. Run the following command to obtain the next sequence number:

    select seq_test.nextval;

  5. Run the following command to obtain the current sequence number:

    select seq_test.currval;

  6. Run the following command to obtain sequence numbers in batches:

    select seq_test.nextval(n);

    • Cross-schema operations are not supported when sequence numbers are obtained in batches.
    • If no global sequence is used, CURRVAL returns 0.

Parent topic: Global Sequence