Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limit UPDATE statements to affect only one row
DA Morgan wrote:
> Serge Rielau wrote:
>> Here are a couple of wild guesses: >> >> UPDATE emp SET sal = 1 WHERE rownum <= 1
Cheers
Serge
-- Serge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ondemandbusiness/conf2006/Received on Fri Aug 11 2006 - 11:47:25 CDT