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

(5635,'ROYAL CHEMICALS' ,'45 NEW BROAD STREET'
,'LONDON' ,'ENGLAND' ,'EC2M 1NH','B2' ),
(7654,'MOTOR DISTRIBUTING','2345 FIRST STREET'
,'CHICAGO' ,'ILLINOIS' ,'60610' ,'E4' ),
(7777,'SLEEPWELL HOTELS' ,'9000 PETERS AVENUE'
,'DALLAS' ,'TEXAS' ,'75244' ,'B1' ),
(9000,'bunknought inn' ,'4738 ralph street'
,'bayonne' ,'new jersey' ,'09520' ,'c1' ),
(9010,'hotel oregon' ,'333 portland ave.'
,'medford' ,'oregon' ,'97444' ,'c2' ),
(9033,'art supplies, inc.','22 sweet st.'
,'pittsburgh','penna.' ,'08333' ,'c3' );
UPDATE STATISTICS FOR TABLE sales.customer ON EVERY COLUMN;
ORDERS Table
CREATE TABLE sales.orders (
ordernum NUMERIC (6) UNSIGNED
NO DEFAULT
NOT NULL
,order_date DATE
DEFAULT DATE '2002-07-01'
NOT NULL
,deliv_date DATE
DEFAULT DATE '2002-08-01'
NOT NULL
,salesrep NUMERIC (4) UNSIGNED
DEFAULT 0
NOT NULL
,custnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,PRIMARY KEY (ordernum)
);
ALTER TABLE sales.orders
ADD CONSTRAINT sales.date_constrnt
CHECK (deliv_date >= order_date);
CREATE INDEX xordrep
ON orders (
salesrep
);
CREATE INDEX xordcus
ON orders (
custnum
);
CREATE VIEW sales.ordrep
AS SELECT empnum
,last_name
,ordernum
SALES Schema 117