<div>
I'm guessing you are trying to use this in a where clause and it is causing a syntax problem.<br />
<br />
Can you post more of the query and what you are trying to do? &nbsp;You might need dynamic SQL.
</div>


I'm guessing you are trying to use this in a where clause and it is causing a syntax problem.

Can you post more of the query and what you are trying to do?  You might need dynamic SQL.

<div>
what about:<br />
<br />
CASE WHEN TYPE_ASSMT = 'F' THEN TTL_APPRAISE ELSE FUL_APPRAISE END AS APPRAISAL<br />
<br />
anyhow, what exactly is the error you get?
</div>


what about:

CASE WHEN TYPE_ASSMT = 'F' THEN TTL_APPRAISE ELSE FUL_APPRAISE END AS APPRAISAL

anyhow, what exactly is the error you get?

<div>
Error from designer (Visual Studio 2010 )<br />
Error in SELECT clause: expression near 'TYPE_ASSMT'.<br />
Unable to parse query text.<br />
<br />
Error from Database:<br />
<br />
ORA-00918: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;column ambiguously defined
</div>


Error from designer (Visual Studio 2010 )
Error in SELECT clause: expression near 'TYPE_ASSMT'.
Unable to parse query text.

Error from Database:

ORA-00918:      column ambiguously defined

<div>
<div class="content wysiwyg-content">
I cannot get this to work:<br />
<br />
CASE TYPE_ASSMT WHEN 'F' THEN TTL_APPRAISE ELSE FUL_APPRAISE END AS APPRAISAL<br />
Where TTL_APPRAISE and FUL_APPRAISE are columns in the table I am selecting from, I can get it to work with static values<br />
<br />
It also fails using DECODE, I am attempting to select the value &nbsp;one of two fields based on the contents of another field
</div>
</div>


I cannot get this to work:

CASE TYPE_ASSMT WHEN 'F' THEN TTL_APPRAISE ELSE FUL_APPRAISE END AS APPRAISAL
Where TTL_APPRAISE and FUL_APPRAISE are columns in the table I am selecting from, I can get it to work with static values

It also fails using DECODE, I am attempting to select the value  one of two fields based on the contents of another field

Oracle Case When with fields in table

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.