Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> decode statement

decode statement

From: gareth hoy <ghoy_at_yourplus.com>
Date: 25 Feb 2003 02:33:27 -0800
Message-ID: <e034dbf5.0302250233.1191bedd@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US