Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

The REPLACE Function

The REPLACE function has the following general syntax: REPLACE (string, look for, replace with) All three arguments are necessary. The 'look for' string will be replaced with the 'replace with' string every time it occurs. SQL> SELECT REPLACE ('This is a test',' is ',' may be ') FROM dual; REPLACE('THISISATE ------------------ This may be a test SQL>