创建表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