ORA-00971: missing SET keyword
Cause: The keyword SET in an UPDATE statement is missing, misspelled, or misplaced
Action: Check syntax and spelling, and use the keyword SET after the name of the table to be updated
All posts by mpbod
ORA-00970: missing WITH keyword
ORA-00970: missing WITH keyword
Cause: The keyword START was specified without the keyword WITH. Both keywords are necessary if a START WITH clause is desired in a tree-structured query
Action: Change the keyword START to the keywords START WITH. Then retry the statement
ORA-00969: missing ON keyword
ORA-00969: missing ON keyword
Cause: The keyword ON in a GRANT, REVOKE, or CREATE INDEX statement was missing, misspelled, or misplaced
Action: Check syntax and spelling, and use the keyword ON where required
ORA-00968: missing INDEX keyword
ORA-00968: missing INDEX keyword
Cause: The keyword INDEX in a CREATE UNIQUE INDEX or VALIDATE INDEX statement was missing, misspelled, or misplaced
Action: Correct the syntax
ORA-00967: missing WHERE keyword
ORA-00967: missing WHERE keyword
Cause: The keyword WHERE in a SELECT statement was missing, misspelled, or misplaced.
Action: Correct the syntax
ORA-00966: missing TABLE keyword
ORA-00966: missing TABLE keyword
Cause: A LOCK statement was specified and the keyword TABLE was missing, misspelled, or misplaced. A LOCK statement must begin with LOCK TABLE tablename
Action: Correct the syntax
ORA-00965: column aliases not allowed for ‘*’
ORA-00965: column aliases not allowed for ‘*’
Cause: The statement is trying to alias the * expression in the select list which is not legal
Action: Remove the alias
ORA-00964: table name not in FROM list
ORA-00964: table name not in FROM list
Cause: The table name referred in the select list is not specified in the from list
Action: Make sure the name is correctly specified and matches one of the names in the from list
ORA-00963: unsupported interval type
ORA-00963: unsupported interval type
Cause: An unsupported interval type was encountered
Action: Use a valid interval type
ORA-00962: too many group-by / order-by expressions
ORA-00962: too many group-by / order-by expressions
Cause: The group-by or order-by column list contain more than 1000 expressions
Action: Use 1000 or less expressions in the group-by or order-by list