【正文】 ordid,carno,is_invoice)values(39。,39。439。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。10039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。end。pro_insqty number(10)。end loop。||||39。,39。539。insert into WIP(ProID,w_qty,is_finish)values(39。,1)。3039。,39。139。insert into WIP(ProID,w_qty,is_finish)values(39。)。A1111139。2339。539。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。739。139。,1)。,39。23/03/9239。),to_date(39。dd/mm/yy39。,39。18/06/9239。,to_date(39。1539。,39。1639。,39。339。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。),0,1)。dd/mm/yy39。,39。25/05/9239。),to_date(39。dd/mm/yy39。,39。15/03/9239。,to_date(39。6039。,39。,39。)。旭聯(lián)電子股份有限公司39。廣州市人民路39。(021)1111239。(037)11111339。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。,39。,39。,39。)。聯(lián)致電子股份有限公司39。北京市中山區(qū)39。(010)11111139。處理器39。80039。0080639。,to_date(39。高中39。xxx39。,39。,39。100039。0080239。,to_date(39。高中39。xxx39。,39。,39。3339。0070139。,39。二年39。Hermes39。,39。,39。助理39。石家莊市人民路39。,39。,39。dd/mm/yy39。)。,39。3300039。(020)11111239。,39。,39。dd/mm/yy39。)。,to_date(39。大學39。(037)11111239。,39。,39。50039。0030439。,39。二年39。xxx39。,39。,39。60039。0020239。,to_date(39。研究所39。xxx39。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。鄭州39。會計科39。1239。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))。invoice；create sequence invoice_seq start with 1increment by 1nomaxvaluenocyclenocache。)。2239。品?？?9。鄭州39。(010)11111139。五年39。,39。0020139。1239。,39。,39。xxx39。三年39。,39。Bart39。2139。,39。,39。xxx39。大學39。,to_date(39。0040239。50039。,39。,39。(020)11111139。大學39。,to_date(39。)。dd/mm/yy39。,39。,39。(037)11111239。4000039。,39。,39。03/09/9439。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。),39。Ford39。3239。,39。,39。CASH39。二年39。,39。0080139。2339。,39。,39。xxx39。八年39。,39。0080539。3539。,39。,39。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。華通電子股份有限公司39。)。,39。,39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(021)11111239。(037)11111139。石家莊市人民路39。銘圖電子股份有限公司39。)。,39。,39。,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。239。,39。1139。,39。5039。,to_date(39。03/04/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。539。,39。,39。,1)。239。1039。A1111139。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,39。,39。,0)。539。139。)。insert into WIP(ProID,w_qty,is_finish)values(39。239。,39。6039。,1)。insert into WIP(ProID,w_qty,is_finish)values(39。539。,39。/create or replace procedure wip_finishascursor a_wip_is_finishisselect wipid,proid,w_qty from where is_finish=0。begin select stiqty into pro_get from where proid=pro_id。||)。 proid:39。539。insert into WIP(ProID,w_qty,is_finish)values(39。,1)。8039。,39。239。insert into WIP(ProID,w_qty,is_finish)values(39。,1)。339。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。1639。339。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。18/04/9239。),to_date(39。dd/mm/yy39。,39。10/02/9239。,to_date(39。20039。,39。1739。,39。339。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。),0,1)。dd/mm/yy39。,39。22/06/9239。),to_date(39。dd/mm/yy39。,39。03/04/9239。,to_date(39。5039。,39。139。(020)11111139。(021)1111339。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。,39。,39。,39。)。華欣電子股份有限公司39。廣州市中山路39。(022)11111239。(031)11111239。insert into customer(custname,custadd,custphone,custfax) values(39。,39。,39。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。),39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。Ian39。,39。,39。科長39。Ira39。),39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。Abel39。,39。,39。QA39。上海市南京路39。),null,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。23/02/9439。,39。,39。2500039。(021)11111139。,39。,39。70039。0060339。,39。二年39。xxx39。,39。,39。2239。0050139。,39。二年39。Carl39。,39。,39。2139。Beau39。),39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。15/12/9139。,39。,39。經(jīng)理39。Bard39。),39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。Abel39。,39。,39?？偨?jīng)理39。0010139。)。,39。,39。insert into Depart(DeptNo,DeptName,LOC) values (39。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))。prostock_seq:create sequence prostock_seq start with 1increment by 1nomaxvaluenocyclenocache。insert into Depart(DeptNo,DeptName,LOC) values (39。,39。,39。)。,39。)。dd/mm/yy39。,39。,39。(037)11111239。4000039。,39。)。dd/mm/yy39。,39。,39。(020)11111239。3000039。,39。,39。18/04/9139。,39。,39。上海市南京路39。普會39。,39。,39。21/03/9239。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。),null,39。北京市中山區(qū)39。生管39。,39。,39。Hermes39。二年39。,39。0060639。40039。,39。,39。(031)1111139。?？?9。,to_date(39。)。dd/mm/yy39。,39。,39。(021)1111239。3200039。,39。)。dd/mm/yy39。,39。,39。(031)1111139。3200039。硬盤39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(037)11111339。(021)11111239。廣州市人民路39。南華電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(021)1111239。(021)11111239。廣州市中山路39。),to_date(39。25/02/9239。,39。dd/mm/yy39。),1,1)。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。239。,39。1039。,39。6039。,to_date(39。15/03/9239。,39。dd/mm/yy39。),to_date(39。25/05/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。139。A1111139。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,39。,39。,0)。339。1739。A1111139。insert into Delivery (proid,ordid,carn