coba ini ... UPDATE user_login SET user_sts = 1 WHERE id = (select id from(SELECT id FROM user_login WHERE user_sts = 0 ORDER BY user_created ASC) where rownum <= 1)
regards, pandu wp --- On Wed, 12/3/08, made kiki <[EMAIL PROTECTED]> wrote: From: made kiki <[EMAIL PROTECTED]> Subject: [indo-oracle] ASK: oracle update dalam select bermasalah To: [email protected] Date: Wednesday, December 3, 2008, 11:56 PM 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] [Non-text portions of this message have been removed]
