Oracle ORA-00904: ***: Invalid identifier Solution

ORA-00904: "***" invalid identifier

The possible cause of this error is that a field name in your SQL statement is incorrect,

Or the table name is wrong. In short, this type of error occurs basically because in SQL statements,

The field name does not correspond to the table. This table may exist, but the field does not exist or the table does not exist.

For example, select deptname from Stu; // at this time, the field deptname is not in the stu table.

Or

Select deptname from ABCD; // at this time, the ABCD table is a table that does not exist in the database. In other words, you have written the wrong table name.

The same error occurs in insert into dept (deptno, deptname, stuno) values (...) because the dept field does not contain the stuno field.

It is also possible that a comma is added when the last field is created during table creation.