转载 Oracle树查询(查询所有子节点包含自己)

查询 某ID 所有的子孙包含自己： 　　 select * from tableName t start with t.pid = '2c948a836b4f94b4016b5000c386014b' or t.id = '2c948a836b4f94b4016b5000c386014b' connect by t.pid = pri...