locking pesimistic?

Answers

1. publicguest

   On 2006-08-01 02:53:28

   
   
   locking pessimistic: This type of locking works at the database level and prevents any other application or user from fetching or updating the same record at the same time. There are different types of locking perssimistic is available in oracle (1)Lock on Select (2)Lock on Update optimistic lock Optimistic locking stores a snapshot of a database row as it is fetched. When EOF updates the record, it appends a qualifier to the update statement that ensures that the record will be updated only if none of the locking columns has been modified. types of locking -------------------- Lock on Some or All Columns Using a Single Locking Column