Formatted report in SQL* Plus

From: shsandeep <sandeeprshah_at_gmail.com>
Date: Sat, 27 May 2006 02:45:48 -0400
Message-ID: <24426ae5198e008fef4fe3298a2d2682@localhost.talkaboutdatabases.com>

Hi, I would like to generate a formatted report in SQL* Plus as below. Can somebody please help me with the SQL statements for the same?

Generate a Billing Summary Report for a Patient by name “David Blanks” with the following Format:

                        Patient Billing Summary
Patient Name:

Patient ID:                         			Encounter ID:

Admission Date:
Discharge Date:

      Charge Category				Cost
Room Stay Summary Charges:	$
Supplies Summary Charges:	$
Radiology Summary Charges:	$
Laboratory Summary Charges:	$
Pathology Summary Charges:	$

		Total Charges: 	$ 

Thanks.

cheers,
San. Received on Sat May 27 2006 - 01:45:48 CDT