oracle函数--replace 函数

如果为a=b,则替换为c
replace (a,b,c)

select replace('2019-08-04', '2019-08-04', '2019-09-04') from dual;

去空格

select replace('fdsfd fdf  sd  ',' ','') from dual;
--fdsfdfdfsd
--解决因为空格或大小写不一致导致查询不到结果问题
select * from lis.ljfiget where upper(replace(accname,' ','')) =upper(replace('PETER TAN',' ',''))