Jump to content
Sign in to follow this  
ruzzo_abi

Update Table Guna Rownum

Recommended Posts

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
)
)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...