Reputation: 321
I have any oracle table that sometimes has valid null values is some cells. In SQL Developer it displays in the null cell as (null). This is not a problem but in a grid I have on a jsp page is also displays as (null) and I need it just to be blank. NVL does not work unless I use a space. I was wondering if there is an oracle setting or something to have valid null cells just be blank ? thank you
Upvotes: 3
Views: 15221
Reputation: 4660
Modifying SQL Developer Preferences
Jeff Smith, the product manager for SQL Developer, blogged about this here, http://www.thatjeffsmith.com.
Just navigate to the SQL Developer tool bar as follows:
Preferences>Database>Advanced
and change the value in the field, "Display Null Value As", to nothing as seen here:
~~~~~~~~~~~~~~~~~~~~~~~~~~
With a jsp, one could create a method for scenarios where a column is null (to display the null as other than '(null)').
Upvotes: 13