新手学java(10) - oracle级联查询

创建表 TBL_TEST ：  

 

CREATE
 TABLE
 TBL_TEST
(
  ID    NUMBER,
  NAME
  VARCHAR2(100 BYTE),
  PID   NUMBER
);

插入测试数据
从Root往树末梢递归: 

select
 * from
 TBL_TEST
 start with
 id=1
 connect
 by
 prior
 id = pid

从末梢往树ROOT递归: 

select
 * from
 TBL_TEST
 start with
 id=5
 connect
 by
 prior
 pid = id