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