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

There are APEX dictionary views for most of the data that represents the 'source' that is your APEX application meta-data. Note:  ...

I don't care what you all think , this is my blog, and I continue to laugh at this SQL joke. select column_value from apex_string.spli...

As a science aficionado, there are certain phrases that ... catch the eye. Recently on twitter there was an interesting thread that conti...

A common follow up clarification on forums is regarding the version of the relevant tool. Questions relating to Oracle APEX could be impact...

Back in around 2005, before the time of smart phones, I had some data. I can't remember what the data was, but I was told that for it ...

You've probably seen this somewhere already, no doubt from Connor, though I couldn't find much beyond Tim's post on pipelined f...

One of my favourite SQL analytic functions is row_number() , and I've used it in the past to identify, then remove duplicates. In this...

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

Last year I described a simple test case that described how to remove outliers from a fictional dataset using the STDDEV() analytical functi...

We have an application written with a heavily customised Theme 25 built for 10" tablets, and we feel the Universal Theme justifies the ...

Our office kitchen is unavailable this Friday, so the call was put out for pub lunch. After a couple of replies I decided to enter my repl...

A colleague asked me about removing outliers from reports and I knew just the function to give a go. Some time ago I had to prove that som...

I've been following the LISTAGG problem for a while because I find the function useful. The problem being this error: ORA-01489: res...

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

Chris Saxon from the Developer Advocates group asked the following question on Twitter. What three things do you think every developer m...

Saddened but not surprised to see COALESCE lagging behind NVL. Weekend #SQL poll: when mapping binds/columns that could contain nulls to...

I came across the need for an UNPIVOT today that require fairly basic syntax, so this is me noting it for later. A single column unpivot, no...

In about 22 hours I'll be talking with Oracle Developer Advocate (or the southern/eastern hemisphere AskTom adjunct)  Connor McDonald a...

In looking for information on pivoting variable number of columns, I stumbled across a question I once managed to AskTom, many moons ago. h...