ORA-00931: missing identifier
Cause: The specified string does not contain an identifier
Action: Correct the string argument
All posts by mpbod
ORA-00930: missing asterisk
ORA-00930: missing asterisk
Cause: This is an internal error message not usually issued
Action: Contact Oracle Support Services
ORA-00929: missing period
ORA-00929: missing period
Cause: This is an internal error message not usually issued
Action: Contact Oracle Support Services
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
Cause: A SELECT subquery must be included in a CREATE VIEW statement
Action: Correct the syntax. Insert the required SELECT clause after the CREATE VIEW clause and then retry the statement
ORA-00927: missing equal sign
ORA-00927: missing equal sign
Cause: An equal sign has been omitted in one of the following places: In the SET clause of an UPDATE statement Following “!” in a search condition to signify not equal
Action: Correct the syntax. Insert the equal sign where required and retry the statement
ORA-00926: missing VALUES keyword
ORA-00926: missing VALUES keyword
Cause: An INSERT statement has been entered without the keyword VALUES or SELECT. Either a VALUES clause or a SELECT subquery must follow the INSERT INTO clause
Action: Correct the syntax. Enter either a VALUES clause or a subquery after the INSERT INTO clause
ORA-00925: missing INTO keyword
ORA-00925: missing INTO keyword
Cause: An INSERT statement has been entered without the keyword INTO
Action: Correct the syntax. Insert the keyword INTO where required and then retry the statement
ORA-00924: missing BY keyword
ORA-00924: missing BY keyword
Cause: The keyword BY was omitted in a GROUP BY, ORDER BY, or CONNECT BY clause. In a GRANT statement, the keyword IDENTIFIED must also be followed by the keyword BY
Action: Correct the syntax. Insert the keyword BY where required and then retry the statement
ORA-00923: FROM keyword not found where expected
ORA-00923: FROM keyword not found where expected
Cause: In a SELECT or REVOKE statement, the keyword FROM was either missing, misplaced, or misspelled. The keyword FROM must follow the last selected item in a SELECT statement or the privileges in a REVOKE statement
Action: Correct the syntax. Insert the keyword FROM where appropriate. The SELECT list itself also may be in error. If quotation marks were used in an alias, check that double quotation marks enclose the alias. Also, check to see if a reserved word was used as an alias
ORA-00922: missing or invalid option
ORA-00922: missing or invalid option
Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error
Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification