Difference between revisions of "Oracle Notes"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) |
PeterHarding (talk | contribs) |
||
| Line 1: | Line 1: | ||
=Notes= | =Notes= | ||
=Exploring Oracle= | |||
<pre> | |||
SELECT table_name FROM user_tables; | |||
</pre> | |||
==cx_Oracle== | ==cx_Oracle== | ||
Revision as of 22:00, 18 October 2010
Notes
Exploring Oracle
SELECT table_name FROM user_tables;
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