The Powerful Oracle DECODE Function

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 it works, and will show you some interesting ways to… Read more »

Using NVL to add optional conditions to your queries

The NVL function is very useful in a lot of different situations  and is probably one of the most widely used among Oracle developers. One of the ways we can use it is to write queries that have ‘optional’ conditions.  How so?  I mean, queries that sometimes might need to be… 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 »