Thursday Thought – Busy busy busy

Database Applications Development
| May 17, 2012 05:50 +0000

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…

More fun with dates

Database Applications Development
| May 16, 2012 16:08 +0000

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…

Oracle PIVOT

Database Applications Development
| May 15, 2012 18:00 +0000

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…

Remember date contains time

Database Applications Development
| May 9, 2012 06:59 +0000

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 …