Oracle+Python命令操作

          前期准备下载好文件instantclient-basic-windows.x64-12.2.0.1.0instantclient_12_2的文件:

Oracle+Python命令操作

      安装pip install cx_Oracle                        

1  import cx_Oracle  
2  cx_Oracle.init_oracle_client(lib_dir=r"D:Oracleinstantclient-basic-windows.x64-12.2.0.1.0instantclient_12_2")
3 db=cx_Oracle.connect('user','password','db')
4 cursor = connection.cursor()
5 print(db.version)   

参考:https://developer.oracle.com/dsl/prez-python-queries.html