Writers don't block readers in Oracle. Not issuing a commit will not cause a SELECT in another session to hang.
Jared On Thu, 2004-03-25 at 09:49, Ronald J Kimball wrote: > By the way, Laurie mentioned to me off-list that she had an SQLPLUS session > open so she could reset the value of the contribute_flag column. That could > have led to the script blocking, as I supposed. > > I've done that myself quite a few times, forgetting to commit in SQLPLUS > while testing a script. :) > > Ronald
