前期准备下载好文件instantclient-basic-windows.x64-12.2.0.1.0instantclient_12_2的文件:
安装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