oracle批量插入sql语句

野性酷女 2024-04-17 06:24 67阅读 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>