Oracle添加或删除多列
添加多列：
ALTER TABLE TABLENAME
ADD
(A NUMBER ,B VARCHAR2(40) ,C DATE );
e.g:
ALTER TABLE PI_BDSURL ADD
(
PROVINCECONFIRMRESULTSTATEID VARCHAR2(20),
PROVINCECONFIRMRESULTSTATE VARCHAR2(40),
PROVINCECONFIRMATTITUDE VARCHAR2(400),
PROVINCECONFIRMER VARCHAR2(20),
PROVINCECONFIRMDATE DATE
);
删除多列：
ALTER TABLE table_name DROP {COLUMN column_names | (column_names)}
e.g:
alter table PI_BDSURL drop
(
PROVINCECONFIRMRESULTSTATEID,
PROVINCECONFIRMRESULTSTATE,
PROVINCECONFIRMATTITUDE,
PROVINCECONFIRMER,
PROVINCECONFIRMDATE
);
页:
[1]