Trying Copy Data One Column Another Different Data Types Changed Phonenumber Title Phonenu Q30611544

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.

"We Offer Paper Writing Services on all Disciplines, Make an Order Now and we will be Glad to Help"
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.