Snippet Name: SEQUENCE: Find sequence MAX value
Description: Here's how to find the MAX value in a sequence.
Also see: » SEQUENCE: Demo code and Examples
» SEQUENCE: Reset a sequence to a predef...
» SEQUENCE: get sequence value into vari...
» SEQUENCE: Autonumber into two tables
» SEQUENCE: Create sequence demo
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 06th, 2009
|
-- find sequence MAX value:
SELECT seq_name.curr_val FROM dual;
-- or, get the MAX value of a sequence
-- by using the data dictionary view
SELECT MAX_VALUE FROM USER_SEQUENCES
WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE' |