python迴圈插入資料 oracle

標籤：io   os   for   資料   on   cti   代碼   ef   python   

python連結oracle，要安裝cx_Oracle

代碼：

#-*-coding=utf-8
import cx_Oracle
import math

Comn=cx_Oracle.Connection(‘system/[email protected]/orcl‘)

Cur=Comn.cursor()
for i in range(1, 100):
　　Cur.execute("insert into business_reconciliation_tbl(id,merchant_name,settle_money,is_del,state,merchant_id) values(‘%s‘,‘%s‘,‘%s‘,‘%s‘,‘%s‘,‘%s‘)" %(i, "test01","100","0","0","EFB8B43400D549EA919431AA85FEE0E4"))
　　Comn.commit()

Cur.close()
Comn.close()

python迴圈插入資料 oracle