I have a situation as follows:
I have three tables say A, B, C and I want to perform select operations over each table in one go as:
Select * From A Where condition
Select * From B Where condition
Select * From C Where condition
What I actually looking is to lock the tables from being insertion/updation of records during the selection. If a transaction is on going involving any of the table then it should complete before the select operations begin. None of the table should get
updated/inserted during the whole bunch of selection operations finished off.
Any idea how this can be achieved?
View Complete Post