This is my data:
CREATE TABLE FavoriteBasketballTeams TeamName VARCHAR(255) Primary Key, DateCreated Date, Championships INT NOT NULL, FinalsAppearances INT NOT NULL ; INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Nets','1976','0','2'); INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Thunder','1967','1','4'); INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Lakers','1948','17','32'); INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Trailblazers','1970','1','3');
And these are the errors I get:
Error starting at line : 1 in command - CREATE TABLE FavoriteBasketballTeams TeamName VARCHAR(255) Primary Key, DateCreated Date, Championships INT NOT NULL, FinalsAppearances INT NOT NULL Error report - ORA-00922: missing or invalid option 00922. 00000 - "missing or invalid option" *Cause: *Action: Error starting at line : 7 in command - INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Nets','1976','0','2') Error at Command Line : 7 Column : 58 Error report - SQL Error: ORA-00904: "CHAMPIONSHIPS": invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: Error starting at line : 8 in command - INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Thunder','1967','1','4') Error at Command Line : 8 Column : 58 Error report - SQL Error: ORA-00904: "CHAMPIONSHIPS": invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: Error starting at line : 9 in command - INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Lakers','1948','17','32') Error at Command Line : 9 Column : 58 Error report - SQL Error: ORA-00904: "CHAMPIONSHIPS": invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: Error starting at line : 10 in command - INSERT INTO FavoriteBasketballTeams(TeamName,DateCreated,Championships,FinalsAppearances) Values('Trailblazers','1970','1','3') Error at Command Line : 10 Column : 58 Error report - SQL Error: ORA-00904: "CHAMPIONSHIPS": invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action:
https://stackoverflow.com/questions/67248753/sql-error-ora-00904-championships-invalid-identifier April 25, 2021 at 08:43AM
没有评论:
发表评论