Decode / Case in IN_LIST

Is there a way to use the decode() or case() function in an IN_LIST and pass a list of values?

Basically the psudo code is:

select ... from ...
where column in (if a then everything, else :value_list)

Has anyone tried this successfully? Received on Tue Dec 10 2002 - 09:17:57 CST