ANKUSH THAVALI
- 05 Nov, 2021
- 0 Comments
- 1 Min Read
ORA-00904 ERROR MESSAGE “INVALID IDENTIFIER”
ORA-00904 ERROR MESSAGE “INVALID IDENTIFIER”
Error Ora-00904 means you are attempting to execute an SQL statement that is one of the following:
- The SQL statement includes an invalid column name.
- The SQL statement includes a column name which does not currently exist.
- The column name cannot be a reserved word.
- The first letter of the column name must be a letter.
- The column name must be less than or equal to 30 characters.
- The column name must be made up of alphanumeric characters.
- The column name can contain any of the following 3 characters: $, _, #. If the column name includes any other characters, it must be enclosed with double quotation marks.