select * from ams_app_special t start with t.special_id=129
connect by prior t.parent_id = t.special_id
查询所有父节点
select * from ams_app_special t start with t.special_id=129
connect by prior t.special_id=t.parent_id
查询所有子节点
connect by prior t.parent_id = t.special_id
查询所有父节点
select * from ams_app_special t start with t.special_id=129
connect by prior t.special_id=t.parent_id
查询所有子节点