Palmi Palmi - 1 year ago 140
SQL Question

Get Increment from Sequence in Oracle

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?

Answer Source

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

select increment_by
from all_sequences
where sequence_name = 'XXX';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download