FORMAT JSON creates improper JSON

View All Public Scripts Login to Run Script

Script Name FORMAT JSON creates improper JSON
Visibility Unlisted - anyone with the share link can access
Description Even though the "FORMAT JSON" clause is supposed to be optional and have no functional impact the inclusion of it causes the result of json_object to be improper json.
Area SQL General / JSON
Contributor Sean D. Stuber
Created Thursday July 04, 2019

Statement 1

SELECT json_object(KEY 'mykey' VALUE 'myvalue') good_results,  
       json_object(KEY 'mykey' VALUE 'myvalue' FORMAT JSON) bad_results 
FROM DUAL


GOOD_RESULTS BAD_RESULTS
{"mykey":"myvalue"} {"mykey":myvalue}

GOOD_RESULTS	BAD_RESULTS
{"mykey":"myvalue"}	{"mykey":myvalue}

Additional Information