where something IN decode

Folks,

Can this be done in Oracle 8i?

select * from dual
where 0 in DECODE(0,0,(0,1),1)

I get missing right parenthesis.

Thanks,
Zzesers Received on Tue Jan 22 2002 - 08:23:03 CST