1.查看要连接的oracle版本号
select * from v$version;
2.下载对应的oracle客户端,一定要下载对应的客户端,不然会报错,64位下载64位的客户端,oracle版本号也要对应
如上面要连接的版本号为 Version 12.2.0.1.0 - Production,下载时也应下载Version 12.2.0.1.0
下载地址:https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
3.将下载后的文件解压,放在Python\Python36\Lib\site-packages,并将Python\Python36\Lib\site-packages\instantclient_12_2加入环境变量
4.安装cx-Oracle包.地址:http://cx-oracle.sourceforge.net/
pip install cx-Oracle
5.连接oracle
import cx_Oracle '''方法一:用户名、密码和监听写在一起''' db = cx_Oracle.connect('username/password@host/orcl') '''方法二:用户名、密码和监听分开写''' db = cx_Oracle.connect('username','password','host/orcl') '''方法三:配置监听并连接''' tns = cx_Oracle.makedsn('host',1521,'orcl') db = cx_Oracle.connect('username','password',tns)
#创建光标 mycursor=conn.cursor()
查询: sql = '''SELECT * FROM TABLE'''
mycursor.execute(sql) #执行SQL
result= mycursor.fetchall() # fetchall() 获取所有记录,result类型为list
for i in result: print(i)