Oracle添加或删除多列

yanghaiskys

  
添加多列：
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)}   [CASCADE   CONSTRAINS]    
e.g:
alter table PI_BDSURL drop
(
  PROVINCECONFIRMRESULTSTATEID,
  PROVINCECONFIRMRESULTSTATE,
  PROVINCECONFIRMATTITUDE,
  PROVINCECONFIRMER,
  PROVINCECONFIRMDATE
);