Re: Swap IDs between two rows
I need to swap the IDs of two rows.
I am looking for a way to do this with one query right at the database level, instead of doing it on the application the long way (retrieve the two IDs, change the first to a random value temporarily, change the second ID then change back the first ID).
Subject
Written By
Posted
September 20, 2006 07:12AM
September 20, 2006 07:21AM
Re: Swap IDs between two rows
September 22, 2006 12:49AM
September 22, 2006 06:05AM
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.