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?
-
- Registered Member
- Posts: 24
- Joined: Fri Aug 16, 2013 1:30 pm
- Anuj Dhawan
- Founder
- Posts: 2801
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Can we use LOCK TABLE on a view?
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.
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.
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute