Hi All,
I've the following table with values and want to get the unique values among the three columns.
create table x (id number, c1 varchar2(20), c2 varchar2(20), c3 varchar2(20));
insert into x values (1, 'a','a,b,c', 'c,a,e,x');
insert into x values (2, 'b,x,y,c','a,b,c,x,z', 'y,m');
insert into x values (3, 'a,b,c','a,b,c', 'a,b,c');
select id, c1||','||c2||','||c3 "Non Unique Values" from x order by id;
Current Output :
Expected Output :
Thanks