For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello,
I need to validate the Email Address using SQL.If the Email Address is VALID it will return NULL or if NOT any values
I am using the below one for validation.
Please advise
select regexp_substr
('sdfg.werty@sdf.com.bi;procurement@sdf.com.bi;Salesorderadmin-DL@testingteam.com;service_operation-dl@testingteam.com;lizbeghh@testingteam.com',
'^[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}$') test1
from
dual ;