RSA Scripts

Display formatted JSON

  1. Oracle
  2. JSON
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

JSON_REQUEST - Column name (Clob)
JSON_RESPONSE - Column name (Clob)
RETURNING clob - Choosing the result set type. Optional
PRETTY - Syntax

The function json_serialize return the result set as varchar2(4000). This is the default.

 

select json_serialize(JSON_REQUEST RETURNING clob pretty) as JSON_REQUEST,
          json_serialize(JSON_RESPONSE RETURNING clob pretty) as JSON_RESPONSE
  from ONLINE_API_JSON;

 

The result set will be display "Pretty" in multi lines.