ThatJeffSmith

Oracle SQL Developer: Display Structured Value In Grid

Tell Others About This Story:

Dealing with a complex data type?

Say, XML?

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.

We  just see the type NAMES.

We just see the type NAMES.

But, if we double-click on the cell…

Now click the pencil.

Now click the pencil.

And after that click…

our 'records' from the nested table

our ‘records’ from the nested table

If we ran this as a SCRIPT (SQL*Plus) Mode…

Don't use SQLFORMAT ANSICONSOLE

Don’t use SQLFORMAT ANSICONSOLE

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.

You can always double-click on the cell to get to the complex type editor/viewers - like you do for BLOBs.

You can always double-click on the cell to get to the complex type editor/viewers – like you do for BLOBs.

And SQLcl?

Again, don’t use ANSICONSOLE, and you’ll be fine.

ta..da

ta..da

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Similar Posts by Content Area: , , , ,