OracleAppsDNA

SQL Query to Validate Email Address

Shailender Thallam 

/******************************************************************* 
 *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}$')

For Further Reading

  1. SQL Query to find Customer, Customer Account and Customer Sites Information
  2. SQL Query to find Report Job History in ERP Cloud
  3. SQL Query to findout Application Tops unix physical path
  4. SQL Query to get List of Procurement Agents in Oracle ERP Coud
  5. Oracle SQL Query to list Months and Years
  6. SQL Query to Convert Comma separated String values to Rows
  7. SQL Query to Fetch BPM Approval Groups Information
Exit mobile version