hopefully I don't have to provide a CREATE and INSERT here, I am thinking this is a general question
So I know that this example will find the good email addresses, but how do I change this to find the bad ones ?
I know that I can use REGEXP_LIKE NOT in the Where clauses, but can I find them from the select clause ?
select
regexp_substr(email_address,'[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}')
from table;