表管理操作

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;