Recently while doing a little web surfing & blog investigating, I signed up to Oracle Mix and Oracle Community (my profile and profil...

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

Date functions have been ubiquitous within our database for years. For the most part date calculations are robust and can solve many problem...

If you haven't seen the AUSOUG broadcast, PL/SQL guru Steven Feuerstein will conduct a seminar in East Perth on 14th August 2009. If no...

I was playing with google seeing what keywords would return my blog, and I saw Chris Muir mention my presentation on his Twitter feed . Now...

Time for my first on topic Oracle titbit - UNION ALL Take the following example. I had two mutually exclusive tables, fairly flat and uncomp...

Thanks everyone for the great feedback from last night's presentation. I was happy with how it went, even though we were both a little r...