I want to copy/migrate data within the same table
For one of the columns, the only thing is that the column name is being updated. so basically I want to migrate everything under USERID col to USERNAME col
While for the other column, the data is migrated based on a mapping as below
WHEN OLD_COL = 'Data 1' THEN 'DATA1'
WHEN OLD_COL = 'Data 2' THEN 'DATA2'
Apart from the above 2 things, rest of the columns data should stay as it is
Can I run a single migration script to achieve the above ?