Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Error: ORA-00904

973589Nov 10 2012 — edited Nov 10 2012
Hi I'm getting the flowing error:
     Error starting at line 1 in command:
    INSERT INTO driver (registration, make, model, gvw, year, body) VALUES('4585 AW','ALBION','RIEVER',20321,1963, ' ');
    Error at Command Line:1 Column:53
    Error report:
    SQL Error: ORA-00904: "BODY": invalid identifier
    00904. 00000 -  "%s: invalid identifier"
when i do the following
INSERT INTO driver 
    (registration, make, model, gvw, year) 
    VALUES
    ('4585 AW','ALBION','RIEVER',20321,1963, ' ');
so i temporally deleted the body data and then give the error
   Error starting at line 1 in command:
    INSERT INTO driver (registration, make, model, gvw, year) VALUES('4585 AW','ALBION','RIEVER',20321,1963)
    Error at Command Line:1 Column:53
    Error report:
    SQL Error: ORA-00904: "YEAR": invalid identifier
    00904. 00000 -  "%s: invalid identifier"
i have columns both called year and body, yet I'm getting errors

how can i fix this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2012
Added on Nov 10 2012
3 comments
1,369 views