python + cx_oracle 向oracle 表中插数据

一条条插数据

import cx_Oracle

import numpy as np



conn = cx_Oracle.connect('user/passwd@host/instance')

c = conn.cursor()



x = np.arange(9).reshape((3,3))   # ndarray

z=x.tolist()  # ndarray to list

b=[[v] for v in z]

for i in range(10):

   c.execute('insert into sales_table (X1,X2) values(:1,:2)',(b[i][0],b[i][1]))



conn.commit()

c.close()

conn.close()

批量插入数据

sql_ins='insert into sales_table (x1,x2) values (:1,:2)'

# 注意(:1,:2)和(:2,:1)一样， :1 是b的第一列，b的列数要和变量数一致

# pg库写法：

# sql_ins='insert into sales_table (x1,x2) values (%s,%s)'

c.executemany(sql_ins,b)

c.execute('commit')



conn.commit()

c.close()

conn.close()