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

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.

.

Relevant Pages

  • Re: What looks like a basic SQL query still not resolved
    ... Oracle has a CONNECT BY clause to do recursive joins like this - not a ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • "order by" with "where value in" clause problem
    ... I'm using Oracle 8i on Solaris box. ... This list will be passed to query where in clause: ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • FOR UPDATE WAIT
    ... Can anybody explain why Oracle allows only INTEGERs for seconds in ... the clause FOR UPDATE WAIT? ... What would be the reason for such behavior and implementation? ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: Locking question when using Select clause with For Update and Skip locked
    ... table for update and skipped the rows locked by other sessions on same ... select top 1 empno from emp ... (we also have order by clause but will remove it here for simplicity) ... Now on Oracle system it is ...
    (comp.databases.oracle.server)
  • Re: Outer join by (+)
    ... Robert Klemme wrote: ... I can read the standard SQL just fine, because that's what I'm used to. ... WHERE clause excludes. ... This still leaves the issue of lesser expressiveness for the proprietary Oracle syntax. ...
    (comp.databases.oracle.server)