DPSQLStudio — JSON & XML Columns

Structured text, made readable

Plenty of Oracle tables stash JSON or XML in a CLOB column. In a plain grid those cells are a single unreadable line. DPSQLStudio gives every long-text cell an Edit window that pretty-prints the content — indented, scrollable, and editable with a write-back. Screenshots are from the live app (v0.1.0 Beta) on Oracle as ADMIN@dpsqltest_high.

1. JSON in a CLOB

The DOC_STORE table keeps a JSON document per row in BODY_CLOB. In the grid it’s one long line; the status bar hints “this CLOB column holds long text — double-click the cell to read it all.”

Double-click and the Edit BODY_CLOB window opens the JSON indented and navigable. Edit it and Save writes the change back to the row:

2. XML in a CLOB

Same idea for XML. The XML_DEMO table stores documents in BODY_XML — orders, a book catalogue, and so on:

The editor indents the XML so the structure is obvious — elements, attributes, and nesting all laid out:

It’s the same viewer plumbing for both formats: detect long text, format it for reading, and let you write it back — so a JSON/XML-heavy schema stays browsable from the grid instead of needing a separate editor.

Coming up

Next: a tour of the full Data menu and Preferences — including the eight editor themes and the light ↔ dark switch.

DPSQLStudio v0.1.0 (Beta) — a free Oracle SQL client for Windows. Screenshots are from the live app; demo data is fictional.

Comments (0)