Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

invalid identifier

Status
Not open for further replies.

agent0064life

Programmer
Joined
Dec 9, 2004
Messages
2
Location
US
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);
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top