Thanks for the question, Neha.
Asked: November 03, 2017 - 3:12 pm UTC
Last updated: November 04, 2017 - 2:28 am UTC
Version: Oracle 11g version 2
Viewed 1000+ times
You Asked
WHERE email IN (
select regexp_substr('one@gmail.com,two@gamil.com,three@gmail.com,four@gmail.com','[^,]+', 1, level) from dual
connect by regexp_substr('one@gmail.com,two@gamil.com,three@gmail.com,four@gmail.com', '[^,]+', 1, level) is not null );
and Connor said...
Well, I do NOT think regexp is a problem.
That evens things out :-)
Is this answer out of date? If it is, please let us know via a Comment