Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

,o.custnum
FROM
persnl.employee e
,sales.orders o
,sales.customer c
WHERE
e.empnum = o.salesrep
AND
o.custnum = C.custnum;
CREATE INDEX xcustnam
ON customer (
custname
);
CREATE VIEW sales.custlist
AS SELECT
custnum
,custname
,street
,city
,state
,postcode
FROM sales.customer;
INSERT INTO sales.orders
VALUES ( 100210,DATE '2003-04-10',DATE '2003-04-10', 220,1234 ),
( 100250,DATE '2003-01-23',DATE '2003-06-15', 220,7777 ),
( 101220,DATE '2003-07-21',DATE '2003-12-15', 221,5635 ),
( 200300,DATE '2003-02-06',DATE '2003-07-01', 222, 926 ),
( 200320,DATE '2003-02-17',DATE '2003-07-20', 223, 21 ),
( 200490,DATE '2003-03-19',DATE '2003-11-01', 226, 123 ),
( 300350,DATE '2003-03-03',DATE '2003-08-10', 231, 543 ),
( 300380,DATE '2003-03-19',DATE '2003-08-20', 226, 123 ),
( 400410,DATE '2003-03-27',DATE '2003-09-01', 227,7654 ),
( 500450,DATE '2003-04-20',DATE '2003-09-15', 220, 324 ),
( 600480,DATE '2003-05-12',DATE '2003-10-10', 226,3333 ),
( 700510,DATE '2003-06-01',DATE '2003-10-20', 229, 143 ),
( 800660,DATE '2003-10-09',DATE '2003-11-01', 568,3210 );
UPDATE STATISTICS FOR TABLE sales.orders ON EVERY COLUMN;
ODETAIL Table
CREATE TABLE sales.odetail (
ordernum NUMERIC (6) UNSIGNED
NO DEFAULT
NOT NULL
,partnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,unit_price NUMERIC (8, 2)
NO DEFAULT
NOT NULL
,qty_ordered NUMERIC (5) UNSIGNED
NO DEFAULT
NOT NULL
,PRIMARY KEY (ordernum,partnum)
);
INSERT INTO sales.odetail
118 Sample Database