Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. If the look for string is not present, then the replacing does not occur
SQL>  SELECT REPLACE ('This is a test','AAAA',' may be ')FROM dual;
REPLACE('THISI
--------------
This is a test
SQL>