oracle 递归

select id,root_id,name,sys_connect_by_path(name,'/') from t2 start with id = 1 connect by prior id = root_id;

推荐片好文章
http://blog.chinaunix.net/u1/54706/showart_1711812.html