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, only registered users may post in this forum.
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.