python连接Oracle数据库的代码

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()

编程技巧