CODEWITHSUNDEEP
sqloracle-database
user1825861
user1825861

Reputation: 49

ORA-00903: invalid table name

I have the following database table:

CREATE TABLE pontaje
    (
    coda        NUMBER(4) REFERENCES angajati( coda ),
    data        DATE,           
    ore         NUMBER(3)   
    );

When I run the code :

SELECT coda, SUM(ore) AS totalore
FROM   pontaje,
GROUP BY coda

I get ORA-00903: invalid table name.

But I know the table exists because: SELECT * FROM pontaje works.

Upvotes: 3

Views: 20704

Answers (2)

John Woo
John Woo

Reputation: 263943

SELECT coda, SUM(ore) AS totalore
FROM pontaje                       -- << remove comma
GROUP BY coda

Upvotes: 4

threenplusone
threenplusone

Reputation: 2122

Remove the comma after the table name.

Upvotes: 11

Related Questions