Hello Gurus,
select * from test where
NOT REGEXP_LIKE (users, '^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$'),',')
I need to validate the field which has valid email addresses so i am using the above statement.
But the problem is that if its a single email address its working but when email address delimited by comma its not working
The one below works fine
insert into test
values ('abc @xyz.com');
The one below does not works fine
insert into test
values ('abc@xyz.com','sdf@test.com');
commit;
Please advise