Hello,
I would like to process the below json file via Sql command :
Select * from JSON_TABLE(get_clob_from_file('/tmp/currencies.json'),
'$'
Columns(.......
..........
I'm stuck as the currency code (i.e. AED , AFN .,.. USD) has no column name and changes at every instance
Thanks
I would like to process the below json file via Sql command :
Select * from JSON_TABLE(get_clob_from_file('/tmp/currencies.json'),
'$'
Columns(.......
..........
I'm stuck as the currency code (i.e. AED , AFN .,.. USD) has no column name and changes at every instance
Thanks
Comment