ORA-00907:缺少右括号，找不到错误

Question

create table book_copies(
book_id integer references book(book_id) on delete cascade, 
programme_id varchar2(20) references library programme(programme_id) on delete cascade,
nof_copies integer, 
primary key(book_id,programme_id)
);

Answer 1

您可能在表名library_programme中缺少下划线。

create table book_copies(
book_id integer references book(book_id) on delete cascade, 
programme_id varchar2(20) references library_programme(programme_id) on delete cascade,
nof_copies integer, 
primary key(book_id,programme_id)
);

db<此处小提琴>