| 11. 16. 1. 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>
|
|