01 2013 档案
摘要:Oracle中增加、删除、修改字段--增加字段:alter table XM_urgency add(CITY_AUDIT_STATE VARCHAR2(50)); comment on column XM_urgency.CITY_AUDIT_STATE is '政企绿色通道项目审批状态';--删除字段ALTER TABLE JN_OBJECT DROP COLUMN DISPOSE_STATE;--修改字段长度alter table JD_CONSQUESTION modify CMT_RECIPIENT VARCHAR2(500);--修改列的名称ALTER TABLE
阅读全文