Swapping column values in Oracle?

Question

I was solving one of the puzzles and came across swapping column values using DML queries: SELECT * FROM TEMP_TABLE; ID1, ID2 -------- 20, 15 20, 15 20, 15 Solution is mathematical calculation: UPDATE TEMP_TABLE SET ID1=ID1+ID2; UPDATE TEMP_TABLE SET ID2=ID1-ID2; UPDATE TEMP_TABLE SET ID1=ID1-ID2; Now, I am trying to figure out whether this can be applied to Strings or not, please suggest. SELECT * FROM TEMP_TABLE_NEW; ID1, ID2 -------- ABC, XYZ ABC, XYZ ABC, XYZ

Answer 1

Hello,

you can do so in simpler way, for any column type

you just need one DML update statement

See below for your example

UPDATE TEMP_TABLE

SET ID1=ID2,

ID2 = ID1;

Applies for both numbers and strings

Hope this helps