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

CASE#5

a)
DECLARE
city			VARCHAR2(20):='Cheyenne';
state			VARCHAR2(20):='Wyoming';
state_nickname	VARCHAR2(20):='Equality State';
city_nickname	VARCHAR2(25):='Magic City of the Plains';
city_population	VARCHAR2(6):='55,000';
statehood_date	DATE:= TO_DATE('07/10/1890','MM/DD/YYYY');
description1	VARCHAR2(25):='is the largest city in';
description2	VARCHAR2(20):='The population of';
description3	VARCHAR2(20):='is about';
description4	VARCHAR2(20):='people';
description5	VARCHAR2(20):='nickname is the';
description6	VARCHAR2(20):='The nickname of';
description7	VARCHAR2(3):='is';
description8	VARCHAR2(20):='became a state on';

BEGIN
DBMS_OUTPUT.PUT_LINE(city || ' ' || description1 || ' ' || state || '.' );
DBMS_OUTPUT.PUT_LINE(description2 || ' ' || city || ' ' ||description3 || ' ' || city_population || ' ' ||
                     description4 || '.');
DBMS_OUTPUT.PUT_LINE(state || '''s' || ' ' ||description5 || ' ' || state_nickname || '.');
DBMS_OUTPUT.PUT_LINE(description6 || ' ' || city || ',' || ' ' || state || ',' || ' ' || description7 ||
                     ' ' || '"' || city_nickname || '.' || '"' );
DBMS_OUTPUT.PUT_LINE(state || ' ' || description8  || ' ' || RTRIM(TO_CHAR(statehood_date,'Month')) || TO_CHAR(statehood_date,' DD YYYY') || '.');

END;