Move values from one column to other in Oracle table
I have around 100,000 re开发者_Go百科cords in my Oracle table.
TableMaster
-----------
TabID
Column1
Column2
How do I update all the records so that Column1 values are moved to Column2, and Column2 values are moved to column1?
Would this work?
UPDATE TableMaster SET Column1 = Column2, Column2 = Column1
Modify the table, changing the column names.
精彩评论