sql语句的正则表达式 数据库

select REGEXP_REPLACE(WAREHOUSENAME,'[[A-Z][A-Z][0-9]|\\[|\\]]','') from WAREHOUSE where regexp_like(WAREHOUSENAME,'[[0-9]|\\[|\\]]');

sql语句  去空格   trim

查重语句 SELECT WAREHOUSENAME FROM WAREHOUSE HAVING COUNT(WAREHOUSENAME) > 1 GROUP BY WAREHOUSENAME

select jwdname,warehousename,count(*) from warehouse group by jwdname ,warehousename having count(*) > 1

查找】之后的 select cangku,substr(cangku,instr(cangku,'】')+1,length(cangku)) from OUTSTOKE

清除用户回收站 purge recyclebin

字符串中插入字符串 UPDATE COMPONENT_IMG t set t.filepath_ = SUBSTR(t.filepath_,1,10)||SUBSTR(t.filepath_,11,8)||'/'||SUBSTR(t.filepath_,11) WHERE SUBSTR(t.filepath_,11,8) = 20170503