The WITH clause to the rescue!

This time I’m just writing to tell you a story about the WITH clause, because it is really powerful and vastly underutilized. You can read the basics about the WITH clause in my previous article about subqueries. So, this is the story about how it helped my brother and me,… Read more »

Oracle NVL, NVL2 and COALESCE functions

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 knowing what differentiates them from each other can help you… Read more »

How to change Oracle SQL Developer language

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 English  because, among other things, it is usually easier to… Read more »