What is use of lock query in SQL Plus? Give its syntax and implementation?

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Exclusive Lock: This is placed when Insert, Update or Delete command is performed. There can be only one exclusive lock on a record at a time.

hussasha

 Profile Answers by hussasha Questions by hussasha

• Mar 17th, 2009

Locking protect table when several users are accessing the same table. Locking is a concurrency control technique in Oracle. It helps in data integrity while allowing maximum concurrency access to...

Answer Question  Select Best Answer