1:添加字段并加上注释
ALTER TABLE T_GFGL_WXFWJHZYLD_BA ADD (SHYJ VARCHAR2(1500));
COMMENT ON COLUMN T_GFGL_WXFWJHZYLD_BA.SHYJ IS ‘审核意见‘;
2:删除一列:
ALTER TABLE T_GFGL_JYXKXXB DROP COLUMN HDGMSYL1Oracle 常用sql,布布扣,bubuko.com
Oracle 常用sql
原文:http://blog.csdn.net/chx10051413/article/details/20791813