oracle connect by 递归,反递归,自动补全查询实现
摘要:
递归: select * from t_pams_solution t start with t.id is null connect by prior id = t.parent_id order by level desc 红字部分分别为 表名,开始条件,子节点与根关联条件 反递归: selec 阅读全文
posted @ 2018-01-13 17:27 instr 阅读(364) 评论(0) 推荐(0) 编辑