Oracle PL/SQL/Regular Expressions/Escape

Change a dollar sign to a blank space

   <source lang="sql">

SQL> --Change a dollar sign to a blank space: SQL> SQL> SELECT REGEXP_REPLACE("$1,234.56","$"," ") FROM dual; REGEXP_REP

---

$1,234.56 SQL> SQL> -- This query "failed" because what was intended was a match for a "$" rather than the use of the "$" as an anchor. To match the "$" in an RE, we use the escape character like this: SQL> SQL> SELECT REGEXP_REPLACE("$1,234.56","\$"," ") FROM dual; REGEXP_RE

---

1,234.56

SQL> SQL>

      </source>