ORA-00907:创建外键Oracle 12c时缺少右括号
ORA-00907:创建外键Oracle 12c时缺少右括号
提问于 2018-01-01 03:58:03
我想做一个表，其中包括一个自动生成的主键和两个外键，但我面临这个错误…
create table answers
( id number generated by default on null as identity primary key
, question_id number foreign key references questions(id)
, user_id number foreign key references users(id)
, answer varchar(1000)
, post_date date);
create table answers (id number generated by default on null as identity primary key, question_id number foreign key references questions(id), user_id number foreign key references users(id), answer varchar(1000), post_date date)第1行出现
错误: ORA-00907:缺少右括号
然后，我尝试了一下：
create table answers
( id number generated by default on null as identity primary key
, question_id number foreign key (question_id) references questions(id)
, user_id number foreign key (user_id) references users(id)
, answer varchar(1000)
, post_date date );
create table answers
( id number generated by default on null as identity primary key
, question_id number foreign key (question_id) references questions(id)
, user_id number foreign key (user_id) references users(id)
, answer varchar(1000)
, post_date date )
*第1行出现
错误: ORA-00907:缺少右括号
它仍然给出相同的错误！
但是，如果我分两步完成：
create table answers
( id number generated by default on null as identity primary key
, question_id number not null
, user_id number not null
, answer varchar(1000)
, post_date date );
Table created.
alter table answers
add foreign key (question_id) references questions(id) add foreign key (user_id) references users(id);表已更改。
有没有人能把我弄出来？
回答 2
Stack Overflow用户
发布于 2018-01-01 05:16:09
在定义内联约束作为列定义的一部分时，不需要指定foreign key
create table answers
( id number generated by default on null as identity primary key
, question_id number references questions(id)
, user_id number references users(id)
, answer varchar(1000)
, post_date date);祝你好运。
Stack Overflow用户
发布于 2018-01-01 04:10:19
您可以在底部定义外键，而不是与列名相邻，如下所示：
create table answers (
id number generated by default on null as identity primary key,
question_id number,
user_id number,
answer varchar(1000),
post_date date,
foreign key(question_id) references questions(id),
foreign key(user_id) references users(id)
);页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/48045336
复制相关文章
相似问题