
CHADI E. answered 07/19/19
Tutor
New to Wyzant
PhD in Systems Engineering with 8+ years expereince in Oracle SQL
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