Re: UPDATE QUERY QUESTION

A copy of this was sent to "Jon" <J_S_Finley_at_yahoo.com> (if that email address didn't require changing) On Fri, 28 Jan 2000 08:59:03 -0500, you wrote:

>I need to do a single update query with the following:
>
>UPDATE sections SET PHASE = 'A' WHERE CONDUCTOR = '2-2, 2-2';
>UPDATE sections SET PHASE = 'AB' WHERE CONDUCTOR = '2-3';
>UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '2-4';
>UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '4-2, 6-2';
>UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '4-2-, 6-2';
>UPDATE sections SET PHASE = 'AB' WHERE CONDUCTOR = '4-3';
>UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '4/0-3, 2/0-1';
>UPDATE sections SET PHASE = 'A' WHERE CONDUCTOR = '6-1, 4-1';
>UPDATE sections SET PHASE = 'A' WHERE CONDUCTOR = '6-2';
>UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '6-2, 4-2';
>
>I'm new to Oracle can anyone help me get this done with one query.
>

update sections set phase = ( decode conductor, '2-2, 2-2', 'A',
                                                '2-3',      'AB',
                                                '2-4',      'ABC',
                                                 ....
                                                '6-2, 4-2', 'ABC',
                                                 phase )   -- default 

>This is how I do it in ACCESS
>
>UPDATE SECTIONS SET SECTIONS.PHASE =
>IIf([conductor]="2-4","ABC",IIf([conductor]="4-2,
>6-2","ABC",IIf([conductor]="4-3","ABC",IIf([conductor]="4/0-3,
>2/0-","ABC",IIf([conductor]="6-1,
>4-1","A",IIf([conductor]="6-2","A",IIf([conductor]="6-2,
>4-2","ABC",[PHASE])))))));
>
>I thought about decode would that work or is there something real simple
>that I am missing here. I apologize for my ignorance I'm very new to this
>program.
>Thanks
>-Jon
>
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jan 28 2000 - 11:41:33 CST