Get Oracle Sequence Current Value

1 year ago
Olivia Parker
1 minute

To check the current value of an Oracle sequence, you can use the following query:

SELECT last_number
FROM user_sequences
WHERE sequence_name = 'YOUR_SEQUENCE_NAME';

In this query statement, replace YOUR_SEQUENCE_NAME with the name of the sequence you want to query. The query will return the current value of that sequence.

bannerAds