I'm a big fan of generating data with dual, using a perk of the connect by syntax. I think Tom Kyte was the originator of this techniq...

I've been having a bit of a play with the Oracle 12c database over the past few days and I thought I'd mention a gotcha I encountere...

When creating LOVs for APEX I sometimes debate to myself whether to make a static or dynamic LOV. I had one scenario where having some SQL...

This one's real quick - something handy for later. I've done some similar before for all days/weekends of the year, or the ubiquit...

I had an interesting SQL problem at work recently, and I came up with a solution that I'm not sure is completely ideal - so I thought I...

OK, this post is partially for my benefit because I'm sure in future I'll need to re-think how this works - and I'll want the ba...

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...

Through general experience I've found the WITH statement either underutilised or people haven't been aware of it's existence, a...