Home » SQL & PL/SQL » SQL & PL/SQL » lock table (2 Merged) (oracle database 11g)
lock table (2 Merged) [message #585080] Tue, 21 May 2013 21:50 Go to next message
Messages: 96
Registered: July 2011
Location: Iran
dear members.
I want to lock some table after I update a many rows for a session and after the transaction unlock those table.would please guide me how to do that.
thank you.
Re: lock table [message #585082 is a reply to message #585080] Tue, 21 May 2013 22:05 Go to previous messageGo to next message
Messages: 24685
Registered: January 2009
Senior Member
You should maintain at least 2 meters separation between you and any keyboard until after all of these crazy thoughts no longer exist in your head.

Why do you want to devolve the application into single user mode by taking explicit locks on any table?
Re: lock table (2 Merged) [message #585086 is a reply to message #585080] Wed, 22 May 2013 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 63158
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is actually not clear what you have and want.
Post an example.

Re: lock table (2 Merged) [message #585092 is a reply to message #585086] Wed, 22 May 2013 00:47 Go to previous message
Messages: 20653
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LOCK TABLE might be what you are looking for.
Previous Topic: Order by in Date Column
Next Topic: Can Any one please tell me how this query working???
Goto Forum:

Current Time: Wed May 25 04:41:59 CDT 2016

Total time taken to generate the page: 0.14907 seconds