1、start with ...connect by prior...
表tb_tree ,字段F_ID,F_NAME,F_PID
select f_id,f_name from tb_tree start with tb_tree.f_id=419 connect by prior tb_tree.f_id=tb_tree.f_pid
start with 后表达式:限定树节点起始位置
connect by prior 后表达式:描述表中自连接字段之间的关系
1、start with ...connect by prior...
表tb_tree ,字段F_ID,F_NAME,F_PID
select f_id,f_name from tb_tree start with tb_tree.f_id=419 connect by prior tb_tree.f_id=tb_tree.f_pid
start with 后表达式:限定树节点起始位置
connect by prior 后表达式:描述表中自连接字段之间的关系