Oracle - SQL - Sequence - Get Current Sequence Value

SELECT id_seq.CURRVAL
FROM dual;

returns:

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

NOTE:

  • id_seq: The name of the Sequence.