Hello list,
When using 'decode' is it possible to combine 2 different search
values into 1
e.g
decode(a.country, 'CH', di.identity,'JA', di.identity, de.identity)
it would be nice to say something like
decode(a.country, 'CH or JA', di.identity, de.identity)
I'm not suggesting that that is the correct syntax, but is it
possible, like it would be in a 'case' statement to give the result
for 2 values, an either or, rather than having to explicitly give the
result for each value. i can't find any examples of this.
This is Oracle 8.1.3, by the way, I know there's something else you
can use instead of DECODE, in Oracle 9.
Many thanks in advance
David