In a query with column defined as so:
I get this warning:
It's notorious the fact that `DECODE` is terrible for readability. This one is kind of fine, but if you have a lot of branches, it's almost impossible to know what is what or if there is an else or not, and `CASE` is immediately recognisable by developers without SQL knowledge trying to debug some issue
The only real reason in favour of `DECODE` in my opinion is when you need to test `NULL`, as the `CASE` in the format used in the screenshot can't deal with that...
So, just being curious here... What's the reasoning for recommending `DECODE` instead of `CASE`? Maybe I'm missing something and start using `DECODE` more