We help IT Professionals succeed at work.

Updating the column2 data with Column1 data in oracle

Hi

I want to update the column2 data with column1 data and Column1 data with value 2 in oracle.

can you please provide me the Optimised query for this.
Comment
Watch Question

Most Valuable Expert 2011
Top Expert 2012
Commented:
update yourtable set column2=column1 ,column1=2

if you meant column2 instead of value 2

update yourtable set column2=column1 ,column1=column2

Author

Commented:
Thanks, it solved the problem