lwk@caen.engin.umich.edu (Woody Kellum) (08/04/90)
I have an application in Oracle that requires records to have a sequence
number associated them. I want to be able to insert new records and move
old records around within the sequence, and then re-number the records
periodically, keeping the same order, so that the sequence numbers don't
get to hairy. I want something like:
UPDATE ORDERD_TABLE SET ORDERNO = MY_$SEQ.NEXTVAL ORDER BY ORDERNO;
The above is not a valid Oracle sql statement. There must be a way to do
this, but I haven't thought of it yet. Any ideas?
Woody Kellum (lwk@caen.engin.umich.edu)
--
Woody Kellum Internet: lwk@caen.engin.umich.edu
lwk@caen.engin.umich.edu (Woody Kellum) (08/04/90)
I have an application in Oracle that requires records to have a sequence
number associated them. I want to be able to insert new records and move
old records around within the sequence, and then re-number the records
periodically, keeping the same order, so that the sequence numbers don't
get to hairy. I want something like:
UPDATE ORDERD_TABLE SET ORDERNO = MY_$SEQ.NEXTVAL ORDER BY ORDERNO;
The above is not a valid Oracle sql statement. There must be a way to do
this, but I haven't thought of it yet. Any ideas?
Woody Kellum (lwk@caen.engin.umich.edu)
--
Woody Kellum Internet: lwk@caen.engin.umich.edu