I am trying to copy data from one column to another withdifferent data types. I changed Phone_Number title toPhone_Number_Old and then created a new column named Phone_Number.Phone_Number_Old has all the phone numbers and has data type ofVARCHAR2. Phone_Number now has a data typoe as PhoneList_vartyp and(null) values. I would like to copy all of the phone numbers fromPhone_Number_Old to Phone_Number but keep the varray data type.
SET Phone_Number_old = Phone_Number; will not work because thecolumns have different data types.