sqlInsert.append(" insert into fh_fs_report_file(file_name,file_type,file_save_path,file_create_date,report_total_record_num,");
sqlInsert.append(" file_feedback_flag,file_feedback_record_num,file_enter_record_num,file_enter_rate,report_org_cd,file_backup_path, ");
sqlInsert.append(" file_no,gather_file_name) ");
sqlInsert.append(" select cfrf.file_name,cfrf.file_type,cfrf.file_save_path,cfrf.file_create_date,cfrf.report_total_record_num, ");
sqlInsert.append(" cfrf.file_feedback_flag,cfrf.file_feedback_record_num,cfrf.file_enter_record_num,cfrf.file_enter_rate,cfrf.report_finance_cd,cfrf.file_backup_path, ");
sqlInsert.append(" cfrf.file_no ,cfrf.gather_file_name ");
sqlInsert.append(" from c_fs_report_file cfrf,c_so_report_config src ");
sqlInsert.append(" where ");
sqlInsert.append(" cfrf.report_finance_cd = src.report_org_cd ");
sqlInsert.append(" and ");
sqlInsert.append(" src.whether_move_report_file='1' ");
sqlInsert.append(" and ");
sqlInsert.append(" cfrf.gather_file_name is not null ");
sqlInsert.append(" and ");
sqlInsert.append(" not exists ");
sqlInsert.append("( select 1 from fh_fs_report_file ffrf where ffrf.file_name = cfrf.file_name)");
之行以上的sql语句,在PLSQL上运行没报错,但就是运行了好久都没反应,放到程序中也是一样,会有什么原因呢,请各位大侠指点一二,谢谢了
sqlInsert.append(" file_feedback_flag,file_feedback_record_num,file_enter_record_num,file_enter_rate,report_org_cd,file_backup_path, ");
sqlInsert.append(" file_no,gather_file_name) ");
sqlInsert.append(" select cfrf.file_name,cfrf.file_type,cfrf.file_save_path,cfrf.file_create_date,cfrf.report_total_record_num, ");
sqlInsert.append(" cfrf.file_feedback_flag,cfrf.file_feedback_record_num,cfrf.file_enter_record_num,cfrf.file_enter_rate,cfrf.report_finance_cd,cfrf.file_backup_path, ");
sqlInsert.append(" cfrf.file_no ,cfrf.gather_file_name ");
sqlInsert.append(" from c_fs_report_file cfrf,c_so_report_config src ");
sqlInsert.append(" where ");
sqlInsert.append(" cfrf.report_finance_cd = src.report_org_cd ");
sqlInsert.append(" and ");
sqlInsert.append(" src.whether_move_report_file='1' ");
sqlInsert.append(" and ");
sqlInsert.append(" cfrf.gather_file_name is not null ");
sqlInsert.append(" and ");
sqlInsert.append(" not exists ");
sqlInsert.append("( select 1 from fh_fs_report_file ffrf where ffrf.file_name = cfrf.file_name)");
之行以上的sql语句,在PLSQL上运行没报错,但就是运行了好久都没反应,放到程序中也是一样,会有什么原因呢,请各位大侠指点一二,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货