Oracle python 批量更新,python Oracle SQL

pyhton Oracle 程序示例

1、pyhton 读写 Oracle 数据

import cx_Oracle

def real_save_to_oracle( lst_file_name, stpf_result_data_dir, dict_area_no ):

conn = cx_Oracle.connect( "SYSDBA/123456@192.168.1.210/orcl" )

cursor = conn.cursor()

for file_name in lst_file_name:

str_suffix = file_name[-4:]

if str_suffix != ".csv":

continue

file_path = os.path.join( stpf_result_data_dir, file_name )

df_data = pd.read_csv( file_path )

file_name = file_name.split("_")[1]

for _, row_data in df_data.iterrows():

area_no = dict_area_no[ file_name ]

print( area_no, file_name )

str_time = row_data["Time"]

d_P_real = row_data["P_use"]

d_Q_real = row_data["Q_use"]

str_sql = """select * from WF_STAT_PERIOD_DATA