Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> decode statement
Hi,
i have the following decode statement:
select DECODE(BUSINESS_CD, PAID_CD,'71','H','IL','NOT IN LIST') from FINREPDBA.T_COMMISSION_TXN;
What i want to do is to be able to select a value of IL when business_cd =71 and paid_cd=H.
I was using the statement:
select DECODE(BUSINESS_CD,'71','IL','NOT IN LIST')
from FINREPDBA.T_COMMISSION_TXN;
this worked fine.
What am i doing wrong? How can you add a second column into a decode statement?
thanks,
Gareth
Received on Tue Feb 25 2003 - 04:33:27 CST