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: Updating a large table (Recursively?)

Re: Updating a large table (Recursively?)

From: Marcus Reichardt <mr_at_diamanda.hh.eunet.de>
Date: Thu, 13 Aug 1998 13:14:15 +0200
Message-ID: <35D2CA87.68FF@diamanda.hh.eunet.de> 





If I got it right, you could decrement ORDINDEX by one, begining with
the first order following the order to be "deleted". Before doing so you
have to assign a new ORDINDEX to the obsolete order row.



    
  
  1.   UPDATE ORDERTABLE SET ORDINDEX = <max ORDINDEX> + 1 WHERE ORDINDEX =

    
<ORDINDEX to be deleted>

    

  
  2.   UPDATE ORDERTABLE SET ORDINDEX = ORDINDEX - 1 WHERE ORDINDEX >


    
<ORDINDEX to be deleted>

    






Marcus Reichardt


Consultant
Received on Thu Aug 13 1998 - 06:14:15 CDT












Original text of this message













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