Oracle’s DECODE is one of the functions I find more powerful and one that over the years I have used thousands of times to solve several different kinds of problems. Here I’m going to talk a little bit about how… Continue Reading
I have seen quite a few questions on internet forums and knowledge exchange sites about Oracle NVL, NVL2, and COALESCE functions for handling nulls, so I decided to write an article about them today. Those functions are actually similar, but… Continue Reading
Today I installed SQL developer on a machine whose operating system is Windows 8 in Spanish, and SQL Developer got installed in Spanish too :-/ Even though Spanish is my first language, I usually like to have programs installed in… Continue Reading