oracle批量插入sql语句

最新推荐文章于 2024-07-17 19:00:48 发布

pain discipline

最新推荐文章于 2024-07-17 19:00:48 发布

阅读量1k

点赞数 1

分类专栏： Oracle 文章标签： Oracle

本文链接：https://blog.csdn.net/qq_28656707/article/details/100082867

版权

Oracle 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

  <insert id="batchInsert" parameterType="java.util.List">
        insert into SCAI_CIFES_INDV_PC02
        (SEQ_NO, ID, PA01AI01,
        PC02AS01, PC02AS02, PC02BS01, PC02BJ01, PC02BS02, PC02CS01,
        PC02CJ01, PC02DS01, PC02ES01, PC02ES02, PC02EJ01, PC02EJ02,
        PC02EJ03, PC02FS01, PC02FS02, PC02FJ01, PC02FJ02, PC02FJ03,
        PC02GS01, PC02GS02, PC02GJ01, PC02GJ02, PC02GJ03, PC02HS01,
        PC02HS02, PC02HJ01, PC02HJ02, PC02HJ03, PC02HJ04, PC02HJ05,
        PC02IS01, PC02IS02, PC02IJ01, PC02IJ02, PC02IJ03, PC02IJ04,
        PC02IJ05, PC030S01, PC040S01, PC05AR01, PC05AD01, PC05AI01,
        PC05AQ01, PC05BS01, PC05BS03, PC05BS04, PC05BS05, PC05BS06,
        PC05BS07, PC05BS08)
        (
        <foreach collection="list" index="index" item="item"
                 separator="UNION ALL">
            select
            #{item.SEQ_NO,jdbcType=VARCHAR}, #{item.ID,jdbcType=INTEGER}, #{item.PA01AI01,jdbcType=VARCHAR},
            #{item.PC02AS01,jdbcType=VARCHAR}, #{item.PC02AS02,jdbcType=VARCHAR}, #{item.PC02BS01,jdbcType=VARCHAR},
            #{item.PC02BJ01,jdbcType=VARCHAR}, #{item.PC02BS02,jdbcType=VARCHAR}, #{item.PC02CS01,jdbcType=VARCHAR},
            #{item.PC02CJ01,jdbcType=VARCHAR}, #{item.PC02DS01,jdbcType=VARCHAR}, #{item.PC02ES01,jdbcType=VARCHAR},
            #{item.PC02ES02,jdbcType=VARCHAR}, #{item.PC02EJ01,jdbcType=VARCHAR}, #{item.PC02EJ02,jdbcType=VARCHAR},
            #{item.PC02EJ03,jdbcType=VARCHAR}, #{item.PC02FS01,jdbcType=VARCHAR}, #{item.PC02FS02,jdbcType=VARCHAR},
            #{item.PC02FJ01,jdbcType=VARCHAR}, #{item.PC02FJ02,jdbcType=VARCHAR}, #{item.PC02FJ03,jdbcType=VARCHAR},
            #{item.PC02GS01,jdbcType=VARCHAR}, #{item.PC02GS02,jdbcType=VARCHAR}, #{item.PC02GJ01,jdbcType=VARCHAR},
            #{item.PC02GJ02,jdbcType=VARCHAR}, #{item.PC02GJ03,jdbcType=VARCHAR}, #{item.PC02HS01,jdbcType=VARCHAR},
            #{item.PC02HS02,jdbcType=VARCHAR}, #{item.PC02HJ01,jdbcType=VARCHAR}, #{item.PC02HJ02,jdbcType=VARCHAR},
            #{item.PC02HJ03,jdbcType=VARCHAR}, #{item.PC02HJ04,jdbcType=VARCHAR}, #{item.PC02HJ05,jdbcType=VARCHAR},
            #{item.PC02IS01,jdbcType=VARCHAR}, #{item.PC02IS02,jdbcType=VARCHAR}, #{item.PC02IJ01,jdbcType=VARCHAR},
            #{item.PC02IJ02,jdbcType=VARCHAR}, #{item.PC02IJ03,jdbcType=VARCHAR}, #{item.PC02IJ04,jdbcType=VARCHAR},
            #{item.PC02IJ05,jdbcType=VARCHAR}, #{item.PC030S01,jdbcType=VARCHAR}, #{item.PC040S01,jdbcType=VARCHAR},
            #{item.PC05AR01,jdbcType=VARCHAR}, #{item.PC05AD01,jdbcType=VARCHAR}, #{item.PC05AI01,jdbcType=VARCHAR},
            #{item.PC05AQ01,jdbcType=VARCHAR}, #{item.PC05BS01,jdbcType=VARCHAR}, #{item.PC05BS03,jdbcType=VARCHAR},
            #{item.PC05BS04,jdbcType=VARCHAR}, #{item.PC05BS05,jdbcType=VARCHAR}, #{item.PC05BS06,jdbcType=VARCHAR},
            #{item.PC05BS07,jdbcType=VARCHAR}, #{item.PC05BS08,jdbcType=VARCHAR}
            from dual
        </foreach>
        )
    </insert>