from sqlalchemy import create_engine
import pandas as pd

con = create_engine(‘oracle+cx_oracle://用户名:密码@IP:端口/库名?charset=utf8‘)

sql = "select * from addressinfo where rownum < 11"

df = pd.read_sql(sql, con)

df.to_csv(‘5.csv‘, header=True, index=False, encoding=‘utf_8_sig‘)