如何在不增加的情況下檢索 Oracle 序列的目前值？

SELECT last_number
  FROM all_sequences
 WHERE sequence_owner = '<sequence owner>'
   AND sequence_name = '<sequence_name>';

SELECT last_number
  FROM user_sequences
 WHERE sequence_name = 'SEQ';

-- Set the sequence to decrement by the same as its original increment
ALTER SEQUENCE seq INCREMENT BY -1;

-- Retrieve the sequence value
SELECT seq.nextval FROM dual;

-- Reset the sequence to its original increment
ALTER SEQUENCE seq INCREMENT BY 1;