Thursday, 21 February 2013


Recently had to transform an Oracle SQL Query into a Standard SQL Query. One of the three steps to take was changing the DECODE into a CASE.

DECODE is an Oracle specific function[1].

The case statements, though more standard, are a bit more wordy than the decode statements. As shown in the following, slightly more complex example.


[1] Oracle DECODE
[2] Case and decode two powerfull constructs of sql t181

No comments:

Post a Comment