How to display unique values among multiple columns

View All Public Scripts Login to Run Script

Statement 1

create table x (id number, c1 varchar2(20), c2 varchar2(20), c3 varchar2(20))

Table created.

Statement 2

insert into x values (1, 'a','a,b,c', 'c,a,e,x')

1 row(s) inserted.

Statement 3

insert into x values (2, 'b,x,y,c','a,b,c,x,z', 'y,m')

1 row(s) inserted.

Statement 4

insert into x values (3, 'a,b,c','a,b,c', 'a,b,c')

1 row(s) inserted.

Statement 5

select * from x


ID C1 C2 C3
2 b,x,y,c a,b,c,x,z y,m
3 a,b,c a,b,c a,b,c
1 a a,b,c c,a,e,x

3 rows selected.

Statement 6

select * from x order by id


ID C1 C2 C3
1 a a,b,c c,a,e,x
2 b,x,y,c a,b,c,x,z y,m
3 a,b,c a,b,c a,b,c

3 rows selected.

Statement 7

select id, c1||c2||c3 Values from x order by id

ORA-00923: FROM keyword not found where expected

Statement 8

select id, c1||c2||c3 "Non Unique Values" from x order by id


ID Non Unique Values
1 aa,b,cc,a,e,x
2 b,x,y,ca,b,c,x,zy,m
3 a,b,ca,b,ca,b,c

3 rows selected.

Statement 9

select id, c1||','||c2||','||c3 "Non Unique Values" from x order by id


ID Non Unique Values
1 a,a,b,c,c,a,e,x
2 b,x,y,c,a,b,c,x,z,y,m
3 a,b,c,a,b,c,a,b,c

3 rows selected.

Additional Information