Oracle DBA Forums
Jul 29 2008, 04:27 AM
1. Is it possible to lock a row in Oracle and unlock in a different session?
2. And if yes what is the command?
3. Also is there any command to lock a particular rows in the table???
Please help me....
Jul 29 2008, 05:19 AM
Here is an overview of Oracle row level locking:
>> Also is there any command to lock a particular rows in the table???
What kind of lock?
You can set lock with many commands, like "select for update"
Jul 29 2008, 07:51 AM
2. alter system kill session 'sid,serial#';
3. see above
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
Invision Power Board © 2001-2014
Invision Power Services, Inc.