snippet.xml

<insert id="insertPostTraceResult">
/* web.rest.insertPostTraceResult */
INSERT INTO EVENT_VIDEO_CHASE_RESULT_INFO(EVENT_SEQ, VIDEO_CHASE_NO, CAMERA_NO, CAMERA_DEVICE_ID, VIDEO_CHASE_RESULT_DATE, REG_DATE, RECOGNITION_RATE)
	VALUES
	<foreach collection="TraceResult" item="item"  open="(" separator="),("  close=")">
	  	#{event_seq}, 
		CAST(#{video_chase_no} as integer),
		#{item.Seq},
		(SELECT CAMERA_DEVICE_ID FROM CAMERA_INFO_PS WHERE CAMERA_SEQ = #{item.CctvNum}),	
		(SELECT TO_CHAR(#{item.TraceTime}::TIMESTAMPTZ, 'YYYYMMDDHH24MISS')),
		TO_CHAR(NOW(), 'YYYYMMDDHH24MISS'),
		#{item.Rate}
	</foreach>	
</insert>	

관련 문서