Sunday, May 4, 2008

ORA-00904: invalid identifier

ORA-00904: "string": invalid identifier/invalid column name

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name.

A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks.

A valid column name may not be an oracle reserver word. The following sql command show list all oracle reserved words

select keyword from V_$RESERVED_WORDS'
or to query the reserved word related to your term just use the following one:
select keyword from V_$RESERVED_WORDS where keyword like '%[your column term]%'