Re: IN LIST in PL/SQL

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 21 Jan 2004 15:17:04 -0800
Message-ID: <1074726954.513643@yasure>

Noons wrote:

> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:400D19DC.4D03_at_yahoo.com...
> 

>>You can use a collection type to do this...Something like:
>>
>>type t is table of varchar2(80);
>>
>>declare
>> x t := t('04','08','13');
>>begin
>> for i in (
>> select * from t1
>> where col in (
>> select column_value
>> from table(cast(x as t)) )

> 
> 
> Ni-s-s-s-s-s!......

Brilliant.

-- 
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)

Received on Wed Jan 21 2004 - 17:17:04 CST