oracle11g - ORA-00911: 无效字符错误

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),
);

你好，谁能告诉我为什么我收到

ORA-00911: invalid character Error

当我尝试在 Oracle Application Express 11g 中运行此代码时？

谢谢!

Answer 1

似乎在最后一行后面多了一个逗号:

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

删除它应该可以解决问题( link to a demo on sqlfiddle )。