(oracle)修改字段类型

 

oracle某个表已经有数据,有一个字段为binary_float类型,需要改成number才可以使用exp导出.

 

alter table student add test_temp number;

update student set test_temp=test,test=null;
commit;
alter table student modify test number;
update student set test=test_temp,test_temp=null;
commit;
alter table student drop column test_temp;
select * from student;