Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IN LIST in PL/SQL

Re: IN LIST in PL/SQL

From: Haximus <14356256546_at_spam.org>
Date: Wed, 21 Jan 2004 16:31:21 GMT
Message-ID: <tPxPb.209259$X%5.147934@pd7tw2no>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US