create table test(
id VARCHAR2(64) ,
name VARCHAR2(100),
sex char(1)
)
ALTER table test add sex char(1);
ALTER table test add (address varchar2(1000),phone varchar2(11));
ALTER table test modify sex char(10);
alter table test drop COLUMN sex;
alter table test add constraint pk_id primary key(id);
alter table test rename to test1;