How change Column Data Type from Number to Varchar 2 with out deleting data
I landed into a funny problem. One of my table DEPARTMENTS as dep_id as number, recentny my organization started to use characters for department ids. Could you tell me is there any way i can change the data type to character with out emptying the column.
add (dep_id_chr varchar2(30));
rename column dep_id_chr to dep_id;
you'd probably have to drop any indexes on dep_id and rebuild them afterwards, and you'd have to revalidate any views, pl/sql etc referencing the table.