【正文】 select insqty into pro_insqty from where proid=pro_id。 w_qty39。beginfor n_wip_is_finish in a_wip_is_finishloop (39。||||39。10039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。439。3039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。339。20039。insert into WIP(ProID,w_qty,is_finish)values(39。,39。,1)。139。3039。insert into Invoice (ordid,proid)values(39。,39。)。2539。,39。539。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。1739。,39。339。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。939。,39。239。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,1)。A1111139。,39。139。),to_date(39。,39。dd/mm/yy39。539。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。15/02/9239。),0,1)。,to_date(39。dd/mm/yy39。30039。,39。,39。25/05/9239。1839。),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。15/03/9239。),0,1)。,to_date(39。dd/mm/yy39。6039。,39。,39。30/06/9239。1039。),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。08/04/9239。),1,1)。,to_date(39。dd/mm/yy39。8039。,39。,39。25/02/9239。239。),to_date(39。,39。廣州市中山路39。,39。(021)11111239。,39。(021)1111239。)。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。柏圖電子股份有限公司39。,39。上海市南京路39。,39。(037)11111239。,39。(010)11111339。)。insert into customer(custname,custadd,custphone,custfax) values(39。南華電子股份有限公司39。,39。廣州市人民路39。,39。(021)11111239。,39。(037)11111339。)。insert into customer(custname,custadd,custphone,custfax) values(39。欣興電子股份有限公司39。,39。北京市海淀區(qū)39。硬盤39。,400,0,20)。3200039。dd/mm/yy39。(031)1111139。)。,39。,39。,39。3300039。dd/mm/yy39。(037)11111139。)。,39。,39。,39。3200039。dd/mm/yy39。(021)1111239。)。,39。,39。,39。2300039。dd/mm/yy39。(021)11111239。)。,39。,to_date(39。,39。?？?9。dd/mm/yy39。(031)1111139。)。,39。,to_date(39。,39。高中39。40039。xxx39。0060639。,39。,39。,39。二年39。3239。Hermes39。Beck39。,39。),39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。生管39。19/06/9239。北京市中山區(qū)39。,39。),null,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。業(yè)助39。21/03/9239。廣州市中山路39。,39。),null,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。普會39。17/10/9139。上海市南京路39。,39。,39。,39。,39。7000039。18/04/9139。鄭州市中山路39。,39。,39。,39。,39。3000039。dd/mm/yy39。(020)11111239。)。,39。,to_date(39。,39。大學(xué)39。dd/mm/yy39。(021)11111239。)。,39。,39。,39。4000039。dd/mm/yy39。(037)11111239。)。,39。,39。,39。12000039。dd/mm/yy39。(021)11111139。)。,39。,39。emp:Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper) values (39。)。鄭州39。,39。生管科39。,39。3139。insert into Depart(DeptNo,DeptName,LOC) values (39。)。prostock_seq:create sequence prostock_seq start with 1increment by 1nomaxvaluenocyclenocache。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_seq；create sequence wip_seq start with 1increment by 1nomaxvaluenocyclenocache。insert into Depart(DeptNo,DeptName,LOC) values (39。2139。,39。業(yè)務(wù)部39。,39。鄭州39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。0010139。xxx39?？偨?jīng)理39。 Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Alan39。Abel39。經(jīng)理39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Bard39。Abel39。經(jīng)理39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),null,39。,39。廣州市人民路39。15/12/9139。人事39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Beau39。Harry39。2139。二年39。,39。,39。,39。Ed39。Carl39。3139。二年39。,39。,39。,39。0050139。xxx39。2239。三年39。,39。,39。,39。0060139。xxx39。3239。二年39。,39。,39。,39。0060339。xxx39。70039。?？?9。,39。,to_date(39。,39。)。(021)11111139。dd/mm/yy39。2500039。,39。,39。,39。,39。上海市四川路39。23/02/9439。外務(wù)39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),null,39。,39。上海市南京路39。09/07/9439。QA39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Ian39。Abel39。副理39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Ira39。Ian39。科長39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Jack39。Ian39?？崎L39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。insert into prostock(ProName,Val,Stiqty,Insqty) values (39。,500,30,0)。,39。上海市四川路39。,39。群策電子股份有限公司39。insert into customer(custname,custadd,custphone,custfax) values(39。)。(031)11111239。,39。(022)11111239。,39。廣州市中山路39。,39。華欣電子股份有限公司39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。)。(037)11111239。,39。(031)1111139。,39。南京市六合區(qū)39。,39。南穎電子股份有限公司39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。)。(021)1111339。,39。(020)11111139。,39。139。20/02/9239。,39。,39。5039。dd/mm/yy39。,to_date(39。),1,1)。03/04/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。939。22/06/9239。,39。,39。3039。dd/mm/yy39。,to_date(39。),0,1)。02/03/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。1739。28/05/9239。,39。,39。20039。dd/mm/yy39。,to_date(39。),0,1)。10/02/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。2539。18/04/9239。,39。A1111139。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。239。,39。839。,39。A1111139。,0)。insert