Oracle SQL
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
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