Forum OpenACS Q&A: Re: decode vs case

3: Re: decode vs case (response to 1)
Posted by Ola Hansson on
I believe we should encourage/recommend the use of CASE in Oracle too (instead of DECODE), since it increases the chance that one common query file is enough. And also because it is SQL 92 ...

In my experience, at least, it works on 8.1.7. Don't know about older versions.

4: Re: decode vs case (response to 3)
Posted by Jarkko Laine on
I agree with you Ola, though I'm not an experienced Oracle programmer. The purpose of a CASE block is IMHO even easier to understand than decode when you read someone other's code.