ORA-00911: invalid character Error

Question

DROP TABLE employee CASCADE CONSTRAINTS;
CREATE TABLE employee (
fname    varchar2(15) not null, 
minit    varchar2(1),
lname    varchar2(15) not null,
ssn      char(9),
bdate    date,
address  varchar2(30),
sex      char,
salary   number(10,2),
superssn char(9),
dno      number(4),
);

Hello, could anyone tell me why I receive

ORA-00911: invalid character Error

When I try to run this code in Oracle Application Express 11g?

Thank you!

This is old but wanted to say that I get this when I include a ; at the end of my query. Since the oci adds this for you it does not like when you add it yourself. — michael.schuett, Oct 15 '14 at 19:56

score 3 · Accepted Answer · answered Mar 04 '13 at 01:18

3

It appears that you have an extra comma after the last line:

dno      number(4), -- <<=== Here

Removing it should fix the problem (link to a demo on sqlfiddle).

answered Mar 04 '13 at 01:18

Sergey Kalinichenko

714,442
84
1,110
1,523

@Adam The problem is not coming from that declaration then: I tried it on sqlfiddle with Oracle 11g R2, and the table creation went fine. – Sergey Kalinichenko Mar 04 '13 at 01:32
DROP TABLE employee CASCADE CONSTRAINTS; which helped , and cleaned error – weia design Mar 04 '13 at 01:34

ORA-00911: invalid character Error

1 Answers1