This content has been marked as final. Show 1 reply
I'm not an Oracle expert, but in general, here are some things I would examine:
- nesting of parentheses
- I don't see an "end" - I don't know if that is required in Oracle, but it is in SQL Server and Tableau
- Again, I don't know Oracle, but in every other language/environment I have worked in, with a Case statement has multiple "when/then"s and only one "else." I see several "else"es. Is that normal for Oracle?
- Have you tried that query in an Oracle environment?
I apologize if none of this is of any help.