Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Apr 29, 2024

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.