09 2017 档案

oracle 递归查询(树查询) connect by prior
摘要：Oracle的 connect by 语句，可用来做有父子关系的表向上或向下查询:// 1、从id为1的开始查询所有子级select * from org connect by prior id=pid star... 阅读全文
posted @ 2017-09-07 15:31 程序员老油条 阅读(79) 评论(0) 推荐(0)