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 strongm 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
Dec 9, 2004
2
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