Re: Limit UPDATE statements to affect only one row

Serge Rielau wrote:
> DA Morgan wrote:

>> I often find using a valid syntax improves things in Oracle.
>> Perhaps that isn't required with DB2.
>>
>> UPDATE (
>>   SELECT sal
>>   FROM emp)
>> SET sal = 1
>> WHERE rownum = 1;

Anyone can write invalid syntax and state it doesn't work. My point was that <=1 makes no sense when applied to rownum: Your cat would appreciate that.

But I must say I find it amusing that you, without benefit of an installed copy of Oracle, comment on Oracle syntax while not one person here, without DB2 installed, would ever critique DB2 syntax in the corresponding IBM usenet group. Doesn't it ever bother you that you are giving syntax advice on a product you claim to not have?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org