python连接oracle

安装数据库资源包：pip install cx_Oracle

连接查询例子：

import cx_Oracle

tns=cx_Oracle.makedns("192.168.0.238","1521","orcl")

db=cx_Oracle.connect("QAS_R_HNSW","raymon",tns)

cu=db.cursor()

cu.execute("select * from T_E_ROLE")

o=cu.fetchone()

print(o)

t=cu.fetchmany(2)

print(t[0],t[1])

a=cu.fetchall()

for row in a:

    print(row)

cu.close()
db.close()