},
{
"insuplc_admdvs": "**99",
"psn_insu_date": "20**-09-01",
"cvlserv_flag": "0",
"balc": 0,
"emp_name": "*人民医院",
"psn_type": "11",
"psn_insu_stas": "1",
"insutype": "510",
"paus_insu_date": null
}
]
}^1^310^01^^^**0001^管理员1^1^1700000^^^***9^11$ReadCardBas||^{"data":{"orgId":"***022","businessType":"01301","operatorId":"00001","operatorName":"管理员1","officeId":"00000","officeName":"00000"},"transType":"ec。query","orgId":"****0022"}^{"code":"0","message":"","data":{"CardInfo":"**00|***99001180047|6***387|360100D1560000056459653872A1B523|**佳|008****063312D2|2。00|20***201|20***01|3***3||","BusiCardInfo":"SQPNYqUL1KjN3kWFCoXDd0IH3qXeIE8hIChTWswdV99xBxrEqUHS+6NKMLZRwQGtTqkJQlJHOVsVwgt3NTyIX1gcl4RXGCdI1mQIcEZM2v9YzcIYdsTVLb7IVfmUYCDKcjNFlGtWJwF0+Vl6yiztPkDPvlfhXAYDTZtLekLJHSAxNjM2MDI1OTQ2NTBFQjc1QkU1QzIzRDM1QjFFQTkwNUUzQzI2NDQ2NEI="}}','insuinfo'),0),'balc') from dual
得到结果为insuinfo 的第一条的balc值
例子 :取读卡信息中的emp_name值
select jsonpkg。getval(jsonpkg。getarrval(jsonpkg。getval(p。read_card_info,'insuinfo'),0),'emp_name'),
p。* from bl_***_oep p