SQL help invalid identifyer

[agent0064life]

I am making a database for the NFL and When I create a talbe on Iacademy's Oracle server i get an invalid identifyer error on every table I tried to create.

Create Table Teams (
Name Varchar(45) not null,
Coach Varchar(45) not null,
Wins Number(2),
Losses Number(2),
Ties Number(2) );

To me the syntax looks perfect. The server doesnt take int, but it does take number because I've made a talbe before on this server.

I can make a table with only one field but it wont let me make more because this gives me an invalid identifyer:

Alter Table Teams Add column Blahblah Varcher(25);

 

[JarlH]

Well, this is the ANSI forum, and ANSI SQL has no Number data type. Except from using that data type your statement is ANSI SQL compliant.

Maybe you should try an Oracle forum?