Search code examples
sqlcase

ORA-00905: missing keyword is coming for this code


select employee_id,case first_name when first_name = "Steve" then "My name is Steve" 
                        else first_name
end
from hr.employees
where 
employee_id = 150;

Please rectify this error for me


Solution

  • It's just a type. Instead of case first_name when first_name = "Steve" you need to use case when first_name = 'Steve' or case first_name when 'Steve'

    select employee_id,case when first_name = 'Steve' then 'My name is Steve' 
                            else first_name
    end as First_Name
    from hr.employees
    where 
    employee_id = 150;