Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with j (sJson) as (
   select '{
      "ID":"1444284517",
      "ID_ORD":"4255;2187606199",
      "Vals":{
               "CODE":"ONB2B3BB8",
               "DORD":"25.04.2021"
             }
   }'
   from dual
)

select jt.*
from j
cross apply json_table (j.sJson, '$'
   columns
      ID varchar2(32) path '$.ID',
      ID_ORD varchar2(32) path '$.ID_ORD',
        nested path '$.Vals[*]'
              columns (
                 CODE varchar2(9) path '$.CODE',
                 DORD varchar2(30) path '$.DORD'
              )) jt


ID
ID_ORD
CODE
DORD


1444284517
4255;2187606199
ONB2B3BB8
25.04.2021


with j (sJson) as (
   select '{
      "ID":"1444284517",
      "ID_ORD":"4255;2187606199",
      "Vals":{
               "CODE":"ONB2B3BB8",
               "DORD":"25.04.2021"
             }
   }'
   from dual
)

select jt.*
from j
cross apply json_table (j.sJson, '$'
   columns
      ID varchar2(32) path '$.ID',
      ID_ORD varchar2(32) path '$.ID_ORD',
        nested path '$.Vals[*].*'
              columns (
                 X varchar2(30) path '$'
              )) jt


ID
ID_ORD
X


1444284517
4255;2187606199
ONB2B3BB8

1444284517
4255;2187606199
25.04.2021


with j (sJson) as (
   select '{
      "ID":"1444284517",
      "ID_ORD":"4255;2187606199",
      "Vals":{
               "CODE":"ONB2B3BB8",
               "DORD":"25.04.2021"
             }
   }'
   from dual
)
select json_dataguide(jt.vals)
from j
cross apply json_table (j.sJson, '$'
   columns
      VALS clob format json path '$.Vals'
) jt


JSON_DATAGUIDE(JT.VALS)


[{"o:path":"$.CODE","type":"string","o:length":16},{"o:path":"$.DORD","type":"string","o:length":16}]


with j (sGuide) as (
   select '[{"o:path":"$.CODE","type":"string","o:length":16},{"o:path":"$.DORD","type":"string","o:length":16}]'
   from dual
)
select jt.*
from j
cross apply json_table (j.sGuide format json, '$[*]'
   columns
      path varchar2(30) path '$."o:path"',
      type varchar2(30) path '$.type',
      length number path '$."o:length"'
) jt


PATH
TYPE
LENGTH


$.CODE
string
16

$.DORD
string
16


declare
  sJson clob := '{
      "ID":"1444284517",
      "ID_ORD":"4255;2187606199",
      "Vals":{
               "CODE":"ONB2B3BB8",
               "DORD":"25.04.2021"
             }
   }';

  sGuide clob;
  sSQL clob;
begin
  -- initial static part of query
  sSQL := q'^select jt.*
from json_table (:sJson, '$'
   columns
      ID varchar2(32) path '$.ID',
      ID_ORD varchar2(32) path '$.ID_ORD',
        nested path '$.Vals[*]'
              columns (^';

  select json_dataguide(jt.vals)
  into sGuide
  from json_table (sJson, '$'
    columns
      VALS clob format json path '$.Vals'
  ) jt;

  for r in (
    select jt.*
    from json_table (sGuide format json, '$[*]'
      columns
        indx for ordinality,
        path varchar2(30) path '$."o:path"',
        type varchar2(30) path '$.type',
        length number path '$."o:length"'
    ) jt
  )
  loop
    sSQL := sSQL || case when r.indx > 1 then ',' end
      || chr(10) || '                 '
      || '"' || substr(r.path, 3) || '"'
      -- may need to handle other data type more carefully too
      || ' ' || case when r.type = 'string' then 'varchar2(' || r.length || ')' else r.type end
      || q'^ path '^' || r.path || q'^'^';
  end loop;

  -- final static part of query
  sSQL := sSQL || chr(10) || '              )) jt';
  dbms_output.put_line(sSQL);
end;
/
1 rows affected

dbms_output:
select jt.*
from json_table (:sJson, '$'
   columns
      ID varchar2(32) path '$.ID',
      ID_ORD varchar2(32) path '$.ID_ORD',
        nested path '$.Vals[*]'
              columns (
                 "CODE" varchar2(16) path '$.CODE',
                 "DORD" varchar2(16) path '$.DORD'
              )) jt

create or replace function dynamic_parse(sJson clob)
return sys_refcursor as
  sGuide clob;
  sSQL clob;
  rc sys_refcursor;
begin
  -- initial static part of query
  sSQL := q'^select jt.*
from json_table (:sJson, '$'
   columns
      ID varchar2(32) path '$.ID',
      ID_ORD varchar2(32) path '$.ID_ORD',
        nested path '$.Vals[*]'
              columns (^';

  select json_dataguide(jt.vals)
  into sGuide
  from json_table (sJson, '$'
    columns
      VALS clob format json path '$.Vals'
  ) jt;

  for r in (
    select jt.*
    from json_table (sGuide format json, '$[*]'
      columns
        indx for ordinality,
        path varchar2(30) path '$."o:path"',
        type varchar2(30) path '$.type',
        length number path '$."o:length"'
    ) jt
  )
  loop
    sSQL := sSQL || case when r.indx > 1 then ',' end
      || chr(10) || '                 '
      || '"' || substr(r.path, 3) || '"'
      -- may need to handle other data type more carefully too
      || ' ' || case when r.type = 'string' then 'varchar2(' || r.length || ')' else r.type end
      || q'^ path '^' || r.path || q'^'^';
  end loop;

  -- final static part of query
  sSQL := sSQL || chr(10) || '              )) jt';
  dbms_output.put_line(sSQL);

  open rc for sSQL using sJson;
  return rc;
end;
/
declare
  sJson clob := '{
      "ID":"1444284517",
      "ID_ORD":"4255;2187606199",
      "Vals":{
               "CODE":"ONB2B3BB8",
               "DORD":"25.04.2021"
             }
   }';

  rc sys_refcursor;
  id varchar2(32);
  id_ord varchar2(32);
  col1 varchar2(4000);
  col2 varchar2(4000);
begin
  rc := dynamic_parse(sJson);
  loop
    fetch rc into id, id_ord, col1, col2;
    exit when rc%notfound;
    dbms_output.put_line(id || ':' || id_ord || ':' || col1 || ':' || col2);
  end loop;
end;
/
1 rows affected

dbms_output:
select jt.*
from json_table (:sJson, '$'
   columns
      ID varchar2(32) path '$.ID',
      ID_ORD varchar2(32) path '$.ID_ORD',
        nested path '$.Vals[*]'
              columns (
                 "CODE" varchar2(16) path '$.CODE',
                 "DORD" varchar2(16) path '$.DORD'
              )) jt
1444284517:4255;2187606199:ONB2B3BB8:25.04.2021
ID	ID_ORD	X
1444284517	4255;2187606199	ONB2B3BB8
1444284517	4255;2187606199	25.04.2021