Search Results

Hi,
Example (in red for you) :
with T As
(select 123 as c1, 'NY,NJ,CA' as c2 from dual
union
select 124 as c1, 'NY,PA,' as c2 from dual)
SELECT DISTINCT C1, regexp_substr(C2,'[^,]+', 1,...