oracle递归

  select * from o_org where org_no like '%43406%'
    
     /* 已知根节点 查询所有的子节点*/
     select * from o_org o start with org_no='43406' connect by  PRIOR  org_no = p_org_no

     /* 已知子节点 查询其所有的上层节点 */
     select * from o_org o start with org_no='43406' connect by  org_no = PRIOR  p_org_no