SQL> desc test
Name Type Nullable Default Comments
---- ---- -------- ------- --------
A DATE Y
SQL> alter table test modify(a number);
alter table test modify(a number)
ORA-01439: 要更改数据类型, 则要修改的列必须为空
SQL> alter table test add(b number);
Table altered
SQL> alter table test rename column a to c;
Table altered
SQL> desc test
Name Type Nullable Default Comments
---- ------ -------- ------- --------
C DATE Y
B NUMBER Y
SQL> alter table test rename column b to a;
Table altered
SQL> alter table test drop column c;
Table altered
SQL> desc test
Name Type Nullable Default Comments
---- ------ -------- ------- --------
A NUMBER Y
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/188692/viewspace-907109/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/188692/viewspace-907109/