I'm doing testing on a data warehouse. I have to keep resetting the sequences. I'm looking for a quicker way to do it
some like this......
DROP SEQUENCE SEQ_PAY_STG_DAY_CAL;
CREATE SEQUENCE SEQ_PAY_STG_DAY_CAL
START WITH (SELECT last_number
WHERE sequence_name = 'SEQ_DIM_CALENDAR')'
I have about 20 to do.
Any ideas? Thanks