select JSON_OBJECT( 
           KEY 'objects' VALUE 
               (SELECT JSON_ARRAYAGG( 
                         JSON_OBJECT( 
                           KEY 'object_type' VALUE object_type, 
                           KEY 'object_name' VALUE object_name 
                         ) 
                       ) 
                FROM   all_objects 
               ) 
         ) 
  from dual