title: does an update statement in oracle hold a lock even if no rows were updated
body: <p>If I run an update statement in oracle that says '0 rows updated' because it does not match the where clause and i do not commit, does it still hold the lock on any protion of the table? My guess is no, but i cannot prove it.</p>