1、新建一张表,表名为tableName;
create table tableName (
id VARCHAR2(64) not null,
columnName VARCHAR2(64),
constraint PK_TABLENAME primary key (id)
);
2、新增tableName一个列名columnName2;
ALTER TABLE tableName ADD columnName2 VARCHAR2(64);
3、修改列名columnName2为columnName3;
select * from tableName;
create table ut as select id,columnName,columnName2 columnName3 from tableName;
select * from ut;
drop table tableName;
rename ut to tableName;