Home -> Usenet -> comp.databases.oracle -> (newbie ?) : SELECT within a DECODE in ORACLE

(newbie ?) : SELECT within a DECODE in ORACLE

From: CaffeineJunkie <tooantsy_at_yahoo.com>
Date: 9 Apr 2002 11:25:39 -0700
Message-ID: <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 Tue Apr 09 2002 - 20:25:39 CEST












Original text of this message