【正文】 ivery) values(39。439。,39。1939。,39。20039。,to_date(39。11/06/9239。,39。dd/mm/yy39。),to_date(39。22/06/9239。,39。dd/mm/yy39。),0,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。439。,39。2039。,39。30039。,to_date(39。18/06/9239。,39。dd/mm/yy39。),to_date(39。30/06/9239。,39。dd/mm/yy39。),0,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。539。,39。2139。,39。3039。,to_date(39。10/02/9239。,39。dd/mm/yy39。),to_date(39。20/02/9239。,39。dd/mm/yy39。),0,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。539。,39。2239。,39。6039。,to_date(39。15/02/9239。,39。dd/mm/yy39。),to_date(39。25/02/9239。,39。dd/mm/yy39。),0,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。539。,39。2339。,39。5039。,to_date(39。02/03/9239。,39。dd/mm/yy39。),to_date(39。16/03/9239。,39。dd/mm/yy39。),0,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。539。,39。2439。,39。8039。,to_date(39。15/03/9239。,39。dd/mm/yy39。),to_date(39。23/03/9239。,39。dd/mm/yy39。),0,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。539。,39。2539。,39。10039。,to_date(39。03/04/9239。,39。dd/mm/yy39。),to_date(39。18/04/9239。,39。dd/mm/yy39。),0,1)。delivery:insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。139。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。239。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。339。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。439。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。539。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。239。,39。639。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。239。,39。739。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。239。,39。839。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。239。,39。939。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。239。,39。1039。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。339。,39。1139。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。339。,39。1239。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。339。,39。1339。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。339。,39。1439。,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。439。,39。1639。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。439。,39。1739。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。439。,39。1839。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。439。,39。1939。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。439。,39。2039。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2139。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2239。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2339。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2439。,39。A1111139。,0)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。539。,39。2539。,39。A1111139。,0)。invoice:insert into Invoice (ordid,proid)values(39。139。,39。139。)。insert into Invoice (ordid,proid)values(39。239。,39。239。)。insert into Invoice (ordid,proid)values(39。339。,39。339。)。insert into Invoice (ordid,proid)values(39。439。,39。439。)。insert into Invoice (ordid,proid)values(39。539。,39。539。)。wip:insert into WIP(ProID,w_qty,is_finish)values(39。139。,39。3039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。139。,39。6039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。139。,39。5039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。139。,39。8039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。139。,39。10039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。15039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。3039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。1539。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。20039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。30039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。339。,39。3039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。339。,39。6039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。339。,39。5039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。339。,39。8039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。339。,39。10039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。439。,39。15039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。439。,39。3039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。439。,39。1539。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。439。,39。20039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。439。,39。30039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。,39。3039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。,39。6039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。,39。5039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。,39。8039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。,39。10039。,1)。6．存儲過程create or replace procedure ord_deliveryascursor a_ord_is_deliveryisselect ordid,proid,o_qty from where is_delivery=0。beginfor n_ord_is_delivery in a_ord_is_deliveryloop (39。未完成訂單:39。)。(39。ordid:39。||||39。 proid:39。||||39。 o_qty:39。||)。end loop。end。/create or replace procedure wip_finishascursor a_wip_is_finishisselect wipid,proid,w_qty from where is_finish=0。beginfor n_wip_is_finish in a_wip_is_finishloop (39。未完成訂單:39。)。(39。wipid:39。||||39。 proid:39。||||39。 w_qty39。||)。end loop。end。/(1)輸入產(chǎn)品號，和采購的數(shù)量(2)跟需補數(shù)量進行對比(3)若采購數(shù)量大于需補數(shù)量，更新庫存為：庫存量+采購數(shù)量，更新需補數(shù)量為：0 若采購數(shù)量小于需補數(shù)量，更新庫存為：庫存量+采購數(shù)量，更新需補數(shù)量為：需補數(shù)量采購數(shù)量create or replace procedure pro_num(pro_id in varchar2,pro_in in number)as count number(10)。pro_get number(10)。pro_insqty number(10)。begin select stiqty into pro_get from where proid=pro_id。 select insqty into pro_insqty from where proid=pro_id。 count:=pro_get+pro_in。 update set stiqty=count where proid=pro_id。 if pro_ins