Insert blob data from one db to other db in oracle
Murthy Jn
murthy919 at gmail.com
Tue Feb 28 08:00:42 EST 2017
I have the table structure in one db is number,photo,date,name.
the same structure is there in other database in other machine.
I want to insert table1 data from db1 into table2 in db2 using python script.
Some one could please help me in this.. I have tried like below.
for fetching rows
db connection
cur=db.cursor()
SqlFth="select no,photo,date,name from table1;
cur.execute(SqlFth)
res=cur.fetchall()
rows=[]
for row in res:
no,photo,date,name=row
rows.append(row)
n1= row[0]
f1=row[1]
d1=row[1]
na1=row[2]
for inserting to other db:
SqlStr="insert into test (no,photo,date,name) values(:n1,:f1,:d1,:na1)"
print SqlStr
cur.executemany(SqlStr,rows)
res1=cur.fetchone()
cur.execute("commit")
Please help me in this...
More information about the Python-list
mailing list