"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
news:400e46ca$0$26118$afc38c87_at_news.optusnet.com.au...
> "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!......
Very.
Received on Wed Jan 21 2004 - 10:31:21 CST
