批处理oracle与mysql的差异

在批处理过程中，Mysql与Oracle有较大区别

Mysql

INSERT into test_table 
(id,name)
VALUES
(1,'li'),
(2,'wang');

<insert id="insertList">
insert into table_name
(id,name)
values
<foreach collection='list' item='item'  separator=','>
    (
     #{item.id},#{item.name}
    )
</foreach>
</insert>

Oracle

insert into table_name
(id,name)
select 'id_1','name_1' from dual
union
select 'id_2','name_2' from dual

<insert id='insertList'>
insert into table_name
(id,name)
<foreach collection='list'  item='item' separator='union'>
    select #{item.id},#{item.name} from dual
</foreach>
</insert>