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

Home -> Community -> Usenet -> c.d.o.misc -> Re: question about DECODE

Re: question about DECODE

From: Martin Doherty <martin.doherty_at_oracle.com>
Date: Wed, 14 Aug 2002 15:16:34 -0700
Message-ID: <3D5AD6C1.B6EDB8B5@oracle.com>


begin
  select decode (PSEG.PSCDE || PSPLN.PLNFLAG

                   ,'PLANY', 1
                   , 0)

  into p_bill
  from ...
  where ...;
exception
  when others then null;
end;

Cynic wrote:

> I think DECODE is what I'm looking for, but I can't seem to figure out how
> it works.
>
> Here's what I have... I have a field called P_BILL.
> If PSEG.PSCDE = 'PLAN' and PSPLN.PLNFLAG = 'Y', then I need the P_BILL
> field to be 1. Otherwise, 0.
>
> Any suggestions?? Or any good references for DECODE??
>
> Thanks


Received on Wed Aug 14 2002 - 17:16:34 CDT

Original text of this message

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