ThatJeffSmith

30 SQL Developer Tips in 30 Days, Day 18: NULLs

Tell Others About This Story:

This post was almost NULL – I was deep in Power Point mode for Open World, and almost forgot to write today’s post! Also, another admission: I said back on Day 1 of this series, that I was planning on doing 5000 push-ups this month as well. Well, I gave up on that a few days ago. I’m still pushing them out, but 5,000 ain’t going to happen – sorry Philip!

Ok, conscience clean – onto today’s post…

Working with the absence of data can be a pain. Forget the logic bits when it comes to SQL and maths – just looking at records, it can be hard to tell when you’re seeing strings with spaces vs NULL strings.

So, SQL Developer wants to make that easier on you and your eyes.

This can also be a good way to get a chuckle out of your audience when doing presentations.

This can also be a good way to get a chuckle out of your audience when doing presentations.

To the Preferences!

Note: the display background color preference currently doesn't play nice if you have the 'Grid in Zebra...' preference enabled. We're working on that :)

Note: this option currently doesn’t play nice if you have the ‘Grid in Zebra…’ preference enabled. We’re working on that 🙂

Look, every post can’t be a huge, awesome thing like yesterday’s SSH Tunneling post. But this feature has saved me some headaches, more than a few times.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Similar Posts by Content Area: , , ,