Locks Oracle v SQL7

How does Oracle compare with Sql7 as regards Locking problems.

For instance, does Oracle put locks on Select statements, what Locks does it put on Update and Insert statements?

Sql7 puts 'read only' Shared locks on all the above statements (default Isolation mode) but converts the Update and Insert statements (after satisfying the Insert and Update conditions) into Exclusive locks in order to do the actual Insert and Update operations. This 'conversion' often causes deadlocks.

How about Oracle does it have 'Lock' problems?

Thanks
J Received on Fri Jun 30 2000 - 00:00:00 CDT