JSON

From: Terrian Thomas J CTR DLA INFO OPERATIONS <dmarc-noreply_at_freelists.org>
Date: Mon, 28 Nov 2022 19:14:19 +0000
Message-ID: <BN8P111MB1908CBCE2A5FAFA65EBDF292B1139_at_BN8P111MB1908.NAMP111.PROD.OUTLOOK.COM>

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)?

--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s

Received on Mon Nov 28 2022 - 20:14:19 CET