SELECT TEST_QUERY.*, LEVEL
FROM TEST_QUERY
START WITH TEST_QUERY.ID = '0006'
CONNECT BY PRIOR TEST_QUERY.ID = TEST_QUERY.PID
FROM TEST_QUERY
START WITH TEST_QUERY.ID = '0006'
CONNECT BY PRIOR TEST_QUERY.ID = TEST_QUERY.PID
FROM TEST_QUERY
START WITH TEST_QUERY.ID = '0006'
CONNECT BY PRIOR TEST_QUERY.ID = TEST_QUERY.PID
正确答案了啦,可以结帖了