We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
G-4220: Try to use CASE rather than DECODE.
If the formatting of the 'bad' example was changed to this, then it isn't quite as bad...
SELECT DECODE(dummy, 'X', 1 , 'Y', 2 , 'Z', 3 , 0) FROM dual;