违反唯一约束的问题:索引的值应该大于表的最大值(左边的值大于右边的)
表示UPDATE_CODE是唯一的
补:升级字段
/**表备注说明字段长度升级20220302 */
sb = new StringBuilder();
sb.append(" DECLARE SELECTNUM NUMBER;BEGIN SELECT COUNT(1) INTO SELECTNUM FROM user_tab_columns ");
sb.append(" WHERE TABLE_NAME = 'MYTABLE' ");
sb.append(" AND COLUMN_NAME = 'MYCOLUMN' AND DATA_TYPE = 'VARCHAR2' AND DATA_LENGTH = 200; ");
sb.append(" IF SELECTNUM = 1 THEN EXECUTE IMMEDIATE ");
sb.append(" 'alter table MYTABLE modify MYCOLUMN VARCHAR2(500)'; END IF;END; ");
this.sqlList.add(258, sb.toString());