SQL INSERT INTO SELECT 语句

 写的比较好的文章：https://www.runoob.com/sql/sql-insert-into-select.html

 <insert id="insertqy" parameterType="map">
   insert into jrfc_import_qy_tmp t
select '',
       DEPARTMENT,
       replace(replace(DOMI_SEC_NM,'（汇总）'),'建行'),
       replace(SUB_BRANCH_NM,'（汇总）'),
       CST_NM,
       CST_ID,
       #{LOAN_CD,jdbcType=DOUBLE},
       #{TOT_LOAN_BAL,jdbcType=DOUBLE},
       #{TOT_LOAN_BAL,jdbcType=DOUBLE},
       #{RESC_TYPE,jdbcType=VARCHAR},
       #{RESC_DT,jdbcType=VARCHAR},
       '',
       #{CABIN_NM,jdbcType=VARCHAR},
       '',
       '',
       '',
       #{IN_REASON,jdbcType=VARCHAR},
       to_char(sysdate,'yyyy-mm-dd'),
       ''
  from jrfc_basic_info_cst a
 where a.cst_nm = #{CST_NM,jdbcType=VARCHAR}
  </insert>