For all those pushing data around, especially dirty data, this one is for you. Today I was preparing to process data I loaded from a sprea...

This post is one of a series on what I learned while not at Kscope18. Dimitri mentioned that he learned about the ANSI date format that a...

SQL Analytics provides a fairly simple mechanism for determining positional rank within a set of results. Before I demonstrate that query ...

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

Back in my Oracle Forms days, we had a library function associated with our date fields that accepted a value of "t", which then r...

Awareness is fantastic. I was aware that somehow in Oracle you could transform a number value into words. I googled a similar phrase and f...

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

This is one thing I regularly mention to trainees, and recently I fell for the problem myself! Dates may contain a time component. Simpl...

Sometimes I stumble across little features that after a moment I realise - hey, that wasn't in the last version. It's good to see th...

This is just a little ditty to remind me which date format mask is more tolerant. SQL> select to_date('21-03-2011','dd-mon-...

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