<insert id="insert" >
insert into tableName(id, name, age, sex, class, classNo) -- values
select seqName.nextval , a.* from(
<foreach collection="list" item="item" separator="union all">
select
-- #{item.id, jdbcType=DECIMAL} as id