Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

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>