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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
