ORCALE 使用 json_table

最新推荐文章于 2024-05-22 17:56:31 发布

江小白写bug

最新推荐文章于 2024-05-22 17:56:31 发布

阅读量1.7k

点赞数

分类专栏：数据库sql 文章标签： linq c#

本文链接：https://blog.csdn.net/qq_25623257/article/details/124735114

版权

数据库sql 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

直接展示效果：

select * from BYL_JSON t,json_table (
           t.STEJSON,
           '$'
          columns (
             policyHolder_name VARCHAR2(32) PATH '$.content.policyHolder.name',
             policyHolder_phone VARCHAR2(32) PATH '$.content.policyHolder.phone',
             policyHolder_certNo VARCHAR2(32) PATH '$.content.policyHolder.certNo',
             policyInsured_name VARCHAR2(32) PATH '$.content.policyHolder.name',
             policyInsured_phone VARCHAR2(32) PATH '$.content.policyHolder.phone',
             policyInsured_certNo VARCHAR2(32) PATH '$.content.policyHolder.certNo'
          )
       ) p

json:

{"content":{"fee":199,"policyHolder":{"phone":"18868955290","name":"时雪东","certNo":"412702199211124653"},"policyInsured":{"phone":"18868955290","name":"时雪东","certNo":"412702199211124653"}},"intNo":"0013"}