ruzzo_abi 0 Report post Posted November 18, 2008 salam...skrg saya tgh buat sistem attendance guna php dan oracle. clinet request utk key in / update masa secara manual. itu admin jer leh buat.saya ada masalah nk update table kerana table ni takde primary key. bila search dlm google kata kena guna rownum / rowid. tp bila try mcm tak jalan. flag = 1 -> masuk keja| Lokasi | TarikhNMasa | NoStaff | Flag | D1 1/12/2007 08:00:00 AM A1 1 D1 1/12/2007 05:00:00 PM A1 0* utk data ini (D1 1/12/2007 08:00:00 AM A1 1) mcm mana saya nk update masa sahaja kepada pkul 7?ini query saya:update $table set TarikhNMasa = to_date('07:00:00', 'hh24:mi:ss')where rowid in( select rowid from ( select rowid from $table where NoStaff = 'A1' and to_char(TarikhNMasa, 'yyyymm') = '200712' and Flag = 1 )) Quote Share this post Link to post Share on other sites