摘要： START WITH...CONNECT BY PRIOR详解ORACLE中的SELECT语句可以用START WITH...CONNECT BY PRIOR子句实现递归查询，CONNECT BY 是结构化查询中用到的，其基本语法是：SELECT columnName1[,columnName2,…]FROM tableName1,tableName2,..[START WITH columnName3]CONNECT BY {PRIOR col 1 = col 2 | col 1 = PRIOR col 2}WHERE columnName4;上述语法主要用查询表中的树型结构关系column 阅读全文