Hallo member oracle id Saya ada permasalahan ketika update, querynya seperti berikut :
UPDATE user_login SET user_sts = 1 WHERE id = (SELECT id FROM user_login WHERE
user_sts = 0 AND rownum <= 1 ORDER BY user_created ASC)
Tapi jika query tersebut tanpa "ORDER BY sms_created ASC" querynya tidak
bermasalah.
Tks atas bantuan rekan2
--
best regard
Made Kiki
[Non-text portions of this message have been removed]
