The other day I was writing a query for my Apex application and I required an outer join. In this case I decided to use the ANSI syntax, and...

Recently I came across a scenario where I thought "say, a full outer join might hit the spot here" It was a simple problem - we ...

Many years ago when I was first learning Oracle (in the deep end) I came by the problem of data densification. I can't remember how I so...