jimmythegeek
Programmer
I want to be able to update the last value in a sequence to the maximum value from a table. If it were a table, I would use this:
Update table1 set lastvalue = (Select Max(ID) from table2)
However my book says to use Alter Sequence, so I tried this:
alter sequence test_seq minvalue (Select Max(ID) from table2)
That doesn't work either. Any help is greatly appreciated.
Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?
Update table1 set lastvalue = (Select Max(ID) from table2)
However my book says to use Alter Sequence, so I tried this:
alter sequence test_seq minvalue (Select Max(ID) from table2)
That doesn't work either. Any help is greatly appreciated.
Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?