Lock

From: "Paul Harrison" <cure@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 10 Mar 2012 10:56:49 -0600

Hello,
 

I have a table with four rows. I issue the sql statement: update table set
name = 'test';  this will update 4 rows. Will Oracle create 4 locks one for
each row or 1 lock for the 4 rows?

 

Thanks,

Paul



--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Lock
From: Guillermo Alan Bort

Re: Lock
From: Toon Koppelaars

RE: Lock
From: Taylor, Chris David

Re: Lock
From: Jonathan Lewis

Other related posts:

» Lock - Paul Harrison
» Re: Lock - Guillermo Alan Bort
» Re: Lock - Toon Koppelaars
» Re: Lock - Andy Klock
» RE: Lock - Mercadante, Thomas F (LABOR)
» RE: Lock - Taylor, Chris David
» RE: Lock - Taylor, Chris David
» Re: Lock - Jonathan Lewis

Browse oracle-l