SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Modify Data Type from Number to Varchar2

Sudhir_MeruApr 4 2013 — edited Apr 4 2013

Hi,

We have a production applications running. There is a column called home_number which has datatype called number, Now the new requirement is to change to varchar2.

I tried to alter the table getting the below error.

-- alter table "TECH_SOURCING_EMPLOYEE_DETAILS" modify
--("HOME_PH_NUMBER" VARCHAR2(1000))
-- /

-- ORA-01439: column to be modified must be empty to change datatype

Please suggest me how to modify the column data type without affecting the data.

Thanks
Sudhir

This post has been answered by user503635 on Apr 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2013

Added on Apr 4 2013

4 comments

9,432 views