Mega Code Archive
Categories
/
Oracle PLSQL
/
Char Functions
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