ora-00923: Requested from keyword not found

ora-00923: Requested from keyword not found

Oracle query, if this error occurs, check the SQL statement for keywords, whether the statement is wrong, whether the word, grammatical spelling errors.

If the query's statement is passed in Plsql, the error occurs when the program runs.

If you are using the DBCP data connection pool, check that the configured test SQL is correct (my error is a configured test SQL error).

---------The following for configuration test SQL in a data connection pool

#oracle Test Select Rest
#ds. Validation=select * FROM dual

#mysql or SQL Server Test Select rest
Ds.validation=select 1