赞
踩
- # 注意字段必须用单引号' ' ,UNION 进行连接
- INSERT INTO ZFXT_TASK_LOCK (COORDINATION_ID)
- SELECT 'ad' FROM dual UNION
- SELECT 'fg' FROM dual
注意字段必须用单引号' '
- insert into ZFXT_TASK_LEGAL_PAPER
- (P_ID,TASK_ID, DOCUMENT_NUMBER)
- <foreach collection="zfxtTaskLegalPaperDOS" item="item" separator="union">
- select #{item.pId},#{item.taskId}, #{item.documentNumber,jdbcType=VARCHAR},
- from dual
- </foreach>
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。