In Oracle.table_test:
ID ID_PRE ID_NEXT
---------- ---------- ----------
01 02
02 01 03
05 04 06
03 02 04
04 03 05>>SQL> SELECT id_pre,id,id_next
2 FROM table_test
3 START WITH id = '01'
4 CONNECT BY PRIOR id_next = id;ID_PRE ID ID_NEXT
---------- ---------- ----------
01 02
01 02 03
02 03 04
03 04 05
04 05 06
ID ID_PRE ID_NEXT
---------- ---------- ----------
01 02
02 01 03
05 04 06
03 02 04
04 03 05>>SQL> SELECT id_pre,id,id_next
2 FROM table_test
3 START WITH id = '01'
4 CONNECT BY PRIOR id_next = id;ID_PRE ID ID_NEXT
---------- ---------- ----------
01 02
01 02 03
02 03 04
03 04 05
04 05 06
不可通用