Re: Formatted report in SQL* Plus

From: ivano Punzo <ivano78_at_cheapnet.it>
Date: 27 May 2006 07:22:05 -0700
Message-ID: <1148739725.029767.210630@y43g2000cwc.googlegroups.com>

Sorry for my first answer...
I think that for solving your problem...could you try in this way:

write into pippo.sql file:
SET PAGES 0 FEEDBACK OFF

PROMPT "                        Patient Billing Summary "

select 'Patient Name: ' FIELD1 from table_name where (condition) select Patient ID: ' FIELD2 from table_name where (condition)
.
.
.

and so on...
I hope that I have really helped you
sorry for my English
  Ivano Received on Sat May 27 2006 - 09:22:05 CDT