python连接oracle数据库
import cx_Oracle
import pandas as pd
import numpy as np
import os
os.environ['NLS_LANG'] = 'AMERICAN_AMERICA.UTF8'
conn = cx_Oracle.connect('****/****@192.168.30.12:1521/JZDB1')
print(conn)
cursor = conn.cursor()
cursor.execute('select * from SYS_XZQH_ZZJG')
result = cursor.fetchall()
df = pd.DataFrame(result)
import pandas as pd
import numpy as np
import os
os.environ['NLS_LANG'] = 'AMERICAN_AMERICA.UTF8'
conn = cx_Oracle.connect('****/****@192.168.30.12:1521/JZDB1')
print(conn)
cursor = conn.cursor()
cursor.execute('select * from SYS_XZQH_ZZJG')
result = cursor.fetchall()
df = pd.DataFrame(result)
评论
发表评论