ORA-00904: invalid identifier

ORA-00904: invalid identifier

Oracle PL/SQL error message: ORA-00904: invalid identifier.

Cause:

The column name entered is either missing or invalid.

Solution:

Check for correct column name. Enter a valid column name.

Example:

CREATE TABLE TEST2
   (TEST_ID NUMBER NOT NULL ENABLE, 
	TEST_NAME VARCHAR2(5) NOT NULL ENABLE
   );
   
INSERT INTO TEST2(TEST_ID, TEST_ABC) VALUES (2 'test');   

Output:

SQL Error: ORA-00904: TEST_ABC: invalid identifier

Correct:

INSERT INTO TEST2(TEST_ID, TEST_NAME) VALUES (2, 'test');

Output:

1 rows inserted.