Scriptnya seperti ini Update matusetrans SET IT2='R262961' where itemnum='13230001' and IT2='R262965' and ROWSTAMP='12449085';
Kalau untuk melihat sedang lock, perintah sessionnya gimana ? Salam Mawardi -----Original Message----- From: Jimmy Sinaga [mailto:[EMAIL PROTECTED] Sent: Thursday, July 06, 2006 13:11 To: [email protected] Subject: Re: [indo-oracle] Update Data Lewat SQL Command masalah bs jg dari commnad SQL. bs di copy paste kan commamnd nya. ada kalanya command sql DDL yg kurang efisien bs mengakibatkan prosesnya makan wkt lama. mgkn kita bs buat jd efisien ... thanks is advance, JS On 7/6/06, Ferry Setiawan <[EMAIL PROTECTED]> wrote: > > mungkin status table sedang lock, coba cek sessionnya > > > > -----Original Message----- > > From: [email protected] > > <indo-oracle%40yahoogroups.com>[mailto: > [email protected] <indo-oracle%40yahoogroups.com>]On > > Behalf Of Mawardi > > Sent: 06 Juli 2006 8:06 > > To: '[email protected] <%27indo-oracle%40yahoogroups.com>' > > Subject: [indo-oracle] Update Data Lewat SQL Command > > > > > > Selamat pagi.. > > Saya coba update data lewat SQL Command, tapi tidak bisa (kayak > > Hang, kalau di lihat dari task Manager Not Responding). Sebelumnya > > tdk ada masalah. > > > > Kira-kira kenapa ya. > > > > OS : Windows NT > > DB : Oracle 8.0.5 > > > > Salam > > Mawardi > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
