table level locks, row level locks, column level locks?

Whenever I update a table
update table A set col1='1' where a.id between 1 and 10000

all rows lock for updates that fall into that range, so while this update is running if another update comes in update table A set col2='2' where a.id between 100 and 150

it cannot complete until the first update completes and commits... but the queries are updating difference columns.. is there are any new features that allow you to differentiate those queries and let them run concurently?

Thanx.
.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email