Get Increment from Sequence in Oracle

Question

In a SQL database I can get the increment value of a sequence:

select increment from sys.sequences where name = 'XXX';

Is there a way to do this for a sequence in an Oracle database?

Jeffrey Kemp · Accepted Answer · 2016-07-15 07:17:46Z

6

The corresponding table in Oracle is all_sequences (see here):

select increment_by
from all_sequences
where sequence_name = 'XXX'
and sequence_owner = 'SCHEMANAME';

Jeffrey Kemp

60.5k15 gold badges111 silver badges161 bronze badges

answered Jul 7, 2016 at 15:18

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TenG · Accepted Answer · 2016-07-07 15:21:19Z

3

select increment_by from user_sequences where sequence_name = 'XXX'

Depending on what user you login as and which schema the sequence is in, you might need to query dba_sequences or all_sequences instead.

answered Jul 7, 2016 at 15:21

TenG

4,0343 gold badges27 silver badges50 bronze badges