20170411-oracle 查询指定节点下的所有子节点包括直到叶子节点

查询父节点

SELECT * FROM r_org org START WITH org.org_code = '6199840Q' CONNECT BY PRIOR PARENT_ID = ID; SELECT * FROM r_org org START WITH org.