Connect python to the oracle database in windows and pythonoracle

Connect python to the oracle database in windows and pythonoracle

The following describes how to connect python to an oracle database:

1. First install the cx_Oracle package
2.decompress instantclient-basic-windows.x64-11.2.0.4.0.zip to c: \ oracle
3. Copy all. dll files under instantclient_11_2 to c: \ python34 \ Lib \ site-packages \ (copy them to the corresponding site-packages folder based on your python version)

Python connection sample code:

#-*-Coding: UTF-8-*-import cx_Oracleconn = cx_Oracle.connect ('reporter ', 'Password', 'localhost: 1521/ORCL') cursor = conn. cursor () SQL = "select * from test" cursor.exe cute (SQL) data = cursor. fetchall () print (data) cursor. close () conn. commit () conn. close ()

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.