oracle递归查询

CREATE TABLE posp_boss.TBL_TEST 
( 
ID NUMBER, 
NAME VARCHAR2(100 BYTE), 
PID NUMBER DEFAULT 0 
); 


INSERT INTO posp_boss.TBL_TEST(ID,NAME,PID) VALUES('1','10','0'); 
INSERT INTO posp_boss.TBL_TEST(ID,NAME,PID) VALUES('2','11','1'); 
INSERT INTO posp_boss.TBL_TEST(ID,NAME,PID) VALUES('3','20','0'); 
INSERT INTO posp_boss.TBL_TEST(ID,NAME,PID) VALUES('4','12','1'); 
INSERT INTO posp_boss.TBL_TEST(ID,NAME,PID) VALUES('5','121','2'); 

select * from posp_boss.TBL_TEST for update;

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

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