RSA Scripts

Get sequances info by owner

select d.SEQUENCE_NAME, d.MIN_VALUE, d.MAX_VALUE, d.INCREMENT_BY, d.LAST_NUMBER, d.CACHE_SIZE from DBA_SEQUENCES d where d.SEQUENCE_OWNER = [OWNER] order by d.SEQUENCE_NAME

  1. Oracle
  2. Sequance
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

select d.SEQUENCE_NAME, d.MIN_VALUE, d.MAX_VALUE, d.INCREMENT_BY, d.LAST_NUMBER, d.CACHE_SIZE
  from DBA_SEQUENCES d
 where d.SEQUENCE_OWNER = [OWNER]
 order by d.SEQUENCE_NAME