How to list all the sequence in schema with size?


All the oracle sequences are stored in a table called "dba_sequences".

The following query selects the min, max ,current value along with the length current value and orders it by the length in desc.

select SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

where SEQUENCE_OWNER='schema owner'

order by length(LAST_NUMBER)desc;

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Back to top