CODE EXAMPLE FOR SQL

oracle current sequence value

SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name';