Monday, April 22, 2013

Oracle: How to lock a table with select command

How to lock a table with select command:
 
SQL: select * from scott.dept for update;

Remember to Rollback when you want to unlock later :)

No comments: