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.