By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Create Table Error -- Help Please

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Victor,

I have just copied and pasted your script and it works well. The table
was created successfully.

There may be an invisible character in your script.

I reccommend you to write your script in a file and start from there.

@c:\scr.sql
best regards....
Jul 19 '05 #2

P: n/a
Hi Victor,

I have just copied and pasted your script and it works well. The table
was created successfully.

There may be an invisible character in your script.

I reccommend you to write your script in a file and start from there.

@c:\scr.sql
best regards....
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.