Using Regular Expressions

From Oramosswiki

This page documents a number of uses of Regular Expressions in SQL.

REGEXP_REPLACE

Lets say you want to strip a character, e.g. a comma, from the end of a string:

SELECT REGEXP_REPLACE('Some characters with a trailing comma,',',$')
FROM   dual
/

Which returns:

Some characters with a trailing comma