Re: Update question

While you can do this with a single update and a decode(), you'll find that the decode function is rather inefficient. It would probably be faster to write a simple PL/SQL block with a cursor and a nested if statement.

Paul Schattling wrote:

> Is it possible to use an 'if' in an UPDATE statement. i.e. If I have a
> column in a table called Departments and it is made up of various values
>
> (like 'AA' and 'VC') and I want to SET these to be 'OAA' and 'VCA' (not
> always the same change) do I have to run it one by one manually or can I
> update them using an IF
> statement somehow? I have about 50 different Departments to update, of
> which there are about 95 records for each.
>
> Thanks in advance!
Received on Mon Oct 12 1998 - 00:00:00 CDT