1、存储Json对象数据：
create table ECOLOGY_TARGET.TIANJIN_JSON_OBJECT (id int, c1 varchar2(100) CHECK (c1 IS JSON(LAX)));

insert into ECOLOGY_TARGET.TIANJIN_JSON_OBJECT values(2, '{“a”:10,“b”:1,“c”:3,“d”:2,“e”:5}::JSON);
查询语句：
SELECT json_query(c1, ‘$.a’ returning varchar2 with wrapper) FROM ECOLOGY_TARGET.TIANJIN_JSON_OBJECT;

2、json对象内部key-value的增、改、查：
UPDATE ECOLOGY_TARGET.TIANJIN_JSON_OBJECT
SET c1 = JSON_SET(c1, ‘.f', 5) -- 添加新键 f:5 WHERE id = 2; --查询发现f:5已经添加到值里面了 select * from ECOLOGY_TARGET.TIANJIN_JSON_OBJECT  UPDATE ECOLOGY_TARGET.TIANJIN_JSON_OBJECT SET c1 = JSON_SET(c1, '.a’, 5) – 更新键 a 的值为5
WHERE id = 2;

select * from ECOLOGY_TARGET.TIANJIN_JSON_OBJECT；
A的值已经由10更新为5