For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Please let me know how we can we use alias name in WHEN clause of CASE statement.
e.g.
SELECT id, name,
case when mon = 'JAN' THEN amt "Jan Sal"
when mon = 'FEB' THEN amt "Feb Sal"
END
FROM table;
This query throws an error : missing keyword.