3 Replies Latest reply: Aug 2, 2013 2:23 AM by goldie12 RSS

    I am unable to run this query and fetch the data according to the column.ORA-00920 'Invalid Relational Operator' Error is coming. '

    goldie12

      Here is the Query.I am trying to fetch different values from column STATE_PROVINCE by Case expression but
      ORA-00920 'Invalid Relational Operator' Error is coming.'

       

      SELECT CITY,STREET_ADDRESS,STATE_PROVINCE,

      CASE WHEN (STATE_PROVINCE,'Washington') then 'Headquarters'

           WHEN (STATE_PROVINCE,'Texas') then 'Oil Wells'

           WHEN (STATE_PROVINCE,'California') then CITY

           WHEN (STATE_PROVINCE,'New Jersey') then STREET_ADDRESS

           ELSE 'Wrong Input'

           END LOCATION_INFO

      FROM LOCATIONS WHERE COUNTRY_ID='US' ORDER BY LOCATION_INFO