Re: Formatted report in SQL* Plus

"ivano Punzo" <ivano78_at_cheapnet.it> wrote in message news:1148739725.029767.210630_at_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
:

multiple selects of the same record from the same table are not necessary and is not good practice, since a single select can bring back all the necessary data

shsandeep, this really looks like classwork -- you should have had some instruction on SQL*Plus formatting commands such as TTITLE, NEW_VALUE, COLUMN, BREAK and others -- plus some instruction on peforming UNIONs and JOINs, building expressions with the concatenation operator, and using Oracle's built-in functions. your coursebook should have some applicable examples that you really should review, and make sure you understand

++ mcs Received on Sat May 27 2006 - 10:22:42 CDT