編輯時間2018-05-28
下載依賴包cx_Oracle 驅(qū)動包
conda info??cx_Oracle?
conda install?cx_Oracle
鏈接oracel 語句
import cx_Oracleas db
import os
os.environ['NLS_LANG'] ='SIMPLIFIED CHINESE_CHINA.UTF8'
def queryOracle(sql):
? ?username ="AI_ROAD_CLASSIFY"
? ? passwd ="AI_ROAD_CLASSIFY"
? ? host ="192.168.0.215"
? ? port ="1521"
? ? serverName ="orcl"
? ? dsn = db.makedsn(host, port, serverName)
con = db.connect(username, passwd, dsn)
cur = con.cursor()
cur.execute(sql)
result = cur.fetchall()
cur.close()
con.close()
return result
if __name__ =="__main__":
? ?sql ="select sysdate from dual"
? ? result = queryOracle(sql)
print result
