Skip to main content

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.

Oracle 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.

Reply


Terms & ConditionsCookie settings