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
Share:
19,358

Related videos on Youtube

user1825861
Author by

user1825861

Updated on September 15, 2022

Comments

  • user1825861
    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.