针对插入数据大小写不一致的情况:
将某一字节全部更改为大写:
SQL> update xxb_dbbak set DB_NAME = upper(DB_NAME) where 1=1;
41 rows updated
SQL> update xxb_dbbak set DB_NAME = upper(DB_NAME) where db_name is not null;
commit;
针对插入数据大小写不一致的情况:
将某一字节全部更改为大写:
SQL> update xxb_dbbak set DB_NAME = upper(DB_NAME) where 1=1;
41 rows updated
SQL> update xxb_dbbak set DB_NAME = upper(DB_NAME) where db_name is not null;
commit;
转载于:https://www.cnblogs.com/Wardenking/p/10286011.html