Database Administration (MOSC)

MOSC Banner

loading and accessing JSON , help Oracle

in Database Administration (MOSC) Question

I'm having trouble reading JSON nested arrays in : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production // Linux

I can load JSON data file into a CLOB and access most of the elements , except nested arrays. APEX tool (19.2) will NOT handle this and is very limited, that is can not handle nested complex arrays/lists (tried this in 11g). Thought moving to oracle 12c would solve this problem and has for the most part except for complex nesting it appears. Below is an example of JSON:

{"elements":2,"elmvalues":[

{"filter":"group1","points":[["1635379200","0.0"],["1635382800","0.0"]],"properties":{"city":"MyCity","part":"Null0","name":"CIn","sitename":"MYSITEH01","custacct":"CUST1","device":"DEVICE1"}},

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center