Re: IN LIST in PL/SQL

"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!......

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam