【正文】 is_invoice)values(39。,0)。A1111139。,39。1939。,39。439。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。1139。,39。239。insert into Delivery (proid,ordid,carno,is_invoice)values(39。,0)。A1111139。,39。339。,39。139。,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。2039。),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。08/04/9239。),0,1)。,to_date(39。dd/mm/yy39。8039。,39。,39。25/02/9239。1239。),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。06/05/9239。),0,1)。,to_date(39。dd/mm/yy39。15039。,39。,39。23/03/9239。439。),to_date(39。,39。dd/mm/yy39。139。,39。Ord:insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。南穎電子股份有限公司39。,39。南京市六合區(qū)39。,39。(031)1111139。,39。(020)11111239。)。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。聯(lián)銘電子股份有限公司39。,39。鄭州市中山路39。,39。(010)11111239。,39。(010)11111239。)。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。,300,20,0)。prostock；insert into prostock(ProName,Val,Stiqty,Insqty) values (39。領(lǐng)班39。19/02/9539。石家莊市人民路39。,39。),null,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。領(lǐng)班39。10/09/9539。鄭州市人民路39。,39。),null,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。工務(wù)39。06/03/9539。上海市南京路39。,39。),null,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。QC39。02/06/9539。南京市六合區(qū)39。,39。,39。,39。,39。4000039。15/11/9339。石家莊市人民路39。,39。,39。,39。,39。3000039。dd/mm/yy39。(010)11111139。)。,39。,to_date(39。,39。高中39。50039。xxx39。0060439。,39。,39。,39。二年39。3239。Hermes39。Des39。,39。,39。,39。一年39。2239。Dan39。Frank39。,39。,39。,39。一年39。3139。Carl39。Cliff39。,39。),39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。經(jīng)理39。Bard39。Carl39。,39。),39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39?？倓?wù)39。08/01/9239。廣州市中山路39。,39。,39。,39。,39。5000039。15/06/9139。南京市六合區(qū)39。,39。),null,39。,39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。監(jiān)督員39。05/02/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。13/01/9239。上海市四川路39。,39。),null,39。,39。鄭州39。,39。制造部39。,39。3239。insert into Depart(DeptNo,DeptName,LOC) values (39。)。北京39。,39。delivery_seq:create sequence delivery_seq start with 1increment by 1nomaxvaluenocyclenocache。/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))。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))。1139。,39。管理部39。,39。北京39。)。insert into Depart(DeptNo,DeptName,LOC) values (39。3439。,39。Abel39。06/05/9039。18000039。,39。,39。,39。,39。鄭州市人民路39。23/06/9139。12000039。,39。,39。,39。,39。上海市南京路39。26/03/9139。7000039。,39。,39。,39。)。(020)11111139。dd/mm/yy39。3000039。,39。,39。,39。,39。北京市海淀區(qū)39。16/01/9239。采購39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),null,39。,39。石家莊市人民路39。28/09/9139。成會(huì)39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Dan39。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。Hermes39。Abel39?？崎L(zhǎng)39。Insert INTO EMP (EmpID,EmpName,EmpAdd,EmpPhone,EMail,MGR,HireDate,COMM,DeptNo,Pro,Sal,Educa,Exper)values (39。,39。),39。,39。Gale39。Hermes39。3239。二年39。,39。,39。,39。0060539。xxx39。80039。?？?9。,39。,to_date(39。,39。)。(021)11111139。dd/mm/yy39。2500039。,39。,39。,39。)。(021)1111239。dd/mm/yy39。2500039。,39。,39。,39。,39。北京市海淀區(qū)39。10/12/9239。6000039。,39。,39。,39。,39。上海市四川路39。26/08/9439。3800039。,39。,39。,39。,39。鄭州市中山路39。16/10/9339。3900039。,39。,39。,39。,39。,1000,10,0)。顯卡39。,39。(021)11111139。,39。鄭州市人民路39。,39。旭德電子股份有限公司39。insert into customer(custname,custadd,custphone,custfax) values(39。)。(022)11111339。,39。(020)11111239。,39。上海市四川路39。,39。群聯(lián)電子股份有限公司39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。)。(021)1111239。,39。(021)11111239。,39。廣州市中山路39。,39。聯(lián)銘電子股份有限公司39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。)。(020)11111239。,39。3039。dd/mm/yy39。,to_date(39。),1,1)。02/03/9239。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。,39。139。dd/mm/yy39。,39。),to_date(39。739。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。339。dd/mm/yy39。,39。),to_date(39。1539。18/04/9239。,39。,39。3039。dd/mm/yy39。,to_date(39。),0,1)。11/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。2339。16/03/9239。,39。,39。10039。dd/mm/yy39。,1)。insert into Delivery (proid,ordid,carno,is_invoice)values(39。139。,39。639。,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。439。,39。2239。,39。A1111139。,0)。,39。insert into Invoice (ordid,proid)values(39。539。139。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。1539。239。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。15039。439。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。8039。beginfor n_ord_is_delivery in a_ord_is_deliveryloop (39。 o_qty:39。(39。end。 if pro_insqty。pro_g