problem with sequences..
22428Jun 15 2004 — edited Jun 15 2004Hi All,
we dont know how its happend for sequences like currval < startwith
we have some 100s of Sequences like below..
sequence name : test1, test1.currval:15022
DDL of this is:
create sequence test1
minvalue 1
maxvalue 99999
start with 15078
increment by 1
seuence name : test2, test2.currval:23644
DDL of this is:
create sequence test2
minvalue 1
maxvalue 99999
start with 23654
increment by 1
so my problem is How to get the DDLs of a sequence from Database without opening
each and every in TOAD or PL/SQL developer.
and Also need a script(if nextval/currval<startwith)
which has to select the nextvals till it reaches(equals) start with value.
Hope problem is clear
thanks in advance
Devender