User Tools

Site Tools


oracle:sql:sequence:get_current_sequence_value

Oracle - SQL - Sequence - Get Current Sequence Value

SELECT id_seq.CURRVAL
FROM dual;

returns:

    CURRVAL
----------
        10        

NOTE:

  • id_seq: The name of the Sequence.
oracle/sql/sequence/get_current_sequence_value.txt · Last modified: 2021/08/11 11:05 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki