请问关于oracle的 replace函数的用法？

Question

oracle的 replace函数的用法

Answer 1

SELECT REPLACE('JACK and JUE','J','BL') "Changes"
FROM DUAL;

Changes
--------------
BLACK and BLUE

Answer 2

replace( string1, string_to_replace, [ replacement_string ] )

For example:

replace('123123tech', '123'); would return 'tech'
replace('123tech123', '123'); would return 'tech'
replace('222tech', '2', '3'); would return '333tech'
replace('0000123', '0'); would return '123'
replace('0000123', '0', ' '); would return ' 123'