JSON

  • From: "Terrian Thomas J CTR DLA INFO OPERATIONS" <dmarc-noreply@xxxxxxxxxxxxx> ("Tom.Terrian.ctr")
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 28 Nov 2022 19:14:19 +0000

Anyone know how to load a JSON file into a database?

 

When I run:

 

select * 

from json_table(

bfilename('JSON_DATA', 'D_20221122.txt'),

'$[*]'

Columns(

Nested path '$.cData[*]'

columns( 

cCode varchar2(5) path '$.cCode[*]'

)

                                                )

);

 

I get only 1 record:

 

CCODE

-----

7MDQ6

 

How can I see all of the records in the file (JSON_DATA/'D_20221122.txt)?

Other related posts:

  • » JSON - Terrian Thomas J CTR DLA INFO OPERATIONS
  1. Home
  2. oracle-l
  3. Archive
  4. 11-2022