Adsense Ad

Thursday, 25 May 2017

Oracle: ORA-00923 Error Message

ORA-00923 Error Message

Learn the cause and how to resolve the ORA-00923 error message in Oracle.

Description

When you encounter an ORA-00923 error, the following error message will appear:
  • 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.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

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;

Option #2

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;

No comments: