python连接oracle数据库的一个例子

1、先安装
pip install cx_Oracle
2、示例内容

import cx_Oracle
import pandas as pd

def get_price_data_from_db():
"""
直接从数据库获取价格数据
"""
# 连接oracle获取数据
conn = cx_Oracle.connect('username/password@IP:1521/BOMSVA')

price_sql_str = """
select f.material_code,
       f.vendor_code,
       f.end_date,
       f.tax_free_price
  from fd_material_price f
 where f.tax_free_price is not null 
   and f.remarks not like '%暂%'
   and f.remarks not like '%样%'
   
   select from fd_ma
   
   """

price_data = pd.read_sql(price_sql_str, conn) 
conn.close()

return price_data

我事先安装了anaconda了