RSA Scripts

Pretty print json in PLSQL

select json_serialize(JSON_FIELD RETURNING clob pretty) as JSON_RESULT from [TABLE NAME]

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

Last updated:

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

Back to results

select json_serialize(JSON_FIELD RETURNING clob pretty) as JSON_RESULT
  from [TABLE NAME]