含下级:select a.id from 表 a start with a.id='123'connect by prior a.id=a.parentid
含上级:select a.id from 表 a start with a.id='123' connect by prior a.parentid=a.id
含下一级:select a.id from 表 a start with a.parentid='123' connect by prior a.parentid=a.id
含下级:select a.id from 表 a start with a.id='123'connect by prior a.id=a.parentid
含上级:select a.id from 表 a start with a.id='123' connect by prior a.parentid=a.id
含下一级:select a.id from 表 a start with a.parentid='123' connect by prior a.parentid=a.id