求一个视图！

[lrq182]

有这样一张表
id type name
1 音乐 1.MP3
2 音乐 2.MP3
3 诗歌 aa.mp3
4 诗歌 bb.mp3

求一个视图，能将这些数据，按这样的方法输出！
type name
音乐 1.mp3|2.mp3
诗歌 aa.mp3|bb.mp3

[小灰狼W]

select type,Substr(Max(Sys_Connect_By_Path(name, '|')), 2) name
from (select t.*,row_number()over(partition by type order by id)rn from tab1 t)
start with rn=1
connect by rn-1=prior rn
and type=prior type
group by type