JSON datas to Database, Mapping Json with field contains array[string], transform to string
I use this code to record a JSON datas to a Oracle Database SELECT NOM, PRENOMS, DATE_NAISS FROM JSON_TABLE('[ { "Id": 123, "Nom": "Toto", "Prenoms": [ "Pascal", "Vincent" ], "DateNaissance": "1983-01-01T00:00:00" }]', '$[*]' COLUMNS ( "NOM" PATH '$.Nom', "PRENOMS" PATH…