Re: (newbie ?) : SELECT within a DECODE in ORACLE
Date: Wed, 10 Apr 2002 14:46:12 -0400
Message-ID: <TD%s8.47747$gA5.4759834_at_e3500-atl2.usenetserver.com>
It might be the the (select s.status_desc .... is not returning any result
in some cases.
So add an NVL function to it: NVL((select s.status_desc ...),NULL)
zamo
"CaffeineJunkie" <tooantsy_at_yahoo.com> wrote in message
news:9fe0e50c.0204091025.5166c55c_at_posting.google.com...
> I'm trying to issue a select within a DECODE STATEMENT (I've read on
> another oracle message board that SELECT within a DECODE would work).
> Followed the example, but PL/SQL is flagging a 'MISSING EXPRESSION'
> during my testing :
>
> Here's the DECODE line:
>
> DECODE(B.issue_type, 6, E.status_desc, 8,(select s.status_desc from
> item_tbl I, status_tbl S where I.status_no = S.status_no and I.item_id
> = B.item_id), ' '),
>
> Any help would be appreciated, thanks.
> --
Received on Wed Apr 10 2002 - 20:46:12 CEST