Re: [cx-oracle-users] INSERT examples

[Fawcett, D. (MPCA) <Dav...@st...>]

If the data is really coming from one table and going unmodified into another table, couldn't you do something like this?

curs1.execute("""insert into emp2 select * from emp""")
db.commit()


-----Original Message-----
From: Robert [mailto:web...@gm...] 
Sent: Thursday, June 17, 2010 11:38 AM
To: cx-...@li...
Subject: [cx-oracle-users] INSERT examples

Given this:
curs1.execute("""select * from emp""")
result_set = curs1.fetchall()

can someone please provide me with sample code to INSERT into emp2
with "result_set" ?

thanks

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users