Oracle-給表增加欄位和註釋

ZHOU_VIP發表於2017-04-13

alter table CAR_OIL ADD  OILCARD_NO VARCHAR2(100);

alter table CAR_OIL ADD  PAYTYPE NUMBER(2);

comment on column CAR_OIL.OILCARD_NO is '加油卡號';

comment on column CAR_OIL.PAYTYPE is '付費方式';


相關文章