oracle父子结构表递归查询sql语句

父子结构表递归查询sql语句

一：从下至上递归

select j.*,j.rowid from SJ_LIB_CATEGORY j start with j.id ='c8759461-9b5e-4375-90f7-94f9c84dbe51' 
connect by prior j.parent_id=j.id and j.status=1 
order by j.create_date,j.biz_type

二：从上至下递归

select j.*,j.rowid from SJ_LIB_CATEGORY j start with j.id ='4b42b50c-292d-4390-a3b6-2cd327e9d8ce' 
connect by prior j.id=j.parent_id and j.status=1 
order by j.create_date,j.biz_type