By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

Deadlock even with SELECT..FOR UPDATE

P: 1
Hi,
I have query something like this:
select * from emp where sal > ( select avg(sal) from emp ) for update

When ran multithreaded environment, i used to get this error
"Abnormal end unit of work condition occured" which is i think is due to deadlock condition.

I just wanted to know that What database lock ( share/update/exclusive) will be aquired for the above statement ? Is it that all txn will try to hold only U lock (since for update clause is present) ?? Or 1 txn holds U lock and other txn holds S lock ( for inner query)??


Thanks,
Jaideep.
Mar 29 '07 #1
Share this Question
Share on Google+
1 Reply


P: 4
hiiiiiiiiiii all
1 tel me can any query possible for retrieving particular fieldname?
2.
please tel me anyone can we eliminate unique records and retrieve duplicates only in a table having 1000 records and we dnt know wats ename
Mar 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.