SQL

How to Resolve ORA-00904 Invalid Identifier

Posted on
Oracle Database Object Name Recognition Examples
Database Object Naming Rules Normally, Oracle treats most identifiers as case insensitive ones excepts password. But there’s some special usages should be taken care of in case of ORA-00904 invalid identifier generated. Not only ORA-00904, but ORA-00903 and ORA-00911 are also related to invalid usage on object identifiers. More specifically, ORA-00903 alerts users for invalid […]