In re-working some old reports that I'm still maintaining, I decided to clean up instances of "WHERE foo > bar or foo is null" with some LNNVL() loving. Given the nature of my query and of LNNVL(), I plugged in LNNVL(foo > bar) and prefaced it with a NOT, since...
[Read More]
I have not yet begun to fight!
So sayeth John Paul Jones (not this one), so sayeth I.I've been taking steps to make sure my developers know of the many benefits of using bind variables, and the punishments for not using bind variables. This is paying off in the newer code coming out, but it will take...
[Read More]
PGA: Not just for Caddyshack 2 fans
Ahh ... Jackie Mason. The poor man's Rodney Dangerfield. The pride of Sheboygan, Wisconsin (other than meat products).But, no, today I'm not talking about golf (nor will I ever, if I can help it). I'm talking about Oracle's PGA, the Program Global Area. The PGA is a private chunk of...
[Read More]
IT'S THE JOIN[T]!
See what I did there? 5 points to anyone who can name the reference. 10 points if you can name the original reference that I wasn't even thinking of. Void where prohibited.Sachin, broadcasting live from his blog Oracle Online Help, has posted a nice primer on the differences between three...
[Read More]
I'm on the clock ...
Padraig O'Sullivan has posted the latest edition of Pythian's Log Buffer, a weekly recap of Oracle blogger activity. The Pythian Group has been letting various bloggers host the Log Buffer from week-to-week. This next week (ending 6 April), I'll be hosting the Log Buffer. This also means I'll have to...
[Read More]