1.Oracle迭代查询
查询所有的子数据(包含符合条件的数据)
SELECT * FROM TABLE START WITH column= '' CONNECT BY PRIOR column = parent_column;
SELEC * FROM sys_office START WITH ID = '2000' CONNECT BY PRIOR ID = PARENT_ID
查询出2000下的所有子数据 2000下有2100,2200.....;2100下有2110,2120......
会把这些数据都查询出来
查询所有的父数据(包含符合条件的数据)
SELECT * FROM TABLE START WITH column= '' CONNECT BY PRIOR parent_column = column;
SELEC * FROM sys_office START WITH ID = '2000' CONNECT BY PRIOR PARENT_IID = ID
查询出2000上的所有父数据 00001;0001上有0
会把这些数据都查询出来