[cx-oracle-users] BULK Insert ?
Brought to you by:
atuining
From: Robert <web...@gm...> - 2010-09-21 18:14:11
|
Given a result set, does cx_oracle provide a way to "bulk insert" the result set rather than what I'm doing below (one-by-one Inserts) ? ssresult_set = sscursor.fetchall() # This is a pyodbc result set, same stucture as that of cx_oracle if len(ssresult_set) > 0: try: for row in ssresult_set: oracursor2.execute('''insert into ........snip......''', row) |