ALTER TABLE my_table RENAME COLUMN my_column TO new_column_name;
修改列名: ALTER table my_table RENAME COLUMN my_column TO new_column_name;修改列: alter table my_table modify mu_column varchar2(20);删除列:alter table my_table drop column my_column;增加列:alter table my_table add my_column varchar2(10);
楼主ORACLE什么版本 上面的语句是可以的 看下面的例子 SQL> select * from t2; ID IP ---------- ---------- 7 3 9 5SQL> alter table t2 rename column id to idd;Table altered.SQL> select * from t2; IDD IP ---------- ---------- 7 3 9 5
SQL> select * from tb1;SNO ----- o001 o002 o003 o004SQL> alter table tb1 rename column sno to snoo; alter table tb1 rename column sno to snoo * ERROR 位于第 1 行: ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失
ALTER table my_table RENAME COLUMN my_column TO new_column_name;修改列:
alter table my_table modify mu_column varchar2(20);删除列:alter table my_table drop column my_column;增加列:alter table my_table add my_column varchar2(10);
上面的语句是可以的
看下面的例子
SQL> select * from t2; ID IP
---------- ----------
7 3
9 5SQL> alter table t2 rename column id to idd;Table altered.SQL> select * from t2; IDD IP
---------- ----------
7 3
9 5
SQL> select * from tb1;SNO
-----
o001
o002
o003
o004SQL> alter table tb1 rename column sno to snoo;
alter table tb1 rename column sno to snoo
*
ERROR 位于第 1 行:
ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失