[펌] ORA-00923 : FROM keyword not found where expected

* 기본적으로 from절이 실제로 없는 경우에 발생하기도 하지만 from 이전 구문들이 정상적이지 않은 경우에도 해당 에러가 발생하기도 한다. 자세한 내용은 아래 참조

 

ORA-00923

Error Message

ORA-00923: FROM keyword not found where expected

Cause of Error

You tried to execute an SQL 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;

-> 실제로 from 절이 위와 같이 없는 경우에도 ora-00923 에러 발생함. 

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;

--> 기본적으로 오라클에서의 alias는 더블쿼테이션( " ) 을 사용해야 한다. 정상적인 구문은 아래 내용 참조 

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

SELECT owner as "owner column"
FROM all_tables;

 

출처 : http://spotyourerror.blogspot.kr/2013/05/ora-00923.html