CODE EXAMPLE FOR SQL

oracle sequence last_number

SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name';