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

dean wrote:
> Yeah I wanted something like:
>
> update field1 where something1,
> field2 where something2,
> field3 where something3;

Not going to happen and not worth doing.

Look at making your decisions in an IF/DECODE/CASE statement and then applying them using FORALL.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)