oracle select update

 

		/* xml.update */
		   UPDATE /*+ BYPASS_UJVC */ 
		  	(SELECT STATUS AS OLDSTATUS, UPDT_DT
		   	 FROM TB_LIST
		 	WHERE 1=1
		      AND STATUS = '00'
		      AND SEQ = #{seq}
		    )
		    SET OLDSTATUS = '01', 
		        UPDT_DT = SYSTIMESTAMP

 

간단하게 작성