UPDATE QUERY QUESTION
Date: 2000/01/28
Message-ID: <86s74h$dfq2_at_svlss.lmms.lmco.com>#1/1
I need to do a single update query with the following:
I'm new to Oracle can anyone help me get this done with one query.
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';
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 - 00:00:00 CET