Skip to content
Advertisement

What is the meaning of : ORA-00904: “QUANTITY”: invalid identifier

Why does the below query returns :

ORA-00904: “QUANTITY”: invalid identifier 00904. 00000 – “%s: invalid identifier”

Advertisement

Answer

It means that there’s no such column.

You can’t use column alias in a GROUP BY clause – must be “real” column name or the whole expression. Also, generally speaking, you should avoid double quotes when working with Oracle.

Guessing table contents (as you didn’t post it):

Query:


As I said, avoid double quotes; I’d go with this instead:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement