Regular Expressions Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Regular Expressions Functions
  4. 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>