Report from SQL*Plus (multiple selects)

#1

Is it possible to develop a report in SQL*Plus in a bill type format with
multiple selects?
I want to run a select to see my customers personal details and then to see
the orders they placed but it needs to be formatted with the customers
personal details at the top of each page and underneath list the order
details.
Thanks

#2

Look up the BREAK, COMPUTE, and title commands.

HTH
ed

#3

"Ed Prochak" <ed.prochak (AT) magicinterface (DOT) com> wrote

Quote:

Look up the BREAK, COMPUTE, and title commands.

but if I run the 1st select (on customers) it lists this table before it

considers listing the 2nd table

#4

then make a join

SELECT <columns of interest>
FROM tableA, tableB
WHERE
GROUP BY

Like I said, look up BREAK and COMPUTE.
Your manual should have a few examples.

#5

"Collywobbles" <spam (AT) spammer (DOT) spam> wrote

Quote:

Is it possible to develop a report in SQL*Plus in a bill type format with
multiple selects?
I want to run a select to see my customers personal details and then to
see
the orders they placed but it needs to be formatted with the customers
personal details at the top of each page and underneath list the order
details.
Thanks

even though some have suggested looking into BREAK and COMPUTE, in actuality

the format you are describing is beyond SQL*Plus's capabilities. You could
coerce the output into something close to an invoice/order format --
typically this involves unions and clever use of SQL*Plus column formatting
(NOPRINT) and concatenation -- but we used to do that when we didn't have
any other options. better you look into using an actual report writer for
this type of output.

++ mcs