Re: Table Lock on Select for Update?

From: <resco_at_delphi.com>
Date: 1995/05/18
Message-ID: <p+3eTjc.resco_at_delphi.com>#1/1

I'm sure this is wrong.

To prove it to yourself, lock a seperate row in the table with a select for update. Keep that row lock on whilst you select for update a second row. If you are then able to update the second row and commit, it could not have taken a table lock

regards,

Mike Peacey
resco_at_delphi.com Received on Thu May 18 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: David Sidwell: "Re: Q: Oracle7 & Row level security..."
Previous message: Ian Abramson: "Re: Using Personal Oracle 7 for Windows with PowerBuilder"
In reply to: BJSIEBEN_at_bcsc02.gov.bc.ca: "Table Lock on Select for Update?"
Next in thread: David Sidwell: "Re: Q: Oracle7 & Row level security..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message