The issue when I don't use AGG type I get a 'ora-01422: exact fetch returns more than requested number of rows using a json_object put into clob so using JSON_ARRAYAGG works I just haven't been able to figure out how…
{ "a": [ { "b": { "c": [ { "id": "123" } ], "d": { "e": { "f": [ { "name": "abc", "type": "in" }, { "name": "xyz", "type": "out" } ] } } } }, { "b": { "c":…
I am trying to create a JSON output but it is displayed truncated. Table creation and inserts: create table test(c1 number, c2 varchar2(10), c3 varchar2(100)); begin for i in 1 .. 1000 loop insert into test values (i, 'val_' ||…
SELECT key1, key2, JSON_ARRAYAGG(foo) foo, JSON_ARRAYAGG(bar) bar FROM ( select 1 as key1, 2 as key2, '1.0' as foo, 'A' as bar from dual UNION select 1, 2, '2.0' , 'A' as bar from dual UNION select 3, 4, '2.0'…
In my PostgreSQL table I have a parts column of type json. I want to check if the given argument is contained in my json column. This query works in the database: select * from elements we where parts::text like…