SELECT x.*
    FROM json_tab t,
             json_table (t.json_data, '$.[*]'
         COLUMNS
            name  VARCHAR2(4000) PATH '$.name',
            cars clob PATH '$.cars[*]') x;