PL/SQL function to return string with regexp special chars escaped

Question

Is there an existing PL/SQL method which takes a string and returns the same string but with backslashes preceding any regexp chars?

Answer 1

Try this:

result := REGEXP_REPLACE(subject, '([$^[()+*?{\|])', '\\\1', 1, 0, 'c');