select t.*,t.rowid from dissentitemresult t for update -- update dissentitemresult t set t.checkorgtype = '0',t.checkorg = '0',t.inchecktype = '1' where t.checkorgtype = '1' and t.startdate =(select max(startdate) from dissentitemresult a where a.infocode = '110120170426000101') update dissentitemresult t set t.checkorgtype = '0',t.inchecktype = '1' where t.checkorgtype = '1' and t.startdate =to_date('2017/4/27 17:21:07','yyyy-mm-dd hh24:mi:ss')