|
-
Hi,
When u write the SELECT..............FOR UPDATE statement Oracle locks the table for that particular session.After processing the rows in the procedure or function or package release the locks on the rows by either COMMIT/ROLLBACK.
In case of any help please be free to ask me at [email protected]
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote