Differences

This shows you the differences between two versions of the page.

Link to this comparison view

oraclepython [2014/10/26 01:52] (current)
Line 1: Line 1:
 +==== Oracle example using Python ====
  
 +<code lang="​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()
 +</​code>​
 +
 +----
 +  * [[pythoninfo|Back to Python]]
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