start with connect by prior 实现递归查询（查询数据的树形结构关系）

1、select id from tablename start with id='idNum' connect by prior id = parentId;- -自顶向下查询
2、select id from tablename start with id='idNum' connect by  id = prior parentId;- -自底向上查询

1、从start with开始查找

2、根据prior后面的列（id/parentId）判断查找的是父节点还是子节点,如果为id,则查询子节点，若为parentId则查询父节点。