Computers - http://phatbowling.com/sqlandstuff/all

spool all_seqs.rslt

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

break on "OWNER" on "SEQ NAME";

/* ****************************************************** */
/* */
/* Name: all_seqs.sql */
/* Purpose: will show all the sequences for a given */
/* database */
/* Creator: R.Kupcunas */
/* Date: 01-Jan-98 */
/* */
/* ****************************************************** */

select substr(sequence_owner,1,10) "OWNER",
substr(sequence_name,1,25) "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;

Sign Guestbook

View Guestbook

tomday2@mail.com

Visitors: 00006

Page Updated Wed Feb 16, 2000 1:33pm EST