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)