oracle解析JSON数组
JSON串:
[{"feeNo":"T00001","feeTyp": "1","taxAmt":10.00,"taxTyp":"1"},{"feeNo":"T00002","feeTyp": "2","taxAmt":2.00,"taxTyp":"1"}
解析脚本:
select feeNo,feeTyp,taxAmt,taxTyp
from JSON_TABLE('[{"feeNo":"T00001","feeTyp": "1","taxAmt":10.00,"taxTyp":"1"},{"feeNo":"T00002","feeTyp": "2","taxAmt":2.00,"taxTyp":"1"}]', '$[*]' COLUMNS (feeNo VARCHAR2(10) PATH '$.feeNo', feeTyp VARCHAR2(50) PATH '$.feeTyp', taxAmt NUMBER PATH '$.taxAmt', taxTyp VARCHAR2(5) PATH '$.taxTyp')) jt;