python连接oracle12c

pip install  whl文件路径

python
>> import sys
>> sys.path
查看\Python\\Python36\\lib\\site-packages
然后把 依赖包中的 第二个压缩包解压后的文件复制到 site-packages
![在这里插入图片描述](https://ucc.alicdn.com/images/user-upload-01/20191206151343651.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMzczNjA4,size_16,color_FFFFFF,t_70)
把instantclient_12_2中的dll文件复制到 site-packages中
或者配置环境变量也可以，但是有点麻烦

import cx_Oracle
db = cx_Oracle.connect('system', 'oracle', 'localhost:1521/XE')
cursor=db.cursor()
sql="select * from user20153442.emp"
cursor.execute(sql)

result=cursor.fetchall()
for row in result:
  print(row)
cursor.close()
db.close()