replace:将字符串的里面的某个值用新的值进行替换,最后返回新的字符串
replace(字符串,“字符串里面的某个值“,“新的值“)
select replace('0123456789','0','a') from dual;--a123456789
select replace('0123456789','0','') from dual;--123456789
select replace('0123456789','0') from dual;--123456789
replace:将字符串的里面的某个值用新的值进行替换,最后返回新的字符串
replace(字符串,“字符串里面的某个值“,“新的值“)
select replace('0123456789','0','a') from dual;--a123456789
select replace('0123456789','0','') from dual;--123456789
select replace('0123456789','0') from dual;--123456789