ORA-00904 error while querying the Oracle database table
When ORA-00904: invalid identifier occurs, we must enter a valid column name as it is either missing or the one entered is invalid. This error most commonly happens when we are referencing an invalid alias in a select statement.  Oracle's voice on ORA-00904 error:


  ORA-00904 string: invalid identifier
  
  Cause: The column name entered is either missing or invalid.
  
  Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. 
  If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.


To avoid ORA-00904, column names must
begin with a letter.
consist only of alphanumeric and the special characters ($_#); other characters need double quotation marks around them.
be less than or equal to thirty characters.