【正文】 into Delivery (proid,ordid,carno,is_invoice)values(39。339。,39。1639。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2439。,39。insert into Invoice (ordid,proid)values(39。339。539。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。15039。239。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。8039。439。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。6039。539。,1)。 proid:39。未完成訂單:39。||)。 count:=pro_get+pro_in。begin select stiqty into pro_get from where proid=pro_id。||||39。/create or replace procedure wip_finishascursor a_wip_is_finishisselect wipid,proid,w_qty from where is_finish=0。ordid:39。,39。,1)。539。30039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。339。6039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。239。8039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。)。339。139。,39。539。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。1839。,39。439。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。1039。,39。239。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,1)。A1111139。,39。239。,39。dd/mm/yy39。539。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。02/03/9239。),0,1)。,to_date(39。dd/mm/yy39。3039。,39。,39。22/06/9239。1939。),to_date(39。,39。dd/mm/yy39。439。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。03/04/9239。),0,1)。,to_date(39。dd/mm/yy39。5039。,39。,39。20/02/9239。1139。),to_date(39。,39。dd/mm/yy39。239。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。16/05/9239。),0,1)。,to_date(39。dd/mm/yy39。10039。,39。,39。16/03/9239。339。),to_date(39。,39。dd/mm/yy39。139。,39。廣州市人民路39。,39。(021)1111239。,39。(020)11111339。)。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。銘圖電子股份有限公司39。,39。石家莊市人民路39。,39。(037)11111139。,39。(021)11111239。)。insert into customer(custname,custadd,custphone,custfax) values(39。定穎電子股份有限公司39。,39。南京市六合區(qū)39。,39。(031)11111139。,39。(037)11111239。)。insert into customer(custname,custadd,custphone,custfax) values(39。華通電子股份有限公司39。,39。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。主板39。,39。,39。,39。六年39。3539。xxx39。0080539。,39。,39。,39。八年39。3439。xxx39。0080339。,39。,39。,39。五年39。2339。xxx39。0080139。,39。,39。,39。二年39。3339。CASH39。Eddy39。,39。,39。,39。二年39。3239。Hermes39。Ford39。,39。),39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。倉管39。03/09/9439。上海市四川路39。,39。,39。,39。,39。4000039。dd/mm/yy39。(037)11111239。)。,39。,to_date(39。,39。?？?9。dd/mm/yy39。(021)11111139。)。,39。,to_date(39。,39。大學(xué)39。dd/mm/yy39。(020)11111139。)。,39。,to_date(39。,39。大學(xué)39。50039。xxx39。0040239。,39。,to_date(39。,39。大學(xué)39。30039。xxx39。0030539。,39。,39。,39。二年39。2139。Harry39。Bart39。,39。,39。,39。三年39。2139。xxx39。0030139。,39。,39。,39。三年39。1239。xxx39。0020139。,39。,39。,39。五年39。1139。(010)11111139。)。鄭州39。,39。品?？?9。,39。2239。insert into Depart(DeptNo,DeptName,LOC) values (39。)。北京39。invoice；create sequence invoice_seq start with 1increment by 1nomaxvaluenocyclenocache。Customer:create table customer(custid varchar2(10) constraint pk_customer primary key,custname varchar2(22),custadd varchar2(20),custphone varchar2(12),custfax varchar2(12))。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))。5．插入數(shù)據(jù)Depart:insert into Depart(DeptNo,DeptName,LOC) values (39。1239。,39。會(huì)計(jì)科39。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3539。,39。,null,to_date(39。,39。0010239。xxx39。20039。研究所39。,39。,to_date(39。,39。0020239。xxx39。60039。大學(xué)39。,39。,to_date(39。,39。0030239。xxx39。2139。二年39。,39。,39。,39。0030439。xxx39。50039。大學(xué)39。,39。,to_date(39。,39。)。(037)11111239。dd/mm/yy39。大學(xué)39。,39。,to_date(39。,39。)。(021)1111239。dd/mm/yy39。3500039。,39。,39。,39。)。(020)11111239。dd/mm/yy39。3300039。,39。,39。,39。)。(010)11111239。dd/mm/yy39。3100039。,39。,39。,39。,39。石家莊市人民路39。25/03/9339。助理39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Danny39。Hermes39。3239。二年39。,39。,39。,39。0070139。xxx39。3339。四年39。,39。,39。,39。0070339。xxx39。70039。高中39。,39。,to_date(39。,39。0080239。xxx39。100039。專科39。,39。,to_date(39。,39。0080439。xxx39。90039。高中39。,39。,to_date(39。,39。0080639。xxx39。80039。高中39。處理器39。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。(010)11111139。,39。北京市中山區(qū)39。,39。聯(lián)致電子股份有限公司39。insert into customer(custname,custadd,custphone,custfax) values(39。)。(021)11111339。,39。(020)11111139。,39。北京市海淀區(qū)39。,39。欣群電子股份有限公司39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。)。(037)11111339。,39。(021)1111239。,39。廣州市人民路39。,39。旭聯(lián)電子股份有限公司39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。)。(021)11111339。,39。(020)11111239。,39。,39。6039。dd/mm/yy39。,to_date(39。),1,1)。15/03/9239。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。,39。239。dd/mm/yy39。,39。),to_date(39。839。25/05/9239。,39。,39。30039。dd/mm/yy39。,to_date(39。),0,1)。15/02/9239。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。,39。339。dd/mm/yy39。,39。),to_date(39。1639。26/04/9239。,39。,39。1539。dd/mm/yy39。,to_date(39。),0,1)。18/06/9239。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。,39。539。dd/mm/yy39。,39。),to_date(39。2439。23/03/9239。,39。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。739。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。339。,39。1539。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2339。,39。A1111139。239。)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。5039。139。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。3039。339。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。20039。539。,1)。,39。6．存儲過程create or replace procedure ord_deliveryascursor a_ord_is_deliveryisselect ordid,proid,o_qty from where is_delivery=0。||||39。)。end loop。 update set stiqty=count where proid=pro_id。pro_insqty number(10)。 proid:39。end。(39。539。5039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。439。10039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。239。3039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。139。439。insert into Invoice (ordid,proid)values(39。,39。539。insert into Delivery (proid,ordid,carno,