Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

If not found, then the replacing does not occur

SQL> SQL> SQL> --If not found, then the replacing does not occur SQL> SQL> SELECT REPLACE ('This is a test','glurg',' may be ') FROM dual; REPLACE('THISI -------------- This is a test