1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| version Cx_Oracle => cx-Oracle==6.0.3
extrait du code
import cx_Oracle
import pandas as pd
dsn_tns = cx_Oracle.makedsn(ip, port, SID)
db = cx_Oracle.connect(login, password, dsn_tns, encoding='utf-8')
cursor = db.cursor()
cursor.execute("alter session set NLS_DATE_FORMAT='DD/MM/YYYY'")
cursor.execute("alter session set NLS_NUMERIC_CHARACTERS=', '")
df1 = pd.read_sql_query(sql, db)
fic_sortie=rep_sortie+fic_sql+'_'+ddj+".txt"
df1.to_csv(fic_sortie, sep="\t", encoding="cp1252", index=False)
cursor.close()
db.close() |