Decode is exactly what you need to do this.
Jon wrote in message <86s74h$dfq2_at_svlss.lmms.lmco.com>...
>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-
>I'm new to Oracle can anyone help me get this done with one query.
>
>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
>
>
>
Received on Fri Jan 28 2000 - 09:51:43 CST
