Hi,
We are getting a set of result from a API call in JSON response.
How can I get the value and map with FSM field?
Currently I am using subtring function to achieve.But when the tag repeats, it creates a problem.
Any quick help regarding this.
Question
Retrieve data from JSON response
+19Oracle Database can process JSON natively. You may need a full license of the Oracle Database software, since creating your own tables is usually not something you can do with an ASFU license.
Attached is some SQL showing how this might work.
The column constraint is not merely a constraint but also a flag that changes the logical behavior of the subsequent SELECT query. This is why this won’t work on a native CLOB you might find in the existing application.
If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.