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 -> Select clause in the decode syntax

Select clause in the decode syntax

From: Ravindra Harve <rharve_at_hotmail.com>
Date: 21 Dec 2001 07:49:15 -0800
Message-ID: <835dd0ad.0112210749.3083a34a@posting.google.com> 





Is it possible to have a select syntax in the decode function ?



Eg: decode(cs_applicant_case_goals.goal_type <> 1421,
cs_applicant_case_goals.description, select codes.description from
codes where codes.code = 1421) as description



If the above statement is not possible, is there any other way to get
a solution ?



Regards


Ravi
Received on Fri Dec 21 2001 - 09:49:15 CST












Original text of this message













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