ORACLE tree query and oracle tree Query

ORACLE tree query and oracle tree Query

The front-end tree structure varies according to personal permissions. For all my queries, You need to query all the subnodes and the information of the current node based on the tree ID.

Select * from table start with id =#{ id} connect by prior id = pid

The id here is the ID of the parent node

Tree display in oracle Query

You can use start with connect by to query the tree structure.
Select * from users start with parentid = 0 connect by prior id = parentid

Oracle tree Query

Select * from emp start with empno = 'xxx' -- connect from employee id = xxx by prior managerid = empid -- manager of the previous ROW = employee id of the Bank