All we need is an easy explanation of the problem, so here it is.
I am typing the below code and it is returning me "ORA-00923: FROM keyword not found where expected". What is happening?
SELECT max(alias.id) AS "id", (SELECT alias.name FROM EXAM WHERE alias.id = alias.id ) AS "REF", alias.name FROM EXAM alias GROUP BY alias.name ORDER BY alias.name ASC;
Here’s a fiddle: http://sqlfiddle.com/#!4/537e2/1
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
'COLUMN PREFIX' is a scalar string, not a valid (alias) column name. Oracle (flagship, not MySQL) uses Double Quotes for such object names. (The
ORA error indicates you are using the flagship product)
Oracle does not distinguish between
''. anything compared to
NULL is unknown. Your
case statement will always go to the
I don’t think Oracle allows you to use a column alias in the
group by clause. I can’t test right now.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂