Hi All,
I am new to regular expressions and am trying to learn about them.
As practice I am trying to develop a query to filter out invalid e-mail id's eg:-
<some-name>.<some-name1>@gmail.com - VALID
<some-name>_<some-name1>@gmail.com - VALID
<some-name>@<some-name1>@gmail.com - INVALID
Lets say the column name is EMAIL_ID
So I have the expression to validate the email end as follows
select email from <table-name> where REGEXP_LIKE (EMAIL,'.com$')
However i have no idea (wheter it is even possible) to filter out the third email id
on the condition that it has *2 @*
Any help regarding this would be welcome