sql字符串

--字符串替换
select REPLACE(t.loginfo,'java.lang.Exception:',''),t.loginfo,t.status,t.* from ZJ_LOG t where t.tb_name='QY_BASE_CONTROL' and t.status='0';


select translate('abcdefga','abc','wo') 返回值 from dual; 

转载于:https://www.cnblogs.com/zshboke-2015/p/5353945.html