Re: select ... where col in (collection)

roger wrote:
<snip>
> Well, the answer to my question seems to be to
> do something like this:
>
> where col in (select column_value from table(collection_variable) )

As silly as it might seem, you have to cast the variable to it's own type to make this work ...

... where user_id in
(select column_value from table(cast(cvar as numtab))))

Richard Kuhler Received on Mon Sep 08 2003 - 15:08:58 CDT