Kayshav.com
About Developer Oracle 19c Oracle 12c Technology Information Sitemap

Oracle JSON_OBJECTAGG
-- JSON Function: JSON_OBJECTAGG

SELECT
  JSON_OBJECTAGG(
          KEY  ref_desc
          VALUE  ref_id)  JSON_OBJECTAGG_
FROM
 (SELECT
    level*10  ref_id,
    TO_CHAR(TO_DATE(level*10,'J'),'JSP') ref_desc  
  FROM  DUAL
  CONNECT BY level < 5)
;


JSON_OBJECTAGG



  Oracle 19c Index   Oracle Functions

  JSON_ARRAY   JSON_ARRAYAGG

  JSON_OBJECT   JSON_SERIALIZE   JSON_TABLE   JSON Updates

  Lower Versions   11g Index   12c Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: January 27th, 2023

  5052