oracle多表递归查询

最新推荐文章于 2022-11-02 17:02:20 发布

weixin_42079714

最新推荐文章于 2022-11-02 17:02:20 发布

阅读量986

点赞数

分类专栏： java 文章标签： oracle sql

本文链接：https://blog.csdn.net/weixin_42079714/article/details/103390924

版权

java 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

oracle多表递归查询和修改

#对Oracle熟悉，在这里记录一下

// 向下递归
SELECT * FROM table WHERE xxx in (SELECT * FROM xxx start with xxx = xxx connect by prior xxx = xxx);

//向上递归
SELECT * FROM table WHERE xxx in (SELECT * FROM xxx start with xxx = xxx connect by xxx =prior xxx)

SELECT * FROM typs_zj_label WHERE excatcode in (SELECT * FROM typs_wd_data start with excatcode = 10051000010 connect by prior excatcode = parentcode)