了解新的PL/SQL JSON数据结构JSON数据结构

procedure parse_json(p_json in blob) is
  l_elem json_element_t := json_element_t.parse(p_json);
  l_obj json_object_t;
  l_arr json_array_t;
  l_keys json_key_list;
begin
  case
    when l_elem.is_Object then 
      l_obj := treat(l_elem as json_object_t);
      l_keys := l_obj.get_Keys;
      for i in 1..l_keys.count loop
        //work with the keys
        if l_obj.get(l_keys(i)).is_object then
          // this key is object,
        end if;
        if l_obj.get(l_keys(i)).is_array then
          // this key is array, 
        end if;
      end loop;
    when l_elem.is_Array then
      l_arr := treat(l_elem as json_array_t);
      for i in 0..l_arr.get_size - 1 loop
        // work with array
        case l_arr..get_type(i) 
          when 'SCALAR' then
             if l_arr.get(i).is_string then
             if l_arr.get(i).is_number then
             if l_arr.get(i).is_timestamp then
             if l_arr.get(i).is_boolean then
          .....
          when 'OBJECT' then 
            ....
          when 'ARRAY' then
            ....
          end case;
      end loop;
    end case; 
end parse_json;

您还可以使用真正有用的JSON Data Guide和DBMS_JSON包来为您Mapjson对象，甚至使用JSON_TABLE自动创建视图。
此致