Re: Select clause in the decode syntax

On 21 Dec 2001 07:49:15 -0800, rharve_at_hotmail.com (Ravindra Harve) wrote:

>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

It is not possible, which can be verified in the sql reference manual online at http://tahiti.oracle.com
Mere syntax questions are best avoided here.

apparently you need
decode(cs_applicant_case_goals.goal_type,1421, codes.description, cs_applicant_case_goals.description) as description

It can't decide for you though how you would join cs_applicant_case_goals and codes together as you don't provide any info on them.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Dec 21 2001 - 12:39:00 CST