CREATE TABLE test1 ( id, json_data ) AS 
SELECT 1, EMPTY_CLOB() || '[ 
  { 
    "debitOverturn": "939.34", 
    "table": [ 
      { 
        "debit": "", 
        "credit": "939.34" 
      }, 
      { 
        "debit": "939.34", 
        "credit": "" 
      } 
    ] 
  }, 
  { 
    "debitOverturn": "939.34", 
    "table": [ 
      { 
        "debit": "", 
        "credit": "939.34" 
      }, 
      { 
        "debit": "939.34", 
        "credit": "" 
      } 
    ] 
  } 
]' FROM DUAL

SELECT jt.u_lvl, 
       jt.debitOverturn, 
       jt.l_lvl, 
       jt.debit, 
       jt.credit 
 FROM test1 s, 
     JSON_TABLE (s.json_data,'$[*]' COLUMNS ( 
        u_lvl FOR ORDINALITY, 
        debitOverturn VARCHAR2(20) PATH '$.debitOverturn', 
        NESTED PATH '$.table[*]' 
            COLUMNS ( 
                l_lvl FOR ORDINALITY, 
                debit VARCHAR2(38) PATH '$.debit', 
                credit VARCHAR2(38) PATH '$.credit'))) AS jt 
WHERE s.id = 1