Sorry for the ignorance again...
Is this correct?
UPDATE SECTIONS
SET PHASE = DECODE(conductor, '2-4', 'ABC'
'4-2, 6-2', 'ABC'
'4-3', 'ABC'
'4/0-3, 2/0-', 'ABC'
'6-1, 4-1', 'A'
'6-2', 'A'
'6-2, 4-2', 'ABC')
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-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.
>
>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 - 11:49:19 CST
