收录日期:2019/12/09 08:24:25 时间: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.