I have a JSON like this, stored in a CLOB column:

So for example

Hi I created a query to generate JSON but I am getting ORA-00935: group function is nested too deeply. I am using Oracle 19c.
Below is the query I wrote but my grouping is somehow repeating.When I use JSON_ARRAYAGG or JSON_OBJECTAGG it gives the above error.I am missing something .Do I have to call the table again?

I am having some issues on extracting data from a field called “JSON” which is a clob inside a table in Oracle SQL.
For example, i have a table called Pippo which has the following data:

“` select JT.* FROM JSON_TABLE (json_sample) ‘$.general[*]’ COLUMNS ( product_key NUMBER PATH ‘$.product_key’, group_subtype_id NUMBER PATH ‘$.group_subtype_id’, group_subtype_name VARCHAR2 ( 100 ) PATH ‘$.group_subtype_name’, variant_id NUMBER PATH ‘$.variant_id’, variant_name VARCHAR2 ( 100 ) PATH ‘$.variant_name’, rb_customer_id NUMBER PATH ‘$.rb_customer_id’, NESTED PATH ‘$.partnumbers[*]’ COLUMNS ( partnumber VARCHAR2 ( 100 ) PATH ‘$.partnumber’, pn_type VARCHAR2 ( 100 […]

I´m trying to create a json file over multiples functions inside a package in oracle sql, i can create the whole json in one single select, but it is a quite big select, so, i want to devide everything into multiple functions.