静默之堂,海上钢琴师qvod,宋密秋
python对oracle数据库的操作用cx_oracle库
操作简单,例如
#例子
import cx_oracle
con = cx_oracle.connect("pythondemo/welcome@192.168.188.11:1521/std1")
cur = con.cursor()
rows = [ (1, "first" ), (2, "second" ),
(3, "third" ), (4, "fourth" ),
(5, "fifth" ), (6, "sixth" ),
(7, "seventh" ) ]
cur.execute("truncate table mytab")
cur.executemany("insert into mytab(id, data) values (:1, :2)", rows)
con.commit()
cur.execute('select * from mytab')
res = cur.fetchall()
print(res)
cur.close()
con.close()
例2
import pandas as pd
import cx_oracle
con = cx_oracle.connect("scott","tiger","192.0.2.21:1521/std1")
d = pd.read_sql('select * from emp',con)
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Python 实现将numpy中的nan和inf,nan替换成对应的均值
python爬虫把url链接编码成gbk2312格式过程解析
网友评论