list all sequences.sql
— seq_lst.sql
— mdw 03/09/02
— summary list of sequences
set pages 32
–set pause on
accept seq_name char prompt ‘enter seq name> ‘
col owner   form a10 word wrap
col seq_name form a22 word wrap
col min     form 999
col inc     form 999
col cach    form 9,999
col lst_num form 9,999,999,999
spool seq_lst.lst
select sequence_owner owner
     ,sequence_name seq_name
     ,last_number   lst_num
     ,min_value     min
     ,increment_by  inc
     ,cache_size    cach
     ,max_value     mx
from dba_sequences
where sequence_name like upper(‘&seq_name’)||’%’
and sequence_owner !=’SYS’
order by 2,1
/
spool off
clear col
—
— EOF
—
Discussion ¬