Is it possible to set SQL/JSON queries to return clob as default
Hi,
I'm using Oracle DB 19c (19.0.0.0.0) SQL/JSON queries in PL/SQL: json_arrayagg, json_object etc. with large quantity of nested data and need to set the "returning clob" option everywhere.
Is there any way to set the default json_* function to return clobs?
select json_serialize( json_arrayagg( json_object( 'id' value name, 'doc' value doc returning clob ) returning clob ) returning clob pretty) select * from mytable