Oracle / SQL Developer displaying (null) in column

Question

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

Patrick Bacon · Accepted Answer · 2015-07-10 22:31:18Z

13

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)').

edited Jul 10, 2015 at 22:31

answered Jul 10, 2015 at 20:43

Patrick Bacon

4,7101 gold badge31 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

GMan1973 Over a year ago

this did fix it in sql developer but it still displays the same way on the form (null). Is there a setting in oracle to fix this?

Patrick Bacon Over a year ago

I would just add a method to address nulls with the jsp.

Collectives™ on Stack Overflow

Oracle / SQL Developer displaying (null) in column

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related