Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

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

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library