Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

The Backslash as an Escape Character

SQL> SQL> SELECT REGEXP_REPLACE('$1,234.56','$',' ') FROM dual; REGEXP_REP ---------- $1,234.56 SQL> SQL> SELECT REGEXP_REPLACE('$1,234.56','\$',' ') FROM dual; REGEXP_RE ---------  1,234.56 SQL>