For update clause

babi_geek · #1 (**permalink**) 03-02-2008

Hi,

If a transaction is updating data in a database, it gets an exclusive lock on that part of the database automatically. Then what is the use of for update clause defining it explicitly?

Regards
Babi

debasisdas · #2 (**permalink**) 03-03-2008

That is used with Select statement to explicitly enforce a lock .

su123 · #3 (**permalink**) 03-03-2008

Hi babi,
If a transaction is updating data in a database, it gets an exclusive lock on that part of the database automatically. Up to this the Question is good After that you typed "Then what is the use of for update clause defining it explicitly?" can you retype the Question clearly.

savitha239 · #4 (**permalink**) 03-19-2008

Hi,
For Update clause is always used in a cursor(or a simple SELECT statement).

The advantage of locking a set of rows fetched by cursor(or a select statement) over an exclusive lock on an update or delete transaction is,
the set of SELECTED rows can be locked before u can modify so that denying the modification of the same set of rows by other user.

Thanks,
Savitha

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
GROUP_BY and HAVING clause in SQL	nancyphilips	SQL	5	09-09-2008 12:39 AM
Pass periodic value into where clause	sheker2007	Oracle	1	10-30-2007 08:55 AM
return clause in cursor	Barbie	Oracle	4	01-31-2007 05:46 AM
Writeing a query with HAVING clause	JobHelper	SQL	2	01-11-2007 12:41 AM
Presence of Clause	nehalshah	MainFrame	1	10-09-2006 04:01 PM

For update clause

For update clause

Similar Threads