spool all_seqs.rslt 

set linesize 1320;
set pagesize 1000;
set long 50;
set echo on;

break on "OWNER" on "SEQ NAME";

/* ****************************************************** */
/*                                                        */
/*  - will show all the sequences for a given database    */
/*                                                        */
/*         @c:\oracle\sql\all_seqs.sql                    */ 
/*                                                        */
/* ****************************************************** */

select 	substr(sequence_owner,1,10)             "OWNER",
        substr(sequence_name,1,30)              "SEQ NAME",
        substr(to_char(min_value),1,3)          "MIN",
	max_value				"MAX",
	increment_by				"INC",
	last_number				"LAST NUM"
from 	all_sequences 
order by 1 asc, 2 asc;

set echo off;
spool off;
set long 80;
commit;









