select orga001
from hrsw_T_organ
start with orga001 = '23' CONNECT BY prior orga001 = ORGA002
start with是从哪里是起始位置,
只有connect by语句中的prior关键字的位置决定了上下查询的方向
prior 子节点列 = 父节点列 [向下查询],prior 父节点列 = 子节点列 [向上查询]
把proir 翻译成"以...为查询条件"
向上查询理解为"以子节点列为查询条件,查询父节点列",
向下查询是"以emp_id为查询条件查询lead_id",即向下查询