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

roger wrote:

>Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in
>news:sm9nlv4ps0n7elk2t7hd54jdijngc9u43n_at_4ax.com:
>
>
>
>>On Sun, 07 Sep 2003 21:30:35 GMT, roger <rsr_at_rogerware.com> wrote:
>>
>>
>>
>>>Should I be able to do this kind of thing or not?
>>>If so, what is the magic syntax I'm missing?
>>>
>>>
>>The CAST operator
>>
>>
>>Sybrand Bakker, Senior Oracle DBA
>>
>>To reply remove -verwijderdit from my e-mail address
>>
>>
>
>
>I appreciate your response, really I do.
>
>But, if I had any idea of how to apply the cast operator
>in this situation, I'd probably have answered my own question.
>
>Could you give me just a bit of a hint here?
>
>
>Thanks
>
>
>

Go to http://tahiti.oracle.com and look up:

CAST and MULTISET

You should find plenty of examples.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)