I really should be able to figure this out but for some reason my brain isn't working. Also, I suck at regex. What I want to do is use the PL/SQL to replace all non-alphanumeric characters in a column ...

What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.