CREATE TABLE order_master(
orderno VARCHAR2(5) primary key,
Odate DATE,
Vencode VARCHAR2(5),
ostatus CHAR(1),
del_date DATE); CREATE TABLE order_detail(
itemcode VARCHAR2(5) primary key,
qty_ord NUMBER(5),
qty_deld NUMBER(5),
orderno VARCHAR2(5),
foreign key(orderno) references order_master(orderno)); insert into order_master values(
'o001',sysdate, 'CHINA', 'P',sysdate);
insert into order_detail values(
'b10',200,200, 'o001'); CREATE VIEW view_orders_test
AS SELECT o.orderno, o.odate, vencode, itemcode, qty_ord
FROM order_master o, order_detail d
WHERE o.orderno=d.orderno;
select * from view_orders_test;
select * from order_master;
select * from order_detail
update view_orders_test set qty_ord=qty_ord*2 where itemcode= 'b10'; 没问题吖!
orderno VARCHAR2(5) primary key,
Odate DATE,
Vencode VARCHAR2(5),
ostatus CHAR(1),
del_date DATE); CREATE TABLE order_detail(
itemcode VARCHAR2(5) primary key,
qty_ord NUMBER(5),
qty_deld NUMBER(5),
orderno VARCHAR2(5),
foreign key(orderno) references order_master(orderno)); insert into order_master values(
'o001',sysdate, 'CHINA', 'P',sysdate);
insert into order_detail values(
'b10',200,200, 'o001'); CREATE VIEW view_orders_test
AS SELECT o.orderno, o.odate, vencode, itemcode, qty_ord
FROM order_master o, order_detail d
WHERE o.orderno=d.orderno;
select * from view_orders_test;
select * from order_master;
select * from order_detail
update view_orders_test set qty_ord=qty_ord*2 where itemcode= 'b10'; 没问题吖!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货