Andre Long
CISP 350 Oracle
April 20, 2006
Chapter 4 PSC 

CASE#2

a)
DECLARE
inventory_ID	NUMBER	:=	1;
inventory_color	VARCHAR2(10):=	'Sky Blue';
inventory_price	NUMBER	:=	259.99;
inventory_QOH	NUMBER	:=	16;

BEGIN
DBMS_OUTPUT.PUT_LINE('Inventory ID:' || ' ' || inventory_ID);
DBMS_OUTPUT.PUT_LINE('Color:' || ' ' || inventory_color);
DBMS_OUTPUT.PUT_LINE('Price:' || ' ' || inventory_price);
DBMS_OUTPUT.PUT_LINE('Quantity on Hand:' || ' ' || inventory_QOH);

END;