create table all_f (sample varchar2(20), typeo varchar2(20));

 insert into all_f (SAMPLE, typeo)
values ('AB35053903-C10', '2');

insert into all_f (SAMPLE, typeo)
values ('AB35053995-A10', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35054283-C3', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35054582-A7', '2');

insert into all_f (SAMPLE, typeo)
values ('AB35055053-H12', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35055158-B2', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35500856-F4', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35501332-G11', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35501428-B9', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35504972-F11', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35505551-H7', '2');

insert into all_f (SAMPLE, typeo)
values ('AB35506138-G5', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35507097-C11', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35507190-G9', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35561723-H10', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35651275-E6', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35896175-C8', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35897805-A3', '2');

insert into all_f (SAMPLE, typeo)
values ('AB35899249-H8', '1');

insert into all_f (SAMPLE, typeo)
values ('AB35899918-H6', '1');

insert into t1 (SAMPLE, TYPEO)
values ('AB35652626-G8', '1');

commit;





create table t1 (sample_id varchar2(20), type varchar2(20));


insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '1');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '0');

insert into t1 (SAMPLE_ID, TYPE)
values ('AB35652626-G8', '0');





The output should be

 'AB35652626-G8' 1 1 1 1 1 1 1 1 1 1 0 0

since only this id exists in c3 (table t1).


This is just a sample...I have huge number of rows to be concatenated for multiple id's.

Thanks