Simple scripts

Since many of my customers are fairly hot on security I’m often banned from plugging USB drives into local PCs, or getting my laptop onto the local network, or downloading from the Internet, so more »

NULL is not zero!

Some time ago I wrote a post about how COUNT(*) and COUNT(column) are semantically different things (link). Such queries may return different results if the column counted has NULLs in it. And the difference comes from that NULL is not a value, it’s rather a state which says “value unknown” or “no value entered”.So, you better understand how NULLs interact with your SQL constructs if you call yourself a DBA or a database developer ;-) more »

Hot Oracle-Related Search Engine Terms For 2009? Carry On Wayward Googler!

2009 is drawing to a close so I just took a gander at the year-end search term statistics for my blog. It?s interesting to see the search terms that send readers to this blog. Some are surprising, others not so surprising. So, for trivial pursuit sake, the following list shows the top 50 search terms more »