生产管理系统实验报告

生产管理系统1．E-R图2．数据字典3．授权情况一览（★为对此人授权）4．创建表，序列4.1表Depart:create table depart(DeptNo number(2) constraint pk_depart primary key, DeptName varchar2(10),LOC varchar2(13));/Emp：create table emp(EmpId varchar2(10) constraint pk_emp primary key, EmpName varchar2(10) NOT NULL,EmpAdd varchar2(20),EmpPhone varchar(12),Email varchar2(20),MGR varchar2(10),HireDate date,COMM number(7,2),DeptNo number(2) not null,Pro varchar2(12),Sal number(6),Educa varchar2(12),Exper varchar2(20),CONSTRAINT fk_emp_DeptNoFOREIGN KEY (DeptNo) REFERENCES depart(DeptNo));Customer:create table customer(custid varchar2(10) constraint pk_customer primary key, custname varchar2(22),custadd varchar2(20),custphone varchar2(12),custfax varchar2(12));Prostock:create table prostock(Proid varchar2(10) constraint pk_prostock primary key, ProName varchar(20),Val number(10),Stiqty number(10),Insqty number(10));Ord:create table ord(ordid varchar2(10) constraint pk_ord primary key, proid varchar2(10) not null,custid varchar2(10) not null,o_qty number(20),orddate date,d_date date,money number(10),is_invoice number(1),is_delivery number(1),constraint fk_ord_proidforeign key(proid) REFERENCES prostock(proid), constraint fk_ord_custidforeign key(custid) REFERENCES customer(custid) );Wip:create table wip(wipid varchar2(10) constraint pk_wip primary key, proid varchar2(10) not null,w_qty number(20),is_finish number(1),constraint fk_wip_proidforeign key(proid) REFERENCES prostock(proid));Delivery:create table delivery(delino varchar(10) constraint pk_delivery primary key, proid varchar(10) not null,ordid varchar(10) not null,carno varchar(10),is_invoice number(1),constraint fk_delivery_proidforeign key(proid) REFERENCES prostock(proid), constraint fk_delivery_ordidforeign key(ordid) REFERENCES ord(ordid));Invoice:create table invoice(invid varchar2(10) constraint pk_invoice primary key, ordid varchar2(10),proid varchar2(10),allmoney number(10),in_date date,constraint fk_invoice_proidforeign key(proid) REFERENCES prostock(proid), constraint fk_invoice_ordidforeign key(ordid) REFERENCES ord(ordid) );4.2序列实现表主键自动增长的对应表的序列Customer_seq:create sequence customer_seqstart with 1increment by 1nomaxvaluenocyclenocache;delivery_seq:create sequence delivery_seqstart with 1increment by 1nomaxvaluenocyclenocache;invoice；create sequence invoice_seqstart with 1increment by 1nomaxvaluenocyclenocache;prostock_seq:create sequence prostock_seqstart with 1increment by 1nomaxvaluenocyclenocache;wip_seq；create sequence wip_seqstart with 1increment by 1nomaxvaluenocyclenocache;5．插入数据Depart:insert into Depart(DeptNo,DeptName,LOC) values ('11','总经理室','北京');insert into Depart(DeptNo,DeptName,LOC) values ('12','监督室','北京');insert into Depart(DeptNo,DeptName,LOC) values ('21','管理部','郑州');insert into Depart(DeptNo,DeptName,LOC) values ('31','会计科','北京');insert into Depart(DeptNo,DeptName,LOC) values ('22','业务部','北京');insert into Depart(DeptNo,DeptName,LOC) values ('32','生管科','郑州');insert into Depart(DeptNo,DeptName,LOC) values ('33','品保科','郑州');insert into Depart(DeptNo,DeptName,LOC) values ('23','制造部','郑州');insert into Depart(DeptNo,DeptName,LOC) values ('34','压合科','郑州');insert into Depart(DeptNo,DeptName,LOC) values ('35','内务科','郑州');emp:Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00101','Abel','北京市海淀区','(010)-111111','xxx@',null,to_date('06/05/90','dd/mm/yy'),null,'11','总经理','180000','研究所','五年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00102','Ivan','上海市四川路','(021)-111111','xxx@','Abel',to_date('13/01/92','dd/mm/yy'),'200','11','特助','120000','研究所','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00201','Alan','郑州市人民路','(037)-111111','xxx@','Abel',to_date('23/06/91','dd/mm/yy'),null,'12','经理','120000','研究所','三年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00202','Henry','郑州市中山路','(037)-111112','xxx@','Alan',to_date('05/02/92','dd/mm/yy'),'600','12','监督员','40000','大学','三年');Insert INTO EMP(EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00301','Bard','上海市南京路','(021)-11112','xxx@','Abel',to_date('26/03/91','dd/mm/yy'),null,'21','经理','70000','大学','三年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00302','Harry','南京市六合区','(021)-111112','xxx@','Bard',to_date('15/06/91','dd/mm/yy'),null,'21','科长','50000','大学','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00303','Bart','广州市人民路','(020)-111111','xxx@','Harry',to_date('15/12/91','dd/mm/yy'),'400','21','人事','30000','专科','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00304','Eden','广州市中山路','(020)-111112','xxx@','Harry',to_date('08/01/92','dd/mm/yy'),'500','21','总务','30000','大学','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00305','Beau','北京市海淀区','(010)-111111','xxx@','Harry',to_date('16/01/92','dd/mm/yy'),'300','21','采购','30000','大学','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00401','Carl','郑州市中山路','(037)-111112','xxx@','Bard',to_date('18/04/91','dd/mm/yy'),null,'31','经理','70000','大学','四年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00402','Ed','石家庄市人民路','(031)-11111','xxx@','Carl',to_date('28/09/91','dd/mm/yy'),'500','31','成会','40000','大学','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values ('00403','Cliff','上海市南京路','(021)-11112','xxx@','Carl',to_date('17/10/91','dd/mm/yy'),'300','31','普会','35000','大学','一年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00501','Dan','广州市人民路','(020)-111111','xxx@','Abel',to_date('24/07/91','dd/mm/yy'),null,'22','经理','80000','大学','三年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00502','Frank','广州市中山路','(020)-111112','xxx@','Dan',to_date('21/03/92','dd/mm/yy'),'1000','22','业助','33000','专科','一年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00601','Hermes','上海市四川路','(021)-111111','xxx@','Abel',to_date('29/04/92','dd/mm/yy'),null,'32','科长','40000','专科','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00602','Des','北京市中山区','(010)-111112','xxx@','Hermes',to_date('19/06/92','dd/mm/yy'),'600','32','生管','31000','专科','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00603','Gale','郑州市中山路','(037)-111112','xxx@','Hermes',to_date('02/12/93','dd/mm/yy'),'700','32','生管','40000','专科','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00604','Beck','石家庄市人民路','(031)-11111','xxx@','Hermes',to_date('25/03/93','dd/mm/yy'),'500','32','助理','25000','高中','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00605','Gary','上海市四川路','(021)-111111','xxx@','Hermes',to_date('03/09/94','dd/mm/yy'),'800','32','仓管','25000','专科','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00606','Danny','北京市海淀区','(010)-111111','xxx@','Hermes',to_date('18/05/93','dd/mm/yy'),'400','32','外务','30000','高中','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00607','Ford','上海市四川路','(021)-111111','xxx@','Hermes',to_date('23/02/94','dd/mm/yy'),'600','32','外务','25000','高中','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00701','CASH','石家庄市人民路','(031)-11111','xxx@','Abel',to_date('15/11/93','dd/mm/yy'),null,'33','科长','40000','专科','四年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00702','Eddy','上海市南京路','(021)-11112','xxx@','CASH',to_date('09/07/94','dd/mm/yy'),'300','33','QA','25000','高中','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00703','Barton','南京市六合区','(021)-111112','xxx@','CASH',to_date('02/06/95','dd/mm/yy'),'700','33','QC','23000','高中','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00801','Ian','北京市海淀区','(010)-111111','xxx@','Abel',to_date('10/12/92','dd/mm/yy'),null,'23','副理','60000','专科','五年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00802','Hank','上海市南京路','(021)-11112','xxx@','Ian',to_date('06/03/95','dd/mm/yy'),'1000','23','工务','32000','专科','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00803','Ira','上海市四川路','(021)-111111','xxx@','Ian',to_date('26/08/94','dd/mm/yy'),null,'34','科长','38000','高中','八年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00804','Abner','郑州市人民路','(037)-111111','xxx@','Ira',to_date('10/09/95','dd/mm/yy'),'900','34','领班','33000','高中','二年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00805','Jack','郑州市中山路','(037)-111112','xxx@','Ian',to_date('16/10/93','dd/mm/yy'),null,'35','科长','39000','专科','六年');Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values ('00806','Ade','石家庄市人民路','(031)-11111','xxx@','Jack',to_date('19/02/95','dd/mm/yy'),'800','35','领班','32000','高中','二年');prostock；insert into prostock(ProName,Val,Stiqty,Insqty) values ('主板',400,0,20);insert into prostock(ProName,Val,Stiqty,Insqty) values ('处理器',1000,10,0);insert into prostock(ProName,Val,Stiqty,Insqty) values ('内存',300,20,0);insert into prostock(ProName,Val,Stiqty,Insqty) values ('硬盘',500,30,0);insert into prostock(ProName,Val,Stiqty,Insqty) values ('显卡',1000,40,0);customer:insert into customer(custname,custadd,custphone,custfax) values('南亚电子股份有限公司','北京市海淀区','(010)-111111','(010)-111112');insert into customer(custname,custadd,custphone,custfax) values('华通电子股份有限公司','上海市四川路','(021)-111111','(021)-111112');insert into customer(custname,custadd,custphone,custfax) values('欣兴电子股份有限公司','北京市中山区','(010)-111112','(010)-111113');insert into customer(custname,custadd,custphone,custfax) values('群策电子股份有限公司','郑州市人民路','(037)-111111','(037)-111112');insert into customer(custname,custadd,custphone,custfax) values('联致电子股份有限公司','郑州市中山路','(037)-111112','(037)-111113');insert into customer(custname,custadd,custphone,custfax) values('旭德电子股份有限公司','石家庄市人民路','(031)-111111','(031)-111112');insert into customer(custname,custadd,custphone,custfax) values('联能电子股份有限公司','上海市南京路','(021)-111112','(021)-111113');insert into customer(custname,custadd,custphone,custfax) values('铭望电子股份有限公司','南京市六合区','(022)-111112','(022)-111113');insert into customer(custname,custadd,custphone,custfax) values('柏拉图电子股份有限公司','广州市人民路','(020)-111111','(020)-111112');insert into customer(custname,custadd,custphone,custfax) values('定颖电子股份有限公司','广州市中山路','(020)-111112','(020)-111113');insert into customer(custname,custadd,custphone,custfax) values('南华电子股份有限公司','北京市海淀区','(010)-111111','(010)-111112');insert into customer(custname,custadd,custphone,custfax) values('华欣电子股份有限公司','上海市四川路','(021)-111112','(021)-111112');Insert INTO Customer(custname,custadd,custphone,custfax) values ('欣群电子股份有限公司','北京市中山区','(010)-111112','(010)-111113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('群联电子股份有限公司','郑州市人民路','(037)-111111','(037)-111112');Insert INTO Customer(custname,custadd,custphone,custfax) values ('联旭电子股份有限公司','郑州市中山路','(037)-111112','(037)-111113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('旭联电子股份有限公司','石家庄市人民路','(031)-11111','(021)-11112');Insert INTO Customer(custname,custadd,custphone,custfax) values ('联铭电子股份有限公司','上海市南京路','(021)-11112','(021)-11113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('铭图电子股份有限公司','南京市六合区','(021)-111112','(021)-111113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('柏图电子股份有限公司','广州市人民路','(020)-111111','(020)-111112');Insert INTO Customer(custname,custadd,custphone,custfax) values ('南颖电子股份有限公司','广州市中山路','(020)-111112','(020)-111113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('旭联电子股份有限公司','石家庄市人民路','(031)-11111','(021)-11112');Insert INTO Customer(custname,custadd,custphone,custfax) values ('联铭电子股份有限公司','上海市南京路','(021)-11112','(021)-11113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('铭图电子股份有限公司','南京市六合区','(021)-111112','(021)-111113');Insert INTO Customer(custname,custadd,custphone,custfax) values ('柏图电子股份有限公司','广州市人民路','(020)-111111','(020)-111112');Insert INTO Customer(custname,custadd,custphone,custfax) values ('南颖电子股份有限公司','广州市中山路','(020)-111112','(020)-111113');Ord:insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('1','1','30',to_date('10/02/92','dd/mm/yy'),to_date('20/02/92','dd/mm/yy'),1,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('1','2','60',to_date('15/02/92','dd/mm/yy'),to_date('25/02/92','dd/mm/yy'),1,1);values('1','3','50',to_date('02/03/92','dd/mm/yy'),to_date('16/03/92','dd/mm/yy'),1,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('1','4','80',to_date('15/03/92','dd/mm/yy'),to_date('23/03/92','dd/mm/yy'),1,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('1','5','100',to_date('03/04/92','dd/mm/yy'),to_date('18/04/92','dd/mm/yy'),1,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('2','6','150',to_date('08/04/92','dd/mm/yy'),to_date('26/04/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('2','7','30',to_date('16/05/92','dd/mm/yy'),to_date('28/05/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('2','8','15',to_date('06/05/92','dd/mm/yy'),to_date('25/05/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('2','9','200',to_date('11/06/92','dd/mm/yy'),to_date('22/06/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('2','10','300',to_date('18/06/92','dd/mm/yy'),to_date('30/06/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('3','11','30',to_date('10/02/92','dd/mm/yy'),to_date('20/02/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('3','12','60',to_date('15/02/92','dd/mm/yy'),to_date('25/02/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('3','13','50',to_date('02/03/92','dd/mm/yy'),to_date('16/03/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('3','14','80',to_date('15/03/92','dd/mm/yy'),to_date('23/03/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('3','15','100',to_date('03/04/92','dd/mm/yy'),to_date('18/04/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('4','16','150',to_date('08/04/92','dd/mm/yy'),to_date('26/04/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('4','17','30',to_date('16/05/92','dd/mm/yy'),to_date('28/05/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('4','18','15',to_date('06/05/92','dd/mm/yy'),to_date('25/05/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('4','19','200',to_date('11/06/92','dd/mm/yy'),to_date('22/06/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('4','20','300',to_date('18/06/92','dd/mm/yy'),to_date('30/06/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('5','21','30',to_date('10/02/92','dd/mm/yy'),to_date('20/02/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('5','22','60',to_date('15/02/92','dd/mm/yy'),to_date('25/02/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('5','23','50',to_date('02/03/92','dd/mm/yy'),to_date('16/03/92','dd/mm/yy'),0,1);insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values('5','24','80',to_date('15/03/92','dd/mm/yy'),to_date('23/03/92','dd/mm/yy'),0,1);values('5','25','100',to_date('03/04/92','dd/mm/yy'),to_date('18/04/92','dd/mm/yy'),0,1);delivery:insert into Delivery (proid,ordid,carno,is_invoice)values('1','1','A1-1111',1);insert into Delivery (proid,ordid,carno,is_invoice)values('1','2','A1-1111',1);insert into Delivery (proid,ordid,carno,is_invoice)values('1','3','A1-1111',1);insert into Delivery (proid,ordid,carno,is_invoice)values('1','4','A1-1111',1);insert into Delivery (proid,ordid,carno,is_invoice)values('1','5','A1-1111',1);insert into Delivery (proid,ordid,carno,is_invoice)values('2','6','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('2','7','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('2','8','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('2','9','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('2','10','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('3','11','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('3','12','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('3','13','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('3','14','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('3','15','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('4','16','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('4','17','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('4','18','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('4','19','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('4','20','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('5','21','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('5','22','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('5','23','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('5','24','A1-1111',0);insert into Delivery (proid,ordid,carno,is_invoice)values('5','25','A1-1111',0);invoice:insert into Invoice (ordid,proid)values('1','1');insert into Invoice (ordid,proid)values('2','2');insert into Invoice (ordid,proid)values('3','3');insert into Invoice (ordid,proid)values('4','4');insert into Invoice (ordid,proid)values('5','5');wip:insert into WIP(ProID,w_qty,is_finish)values('1','30',1);insert into WIP(ProID,w_qty,is_finish)values('1','60',1);insert into WIP(ProID,w_qty,is_finish)values('1','50',1);insert into WIP(ProID,w_qty,is_finish)values('1','80',1);insert into WIP(ProID,w_qty,is_finish)values('1','100',1);insert into WIP(ProID,w_qty,is_finish)values('2','150',1);insert into WIP(ProID,w_qty,is_finish)values('2','30',1);insert into WIP(ProID,w_qty,is_finish)values('2','15',1);insert into WIP(ProID,w_qty,is_finish)values('2','200',1);insert into WIP(ProID,w_qty,is_finish)values('2','300',1);insert into WIP(ProID,w_qty,is_finish)values('3','30',1);insert into WIP(ProID,w_qty,is_finish)values('3','60',1);insert into WIP(ProID,w_qty,is_finish)values('3','50',1);insert into WIP(ProID,w_qty,is_finish)values('3','80',1);insert into WIP(ProID,w_qty,is_finish)values('3','100',1);insert into WIP(ProID,w_qty,is_finish)values('4','150',1);insert into WIP(ProID,w_qty,is_finish)values('4','30',1);insert into WIP(ProID,w_qty,is_finish)values('4','15',1);insert into WIP(ProID,w_qty,is_finish)values('4','200',1);insert into WIP(ProID,w_qty,is_finish)values('4','300',1);insert into WIP(ProID,w_qty,is_finish)values('5','30',1);insert into WIP(ProID,w_qty,is_finish)values('5','60',1);insert into WIP(ProID,w_qty,is_finish)values('5','50',1);insert into WIP(ProID,w_qty,is_finish)values('5','80',1);insert into WIP(ProID,w_qty,is_finish)values('5','100',1);6．存储过程6.1显示未完成订单create or replace procedure ord_deliveryascursor a_ord_is_deliveryisselect ordid,proid,o_qty from system.ord where is_delivery=0;beginfor n_ord_is_delivery in a_ord_is_deliveryloopDBMS_OUTPUT.PUT_LINE('未完成订单:');DBMS_OUTPUT.PUT_LINE('ordid:'||n_ord_is_delivery.ordid||'proid:'||n_ord_is_delivery.proid||' o_qty:'||n_ord_is_delivery.o_qty); end loop;end;/。