父子结构表递归查询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