Oracel

• oracel一次查询多个sequence，批量查询sequence

        SELECT SEQ.nextval
        FROM dual
        CONNECT BY ROWNUM <= #{batchSize}

• oracel批量插入-先批量获取sequenceId赋值给主键，再批量插入

    <insert id="batchSave">
        INSERT INTO NOTIFY_BREED(id, notify_id, breed_id)
        <foreach collection="dataSet" open="(" item="item" separator=" union " index="index" close=")">
            SELECT
            #{item.id},
            #{item.notifyId},
            #{item.breedId}
            FROM DUAL
        </foreach>
    </insert>