Shulou(Shulou.com)06/01 Report--

Lock: The mechanism used in Oracle to implement concurrent access control;

Classification: table-level lock, row-level lock;

Lock application: Oracle automatically applies row-level locks when insert, delete and update are executed; no locks are added when select is executed;

select for update: row-level locks and table-level locks are added when executed; insert statements can be executed;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.