select country_olympic_name, SUM(part_gold) as 'Number of Gold Medals' From games.country, games.participation where participation.country_isocode = country.country_isocode group by country_olympic_name;

I have been getting the error ORA-00923: FROM keyword not found where expected and do not know why, please help

1

5 Answers

Identifiers need to be quoted with double quotes ("). Single quotes (') denote a character value (not a "name").

Therefor you need to use:

SUM(part_gold) as "Number of Gold Medals"

More details in the manual:

• Database Object Names and Qualifiers
• Text literals

0

Check reserved words. This was my issue. For whatever reason using "size" as a column alias caused oracle to spit that exact error out and it had me scratching my head for a while.

select 1 size, 1 id from dual

You may try doing this:-

select country_olympic_name, SUM(part_gold) as "Number of Gold Medals"
From games.country, games.participation
where participation.country_isocode = country.country_isocode
group by country_olympic_name;

Try this...

SELECT COUNTRY_OLYMPIC_NAME, SUM ( PART_GOLD ) AS NUMBER_OF_GOLD_MEDALS
FROM GAMES.COUNTRY, GAMES.PARTICIPATION
WHERE PARTICIPATION.COUNTRY_ISOCODE = COUNTRY.COUNTRY_ISOCODE
GROUP BY COUNTRY_OLYMPIC_NAME;

1

In my case, I had this query

SELECT BANK_NAME
DECODE (SWIFT_CODE, 'BRDEROBU', 'BRD', 'NO RESULT') RESULT
FROM BANK_GAR;

As you may see, I didn't had the comma after the SELECT BANK_NAME line.

The correct query is:

SELECT BANK_NAME,
DECODE (SWIFT_CODE, 'BRDEROBU', 'BRD', 'NO RESULT') RESULT
FROM BANK_GAR;

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy