Entry

Connecting to Oracle database

Jul 5th, 2000 10:01
Nathan Wallace, unknown unknown, Hans Nowak, Snippet 202, Raymond Cote

"""
Packages: database
"""
"""
Thanks to the kind response of Alexander Smishlajev who just sent me the
binary 8.0.4 Oracle extensions for Windows, I've gone from completely
clueless to a db data slinger in about half an hour. 
So, commenting from that vast experience.... :}
"""
import DCOracle, oci_, Busys
dbc = DCOracle.Connect('userID/password@hostname');
c = dbc.cursor();
c.execute('select * from sometablename');
for x in c.fetchall():
	print x
dbc.close();
"""
Also remember that fetchall() is not going to be the best solution when
working with large tables. In those cases use fetchone() to return the
next row of a query or fetchmany(howmany) to return chunks of rows.
"""