ORCALE 使用 json_table

江小白写bug

2000人浏览 · 2022-05-12 17:00:03

江小白写bug · 2022-05-12 17:00:03 发布

直接展示效果：

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"}