REPLACE('This is a test','t','XYZ')
SQL> -- Regext_Replace
SQL> -- An example of the REPLACE function
SQL>
SQL> SELECT REPLACE('This is a test','t','XYZ') FROM dual;
REPLACE('THISISATE
------------------
This is a XYZesXYZ
Related examples in the same category