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]%'
0 comments:
Post a Comment