Oracle递归查询

Oracle递归查询start with connect by prior用于构建层次结构，通过指定起始条件和连接条件实现数据关联。

SELECT * FROM table_name START WITH parent_id = '1' CONNECT BY PRIOR child_id = parent_id;