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