REPLACE

=REPLACE=

Syntax
**REPLACE**(//char, search_str//[, //replace_str//])

Definition
Replaces a sequence of characters in a string with another set of characters.

Examples
SELECT REPLACE('JACK and JUE','J','BL') FROM employees
 * REPLACE('JACK and JUE','J','BL') ||
 * BLACK and BLUE ||

SELECT REPLACE('CAT and BAT','C','B') FROM dual
 * REPLACE('CAT and BAT','C','B') ||
 * BAT and BAT ||

SELECT REPLACE('MOUSE and HOUSE','H','M') FROM dual
 * REPLACE('MOUSE and HOUSE','H','M') ||
 * MOUSE and MOUSE ||