Oracle - SQL - Sequence - Get Current Sequence Value
SELECT
id_seq
.
CURRVAL
FROM
dual;
returns:
CURRVAL
----------
10
NOTE:
id_seq
: The name of the Sequence.