Oracle中start with和connect by 使用
转自:https://blog.csdn.net/qq_29274091/article/details/72627350,多谢博主分享
connect by 是结构化查询中用到的,其基本语法是:
1 select … from tablename
2 start with 条件1
3 connect by 条件2
4 where 条件3;
例:
1 select * from tab...
转载
2019-01-30 10:21:46 ·
931 阅读 ·
0 评论