create table automobiles(
part_id number(5)
constraint pk_auto_part_id primary key,
parent_id number(5)
constant fk_auto_ppid_ reference automobiles(part_id),
part_cname varchar2(30) not null,
part_ename varchar2(30) not null,
mp_cost number(9,2),
desribe varchar2(20)
);报如下错误:
ORA-00922: missing or invalid option大家帮看下,我觉得没有错啊!
part_id number(5)
constraint pk_auto_part_id primary key,
parent_id number(5)
constant fk_auto_ppid_ reference automobiles(part_id),
part_cname varchar2(30) not null,
part_ename varchar2(30) not null,
mp_cost number(9,2),
desribe varchar2(20)
);报如下错误:
ORA-00922: missing or invalid option大家帮看下,我觉得没有错啊!
创建外键的时候关键字错误:constant 换成constraint
create table automobiles(
part_id number(5)
constraint pk_auto_part_id primary key,
parent_id number(5)
constraint fk_auto_ppid_ references automobiles(part_id),
part_cname varchar2(30) not null,
part_ename varchar2(30) not null,
mp_cost number(9,2),
desribe varchar2(20)
);
part_id number(5)
constraint pk_auto_part_id primary key,
parent_id number(5),
part_cname varchar2(30) not null,
part_ename varchar2(30) not null,
mp_cost number(9,2),
desribe varchar2(20),
constraint fk_auto_ppid foreign key(parent_id) references automobiles(part_id));