Query
From: Deepesh Garg <deepesh_garg_at_yahoo.com>
Date: 27 Nov 2002 17:06:11 -0800
Message-ID: <b21bb3.0211271706.4648cd0e_at_posting.google.com>
Date: 27 Nov 2002 17:06:11 -0800
Message-ID: <b21bb3.0211271706.4648cd0e_at_posting.google.com>
Hi,
update some_table set some_field = 'some value', primary_key_field =
100 where primary_key_field = 100
I know its stupid, but I want to know that why this type of query
hangs. If I remove the primari_key_field = 100 from set part of the
query, it runs fine.
-Deepesh.
I am running a query of this sort (on Oracle 8i) and it seems to hang
most of the time. Can anyone tell me why does it hangs.