PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How do you find whether table is locked or not?

4) How do you whether table is locked or not?
Answers) Just run the following query on the table.

Lock Table DBNAME.TABLENAME write nowait
Select * from DBNAME.TABLENAME;

Add a Comment

Your email address will not be published. Required fields are marked *