Use of COMMIT for DML Sql queries [message #2699] |
Wed, 07 August 2002 02:36 |
Mark Grimshaw
Messages: 73 Registered: June 2002
|
Member |
|
|
Just a quick question.
For DML update and insert like sql statements, does the keyword COMMIT need to be issued immediately after the staement to prevent resource locks?
Mark Grimshaw
|
|
|
Re: Use of COMMIT for DML Sql queries [message #2700 is a reply to message #2699] |
Wed, 07 August 2002 02:50 |
santosh
Messages: 85 Registered: October 2000
|
Member |
|
|
Hi Mark,
It is not necessary to commit immediately after every DML statement if you are not using any kinds of locks.If you are using queries like select .. for update of.. then it automatically puts lock and u need to commit or rollback in this case.
|
|
|