python连接oracle数据库

准备下载版本                                                                                                        

instantclient                                                                                                         

https://www.oracle.com/technetwork/topics/winx64soft-089540.html                                                                                                    

cx-oracle                                                                                                               

https://pypi.org/project/cx-Oracle/#files                                                                                                         

python                                                                                                    

https://www.python.org/downloads/                                                                                                              

                                                                                                               

注意点                                                                                                     

oracle数据库版本和instantclient保持一致                                                                                                    

python版本和cx-oracle保持一致                                                                                                     

安装步骤                                                                                                               

1.解压instantclient到合适的路径下，并把该路径添加到环境变量里                                                                                                        

              例如D:\python\connectapi\instantclient_11_2                                                                                          

2.把tnsnames.ora放入instantclient_11_2解压路径下                                                                                                             

3.把instantclient_11_2里的 oci.dll oraocci11.dll oraociei11.dll 复制到python安装路径下

              例如D:\python\Lib\site-packages                                                                                                        

4.用pip安装cx-oracle                                                                                                        

              使用pip命令前需配置环境变量，例如D:\python\Scripts;                                                                                         

              pip.exe   install    cx_Oracle-7.1.0-cp37-cp37m-win_amd64.whl                                                                   

测试 

#!/user/bin/python3
import cx_Oracle 
conn=cx_Oracle.connect('用户名','密码', 'host:port/database')  
print('sucess!')
cur=conn.cursor()
#sql1='ALTER SESSION SET nls_language =\'japanese\''
#cur.execute(sql1)
sql='''
select * from emp_1
'''
cur.execute(sql)
rs=cur.fetchall()
for x in rs:
 print(x)
cur.close()
conn.close()