Oracle Regex

Needed some regex to only leave a-z values.

This seemed to work for me:


select regexp_replace(ent_val,'[^a-zA-Z]','') from ac