cx_Oracle-5.1-11g.win32-py3.2.msi

python3.2操作Oracle库的第三方库，下面是例子 import cx_Oracle db=cx_Oracle.connect('scott','tiger','localhost/MYTEST') print(db.version) cursor=db.cursor() #sql语句不能加; sql="select * from scott.emp t WHERE T.Sal>:Sal AND T.Hiredate >= to_date(:time,'yyyymmddhh24miss')" condition = {'Sal':1000, 'time':'19810402000000'} cursor.execute(sql,condition) row = cursor.fetchall() for x in row: for y in x: print(y) print() db.close()