Oracle递归查询，级联查询

select * from cascade start with id = 1 connect by PRior id = sjcd_id  order by id;start with id = 1 --代表从哪里开始递归查询，包括自己。connect by prior id = sjcd_id --代表使用 sjcd_id 和 id 进行递归匹配。