Filter
Top Products
Tutorial Source Code
FairCom Corporation A-3
COLUMN oi_quantity FORMAT "A10" heading "QTY"
COLUMN im_price FORMAT "$99.99" heading "PRICE"
SELECT custmast.cm_name, orderitems.oi_quantity, itemmast.im_price
FROM custmast, orderitems, itemmast, orderlist
WHERE orderlist.ol_custnum = custmast.cm_custnum AND
orderlist.ol_ordernum = orderitems.oi_ordernum AND
orderitems.oi_itemnum = itemmast.im_itemnum
ORDER BY orderlist.ol_custnum;
A.3 LOCKING TUTORIAL
CREATE TABLE CUSTMAST (
cm_custnum VARCHAR(5),
cm_zip VARCHAR(10),
cm_state VARCHAR(3),
cm_rating VARCHAR(2),
cm_name VARCHAR(48),
cm_address VARCHAR(48),
cm_city VARCHAR(48));
COMMIT WORK;
DELETE FROM CUSTMAST;
COMMIT WORK;
INSERT INTO CUSTMAST VALUES ('1000', '92867', 'CA', '1', 'Bryan
Williams', '2999 Regency', 'Orange');
INSERT INTO CUSTMAST VALUES ('1001', '61434', 'CT', '1', 'Michael
Jordan', '13 Main', 'Harford');
INSERT INTO CUSTMAST VALUES ('1002', '73677', 'GA', '1', 'Joshua
Brown', '4356 Cambridge', 'Atlanta');
INSERT INTO CUSTMAST VALUES ('1003', '10034', 'MO', '1', 'Keyon
Dooling', '19771 Park Avenue', 'Columbia');
COMMIT WORK;
UPDATE custmast SET cm_name = 'KEYON DOOLING' where cm_custnum = '1003';
A.4 TRANSACTION PROCESSING TUTORIAL
CREATE TABLE orderlist (
ol_orderdate DATE,
ol_promdate DATE,
ol_ordernum VARCHAR(7),
ol_custnum VARCHAR(4));
CREATE TABLE orderitems (
oi_ordernum VARCHAR(7),
oi_seqnumber SMALLINT,
oi_quantity SMALLINT,
oi_itemnum VARCHAR(6));
CREATE TABLE itemmast (
im_weight INTEGER,
im_price MONEY,
im_itemnum VARCHAR(6),