Can we use LOCK TABLE on a view?
Posted: Mon Jun 09, 2014 5:35 pm
Hi,
Can we use LOCK TABLE on a view? I think no, but is it correct? Please help.
Can we use LOCK TABLE on a view? I think no, but is it correct? Please help.
Hi Ankit,
No, you can not. VIEWs are imaginary entities, there is no physical existence of them. If you want to lock a view, you have to issue the lock on the underlying tables.