Re: (newbie ?) : SELECT within a DECODE in ORACLE
From: Valentin Minzatu <vminzatu_at_rogers.com>
Date: Tue, 09 Apr 2002 20:20:36 GMT
Message-ID: <o2Is8.30323$Oo1.23233_at_news02.bloor.is.net.cable.rogers.com>
Date: Tue, 09 Apr 2002 20:20:36 GMT
Message-ID: <o2Is8.30323$Oo1.23233_at_news02.bloor.is.net.cable.rogers.com>
DECODE syntax:
DECODE( expr, search, result, [expr, search, result, ...], default)
If you format you text like below, you'll see that your decode cannot work
as you compare a number with a character ....
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), ' '
)
Received on Tue Apr 09 2002 - 22:20:36 CEST