Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Regarding some update SQL with a running sequence

Re: Regarding some update SQL with a running sequence

From: saurangshu <saurangshu_at_gmail.com>
Date: 29 Dec 2005 04:50:27 -0800
Message-ID: <1135860627.183198.131390@g14g2000cwa.googlegroups.com> 





Hi Michel,



I think there is a problem here - all the rows are updated by only one
(i.e. 2450 ->2451, 1300 ->1301 etc). So, it is not adding the num but
making a shorteer window of size one and the row_number() function is
returning 1 everytime.


Any clue to resolve this?



Thanks a lot for the reply.
Received on Thu Dec 29 2005 - 06:50:27 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US