oracle 递归查询数据

SELECT *
FROM 表名
START WITH 条件
CONNECT BY PRIOR ID=typePid

 比如：
SELECT *
FROM ProLibraryType
START WITH id in ('4028ac0073982a1c017398745ee10001')
CONNECT BY PRIOR ID=typePid 

就是查询 ProLibraryType  表中  id为 4028ac0073982a1c017398745ee10001 并且  id=typepid的递归数据