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

[ashis1upreti]

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.

[AleksandarAngel]

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!

[ashis1upreti]

@AleksandarAngel thanks for taking time to read the question and reaching out. I however was able to figure it out by using a mapper. 

Thanks anyways. have a good day!