Oracle 树操作、递归查询(select…start with…connect by…prior)_select start with connect by prior-CSDN博客

网站介绍:文章浏览阅读258次。一、Oracle中start with…connect by prior子句用法connect by 是结构化查询中用到的,其基本语法是:select … from tablenamestart with 条件1connect by 条件2where 条件3;例:select * from tablestart with org_id = ‘HBHqfWGWPy’connec..._select start with connect by prior