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博客 ” ，链接：https://blog.itpub.net/188692/viewspace-907109/ ，如需转载，请注明出处，否则将追究法律责任。
