oracle - Merging Multiple columns data to a single row in SQL -

this question has answer here:

• oracle sql pivot query 2 answers

i have table has data following

name |reg_type  aaa   reg_type1  aaa   reg_type2  bbb   reg_type3  aaa   reg_type5  bbb   reg_type4  bbb   reg_type1 

however, want sql returning result set like:-

name| reg_type1|  reg_type2  |reg_type3  |reg_type4  |reg_type5  |reg_type6  aaa      y          y            n           n          y            n bbb      y          n            y           y          n            n 

the listagg function need. can learn here:

http://www.oracle-base.com/articles/misc/string-aggregation-techniques.php

select name, listagg(reg_type,'|') within group (order reg_type) reg reg group name;