ORA error

ORA-00904

ORA-00904: string: invalid identifier

Quick fix

Cause: The statement names a column, alias or function that Oracle cannot resolve in that part of the query: a misspelled or quoted-case column name, a column that does not exist in the table, or a SELECT-list alias used in WHERE or GROUP BY, which are evaluated before the alias exists.
Fix: Check the spelling and case against DESCRIBE table. To filter or group on an alias, repeat the expression or wrap the query in an inline view and filter the outer query. Aggregate filters belong in HAVING.

ORA-00904: invalid identifier – Column alias used in WHERE (use HAVING or inline view instead).

Database