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 10:57:16 -0800
Message-ID: <1135882636.914297.117950@g43g2000cwa.googlegroups.com> 





It perfectly worked for me. Thanks a million for such simple solution.
Just a last followup question -


The update sql seems to be very innocent with an explained cost of 3
for a 50000 row update but it takes long time (about 500s or more) to
update the table. Do you think bulk update in PL/SQL should be a better
choice than these? Or is it theoretically it will be slower. Just any
thought if you have.



Thanks again.
Received on Thu Dec 29 2005 - 12:57:16 CST












Original text of this message













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