sql – J. Hunter Johnson LLC

April 6, 2013 Hunter

Transforming mostly static data to date ranges

I recently had to transform a set of data from typical date & measurement to a more compact date range & measurement format. The data in this case was very static: as the date incremented, the measurement was much more likely to be remain the same than it was to change. So storing the starting […]

Read article

February 5, 2013 Hunter

Decoding SQL’s Decode

I came across a SQL function I was not familiar with: decode. I looked it up and immediately replaced it with a CASE statement (in addition to other code cleanup). I’m afraid I don’t understand the existence of Oracle SQL’s decode() function: decode(expression, search, result [, search , result]… [, default] ) seems functionally equivalent […]

Read article