oracle12c JSON数据使用SQL语句实现多表左外连接显示无效数据分页查询

最新推荐文章于 2021-04-10 05:35:25 发布

PandaXml

最新推荐文章于 2021-04-10 05:35:25 发布

阅读量1.2k

点赞数 1

分类专栏：编程语言数据库文章标签： sql分页查询 Oracle12c json数据多表左外查询

本文链接：https://blog.csdn.net/shuguang_2008/article/details/48268561

版权

编程语言同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

数据库

1 篇文章 0 订阅

订阅专栏

SQL代码如下：

SELECT *
  FROM (SELECT oo.*, ROWNUM AS rowno
          FROM(SELECT o.DATA.orderNo, os.DATA.name as orderSource,bu.DATA.name as businessType, o.DATA.customNo, o.DATA.productName, o.DATA.contactTel, 
                  o.DATA.loadTime, o.DATA.loadPlace, o.DATA.deliverTime, o.DATA.deliverPlace, ar.DATA.name as area,
                  o.DATA.others, cu.DATA.customName, cs.DATA.name as customSource, cu.DATA.contactWay, cu.DATA.customUnit
                FROM GJ_WULIIU_ORDER o, GJ_WULIU_CUSTOMER cu,GJ_WULIU_ORDERSOURCE os,gj_wuliu_busitype bu,gj_wuliu_custsource cs,gj_wuliu_area ar
                WHERE o.DATA.customNo= cu.DATA.customNo(+)
                    AND o.DATA.orderSource=os.DATA.code(+)
                    AND o.DATA.businessType=bu.DATA.code(+)
                    AND cu.DATA.customSource=cs.DATA.code(+)
                    AND o.DATA.area=ar.DATA.code(+)
                ORDER BY o.DATA.orderNo DESC
              ) oo
         WHERE ROWNUM <= pageBean.getCurrentPage()*pageBean.getPageSize()) table_alias
 WHERE table_alias.rowno >= (pageBean.getCurrentPage()-1)*pageBean.getPageSize();

以上代码仅供参考，谢谢!