如何在ORACLE中从JSON中提取嵌套的节点值

-- 创建包含JSON数据的表
CREATE TABLE json_data (
  id NUMBER,
  data CLOB
);

-- 插入包含JSON数据的示例数据
INSERT INTO json_data VALUES (1, '{"name": "John", "age": 30, "address": {"city": "New York", "country": "USA"}}');

-- 提取嵌套的节点值
SELECT JSON_VALUE(data, '$.name') AS name,
       JSON_VALUE(data, '$.age') AS age,
       JSON_VALUE(data, '$.address.city') AS city,
       JSON_VALUE(data, '$.address.country') AS country
FROM json_data
WHERE id = 1;

NAME | AGE | CITY     | COUNTRY
-----|-----|----------|---------
John | 30  | New York | USA