February 19, 2013 by Joris Visscher

Mark or colour NULL values in SQL Developer

By default SQL Developer shows null values in the following way:

Screenshot - SQL Developer - Default Null value — Screenshot – SQL Developer – Default Null value

This is not very notable, so we’ll change it to the following markup:

Screenshot - SQL Developer - What an awesome NULL color! — Screenshot – SQL Developer – What an awesome NULL color!

To do this, we need to go to Preferences – Database – Advanced and change the value for “Display Null Using Background Color”

Screenshot - SQL Developer - Settings for colouring NULL values — Screenshot – SQL Developer – Settings for colouring NULL values

Related

3 Replies to “Mark or colour NULL values in SQL Developer”

JC says:

February 15, 2018 at 6:18 pm

Thanks so much

Reply
Anu says:

February 28, 2019 at 11:49 am

Super. It works.

Reply
Anu says:

February 28, 2019 at 11:51 am

Good work. It works.tqsm.

Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.