使用ORDER SIBLINGS BY
例:
SELECT * FROM tabletest t CONNECT BY PRIOR t.id = t.pid START WITH t.id = 0 ORDER SIBLINGS BY t.id
使用ORDER SIBLINGS BY
例:
SELECT * FROM tabletest t CONNECT BY PRIOR t.id = t.pid START WITH t.id = 0 ORDER SIBLINGS BY t.id