Question: how to transfer data from one column to another column in oracle?
Answer: If it is a column for the same row that you want updated, the syntax is simpler: Update Table A Set Column1 = Column2. ... 
The following example demonstrates how you can do it: ... 
UPDATE TABLE SET COLUMN 1= COLUMN2; ... 
Jack. ... 
This is right if you are getting it from another table. ... 
Hi,