Suggestion: Better display of LONG, BLOB, CLOB columns?

[guttormvik]

When a query contains one of these column types column, it is always displayed as "<Long>", "<BLOB>" etc in the result list.
Would it be possible to display it as blank if it is null?

I understand a query by default gets a reference for a blob, and then getting the actual blob content is a separate io operation.
That would mean that getting the actual blob content to check the length would be slow, but does the reference maybe contain the length?

Googling, I found this:

OracleBlob (Oracle AI Database JDBC Java API Reference)

boolean	isEmptyLob()	Return true if the lob locator points to an empty blob.

 

[Marco Kalter]

In the SQL Window, null values will be be displayed with a different background color. You can define the color though Preferences > Window Types > SQL Window > "Null value cell color".

 

[guttormvik]

Good to know. The coloring is good for the cases where the value is blanks, but I'd still prefer you to *not* show "<Long>" etc when it is null.
Here is user_tab_cols.data_default for one of my tables. It is not that easy to spot the only one that has a value:

 

[Marco Kalter]

I have added this to the list of enhancement requests.