Oracle error
ORA-00904
ORA-00904: "%s": invalid identifier
What usually causes it
A column name is misspelled, doesn't exist, or was created in mixed case with double quotes.
What to check first
DESC the table. Names created with double quotes are case-sensitive and must be quoted the same way every time.
Scripts that help
- Generate DDL for a table and an indexUses DBMS_METADATA to write the CREATE statements for a table and one of its indexes into ddl_list.sql in your current directory. Prompts for the…