请问关于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'