2021年4月24日星期六

SQL Error: ORA-00904: "CHAMPIONSHIPS": invalid identifier

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

没有评论:

发表评论