Dealing with a complex data type?
Or, a nested table?
If you want to see a ‘flat’ view of the data for that bit or a row when browsing a data set that contains that TYPE of data, you’ll want to check this preference.
Using the code sample from OraFaq – thanks folks! – here’s what I mean.
But, if we double-click on the cell…
And after that click…
If we ran this as a SCRIPT (SQL*Plus) Mode…
From the SQL Developer HELP:
Display Struct Value in Grid: Controls how unstructured data types are displayed in the table Data grid. For example, if this option is checked, Oracle Spatial and Graph geometry data is displayed with the full SDO_GEOMETRY definition; but if this option is not checked, each Oracle Spatial and Graph geometry object is displayed as just [MDSYS.SDO_GEOMETRY]
Structure Data In Grid Option ON
Just one less click, we’ll show you the data, in-line, in the cell. It might be hard to read, or go off-screen, so you can still use the single record viewer.
Again, don’t use ANSICONSOLE, and you’ll be fine.