hmmm ..... coba jalanin dgn script yg baru dgn tanpa IT2='R262965', kan yg mo di update hanya IT2 jadi tdk perlu masukin IT2 yg nilai lama :
semoga membantu, Jimmy Sinaga On 7/6/06, Mawardi <[EMAIL PROTECTED]> wrote: > > 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] <jimmyps%40gmail.com>] > Sent: Thursday, July 06, 2006 13:11 > To: [email protected] <indo-oracle%40yahoogroups.com> > 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]<ferry.setiawan%40platinumceramics.com>> > wrote: > > > > mungkin status table sedang lock, coba cek sessionnya > > > > > > > -----Original Message----- > > > From: [email protected] <indo-oracle%40yahoogroups.com> > > > <indo-oracle%40yahoogroups.com>[mailto: > > [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com>]On > > > Behalf Of Mawardi > > > Sent: 06 Juli 2006 8:06 > > > To: '[email protected] > > > <%27indo-oracle%40yahoogroups.com><%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]<indo-oracle-unsubscribe%40yahoogroups.com> > 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 > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
