查询父节点
select * from 表名 start with 条件(例:columnA = ‘1’)
connect by prior PARENT_SID = SID
查询子节点
select * from 表名 start with 条件(例:columnA = ‘1’)
connect by PARENT_SID = prior SID
查询父节点
select * from 表名 start with 条件(例:columnA = ‘1’)
connect by prior PARENT_SID = SID
查询子节点
select * from 表名 start with 条件(例:columnA = ‘1’)
connect by PARENT_SID = prior SID