1.安装cx_Oracle
pip install cx_Oracle
2.数据库查询
host = "192.x.x.x" #数据库ip
port = "1521" #端口
sid = "xx" #服务名
dsn = cx_Oracle.makedsn(host, port, sid)
conn = cx_Oracle.connect("user", "password", dsn)
sql = 'select * from test'
results = pd.read_sql(sql,conn)
conn.close
print(results)