![not found where expected not found where expected](https://user-images.githubusercontent.com/4084443/38464825-0aafde10-3b14-11e8-941a-cc8594bd0575.png)
Problem select id, name as senior manager from emp Ġ0923. The column name contains a space in between and no double quotes is used to the column name. Oracle will treat the error in the column list and expects the FROM keyword in the select statement to specify the table or view name. If there is a mistake in the list of column names in the select statement, an error message will be displayed. If the FROM keyword is used in combination with the name of a column, Oracle will consider the FROM keyword to be one of the columns and will expect the FROM keyword to identify the table or view name. The FROM keyword should come before the table or view name and after the list of column names. If the FROM keyword is misplaced in the select statement, an error notice will be produced. The FROM keyword must be properly written. In this scenario, the table or view name could not be discovered. The FROM keyword was not found in the query, thus the select statement failed. Oracle will give an error if the FROM keyword in the select statement is misspelled.
![not found where expected not found where expected](http://tarstarkas.net/wp-content/uploads/2017/10/this-is-not-what-i-expected-05-600x338.jpg)
00000 - "FROM keyword not found where expected" Solution select id,name FROM emp Check that the FROM keyword is present in the select query. The select statement reads the table or view name and retrieves data from it. If the FROM keyword is not present in the select statement, it should be added before the table or view name. As a result, an Oracle error “ORA-00923: FROM keyword not found where expected” will be thrown. In this example, the select statement expects the presence of a FROM keyword in the query. If the FROM keyword is missing, misplaced, or misspelled in the select statement, the table name cannot be identified. The FROM keyword will be used in the select statement to specify the table or view name from which the data will be retrieved. 00000 - "FROM keyword not found where expected" ORA-00923: FROM keyword not found where expectedĠ0923. If you examine the sql query in and around the FROM keyword, you may be able to rectify the error.
#Not found where expected code#
The error will occur if there are any errors in the code written before the FROM keyword. The error will occur in the Oracle database if the FROM keyword is missing, misspelled, or misplaced in the select statement. The issue ORA-00923: FROM keyword not found where expected will be fixed if you rewrite the select query along with the FROM keyword.
![not found where expected not found where expected](https://pic.pimg.tw/rx1226/1439728676-4188193030_n.png)
The issue is caused by the FROM keyword or the code written before the FROM keyword. The select statement could not identify the table names if the FROM keyword was missing, misspelled, or misplaced. The FROM keyword is used in the select statement to specify the table or view name. If the FROM keyword is not found where it should be, an error message ORA-00923: FROM keyword not found where expected will be displayed. If the the FROM keyword is missing from the SQL query, misspelled, or misplaced in the select statement, Oracle parser will fail to detect the FROM keyword. If an error occurs when checking for the FROM keyword, the table name cannot be found. The FROM keyword is used to identify the table name.
![not found where expected not found where expected](https://i.ytimg.com/vi/DcP40hozspY/maxresdefault.jpg)
The ORA-00923: FROM keyword not found where expected error occurs when the FROM keyword is missing, misspelled, or misplaced in the Oracle SQL statement such as select or delete.