Oracle中批量上传
<!--批量上传工作岗位-->
<insert id="uploadJob" parameterType="java.util.List">
INSERT INTO t_co_job(id, co_id, name, area_id, function_category, welfare, hire_num, certificate,
education, working_seniority, language, mobile, salary_min, salary_max, address, contact,
require, duty, status, create_time, update_time)
SELECT t_co_job_id_seq.nextval id, A.* FROM (
<foreach collection="list" index="index" item="item" separator="UNION ALL">
SELECT
#{item.coId} co_id, #{item.name} name, #{item.areaId} area_id, #{item.functionCategory} function_category,
#{item.welfare} welfare, #{item.hireNum} hire_num, #{item.certificate} certificate, #{item.education} education,
#{item.workingSeniority} working_seniority, #{item.language} language, #{item.mobile} mobile,
#{item.salaryMin} salary_min, #{item.salaryMax} salary_max, #{item.address} address,
#{item.contact} contact, #{item.require} require, #{item.duty} duty, #{item.status} status,
#{item.createTime} create_time, #{item.updateTime} update_time
FROM dual
</foreach>
)A
</insert>
为什么在insert into 的后面没有values 这个关键字呢?