Difference between revisions of "Oracle Notes"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) (Created page with '=Notes= ==cx_Oracle== <pre> >>> import cx_Oracle >>> conn = cx_Oracle.connect('xxxx','xxxx','XX') >>> curs = conn.cursor() >>> curs.arraysize=50 >>> sql = 'SELECT * from DBUSE...') |
PeterHarding (talk | contribs) |
||
| Line 29: | Line 29: | ||
=== cx_Oracle Working Notes=== | === cx_Oracle Working Notes=== | ||
* | * http://cx-oracle.sourceforge.net/ | ||
* | * http://cx-oracle.sourceforge.net/html/index.html | ||
* | * http://wiki.oracle.com/page/Python | ||
* | * http://www.oracle.com/technology/pub/articles/devlin-python-oracle.html | ||
* | * http://www.oracle.com/technology/pub/articles/tuininga-cx_oracle.html | ||
=Python DBI= | =Python DBI= | ||
Revision as of 15:15, 21 October 2009
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
- http://cx-oracle.sourceforge.net/
- http://cx-oracle.sourceforge.net/html/index.html
- http://wiki.oracle.com/page/Python
- http://www.oracle.com/technology/pub/articles/devlin-python-oracle.html
- http://www.oracle.com/technology/pub/articles/tuininga-cx_oracle.html