CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
GMan1973
GMan1973

Reputation: 321

Oracle / SQL Developer displaying (null) in column

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

Answers (1)

Patrick Bacon
Patrick Bacon

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: enter image description 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

Related Questions