Oracle Notes

Notes

cx_Oracle

>>> import cx_Oracle
>>> conn = cx_Oracle.connect('xxxx','xxxx','XX')
>>> curs = conn.cursor()
>>> curs.arraysize=50

>>> sql = 'SELECT * from DBUSER.BUG'

>>> curs.execute(sql)
<__builtin__.OracleCursor on <cx_Oracle.Connection to xxx@XX>>

>>> print curs.description
...

>>> print curs.fetchone()
...

>>> for x in curs:
	print x
...

>>> curs.execute('describe XXX.BUG')

cx_Oracle Working Notes

• [1]
• [2]
• [3]
• [4]
• [5]

Python DBI

• [6]