ORACLE PLSQL解析JSON
下载pljson
地址:https://github.com/pljson/pljson
打开command window
执行:SQL> @C:\pljson-master\install.sql;
select grade, content from shop.t_point_grade_kg_test where grade = 1;
查询结果:
grade | content |
---|---|
1 | [{“serviceName”:”cashCouponProductImpl”,”serviceParam”:”{\”vouchersRuleId\”:\”1009\”,\”period\”:\”30\”}”},{“serviceName”:”interestCouponProductImpl”,”serviceParam”:”{\”rateRises\”:\”0.5\”,\”riseDays\”:\”5\”,\”productId\”:\”109\”,\”period\”:\”30\”}”}] |
json:
[
{
"serviceName":"c