Updating the column2 data with Column1 data in oracle


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.
Who is Participating?
update yourtable set column2=column1 ,column1=2

if you meant column2 instead of value 2

update yourtable set column2=column1 ,column1=column2
praveen1981Author Commented:
Thanks, it solved the problem
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.