sequence

[kavithared]

Hiii,friends I want to get all sequences text ,i.e source from
owner abc.
So is there any sql script to find the all sequences text in abc owner.
if any one know plsss reply.
thanks
kavitha

[julian]

What is "sequences text"? Do you need the metadata?

[kavithared]

YES, I want sql scripts of all sequences in a particular owner.
ex- create seqence seqname etc like all sequences sql script.
thanks

[julian]

I just wrote that, try it first, it might not be 100% ok:

select 'CREATE SEQUENCE '||SEQUENCE_NAME||chr(10)||
' INCREMENT BY '||INCREMENT_BY||chr(10)||
' START WITH '||LAST_NUMBER||chr(10)||
' MINVALUE '||MIN_VALUE||chr(10)||
' MAXVALUE '||MAX_VALUE||chr(10)||
decode(CYCLE_FLAG,'N',' NOCYCLE','CICLE')||chr(10)||
decode(ORDER_FLAG,'N',' NOORDER','ORDER')||chr(10)||
' CACHE '||CACHE_SIZE
from ALL_SEQUENCES
where SEQUENCE_OWNER = 'ABC' ;

[kavithared]

hii thanks