不能改,只有9i可以可以使用create table吧, 如下:
create table aaa(a1, a3) as select a1, a2 from aaa_origin ; drop table aaa_origin; create table aaa_origin as select * from aaa;
create table aaa(a1, a3) as select a1, a2 from aaa_origin ; drop table aaa_origin; create table aaa_origin as select * from aaa;
这类第三方管理oracle软件,其实是 重新建立编译,
不过操作 上让你很方便,觉得就象是普通的改动。
RENAME COLUMN "ASFRAME" TO "ASFRAME1"