Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

REPLACE() replaces every occurrence of the string specified as the search_string with the replacement_string

SQL> Syntax: REPLACE(<string_expression>, <search_string> [, <replacement_string>]) SQL> SQL> SQL> SELECT   2     REPLACE ('ABCDA', 'A','*')  replace_A,   3     REPLACE ('ABCDA', 'A')      remove_A,   4     REPLACE ('ABCDA',NULL)      null_search   5  FROM dual; REPLA REM NULL_ ----- --- ----- *BCD* BCD ABCDA SQL> SQL>