ALTER TABLE
hi,
i am trying to modify the datatype but i couldn't.i know we can't modify the datatype if the column contain values(unless it contain null values).but itz the situation arises for me to modify it without dropping the column.is it possible?actually i hav datatype LONG(1000) i want to convert it to VARCHAR2(1000).how come it possible any idea? (i dont want to drop that column and add the column)
SQL> ALTER TABLE T_COURSECATALOG MODIFY (SCODESC VARCHAR2(1000));
ALTER TABLE T_COURSECATALOG MODIFY (SCODESC VARCHAR2(1000))
*
ERROR at line 1:
ORA-01439: column to be modified must be empty to change datatype
ur idea's are greatly welcome........
With Regards
Boo