Re: [cx-oracle-users] INSERT examples

[Mark H. <mh...@pi...>]

On 6/17/10 9:38 AM, Robert wrote:
> 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" ?

here's one way...  cx_Experts, any nice shorthand for :1,:2,:3,...?

curs1.execute('select empno,ename,job,mgr,hiredate,sal,comm,deptno from emp')

for row in curs1:
     curs2.execute('insert into emp2(empno,ename,job,mgr,hiredate,sal,comm,deptno) values (:1,:2,:3,:4,:5,:6,:7,:8)',row)