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?

Answer 1

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

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