SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

3 months ago

Turn the output of Oracle #SQL queries into #JSON with JSON_OBJECT JSON_OBJECT_AGG JSON_ARRAY JSON_ARRAY_AGG e.g. SELECT JSON_OBJECT ( 'key' VALUE JSON_ARRAYAGG ( ... ) ) FROM ... These return JSON objects and arrays; the _AGG versions group rows into one document

Turn the output of Oracle #SQL queries into #JSON with JSON_OBJECT JSON_OBJECT_AGG JSON_ARRAY JSON_ARRAY_AGG e.g. SELECT JSON_OBJECT ( 'key' VALUE JSON_ARRAYAGG ( ... ) ) FROM ... These return JSON objects and arrays; the _AGG versions group rows into one document