mysql - 无法解析查询，请检查查询的语法。 (ORA-00905 : missing keyword)

Question

尝试使用以下 SQL 查询创建交互式报告。出现标题中提到的错误。

SELECT 
  FIRST_NAME||' '||LAST_NAME "USERNAME" 
FROM 
  USERS 
WHERE 
  USERNAME IN (
    select 
      username 
    from 
      users 
    where 
      username not in (
        Select 
          accessed_by 
        from 
          temp_amal
        where 
          access_date >= :P2610_DATE_FROM
          and access_date <= :P2610_DATE_TO
          and (CASE :P2610_RADIO
            when 'F' then col1='F'
          end)
      )
  )
order by 1;

Answer 1

WHERE 条件的两个操作数不能位于CASE 中。只需其中之一。

SELECT FIRST_NAME||' '||LAST_NAME "USERNAME" FROM USERS WHERE USERNAME 
IN
(select username from users 
where username not in 
(Select accessed_by from temp_amal
where access_date >= :P2610_DATE_FROM
and access_date <= :P2610_DATE_TO
and col1 = (CASE :P2610_RADIO
            when 'F' then 'F'
            end)
))
order by 1;

所以，如果您想让查询更加动态。您必须进行动态 SQL 查询生成。