http://blog.sina.com.cn/s/blog_58844e710100g9lx.html
#从Root往树末梢递归 SELECT * FROM TBL_TEST start WITH id=1 connect BY prior id = pid
SELECT * FROM TBL_TEST start WITH id in (1,2,3) connect BY prior id = pid ; //以树的形式显示树形表的所有行(递归查询)
SELECT S.PRD_ID AS prdId, S.PRD_FLMC AS prdFlmc,S.PRD_FID FROM ( SELECT PRD_ID, PRD_FLMC, PRD_FID FROM T_PRODUCTS) S CONNECT BY PRIOR S.PRD_ID = S.PRD_FID START WITH S.PRD_FID is null (以树的形式显示所有的数据)