Yes, it does answer my question. And it should have been easy enough for me to test if I had been *thinking*.
I'll blame it on me being sick yesterday and still not in the right frame of mind, and my ribs are still tender from repeated reverse peristalsis. Thanks, Robert! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Robert Pegram [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 10, 2002 12:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle FM interpretation of locking behavior > > > If I understand what you are asking, a simple test > will tell you. > > >>> Session A > > SQL> create table t2 (x number); > > Table created. > > > SQL> insert into t2 values (1); > > 1 row created. > > SQL> insert into t2 values (2); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> update t2 set x=4 where x=1; > > 1 row updated. > > SQL> > > Notice No commit; > > >>>>>>> Session B > SQL> update t2 set x=4 where x=2; > > 1 row updated. > > SQL> update t2 set x=4 where x=1; > > >>> this waits for the commit/rollback in session A > > Robert Pegram > Oracle Certified DBA (8i,9i) > > > --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > > Hey all, > > > > After converting three columns on a multi-million > > row table from NULLs to > > SPACEs, the devs found one other program that pops > > NULLs into those columns > > (sigh). So, with only 150 rows needing updating, my > > knee-jerk reaction was > > to do a simple: > > > > UPDATE mytable > > SET mcol1 = ' ' > > WHERE mcol1 IS NULL; > > > > ...and repeat for "mcol2" and "mcol3". Since this > > is a heavy table for us > > (Time/Attendance), I'm wondering about locking, > > since the UPDATEs won't be > > using an index because of the "IS NULL". When I > > RTFM for 8.1.7, I found > > this: > > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
