oracle 中的select …connect by prior …start with 及(+)的用法
1.select …connect by prior …start with的用法:
select … from <tablename>
where <conditional-1> –过滤条件,用于对返回的所有记录进行过滤
start with <conditional-2> –查询结果从起始根节点的限定条件
connect by prior <conditional-3> –连接条件
数据库表[......]