Replace: returns a string in which every occurrence of the pattern_to_find has been replaced with pattern_to_replace_by
SQL>
SQL> -- Replace: returns a string in which every occurrence of the pattern_to_find has been replaced with pattern_to_replace_by.
SQL>
SQL> --The general format for this function is:
SQL>
SQL> --REPLACE(source_string, pattern_to_find, pattern_to_replace_by)
SQL>
SQL> SELECT REPLACE('Mississippi', 'pi', 'PI') FROM dual;
REPLACE('MI
-----------
MississipPI
Related examples in the same category