本示例使用pandas+cx_Oracle完成数据的读取和插入,一开始是想尝试pd.to_sql方法,但是需要借助sqlalchemy,因此本示例单纯使用cx_Oracle
import pandas as pd
import cx_Oracle as cx
conn = cx.connect('user_name/password@hostname:port/service_name')
sql = 'select * from test'
data = pd.read_sql(sql, con=conn)
# 这里可以对数据进行操作
result = data.values.tolist()
insert_sql = 'insert into test2 (field_1, field_2, field_3) values (:1, :2, :3)'
cur = conn.cursor()
cur.executemany(insert_sql, result)
conn.commit()
conn.close()