You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.ja

in Reporting & Analytics for Sales

Summary:

Hello Team,

we have an sql report with multiple parameters and each parameter is a multi selelct pick list. we are trying following SQL for this and it is failing with error. Error Message = ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer11

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

SQL:

SELECT * FROM ( SELECT o.OPTY_NUMBER,

MAX(CASE WHEN v.EXTN_ATTRIBUTE_CHAR009 = 'OEM'

THEN v.EXTN_ATTRIBUTE_CHAR007 END) AS OEM_AUTO,

MAX(CASE WHEN v.EXTN_ATTRIBUTE_CHAR009 = 'Converter'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!