Oracle Sequences - How to know next number in the sequence

To get the details about a sequence in Oracle, the table is user_sequences. We can query this table to get the next number in the sequence.

SELECT last_number FROM user_sequences
WHERE sequence_name = 'SEQUENCE NAME';

last_number column holds the next number in the sequence. The sequence name is the sequence for which you want to know the next number.

Note : The sequence number in the above query must be in upper case.

You can get more information like minimum/maximum value, cache size etc from user_sequences table.

SQL> desc user_sequences;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SEQUENCE_NAME                             NOT NULL VARCHAR2(30)
 MIN_VALUE                                          NUMBER
 MAX_VALUE                                          NUMBER
 INCREMENT_BY                              NOT NULL NUMBER
 CYCLE_FLAG                                         VARCHAR2(1)
 ORDER_FLAG                                         VARCHAR2(1)
 CACHE_SIZE                                NOT NULL NUMBER
 LAST_NUMBER                               NOT NULL NUMBER