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

From: roger <rsr_at_rogerware.com>
Date: Mon, 08 Sep 2003 01:30:29 GMT
Message-ID: <Xns93EFBCFDA5C5rsrrogerwarecom@204.127.199.17>

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in news:1062981092.542083 @yasure:

> Go to http://tahiti.oracle.com and look up:
>
> CAST and MULTISET
>
> You should find plenty of examples.
>

All of the examples I find are using cast in the select list, which I can understand just fine.

What I still don't see is how to use cast in order to allow me to use the collection variable with the IN operator in the where clause:

where col IN (collection_variable)

I'm guessing it would be

where col IN ( cast(collection_variable as something) )

but what to use for the "something" part??? Received on Sun Sep 07 2003 - 20:30:29 CDT