父表:
create table orders2(
orderid number(7) primary key,
ordername varchar2(24) not null,
ordercost number(10,2) not null
);
子表:
create table shipments2(
shipmentid number(7) primary key,
shipmentname varchar2(24) not null,
street varchar2(64) not null,
约束:
constraint shipments_orders_o2o_fk foreign key(shipmentid) references orders(orderid)
);在父表插入数据
insert
into
ORDERS2
(ORDERNAME, ORDERCOST, ORDERID)
values
('book', 10.01, 20);之后在子表插入数据
insert
into
SHIPMENTS2
(SHIPMENTNAME, STREET, SHIPMENTID)
values
('ASDF', 'WLD', 20);最后还是给我报violated - parent key not found错误,这是怎么回事?
create table orders2(
orderid number(7) primary key,
ordername varchar2(24) not null,
ordercost number(10,2) not null
);
子表:
create table shipments2(
shipmentid number(7) primary key,
shipmentname varchar2(24) not null,
street varchar2(64) not null,
约束:
constraint shipments_orders_o2o_fk foreign key(shipmentid) references orders(orderid)
);在父表插入数据
insert
into
ORDERS2
(ORDERNAME, ORDERCOST, ORDERID)
values
('book', 10.01, 20);之后在子表插入数据
insert
into
SHIPMENTS2
(SHIPMENTNAME, STREET, SHIPMENTID)
values
('ASDF', 'WLD', 20);最后还是给我报violated - parent key not found错误,这是怎么回事?
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.
你还有个表叫orders啊。
nsert
into
ORDERS2 根本不是同一张表。 改一下的表吧.
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.