Palmi Palmi - 4 months ago 15
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

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

select increment_by
from all_sequences
where sequence_name = 'XXX';
Comments