oracle建表时出现缺失右括号问题
在iSQL*PLUS中输入如下内容建表,该表参照的表都已经建好
create table tb_fault_info
(
fid int identity(1,1) primary key,
fsim char(40) not null,
fdet char(600) not null,
company char(40) not null,
ftime datetime not null,
gid int foreign key references tb_group(gid),
fsid int foreign key references tb_fault_state(fsid),
addf char(600),
fnum char(10) not null,
fc int not null
);
出现如下问题:
fid int identity(1,1) primary key,
*
第 3 行出现错误:
ORA-00907: 缺失右括号
都改了一天了,希望各位朋友帮帮忙,我很着急