Oracle error ORA-00923
The ORA-00923 error is caused when the FROM keyword is not found where expected.
The 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.
Remedy: 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.