windows下python连接oracle数据库实例方法

# -*- coding: utf-8 -*-import cx_Oracle

conn=cx_Oracle.connect('reporter','password','localhost:1521/ORCL')

cursor=conn.cursor()

sql="select * from test"cursor.execute(sql)

data=cursor.fetchall()print(data)

cursor.close()

conn.commit()

conn.close()