CODEWITHSUNDEEP
python-3.xoracle-sqldeveloperpypyodbc
Santhosh
Santhosh

Reputation: 579

Connect OracleDB in Python

I need to connect Oracle DB and run scripts in Python but not sure how to do it. I currently use Oracle SQL Developer to run my queries. Please help, Attached screen shot has connection details from Oracle SQL Developer. enter image description here

Upvotes: 3

Views: 12940

Answers (1)

Jesus Peralta
Jesus Peralta

Reputation: 681

In the oracle web site there is a good tutorial that helped me a lot: Tutorial: Using Python with Oracle Database 11g.

I had to import the cx_Oracle library and I write the follow code:

import cx_Oracle

connection = cx_Oracle.connect('username/password@IP:Port/DatabaseName')
cur = connection.cursor()
cur.execute('my query')
for result in cur:
    print(result)
cur.close()
connection.close()

Upvotes: 4

Related Questions