Over the next month or so, my posts may slow down a touch.One exciting reason involves this little device pictured. I won’t let too much out of the bag just yet, but an opportunity presented itself and I just had to take it.This means I need to start p…
Last week I had a post reminding us to consider the time component of our date data types.Here I’m just listing some fun with dates, either from single row sql expressions or cool little queries.select sysdate today ,trunc(sysdate) midnight_today ,tr…
A common requirement for queries is to turn rows into columns, or the other way around.In Excel, we can do this using TRANSPOSE, a bit of patience & know-how, and ctrl+shift+enter.In Oracle, if we have aggregate data displaying months by row, the o…
This is one thing I regularly mention to trainees, and recently I fell for the problem myself!Dates may contain a time component.Simple example, some might expect this statement to return a result (as I write this being 1st March) – it does not.select …