Re: Limit UPDATE statements to affect only one row

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

Do you contributions here mean you've finally installed a copy of Oracle or are you just guessing at syntax? ;-)

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