create table godown_list
(
productid char(8) not null,
username varchar2(8) not null,
godownname varchar2(8) not null
godowntime date default sysdate,
godownnum number default 0,
constraint pk_godown_list primary key(productid,username,godownname),
constraint pk_godown_list foreign key(productid) references storage_list(productid),
constraint pk_godown_list foreign key(username) references manager(username)
);为什么会出现missing or invalid option错误????
(
productid char(8) not null,
username varchar2(8) not null,
godownname varchar2(8) not null
godowntime date default sysdate,
godownnum number default 0,
constraint pk_godown_list primary key(productid,username,godownname),
constraint pk_godown_list foreign key(productid) references storage_list(productid),
constraint pk_godown_list foreign key(username) references manager(username)
);为什么会出现missing or invalid option错误????
(
gdname varchar2(8) not null,
gdtime date default sysdate,
gdnum number default 0,
productid char(8) not null,
username varchar2(8) not null,
constraint pk_godown_list primary key(productid,username,gdname),
constraint fk_godown_list foreign key(productid,username) references storage_list(productid,username)
);我外行,哈哈
这里后面少个逗号
create table godown_list
(
productid char(8) not null,
username varchar2(8) not null,
godownname varchar2(8) not null
godowntime date default sysdate,
godownnum number default 0,
constraint pk_godown_list primary key(productid,username,godownname),
constraint pk_godown_list1 foreign key(productid) references storage_list(productid),
constraint pk_godown_list2 foreign key(username) references manager(username)
);
(
productid char(8) not null,
username varchar2(8) not null,
godownname varchar2(8) not null,
godowntime date default sysdate,
godownnum number default 0,
constraint pk_godown_list primary key(productid,username,godownname),
constraint fk_godown_list1 foreign key(productid) references storage_list(productid),
constraint fk_godown_list2 foreign key(username) references manager(username)
);
(productid char(8) not null,
username varchar2(8) not null,
godownname varchar2(8) not null,--这里少了逗号
godowntime date default sysdate,
godownnum number default 0,
constraint pk_godown_list primary key(productid,username,godownname),
constraint fk_godown_list foreign key(productid) references storage_list(productid),
constraint fk_godown_manager foreign key(username) references manager(username)
)
--主外键约束名称不能一样