import cx_Oracle
import os
conn=cx_Oracle.connect('use/password@ip:port/db',nencoding='utf8')
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'
# 使用cursor()方法获取操作游标
cursor = conn.cursor()
sql="select * from table"
data=cursor.execute(sql).fetchall()
print(data)
出现编码问题解决方法,加上 nencoding='utf8'
以及 os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'