Top "Ora-00923" questions

ORA-00923: FROM keyword not found where expected.

How do you select all columns, plus the result of a CASE statement in oracle 11g?

I want to select *, and not have to type out all individual columns, but I also want to include a …

Read More
sql oracle ora-00923
"ORA-00923: FROM keyword not found where expected" Encountered in my oracle query

SELECT TITLE, CONCAT(TO_CHAR(SUM((COST-RETAIL)/COST)*100), '100'), '%') AS "Markup" FROM BOOKS GROUP BY TITLE; ::THE …

Read More
sql oracle ora-00923
PLSQL CASE WHEN CONDITION

I have two queries. Query 1. Below PL/SQL is not working. I want to store the output into varable test1 …

Read More
sql oracle plsql oracle10g ora-00923
ORA-00923 FROM keyword not found where expected

I am trying to concatenate some fields to return a single string for each row from an oracle table. This …

Read More
sql oracle plsql ora-00923
Why am I getting "ORA-00923: FROM keyword not found where expected"?

Why is the "From" seen as being in the wrong spot? I had to change double quotes to single quotes …

Read More
sql oracle ora-00923
ORACLE SQL listagg function

I'm not sure what's going on here, mostly because I've never used this function, but when I use the listagg …

Read More
sql oracle ora-00923
oracle10g hibernate problem

when my app startup, i get error like below, can anyone elaborate what i missed out? the app running fine …

Read More
java oracle hibernate connection-pooling ora-00923