-- Oracle 12c (12.2): Oracle JSON_Object SELECT JSON_OBJECT( KEY 'Department-ID' VALUE qt.dept_id, KEY 'Department-Name' VALUE qt.dept_desc, KEY 'Department-Bldg' VALUE qt.bldg_cd ) AS departments FROM (SELECT 101 dept_id, 'Engineering' dept_desc, 'A01' bldg_cd FROM DUAL UNION SELECT 102 dept_id, 'Finance' dept_desc, 'B01' bldg_cd FROM DUAL UNION SELECT 103 dept_id, 'Human Resource' dept_desc, 'B02' bldg_cd FROM DUAL UNION SELECT 104 dept_id, 'Information Tecnnology' dept_desc, 'A01' bldg_cd FROM DUAL ) qt ;
10356