oracle中进行简单树查询(递归查询) ,PRIOR、CONNECT_BY_ROOT的用法

1、有下面样式的5层树形数据，现在要筛选基层以及基层以下所有数据

select *
  from AUTH_ORGANIZATION_TB t
 start with t.org_id = 32
connect by prior t.org_id = t.org_id_superior
 order by t.org_id_superior,org_id

运行结果入下：

2、如上图，已知生产技术科，要获取他的上两级数据炼油运行一部

select level,
       T.ORG_ID,
       T.ORG_ID_SUPERIOR,
       RPAD('_', (level - 1) * 6, '_') || T.U_NAME,
       CONNECT_BY_ROOT ORG_ID,
       CONNECT_BY_ROOT U_NAME_FULL,
       CONNECT_BY_ISLEAF
  from AUTH_ORGANIZATION_TB T
 start with T.ORG_ID_SUPERIOR = 32
connect by prior T.ORG_ID = T.ORG_ID_SUPERIOR

运行结果如下：