Re: Limit UPDATE statements to affect only one row

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 11 Aug 2006 09:57:51 -0700
Message-ID: <1155315472.434052@bubbleator.drizzle.com>

Serge Rielau wrote:
> DA Morgan wrote:

>> Serge Rielau wrote:
>>> Here are a couple of wild guesses:
>>>
>>> UPDATE emp SET sal = 1 WHERE rownum <= 1
>>
>> Fascinating logic. Less than or equal to ...
>>
>> How does that differ from WHERE rownum = 1;?

> Much more interesting than your nit would be whether one of my proposals
> works.
> And, no, I don't have Oracle installed any more than you have IDS
> installed. At least my contributions are constructive. :-)
>
> Cheers
> Serge

You don't think I have IDS installed ... On what basis? This is a university ... we have everything installed. If someone sold it, gave it away, or lost it ... we have it. And so do I. ;-)

Heck I've even got a server running Teradata.

-- 
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

Received on Fri Aug 11 2006 - 11:57:51 CDT