# cat test.json
{
rows: [
       {a: 1,b: 2},
       {a: 2,b: 3},
       {a: 3,b: 4}
       ]
}

SQL> select * from json_table(bfilename('FILES','test.json'), '$.rows[*]' columns a path '$.a', b path '$.b');

A          B
---------- ----------
1          2
2          3
3          4

CREATE TABLE json_dump_file_contents (json_document clob)
  ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY files
                         ACCESS PARAMETERS
                           (RECORDS DELIMITED BY 0x'00'
                            DISABLE_DIRECTORY_LINK_CHECK
                            FIELDS (json_document CHAR(500000)))
                         LOCATION (files:'test.json'))
  PARALLEL
  REJECT LIMIT UNLIMITED
/
select json_document from json_dump_file_contents;

JSON_DOCUMENT
---------------------------------------------------------
{
rows: [
       {a: 1,b: 2},
       {a: 2,b: 3},
       {a: 3,b: 4}
       ]
}