oracle批量插入查询结果集

insert之后的括号不应该添加values 

insert into table1 (P_CODE, DEP_CODE, DOC_UUID, created, updated)  (
SELECT
  '14993' P_CODE,'HO0302' DEP_CODE ,A .uuid DOC_UUID,SYSDATE created,SYSDATE updated
FROM
  table2 A
WHERE
  A .uuid NOT IN (
    SELECT
      b.doc_uuid
    FROM
      PCREW_DOC_READ b
    WHERE
      b.p_code ='14993')
) 

 mysql插入

insert into demo.user(id,name,age,email) values('21','1.2',18,'smile1@ityouknow.com'),('22','keep',36,'smile2@ityouknow.com')

oracle不支持mysql那种写入方法，需要靠dual模拟临时表的方法 

insert into  T_EVEN (
				ID,
				EVENET_ID
			
				) 
    		<foreach collection="list" item="item" index="index" separator="union all" >
				select #{item.id,jdbcType=VARCHAR} ID
				from dual
			</foreach>

批量更新

BEGIN
	UPDATE tfb_pur
SET premium = ?, economic = ?, ANNOUNCER = ?, takeoff = ?, land = ?, firstblanket = ?, MAGAZINE = ?, economyblanket = ?, bag = ?, economyFood = ?, firstfood = ?
WHERE
	flightid = ?
AND baseid = ? ; UPDATE tfb_purserl
SET premium = ?, economic = ?, ANNOUNCER = ?, takeoff = ?, land = ?, firstblanket = ?, MAGAZINE = ?, economyblanket = ?, bag = ?, economyFood = ?, firstfood = ?
WHERE
	flightid = ?
AND baseid = ? ; 
END ;