Re: Populating columns with sequential values
Why do you feel the need to do this?
If "order by order1" gets you records in the sequence you want, then why go to all the trouble of "hard-coding" that sequence into values held in order2?
If this is to store a user-specified sequence, then I'd recommend generating those sequence values the client Application and storing them along with everything else in the records.
Regards, Phill W.
Subject
Written By
Posted
Re: Populating columns with sequential values
January 31, 2023 08:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.