Create Table Error -- Help Please

Hello everyone.

I'm running Oracle 8.0 on NT4 (yep thats right) and running SQL*Plus 8.03.

I'm typing the following at the SQL*Plus prompt:

1. Create Table EMPLOYEES
2. (
3. FName VARCHAR(15) NOT NULL,
4. MINIT CHAR,
5. LName VARCHAR(15) NOT NULL,
6. SSN CHAR(9) NOT NULL,
7. BDATE CHAR(25),
8. Address VARCHAR(30),
9. Sex CHAR,
10. Salary DECIMAL(10,2),
11. SUPERSSN CHAR(9),
12. DNO INT,
13. Primary Key(SSN),
14. Foreign Key(SUPERSSN) REFERENCES EMPLOYEES(SSN),
15. Foreign Key(DNO) REFERENCES DEPARTMENT(DNUMBER) 16.);

I receive the following error:

"ORA-0091:invalid Character" line 16

Can anyone suggest why I'm getting this error ? I've tried removing the character (semi-colon) but then I get a error ("missing or invalid option line 16" )for the next Create Table ... statement that follows. I've tried replacing it with a comma (,) but this gives the same error as "missing or invalid option line 16".

Thanks very much for your time. Any help would be appreciated.

Victor Received on Mon Jul 07 2003 - 03:53:09 CEST