P'Made, Menurut saya logikanya ketika kita lakukan update dng menggunakan metode tsb, dari hasil select itu harus didapatkan 1 row, kalo hasilnya beberapa row pasti error. Bila hasil yg didapat sudah yakin 1 row untuk apa kita mesti sertakan clause SORT BY ?
Mungkin itu yg mendasari kenapa syntax tsb menjadi bermasalah ketika dijalankan. CMIIW ya... ________________________________ From: made kiki <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, December 4, 2008 2:56:37 PM Subject: [indo-oracle] ASK: oracle update dalam select bermasalah 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]
