oracle:sql:sequence:get_next_sequence_value

Oracle - SQL - Sequence - Get Next Sequence Value

SELECT id_seq.NEXTVAL 
FROM dual;

returns:

    NEXTVAL
----------
        10

NOTE:

id_seq: The name of the Sequence.

oracle/sql/sequence/get_next_sequence_value.txt · Last modified: 2021/08/11 12:04 by peter