ORA-00903: invalid table name
19,358
Solution 1
Remove the comma after the table name.
Solution 2
SELECT coda, SUM(ore) AS totalore
FROM pontaje -- << remove comma
GROUP BY coda
Related videos on Youtube
Author by
user1825861
Updated on September 15, 2022Comments
-
user1825861 about 1 year
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.