收录日期:2020/07/07 01:43:33 时间:2010-10-28 14:39:38 标签:oracle10g

I have around 100,000 records 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.