Connect OracleDB in Python

python-3.x oracle-sqldeveloper pypyodbc
Santhosh picture Santhosh · Jun 30, 2016 · Viewed 7.3k times · Source

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

Answer

jesusperalta picture jesusperalta · Mar 2, 2017

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()

Related questions

Convert bytes to a string

I'm using this code to get standard output from an external program: >>> from subprocess import * >>> command_stdout = Popen(['ls', '-l'], stdout=PIPE).communicate()[0] The communicate() method returns an array of bytes: >>> …

Read More
Best way to convert string to bytes in Python 3?

There appear to be two different ways to convert a string to bytes, as seen in the answers to TypeError: 'str' does not support the buffer interface Which of these methods would be better or more Pythonic? Or is it …

Read More
How to install pip with Python 3?

I want to install pip. It should support Python 3, but it requires setuptools, which is available only for Python 2. How can I install pip with Python 3?

Read More