python连接Oracle数据库的代码,需要引用cx_Oracle库
- #coding=UTF-8
- import cx_Oracle
- def hello():
- '''Hello cx_Oracle示例:
- 1)打印数据库版本信息.
- 2)查询表数据.'''
- conn = cx_Oracle.connect("obs61","obs61","tx8i.hp")
- cur = conn.cursor()
- try:
- print "Oracle Version:%s" % conn.version
- print "Table SUB_POLICY rows:"
- cur.execute('select * from wlan_future_event')
- for row in cur:
- print row
- finally:
- cur.close()
- conn.close()
- hello()
来源: http://www.phpxs.com/code/1004856/