摘要: 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 阅读全文
posted @ 2013-01-22 10:58 Mr zhao 阅读(289) 评论(0) 推荐(0) 编辑