about commit

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

i want to know about commit and if u can please give me a small example
of commit i want to work on commit how it work exactly.

thanx in advance.
regard..
manjinder

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

Hi,

Commit is basically use to make your changes permenant. A commit occurs automatically at the end of the program, or by request one or more times during the execution of the program. Releases all locks acquired by the program since the last commit, so that other programs and users may obtain access to the data. Any open cursors are automatically closed. All database changes are made permanent.

Hope this helps

Regards
Rupesh

priyesh.agrawal · Posted: Fri Jan 20, 2006 10:02 am

Its always good referring manuals...

Regards,

Priyesh.

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

thanx priyesh and rupesh as in manual we can lock our table in 2 modes in exclusive and shared mode i have selected exclusive mode,but i am able to do all the operation on that table values r getting inserted and selected then why lock?

thanx alottt.
regard..
manjinder