Hi All,
I want to use a case statement in my query in XMLELEMENT but it throws an error "PL/SQL: ORA-00904: "EVALNAME": invalid identifier". I think I am using it incorrectly.
Could you please suggest how to use the case in the XML element correctly?
SELECT XMLELEMENT (
"Emp"
, XMLELEMENT (
"Name"
, evalname (
CASE
WHEN empno > 7499 THEN
job
ELSE
NULL
END
)
)
) AS "Result"
FROM emp e
WHERE empno > 7499;