Search notes:

Oracle: JSON_DATAGUIDE

json_dataguide returns a JSON document that contains metadata about a given JSON document. 
select json_dataguide(
'{
  "number": 42,
  "translations": [
    {
      "lang": "germam",
      "text": "Zweiundvierzig"
    },
    {
      "lang": "french",
      "text": "quarante-deux"
    }
  ]
}') from dual;

with dg as (
select json_dataguide(
'
    {
      "number": 42,
      "translations": [
      {
        "lang": "germam",
        "text": "Zweiundvierzig"
      },
      {
        "lang": "french",
        "text": "quarante-deux"
      }
    ]
  }
  ') j from dual
)
select
    path,
    type,
    length
from dg nested
    j, '$[*]'
   columns (
      path   varchar2(4000) path '$."o:path"',
      type   varchar2(4000) path '$.type'    ,
      length number         path '$."o:length"'
   )
;

TODO

json_dataguide is an aggregate function.

See also

The dictionary view dba_json_dataguides and dba_json_dataguide_fields.

Index