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

sql oracle ora-00923
Tas picture Tas · Mar 21, 2013 · Viewed 15.5k times · Source 
      SELECT TITLE, CONCAT(TO_CHAR(SUM((COST-RETAIL)/COST)*100), '100'), '%') 
      AS "Markup"
      FROM BOOKS
      GROUP BY TITLE;

::THE GOAL::
I'm trying to calculate the mark-up for my products (books).

::ZE PROBLEM::
When I try to run the stated SQL, I get the error

ORA-00923: FROM keyword not found where expected

In advance I thank you for any and all input on my issue.

Answer

munch1324 picture munch1324 · Mar 21, 2013

Your parentheses are not balanced I count 4 left and 5 right. This error usually happens when there is a formatting error that prevents the FROM clause from being reached (missing/extra comma, unbalanced bracket, etc)

Related questions

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 custom column with a case statement. I tried the following: select *, (case when PRI_VAL = 1 then 'High' when PRI_VAL = 2 …

Read More
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 and test2. It's saying ORA-00923: FROM keyword not found. Not sure what is wrong DECLARE file_id NUMBER(10) NOT NULL :=5; …

Read More
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 is in 10g. Here is my query: SELECT t.value || '|' || t.label || '|' t.label_abbrv || '||…

Read More