oracle数结构查询【递归查询】
例:
SELECT t.*, t.rowid FROM emp t START WITH t.empno = 7934 CONNECT BY PRIOR [size=large][color=red]t.mgr = t.empno[/color][/size];
根据t.empno = 7934 查询本身及其父节点【sfswcbp,子父子】
例:SELECT t.*, t.rowid FROM emp t START WITH t.empno = 7839 CONNECT BY PRIOR [size=large][color=red]t.empno = t.mgr[/color][/size];
根据t.empno = 7934 查询本身及其子节点【sfswcbp,子子父】
例:
SELECT t.*, t.rowid FROM emp t START WITH t.empno = 7934 CONNECT BY PRIOR [size=large][color=red]t.mgr = t.empno[/color][/size];
根据t.empno = 7934 查询本身及其父节点【sfswcbp,子父子】
例:SELECT t.*, t.rowid FROM emp t START WITH t.empno = 7839 CONNECT BY PRIOR [size=large][color=red]t.empno = t.mgr[/color][/size];
根据t.empno = 7934 查询本身及其子节点【sfswcbp,子子父】