Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> ALTERing a sequence's min value
I have a sequence for a table coupled with a trigger to automatically number the table. However, I am importing data first. Therefore I want to alter the trigger (or just create it then) with a minimum value of the maximum value in the table.
Something like:
ALTER SEQUENCE MySequence MINVALUE (SELECT MAX(Id) FROM MyTable)
Is there a way to do that? Received on Fri May 19 2000 - 00:00:00 CDT