RE: how to do a variable in-list of numbers?

A stupid suggestion :

insert into tab2
select col1
from tab1
where col2 in (select you use to build your inlist);

>
>I need to do an insert select of the form
>
>insert into tab2
>select col1
>from tab1
>where col2 in (inlist of numbers);
>
>I do not know how many values will be in my inlist
>at runtime. With strings I just build a big string.
>How do I build an 'inlist' of numbers at runtime?
>
>Im using a cursor to determine which values need to
>be added to my inlist. I think I can do some kind
>of cast, but im not familiar with it.
>
>Im on 8i. I do not want to j ust run this inside my
>cursor. It could then execute 300-400 times and
>will run all day.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).