Basic email validation in SQL.
case when regexp_substr(SUBSCRIBER_EMAIL_ADDRESS,'[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}') = SUBSCRIBER_EMAIL_ADDRESS then 1 else 0 end