Hi Gurus,
I have a table where column has comma separated list.
Is there a way to use that column in in-clause to compare with individual values?
create table a
(col varchar2(100));
insert into a values('a,b,c,d');
insert into a values('c,d,e,f');
commit;
select * from a
where col_val in ('a','b');
Thanks