Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> ALTERing a sequence's min value

ALTERing a sequence's min value

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: 2000/05/19
Message-ID: <39259717.22316359@news.alt.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US