Oracle/PLSQL: ORA-00923 Error

Error:

ORA-00923: FROM keyword not found where expected

Cause:

You tried to execute a SELECT statement, and you either missed or misplaced the FROM keyword.

Action:

The options to resolve this Oracle error are:

This error can occur when executing a SELECT statement.

For example, if you tried to execute the following SELECT statement:

SELECT *
suppliers;

You could correct this SELECT statement by including the FROM keyword as follows:

SELECT *
FROM suppliers;

For more information on the SELECT statement, go to our SELECT Statement webpage.

This error can also occur if you use an alias, but do not include the alias in double quotation marks.

For example, if you tried to execute the following SQL statement:

SELECT owner as 'owner column'
FROM all_tables;

You could correct this SELECT statement by using double quotation marks around the alias.

SELECT owner as "owner column"
FROM all_tables;