Lock
From: Paul Harrison <cure_at_austin.rr.com>
Date: Sat, 10 Mar 2012 10:56:49 -0600
Message-ID: <000001ccfede$c9769b50$5c63d1f0$_at_austin.rr.com>
Hello,
Date: Sat, 10 Mar 2012 10:56:49 -0600
Message-ID: <000001ccfede$c9769b50$5c63d1f0$_at_austin.rr.com>
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-lReceived on Sat Mar 10 2012 - 10:56:49 CST