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

创建表TBL_TEST：?

?

1. CREATE?TABLE?TBL_TEST??
2. (??
3. ??ID????NUMBER,??
4. ??NAME??VARCHAR2(100?BYTE),??
5. ??PID???NUMBER???
6. );??

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

1. select?*?from?TBL_TEST??
2. ?start?with?id=1??
3. ?connect?by?prior?id?=?pid??

从末梢往树ROOT递归:?

1. select?*?from?TBL_TEST??
2. ?start?with?id=5??
3. ?connect?by?prior?pid?=?id ?