Oracle example using Python

#!/usr/bin/python
 
# orcl.py
 
import cx_Oracle
 
login = 'madan'
passwd = 'fdca2010'
db = 'xe'
connection = cx_Oracle.connect(login + '/' + passwd + '@' + db)
curs = connection.cursor()
table = 'staff'
sql = '''select * from ''' + table
rs = curs.execute(sql)
print rs
row = curs.fetchone
rowCount = 0
while (row):
	print row
	row = curs.fetchone()
	rowCount += 1
 
print "Table " + table + " has " + str(rowCount) + " rows"
curs.close()
connection.close()

oraclepython.txt · Last modified: 2014/10/26 01:52 (external edit)
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0