Forum Discussion

ashis1upreti's avatar
ashis1upreti
New Contributor II
2 years ago

Grab each object from array and insert whole JSON object as a string (VARCHAR) in DB

Hello, can someone please help with this? I was to extract each of the { "securityAlt":[...], "security":[...]} section out of the main array, and store each record on oracle table under a field. So for this below example, I want to insert the 12 objects from the main array in my ORACLE table.

 

 

 

2 Replies

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    2 years ago
    Copy LinkReport

    Hello ashis1upreti,

    Could you please provide additional details regarding the input and the desired output? That would help us better understand the context and requirements.

    An example input and example expected output data would be a great starting point!