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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I use N different where clauses in a single update statement?

Re: How can I use N different where clauses in a single update statement?

From: dean <deanbrown3d_at_yahoo.com>
Date: 14 Sep 2005 10:06:50 -0700
Message-ID: <1126717610.085349.202990@o13g2000cwo.googlegroups.com> 





Yes I was considering exactly that, but won't this result in updates to
records where the values are NOT changed? What I mean is, if a field
value is (for example) 'ABCDEF', and you update it to the same value,
won't that still be an update that gets processed by Oracle?



What I'm really looking for is how to vary the WHERE clause for each
field I need to update.
Received on Wed Sep 14 2005 - 12:06:50 CDT












Original text of this message













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