Stepwise-Lab

ORA-00904: Invalid identifier

Oracle cannot find a column or alias with this name where it was used. Common causes: a typo, a column alias used in WHERE or GROUP BY (aliases exist only in ORDER BY), a column of a table not in FROM, or a quoted identifier with the wrong case.

On the exam

This error belongs to the topic Basic SELECT of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors