Altering data type for column in a table--- Oracle 8i
Team,
I need to alter one column from VARCHAR2 to number.
alter table xyz modify abc number;
By giving above statment it says i need empty that column before altering.
Can't i change the data type before empty that column.
Please advise any alternative. Give me some suggestions.
Emptying the column for me here BIG task.