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

CASE#3

a)
DECLARE
student_last_name	VARCHAR2(20):=	'Miller';
student_first_name	VARCHAR2(20):=	'Sarah';
student_MI			VARCHAR2(2):=	'M';
student_address		VARCHAR2(40):=	'144 Windrige Blvd.';
student_city		VARCHAR2(40):=	'Eau Claire';
student_state		VARCHAR2(3):=	'WI';
student_zip			VARCHAR2(5):=	'54703';

BEGIN
DBMS_OUTPUT.PUT_LINE(student_last_name || ' ' || student_MI || '.' || ' ' || student_first_name);
DBMS_OUTPUT.PUT_LINE(student_address);
DBMS_OUTPUT.PUT_LINE(student_city || ',' || ' ' || student_state || '   ' || student_zip);

END;