Re: Query

What does look a little strange is your setting the primary_key_field = 100 but your where clause is looking for primary_key_field = 100. That seems redundent to me.

On 27 Nov 2002 17:06:11 -0800, deepesh_garg_at_yahoo.com (Deepesh Garg) wrote:

>Hi,
>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.
>
>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.
Received on Sat Nov 30 2002 - 02:02:18 CET