start with....connect by 递归查询树状SQL
Select * from t_tree
where UPPER(is_display) = 'ON' start with p_node_id =1 --当前节点ID connect by prior node_id = p_node_id and level <= 1 --(从父往子递归只查询一级子节点) order SIBLINGS by display_order本文共 292 字，大约阅读时间需要 1 分钟。
start with....connect by 递归查询树状SQL
Select * from t_tree
where UPPER(is_display) = 'ON' start with p_node_id =1 --当前节点ID connect by prior node_id = p_node_id and level <= 1 --(从父往子递归只查询一级子节点) order SIBLINGS by display_order转载于:https://www.cnblogs.com/onlywujun/archive/2013/02/21/2920864.html