REGEXP_LIKE

SQL Query to Validate Email Address

by Shailender Thallam
November 30, 2020November 30, 2020

/******************************************************************* *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… Read More »SQL Query to Validate Email Address

Oracle SQL Regular Expression to find if a Value is String or Number

by Shailender Thallam
October 9, 2015October 10, 2015
2 Comments

We can use oracle standard REGEXP_LIKE command to apply a regular expression on value. Below is sample query to find if a value is String… Read More »Oracle SQL Regular Expression to find if a Value is String or Number