AFAIK, option autocommit biasanya terdapat di SQL Developer, mis SQL*Plus Jika user melakukan transaksi di SQL*Plus bisa dicek dg perintah: SHOW AUTOCOMMIT Setting autocommit adalah SET AUTOCOMMIT ON|OFF|IMMEDIATE|n
rgds, AWAL ----- Original Message ----- From: Muhamad Safik To: [email protected] Sent: Thursday, June 22, 2006 9:39 AM Subject: Re: [indo-oracle] Commit dan Rollback dimana bisa dilihat configurasi untuk AUTOCOMMIT diset ON.. di oracle 10g On 6/21/06, awal <[EMAIL PROTECTED]> wrote: > > Kalau benar belum di-commit maka data tsb tidak akan masuk ke database > Mungkin isi table dilihat melalui perintah SELECT via SQL command jd > seolah2 data tsb sudah ada, > padahal query itu berasal dr buffer usernya, selain itu user lain juga tdk > bisa melihat perubahan tsb. > Jika anda masuk langsung ke database dan melihat isi tabelnya maka data > tsb pasti belum ada. > Kecuali AUTOCOMMIT diset ke ON > > rgds, > AWAL > > ----- Original Message ----- > From: Safik > To: [email protected] > Sent: Wednesday, June 21, 2006 9:34 AM > Subject: [indo-oracle] Commit dan Rollback > > > Mohon pencerahan, > Oracle 10g > OS RHEL AS 4 > > Saya melakukan perintah insert into data ke suatu table, sebelum melakukan > commit, table tersebut sudah terisi data.... > Bagaimana caranya agar table tsb tidak terisi data dulu sebelum di lakukan > perintah commit.... di PL/SQL > > > > > > > [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 > > > > > > > > [Non-text portions of this message have been removed] [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/
