/*******************************************************************
*PURPOSE: SQL Query to validate email address *
*AUTHOR: Shailender Thallam *
*******************************************************************/
SELECT EMAIL_ADDRESS FROM HZ_CONTACT_POINTS
WHERE EMAIL_ADDRESS IS NOT NULL
AND NOT REGEXP_LIKE(email_address,'^[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}$') |
/*******************************************************************
*PURPOSE: SQL Query to validate email address *
*AUTHOR: Shailender Thallam *
*******************************************************************/
select EMAIL_ADDRESS from HZ_CONTACT_POINTS
where EMAIL_ADDRESS is not null
and not REGEXP_LIKE(email_address,'^[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}$')