1.安裝cx_Oracle
pip install cx_Oracle
2.數(shù)據(jù)庫查詢
host = "192.x.x.x" #數(shù)據(jù)庫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)
