描述tb_doc_catalog表(cat_id,cat_name,parent_cat_id)
oracle 查询当前节点的所有子节点的语句
select g.* from tb_doc_catalog g start width g.cat_id=当前id
connect by prior g.cat_id=g.parent_cat_id
-----------------------------------------------------
oracle 查询当前节点的所有父节点的语句
select g.* from tb_doc_catalog g start width g.cat_id=当前id
connect by prior g.parent_cat_id=g.cat_id