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