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

CASE#6

a)
DECLARE
pi					NUMBER:=	3.1415926;
current_radius		NUMBER:=	3;
description1		VARCHAR2(25):=	'For a circle with radius';
description2		VARCHAR2(16):=	'the diameter is';
description3		VARCHAR2(16):=	'and the area is';
diameter			NUMBER:=	ROUND(2 * current_radius, 2);
area				NUMBER:=	ROUND(2 * pi * current_radius ** 2, 2);

BEGIN
DBMS_OUTPUT.PUT_LINE(description1 || ' ' || current_radius || ',' || ' ' || description2 || ' ' 
                     || diameter || ' ' || description3 || ' ' || area || '.');
                     
END;