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
