1、查看python版本号
2、下载并安装对应python版本的cx_Oracle
搜索地址:https://pypi.python.org/pypi
搜索cx_Oracle,地址:https://pypi.org/project/cx_Oracle/#files
安装轮子文件:
pip install cx_Oracle-8.0.0-cp37-cp37m-win_amd64.whl
3、百度下载instantclient并解压到一个目录下
下载地址:http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
将解压后文件夹中的oci.dll、oraocci12.dll、oraociei12.dll三个文件复制粘贴到python安装目录下的\Lib\site-packages
添加3处环境变量:
ORACLE_HOME=E:\instantclient_12_2
TNS_ADMIN=E:\instantclient_12_2
Path=E:\instantclient_12_2
4、Pycharm->File->Settings->Project Interpreter,点击+号搜索cx-Oracle并安装成功
5、编写代码如下:
import cx_Oracle
conn = cx_Oracle.connect('用户名/密码@服务器IP/服务名')
curs = conn.cursor()
sql = "SELECT * FROM 表名 WHERE CODE='1035'"
rr = curs.execute(sql)
row = curs.fetchone()
print(row[0])
curs.close()
conn.close()
运行结果: