oracle删除添加多列

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)}   [CASCADE   CONSTRAINS]    

e.g:
alter table PI_BDSURL drop
(
  PROVINCECONFIRMRESULTSTATEID,
  PROVINCECONFIRMRESULTSTATE,
  PROVINCECONFIRMATTITUDE,
  PROVINCECONFIRMER,
  PROVINCECONFIRMDATE
);