create table main (re varchar2(10),purpose varchar2(10));insert into main values('re','purpose'); insert into main values('re','purpose'); commit; select * from main REMARK PURPOSE ---------- ---------- re purpose re purpose alter table main rename column re to tmp; alter table main rename column purpose to re; alter table main rename column tmp to purpose;select * from main PURPOSE REMARK ---------- ---------- re purpose re purpose
alter table main rename column purpose to re;
alter table main rename column tmp to purpose;
as
select purpose,re
from t;drop table t;
rename m to t;
alter table main rename column re to tmp;
没有任何反应,alter操作是否需要DBA权限
alter table tablename rename column oldname to newname ;
http://topic.csdn.net/t/20030624/11/1950544.html
insert into main values('re','purpose');
commit;
select * from main
REMARK PURPOSE
---------- ----------
re purpose
re purpose alter table main rename column re to tmp;
alter table main rename column purpose to re;
alter table main rename column tmp to purpose;select * from main
PURPOSE REMARK
---------- ----------
re purpose
re purpose