新手学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