How to connect python to the Oracle database: pythonoracle Database

How to connect python to the Oracle database: pythonoracle Database

This example describes how to connect python to an Oracle database. Share it with you for your reference. The details are as follows:

To connect to the Oracle database using python, you must reference the cx_Oracle database.

# Coding = UTF-8 import cx_Oracle def hello (): ''' Hello cx_Oracle example: 1) print database version information. 2) query table data. '''conn = cx_Oracle.connect ("obs61", "obs61", "tx8i. hp ") cur = conn. cursor () try: print "Oracle Version: % s" % conn. version print "Table SUB_POLICY rows:" cur.exe cute ('select * from wlan_future_event ') for row in cur: print row finally: cur. close () conn. close () hello ()

I hope this article will help you with Python programming.