Home » SQL & PL/SQL » SQL & PL/SQL » Use of COMMIT for DML Sql queries
Use of COMMIT for DML Sql queries [message #2699] Wed, 07 August 2002 02:36 Go to next message
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 Go to previous message
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.
Previous Topic: Crystal Report Support for Ref_Cursors
Next Topic: INSERT ROWS - DOES NOT WORK
Goto Forum:
  


Current Time: Thu Mar 28 09:09:13 CDT 2024