增加列：ALTER TABLE HERB_ORDER_DETAIL ADD MEDICAL_INSURANCE_TYPE VARCHAR2(10);COMMENT ON COLUMN HERB_ORDER_DETAIL.MEDICAL_INSURANCE_TYPE IS ‘医保类型‘;
调整字段长度：ALTER TABLE DOCTOR_ORDERS MODIFY MEMO VARCHAR2(4000);
原文：http://www.cnblogs.com/ms-grf/p/7943923.html