},

    {

      "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